Steve Jones - SSC Editor (12/9/2015)

---

I don't have fundamental problems with gathering some of this data. Now keeping it, that's perhaps something we don't want to do. However we are...

I would suggest that the growth in the volume of data stored does not reflect a growth in actual information.

If you look, how much of that growth is a...

For many years, I supported an application which had absorbed another application to add functionality, and each part had its own schema.

Because we supported geographically dispersed sites with data replication...

Eric M Russell (10/29/2015)

---

william-700725 (10/28/2015)

---

WHERE? Those are the ones I want but can never find. I always get stuck...

WHERE? Those are the ones I want but can never find. I always get stuck having to earn the...

Steve Jones - SSC Editor (10/19/2015)

---

william-700725 (10/19/2015)

---

Steve, I think you are seriously understating the potential damage a bad manager can do.

The two worst-case scenarios are managers who actually increase divisiveness...

Steve, I think you are seriously understating the potential damage a bad manager can do.

The two worst-case scenarios are managers who actually increase divisiveness on a team, eliminating synergy and...

Steve,

"Happy Memorial Day"?

Reflective, yes, certainly. Somber, perhaps. Happy? Not really -- it's not supposed to be that kind of a holiday.

Which in my mind begs the question of...

sqlfriends (10/9/2013)

---

http://technet.microsoft.com/en-us/library/ms143504.aspx

I am a little confused a bout MSA account, it says :

When resources external to the SQL Server computer are needed, Microsoft recommends using a Managed Service...

Really? Why not? There are countless open-source applications written in other scripting languages (perl, php, Python).

And what makes ETL in particular unsuitable for scripting?

In my (rarely humble) opinion, Powershell proficiency is a skill any DBA working with Windows-based servers should acquire. If you have any task that would benefit from automation, it can...

David McKinney (1/28/2011)

---

Everything is relative!

My recursive CTE was EXTREMELY FAST and I was more than happy with it until I compared against the tally table alternative, when suddenly it became...

Michael Valentine Jones (1/27/2011)

---

william-700725 (1/27/2011)

---

[font="Courier New"]About time somebody pointed out the convenience of the standardized formats. I've been using UCASE( CONVERT( char ( 11 ) , GETDATE() , 106 )...

Jeff Moden (1/27/2011)

---

... my favorite mil-spec is [font="Arial Black"]MIL-TP-41[/font] and, to me, is the crux of ISO and SOX compliance... it means "Make It Like The Print for once". ...