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: April 2011

SQL University: SQL Azure & PowerShell

Welcome once more to the Miskatonic branch of SQL University. I see that most off you survived out last encounter… uh, class. Most of you even appear somewhat sane… somewhat. Today we’re going to talk about PowerShell and it’s use with SQL Azure. Which sounds a something like an… Read more

0 comments, 1,716 reads

Posted in The Scary DBA on 28 April 2011

SQL Azure Diagnostic Tool

One of the CSS Engineers from Microsoft has released a diagnostic tool for SQL Azure. It’s worth a look. It’s just using standard DMO queries to pull back data, but they’re put them together inside a nice UI to help out. If you’re already a DMO super-star, this might… Read more

0 comments, 1,002 reads

Posted in The Scary DBA on 26 April 2011

SQL Azure Deployments

You’ve set up your access to a SQL Azure site so you’re ready to go. Now how do you get your database up there? Well, TSQL works just fine, so you can script it all out to a file or set of files and apply them. Because you can connect… Read more

2 comments, 1,504 reads

Posted in The Scary DBA on 25 April 2011

SQL Azure Cost

We’ve all heard the scary stories. A developer starts testing Azure and then suddenly gets a thousand dollar bill on their credit card. The whole idea behind Azure works of the premise that you are not paying for the infrastructure. Instead of buying servers and disks and racks and switches… Read more

0 comments, 1,511 reads

Posted in The Scary DBA on 18 April 2011

SQL Azure

If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made very clear. Microsoft is all in on the cloud. What’s that mean? My understanding of it means they are really, seriously committed to building a viable and large presence there.… Read more

0 comments, 618 reads

Posted in The Scary DBA on 15 April 2011

Performance Tuning: Start to Finish

The very first ever SQL Rally is taking place in a little less than four weeks in Orlando Florida. It’s going to be quite the event. There will be two full days of sessions on any number of topics. But before that all starts, there’s going to be a set… Read more

2 comments, 1,316 reads

Posted in The Scary DBA on 14 April 2011

SQL University: Index Usage

Greetings. Welcome once more to the Miskatonic University branch of SQL University. Does anyone know where to buy some camping equipment, cheap? I’ve been tagged to go an expedition to Antarctica and I need some cold weather gear a bit more substantial than my LL Bean boots. Evidently the last… Read more

0 comments, 863 reads

Posted in The Scary DBA on 6 April 2011

SQL Saturday #71 Wrap-up

It’s over. It’s finally over. This year, unlike previous years, Adam Machanic (blog|twitter) was very good about delegating the work. Which, is actually a mixed blessing. I did a lot more work this year than I have done in years past. Luckily, we had more help… Read more

1 comments, 750 reads

Posted in The Scary DBA on 4 April 2011

Meme Monday

Tom LaRock has an idea. Several people respond, not all well.

Read more

0 comments, 608 reads

Posted in The Scary DBA on 4 April 2011

SQL University–Recommendations for a Clustered Index

Welcome, SQL University Students to another extension class here at Miskatonic University, home to the Fighting Cephalopods (GO PODS!). Never mind the stains on the floor, or the walls…or those really nasty ones on the ceiling. There was a… oh what did the dean call it… an incident last week… Read more

0 comments, 1,209 reads

Posted in The Scary DBA on 4 April 2011