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).

Avoiding Bad Query Performance

There’s a very old saying, “When you find yourself in a hole, stop digging.”

And my evidence today is:

That’s certainly not the hairiest execution plan I’ve seen. In some ways, it’s not all that horrible. But it sure is evidence that someone was down in a hole and they… Read more

4 comments, 147 reads

Posted in The Scary DBA on 7 February 2012

Meme Monday: Deadlines

Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.

Some people hate deadlines. Some people love deadlines. But when you have one, there’s a good chance you need to really meet that deadline or there could be repercussions. Read more

0 comments, 130 reads

Posted in The Scary DBA on 6 February 2012

Learning, Networking & Wine

Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some time networking with others. And, it just so happens, you’re a bit of a wine connoisseur. I have the event with you in mind.

It’s the first ever, SQL Excursion Read more

0 comments, 193 reads

Posted in The Scary DBA on 1 February 2012

Tech on Tap v1.1 Wrap-up

The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in Appleton, WI. If you weren’t there, well, you missed it. Notice that keyword in that earlier sentence, Brewpub. Yes, the Tech on Tap events (and there will be more) are… Read more

0 comments, 208 reads

Posted in The Scary DBA on 31 January 2012

Execution Plans, What Do I Look At?

The question came up, what are the top 3-5 things that you look at in a query. I realized then that I hadn’t really written them down. There are some areas that let me know pretty much immediately where problems lie within a plan. You don’t necessarily know the answer… Read more

6 comments, 243 reads

Posted in The Scary DBA on 30 January 2012

Deadlock Monitoring

There are four different ways you can get information about deadlocks in your system. These are:

  • traceflag 1204
  • traceflag 1222
  • trace events
  • extended events

For years I’ve been pushing traceflag 1222 as the best of the lot. Well, that’s over. I’ve been learning more and more about extended events and… Read more

5 comments, 1,529 reads

Posted in The Scary DBA on 23 January 2012

Stop PIPA & SOPA

I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six of you who read this (and, of course, you Mom), I do want to point out that these are horrific bad bills. They are sponsored by Democrats and Republicans, so… Read more

6 comments, 382 reads

Posted in The Scary DBA on 18 January 2012

Friday SQL Nugget #1

Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like you.

We have a tagging theme started by Ted Krueger (blog|twitter) who I also used to like.

The theme is: Deciding that… Read more

2 comments, 492 reads

Posted in The Scary DBA on 13 January 2012

Database Backups: Things You Need To Do Now

I want to say a few things about database backups that you need to know.

Wait a minute, haven’t you written about backups before?

Why, yes. Yes I have.

Aaand… you’re doing it again because?

Have you noticed the shocking number of questions that come up on SQL Server Central… Read more

9 comments, 2,979 reads

Posted in The Scary DBA on 11 January 2012

PASS Summit 2012 Evaluation Results

I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not indifferent), feedback is a wonderful gift. Any time you appreciate a speaker, give them feedback. Any time you think a speaker could improve, give them feedback. Any time you hate… Read more

2 comments, 655 reads

Posted in The Scary DBA on 19 December 2011

SQL Saturday #104: Colorado Springs

I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways to Fix Bad Parameter Sniffing. Please, if you’re in the area, register and come to the event. There are going to be some truly excellent speakers there. There is… Read more

0 comments, 741 reads

Posted in The Scary DBA on 14 December 2011

Changes to SQL Server 2012 Execution Plans

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT… Read more

10 comments, 2,558 reads

Posted in The Scary DBA on 12 December 2011

#sqlfamily

Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a single better cause to throw some support behind. Not one. They’re going to donate money based on posts about #sqlfamily.

Well done to Brian Knight (blog|twitter)… Read more

3 comments, 717 reads

Posted in The Scary DBA on 9 December 2011

SQL Connections Fall 2011 Speaker Evaluations

In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did at Connections in Vegas back in November. It was a mixed conference for me. The first session I had ~80 people. The second session I had 9. Yeah, weird. But… Read more

1 comments, 749 reads

Posted in The Scary DBA on 6 December 2011

Resolutions: Outcome

Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked by Jen McCown (flat out, one of my favorite people, blog|twitter). It was supposed to be about resolutions, but I just don’t make those. I make plans.… Read more

1 comments, 793 reads

Posted in The Scary DBA on 5 December 2011

PASS Board Elections

Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look these people over, weigh them, and vote well. Things are running a little different this year. The elections are being held between the 6th and the 20th of December. Read more

1 comments, 802 reads

Posted in The Scary DBA on 30 November 2011

Installing SQL Server 2012 RC0

Very short informational post.

If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server Denali, uh, I mean 2012, then the news about the release of RC0 is pretty exciting stuff… until you realize that you’re going to have to tear down your… Read more

0 comments, 830 reads

Posted in The Scary DBA on 21 November 2011

Thank you

I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the bottom). This was evidently a write-in list and some of you who read my rambling attempts to understand this SQL Server stuff thought enough to actually write down this blog.… Read more

0 comments, 803 reads

Posted in The Scary DBA on 18 November 2011

Meme Monday: SQL Family

Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me?

Wow…

Geez Tom, couldn’t you ask a hard question for once?

Hmmm…

Just saying #sqlfamily and a whole series of images of people flashes through my head. And those images are accompanied by all… Read more

0 comments, 802 reads

Posted in The Scary DBA on 7 November 2011

Book Review: Guerilla Leader, T.E. Lawrence and the Arab Revolt

As part of my commitment to read and review 12 books in an effort to be active in my own personal development, a commitment made on the SQL Cruise back in June, I’ve completed another book, Guerrilla Leader: T. E. Lawrence and the Arab Revolt by James J. Schneider.

This… Read more

0 comments, 809 reads

Posted in The Scary DBA on 7 November 2011

Older posts