Subscribe to this blog
The Scary DBA
Archives: January 2011
Powershell to Automate SQL Compare
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate creating scripts for all your databases at once. What’s the first thing that popped into my head? Yep, Powershell.
SQL Compare Pro comes with a command line utility that allows… Read more
2 comments, 1,620 reads
Posted in The Scary DBA on 31 January 2011
SQL Saturday #71: Call For Speakers
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we had not yet sent out an official request. That email has now gone out the door. Here it is for those who might be interested in presenting. Please consider this… Read more
2 comments, 216 reads
Posted in The Scary DBA on 26 January 2011
A Friend of Red Gate No More
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a great relationship, a fantastic friendship. Look, it’s not you, it’s me. I want more. I want to take our relationship to the next level.
That’s why I’m excited as can… Read more
5 comments, 100 reads
Posted in The Scary DBA on 21 January 2011
Deprecation, Trace and Execution Plans
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or, it even reinforces bad decisions. Regardless of the purpose, the means by which these changes are implemented when they involve taking things away is deprecation. Usually in SQL Server the… Read more
1 comments, 189 reads
Posted in The Scary DBA on 21 January 2011
DBA 101: Why is my log file full?
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central. I know it pops up at least once a week on Ask SSC. I’m sure I’ve seen it on Twitter #sqlhelp. “Why is my log file growing?” and… Read more
14 comments, 1,024 reads
Posted in The Scary DBA on 18 January 2011
Failed Blog Posts
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some great idea and then it all goes south. For example, I was going to explain the difference between a table/heap scan and a clustered index scan. The problem was, I… Read more
3 comments, 99 reads
Posted in The Scary DBA on 14 January 2011
TSQL Tuesday: Resolutions
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown (blog|twitter) of SQLawesomesauce, is Resolutions. In particular, Techie Resolutions. I have to do this because Jen just received her MVP award, in case you’ve been… Read more
1 comments, 153 reads
Posted in The Scary DBA on 11 January 2011
Encryption and the Performance DMOs
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I did get that question during my DMO presentation at the PASS Summit. I did not have an answer. I did get an answer from Johan Biknens (twitter) from… Read more
1 comments, 119 reads
Posted in The Scary DBA on 5 January 2011
My Review of SeV Revolution Jacket
Originally submitted at SCOTTEVEST, Inc.
26 Pockets are perfect for everyday and travel items; includes the TravelSmartSystem?. The SCOTTEVEST revolution began about 10 years ago, but this SeV Revolution Jacket is just getting started! This jacket has a silky lining and all of the features you've come to expect from…
0 comments, 512 reads
Posted in The Scary DBA on 5 January 2011
Temporary Post Used For Theme Detection (7152665d-114f-4469-a816-6ca6880e832a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (95b57a7c-aa49-471e-a63c-76ea6775d1d4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
0 comments, 93 reads
Posted in The Scary DBA on 4 January 2011