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: July 2017

SQL Cruise: Alaska 2017

We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more. There you’ll also find testimonials and suggestions on how to sell SQL Cruise to your boss. I’m going to leave selling it to your boss to you. I want… Read more

4 comments, 149 reads

Posted in The Scary DBA on 19 July 2017

Thoughts on the State of Data Management

I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share it with you. If you’re wondering what I think of the current state of the industry, go here to check it out.

The post Thoughts on the State of Data… Read more

2 comments, 102 reads

Posted in The Scary DBA on 18 July 2017

Database Fundamentals #5: Database Properties

Don’t let the ease of creating databases lull you into a false sense of security. They actually can be very complicated. You can modify and individualize their behavior within your server so that different databases behave in radically different ways. The best way to see all the different manipulations you… Read more

1 comments, 153 reads

Posted in The Scary DBA on 17 July 2017

The Choices We Make

If you keep your head up and look around you’ll see the choices people make all the time. I saw a recent example online in this story about two experiences, shopping at Home Depot vs. Lowes (very minor NSFW warning due to language).

I don’t want to get into a… Read more

4 comments, 1,065 reads

Posted in The Scary DBA on 10 July 2017


I want to take a moment to thank a few people for being amazing.

First up, Thomas LaRock is wrapping up his tenure on the PASS Board this year. He has one more in-person meeting at Summit 2017 and then he’s basically done. I followed Tom to karaoke during my… Read more

0 comments, 120 reads

Posted in The Scary DBA on 6 July 2017

I Love Entity Framework

I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling you I love Object/Relational Mapping tools (ORM). I think this is a technology set that the DBA needs to more tightly embrace. Let me tell you why.

Most of…

Read more

24 comments, 1,962 reads

Posted in The Scary DBA on 5 July 2017