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: May 2013

Painting the US Red

We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.

This event has been hosted in London multiple times, Los Angeles, New York, Austin, San Francisco, Chicago and Boston. It’s a fun day of training, presentations, and networking, all done… Read more

4 comments, 812 reads

Posted in The Scary DBA on 29 May 2013

SMO vs Invoke-Sqlcmd in Azure

I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be giving at TechEd and the PASS Summit. One of the things I want to do is script out a full backup process (one that’s consistent with transactions)… Read more

3 comments, 1,047 reads

Posted in The Scary DBA on 28 May 2013

A Little Azure Fun on Friday

You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions of SQL Server? Have you tried running something like this on any of your Windows Azure SQL Databases yet:

EXEC sp_msforeachtable 'select ''?'', count(*) from ?'

Try it out.

Read more

3 comments, 716 reads

Posted in The Scary DBA on 24 May 2013

PASS Summit 2013 is Looking Cloudy

No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be speaking at the PASS Summit, but I’m speaking about Azure… a lot.

First up, I’m going to be doing an all-day pre-conference seminar specifically aimed at getting you into Azure.… Read more

6 comments, 630 reads

Posted in The Scary DBA on 22 May 2013

Microsoft Lync Through the Web

Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid Office365 account do you? So, you click the link, figure it’ll open a web browser and off you go, right?


Instead it opens up a Lync app that you… Read more

3 comments, 780 reads

Posted in The Scary DBA on 21 May 2013

Azure does Powershell too

Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of commandlets for Azure and Azure SQL Database. Here’s the link to get you started and the basic documentation. After that, it’s a little tricky to know for sure what’s required.… Read more

2 comments, 1,892 reads

Posted in The Scary DBA on 20 May 2013

Book Review: Business in the Trenches

I’m trying to improve.

That’s at just about everything too. I know I don’t know enough or have enough skills to always get things done in an efficient manner, so I’m trying to learn more. One way is by reading, a lot. I’ve read a number of management and leadership… Read more

0 comments, 722 reads

Posted in The Scary DBA on 9 May 2013

How to Tell Your Windows Azure SQL Database Moved

The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies of your database. Should there be a hardware or software failure that would cause the primary replica to go down, your database gets moved to one of the secondary… Read more

8 comments, 1,561 reads

Posted in The Scary DBA on 7 May 2013