Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: July 2010

Powershell Remoting with SQL Server

One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of these, you can basically send commands simultaneously to a number of SQL Server instances. BUT… and there always seems to be one of those, there is a lot of work… Read more

0 comments, 956 reads

Posted in The Scary DBA on 27 July 2010

SQL University: Introduction to Indexes, Part the Third

Nice to see most of you have managed to fight your way through the shoggoths outside to attend another lecture at the Miskatonic branch of SQL University. This will be the third and final part of the introduction to indexes lecture. Please, if you’re going mad, step out into… Read more

1 comments, 238 reads

Posted in The Scary DBA on 23 July 2010

SQL University: Introduction to Indexes, Part the Second

Welcome once more to the Miskatonic branch of SQL University. Please try to concentrate. I realize the whipoorwills singing outside the window in a coordinated fashion that sounds almost like laboured breathing can be distracting, but we’re talking about indexes here.

We left last class with a general idea… Read more

2 comments, 257 reads

Posted in The Scary DBA on 21 July 2010

SQL University: Introduction to Indexes, Part the First

Right, all eldritch tomes are to be closed and Elder Signs are to be put away during this course.

Welcome to the History department here at the Miskatonic branch of SQL University. Why the History department? Well, first, because I like history and have frequently thought I would enjoy… Read more

2 comments, 232 reads

Posted in The Scary DBA on 19 July 2010

Steve Jones to Run for PASS Board

I couldn’t hide the lead. Steve Jones (blog|twitter) has announced he’s running for the PASS board. I’m excited. I’m almost as excited as if I were going to run. Steve is not simply a major influencer in what we call the SQL Community. He brings… Read more

1 comments, 435 reads

Posted in The Scary DBA on 16 July 2010

SQL University: Introduction to Indexes

For some crazy reason (probably everyone is on vacation), Jorge Segarra (blog|twitter) who runs SQL University has asked me to submit some material. I’ve got three posts, all coming up next week, that give a very, very basic introduction to indexes in SQL Server.


Read more

3 comments, 207 reads

Posted in The Scary DBA on 16 July 2010

In the Clouds

The July meeting for the Southern New England SQL Server Users Group is tonight. Andrew Novick will be talking about SQL Azure. It’ll be a great meeting. Our sponsor is Red Gate. They bought pizza.


Read more

0 comments, 277 reads

Posted in The Scary DBA on 14 July 2010

Red Gate SQL Source Control

You just have to love Red Gate tools. They find the small area that they want to cover and then they cover it extremely well. I rave regularly about SQL Prompt and SQL Compare and SQL Search (free one, btw). I’ve got SQL Data Compare and SQL Data… Read more

2 comments, 867 reads

Posted in The Scary DBA on 14 July 2010

Delivering the Bad News

It’s a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week, but I’m passing it on now:

The Standard is dead.

Let me first say, a couple of authors are right in the middle of finishing up articles. Those will… Read more

6 comments, 215 reads

Posted in The Scary DBA on 9 July 2010

Small PowerShell Script

I’m still trying to learn PowerShell better. The opportunity to answer simple questions and problems with the tool is hard to pass up. We had a need to clean up data directories where data files were left behind or people put inappropiate files, so I wrote the following Powershell script: Read more

0 comments, 370 reads

Posted in The Scary DBA on 6 July 2010