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

I Don’t Care

It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.

When thinking about cloud-based data management, things come down to a simple, if misleading, statement; I don’t care.

I don’t care about operating systems or servers or disks. I need to have a… Read more

4 comments, 728 reads

Posted in The Scary DBA on 24 June 2013

Azure First

Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on a massively accelerated schedule. Because of this, they’re doing lots of code on lots of things that may, one day, end up in your full blown SQL Server instance, but… Read more

6 comments, 2,201 reads

Posted in The Scary DBA on 17 June 2013

Praise and a Suggestion for AlwaysOn

One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are awesome. It’s basically shared nothing clustering at a database-by-database level. You can set up a series of secondary machines that will enable you to failover a database in the… Read more

1 comments, 809 reads

Posted in The Scary DBA on 10 June 2013

Helping Database Administrators

Let’s be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on line. Some maintenance routines for statistics and maybe for fragmentation are also helpful. Set up security. In most of the important ways, you’re done. Sit back, monitor the whole thing… Read more

4 comments, 1,740 reads

Posted in The Scary DBA on 4 June 2013

Using PowerShell to move files to Azure Storage

I was searching all over the place to try to find out how to move files into Azure Storage. Most of the examples I could track down were for API calls through C#. There were very few examples using PowerShell, and most of those were for older versions of Azure.… Read more

6 comments, 1,917 reads

Posted in The Scary DBA on 3 June 2013

Microsoft Teched 2013 Keynote

Welcome to Teched 2013

We’re starting off with some type of James Bond video. Chase scene with a really cool car. Not quite French Connection, but good. OK, that was, if a little ballsy, “you’ll never crack it” Jeez, how to upset people. And the car from the video drives… Read more

1 comments, 861 reads

Posted in The Scary DBA on 3 June 2013