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: October 2012

Microsoft Surface Update

Let’s talk some more about the basic keyboard. I’m really surprised at how well it works. But, it’s absolutely going to take some getting used to. Here’s some typing I did as a test to see where I missed keys, etc.;

Once upon a midngith dreary while I pondered weak…

Read more

3 comments, 1,415 reads

Posted in The Scary DBA on 31 October 2012

Microsoft Surface

I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the experience.

Getting the silly thing required several phone calls and a car trip, but I wanted it.

Out of the box.

It turned on. Yay!

The first thing it wants… Read more

5 comments, 3,246 reads

Posted in The Scary DBA on 28 October 2012

Scary Reading List for Halloween

I know I focus on community, SQL Server, professional development and process. But you need to do other stuff occasionally too. For example, I’ve long been a fan of horror stories (and science fiction/speculative fiction and some historical novels and history books and… I like to read, OK?). I received… Read more

6 comments, 717 reads

Posted in The Scary DBA on 26 October 2012

Clustered Indexes Have Statistics Too

It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index just don’t matter. That if the clustered index can satisfy a given query, it’s going to get selected. That just didn’t make any sense to me, but I haven’t seen… Read more

4 comments, 1,142 reads

Posted in The Scary DBA on 22 October 2012

SQL In The City: Seattle

If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many of the same people will be back at SQL in the City in Seattle. It’s scheduled on Monday before the PASS Summit proper starts, so if you’re looking to… Read more

2 comments, 1,132 reads

Posted in The Scary DBA on 17 October 2012

RML Utilities and SQL Server 2012

I’m working through some code that I haven’t touched recently and I’m running it for the first time on a SQL Server 2012 server. The code is a way to load information into the RML utilities and I started hitting errors. First, I hit an error that my server couldn’t… Read more

6 comments, 1,443 reads

Posted in The Scary DBA on 16 October 2012

Why Tune Queries?

It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or get a few more disks. Right? Seriously, tuning queries is just a pain and there’s no clear evidence that writing them correctly or tuning them has a major impact. Right? Read more

6 comments, 2,948 reads

Posted in The Scary DBA on 15 October 2012