Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: January 2010

SQL Saturday #34


The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a great opportunity to learn about SQL Server and things around SQL Server. If you’re in the New England area, please register and take advantage of this excellent event. 450 of…

Read more

0 comments, 182 reads

Posted in The Scary DBA on 27 January 2010

A Call to Arms


Phil Factor’s most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer’s spiffy new outfit… well, it’s not exactly there. That’s why he looks so nekkid.

But seriously, the very idea of naming objects inside of the database with Hungarian-style notation really…

Read more

6 comments, 278 reads

Posted in The Scary DBA on 25 January 2010

PowerShell Script for Creating Indexes


I needed to create an identical index on a bunch of tables within one of my projects (yes, I know this is problematic on multiple levels and I’m working on that too). Rather than sitting around typing this up, I decided to use PowerShell to do the work for me.…

Read more

1 comments, 433 reads

Posted in The Scary DBA on 21 January 2010

What three events brought you here?


Another one of the DBA bloggers games of tag is occurring. I’ve been asked by Tom LaRock to answer Paul Randal’s question; What three events brought you here. Well, mom was a cheerleader and dad was a football player, so… Oh, wait. I guess I misunderstood the question. He means…

Read more

3 comments, 225 reads

Posted in The Scary DBA on 18 January 2010

Database Design Process


Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked four questions about how each of us do our work:

  1. What process do you follow?
  2. How important are the business requirements?
  3. What tool do you use to create the…

Read more

4 comments, 594 reads

Posted in The Scary DBA on 18 January 2010

SQL Server Standard Volume 7 Issue 1


Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more articles in the hopper. Keep an eye out for them. We’re providing you with the best writers giving us some of their best stuff. Go and check it…

Read more

1 comments, 327 reads

Posted in The Scary DBA on 13 January 2010

Excel Within Management Studio


Aaron Bertrand has put in a Connect request for a feature whereby data returned as a grid from a query can just go right into an Excel spreadsheet. All in favor? Opposed? Motion passed. Go and vote this one up, up, up.

Read more

0 comments, 319 reads

Posted in The Scary DBA on 13 January 2010

Connections Sessions Evals


I’ve kind of been embarassed to post these despite the fact that I received them a couple of weeks ago. Overall, I’d say they’re very good, and I’m quite proud of them, but one comment still has me upset. Anyway, here we go:

DMV’s For Performance Tuning (same session as…

Read more

0 comments, 152 reads

Posted in The Scary DBA on 13 January 2010

TSQL Tuesday #2


I’ve wracked my brain for some bit of puzzle that I could present as part of TSQL Tuesday #2 and I finally came up with a bit of something.

When you’re looking at an execution plan for a query, you know that this represents SQL Servers best attempt at a…

Read more

1 comments, 435 reads

Posted in The Scary DBA on 12 January 2010

Horror… sort of


You must read this post from Tim Ford to understand why I might do this on my technical blog. But Tim’s a friend and the chance to branch out, at least a little, could not be avoided. I hope I don’t lose too many of my eight readers from this….

Read more

3 comments, 304 reads

Posted in The Scary DBA on 11 January 2010

New England Data Camp v2/SQL Saturdy #34 Update


The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set of sponsors. Thanks to them we’re providing much better food than last year and the chance at a bit of swag, again, better than last year. But, most importantly, we…

Read more

0 comments, 188 reads

Posted in The Scary DBA on 11 January 2010

PASS Summit Evaluations


The big day has arrived and all the speakers are poring over their PASS Summit 2009 evaluations, me included. These things are always a mixed bag. On the one hand you get nice positive reinforcement. On the other, you wonder how you may have fallen short to not get even…

Read more

0 comments, 205 reads

Posted in The Scary DBA on 6 January 2010

SQL Server Standard Article Abstracts


I’d really like to publish your article in SQL Server Standard. All I need from you is an abstract, a description of what the article will be. I’ve posted this before, but I’ve never provided examples. So, to get people started, here are a few examples of articles that have…

Read more

1 comments, 245 reads

Posted in The Scary DBA on 4 January 2010

Plagiarism


And really bad plagiarism at that.

I received an email from someone suggesting I check out a book on Lulu.com, that it might be a copy of my book. Sure enough, this other guy, William Miller, had posted my book, with the original cover (that had my name on it)…

Read more

2 comments, 199 reads

Posted in The Scary DBA on 1 January 2010