SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

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, 4,136 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, 1,021 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, 767 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, 874 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, 2,643 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, 721 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, 990 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, 574 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…

Read more

0 comments, 1,594 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)

Read more

0 comments, 511 reads

Posted in The Scary DBA on 4 January 2011