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

“Pretty Plans vs. Performance” or “Grant Gets Pwned”

If you get an execution plan that looks like this:

I wouldn’t blame you for immediately thinking about query tuning. Especially if the code that generated it looks like this:

SELECT  soh.OrderDate,
        sod.OrderQty,
        sod.LineTotal
FROM    Sales.SalesOrderHeader AS soh
INNER JOIN Sales.SalesOrderDetail AS sod
        ON sod.SalesOrderID = soh.SalesOrderID
WHERE   soh.SalesOrderID IN…

Read more

1 comments, 62 reads

Posted in The Scary DBA on 19 December 2014

Speaker of the Month: December 2014

For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new speakers to see (heck, I didn’t get to see any sessions at Summit this year). But, that didn’t mean I didn’t get to see great speakers. I did (Rimma!… Read more

3 comments, 122 reads

Posted in The Scary DBA on 8 December 2014

Speaker of the Month: November 2014

I have been very remiss in my blogging of late. Apologies.

One thing I haven’t blogged about is Speaker of the Month. I’m behind. So, I’ll be posting two of them over the next few days in order to catch up.

First up, Speaker of the Month for November.

I… Read more

1 comments, 117 reads

Posted in The Scary DBA on 5 December 2014

PASS Summit 2014 Speaker Idol

For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015 Summit. This competition was organized and run by Denny Cherry. You can read all about what he thought of the event right here. I was asked to take part… Read more

3 comments, 112 reads

Posted in The Scary DBA on 13 November 2014

I’m Still Not on the Board

I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different. I did a lot of the usual things, presented a pre-conference seminar to about 130 people, helped out at the Red Gate booth, presented a session on execution plans on… Read more

1 comments, 133 reads

Posted in The Scary DBA on 11 November 2014

PASS Summit 2014: WIT Luncheon

Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time since they had a bloggers. But, I am going to blog through the Women in Technology (WIT) Luncheon because I just love getting to take part in this amazing event. Read more

7 comments, 116 reads

Posted in The Scary DBA on 6 November 2014

Database Lifecycle Management

There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every application and if you do a similar search, there aren’t very many people talking about Database Lifecycle Management at all. Why not? I’m positive you’re deploying a database with… Read more

4 comments, 5,414 reads

Posted in The Scary DBA on 20 October 2014

Why Haven’t You Changed Everything?

The first in what I hope will be many regular reports on what I’m doing on the PASS board.

To answer the question that I’ve already been asked (who had 47 hours in the pool?), first, I’m not on the board yet. I was elected to it and my term… Read more

7 comments, 153 reads

Posted in The Scary DBA on 17 October 2014

Query Performance Tuning in SQL Server

I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query Performance Tuning in SQL Server 2014″ because it seemed like a good idea to bring out the aspects of 2014, and we will. But, I need to tell you,… Read more

0 comments, 152 reads

Posted in The Scary DBA on 16 October 2014

Thank You: #passvotes

The results are in and it seems that I’ve been elected to a place on the PASS Board.

Thank you.

I will strive to be worthy of the position you’ve placed in my hands. I will do my best to make a difference on the board. Watch this space for… Read more

8 comments, 129 reads

Posted in The Scary DBA on 15 October 2014

Navel Gazing

I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to think about. Am I presenting the right material? Am I presenting it in the right way? Can I improve? But, in order to get constructive feedback, people have to tell… Read more

0 comments, 5,749 reads

Posted in The Scary DBA on 12 October 2014

Speaker of the Month: October 2014

I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to San Diego and then Antwerp and Utrecht at Connections, two different SQL Saturday events and SQL Server Days. The speakers just seem to keep getting better, making this more difficult.… Read more

0 comments, 137 reads

Posted in The Scary DBA on 9 October 2014

The PASS Board: #passvotes

Ever been in a fight? Ever been in one that’s not completely going your way? I’ve done this and seen this in the martial arts and, unfortunately, on the street. As you start to lose the fight, you tend to fold in on yourself. It’s a natural reaction. You’re protecting… Read more

3 comments, 122 reads

Posted in The Scary DBA on 2 October 2014

PASS Votes… A little bit more #passvotes

I am putting up an abnormal Saturday morning blog post in support of the actions taken by the PASS Board last night.

The story so far…

In order to eliminate all the excess ballots (I received 5 one year although I only used one) being sent to eligible members… Read more

1 comments, 141 reads

Posted in The Scary DBA on 27 September 2014

Development, Leadership, Age

While I was at the VMWare HQ getting some amazing training a few weeks ago, we had the opportunity to meet a large number of “C” level people from that organization and Pure Storage. In addition, they had multiple development and project management leads come and talk to us. All… Read more

2 comments, 126 reads

Posted in The Scary DBA on 26 September 2014

Thoughts on PASS Board Nomination Process: #passvotes

Having very recently gone through the nomination process for the PASS Board, I thought I would share a few things about it. Overall, it was a great experience. I feel that I really had to stretch to meet everything required of me. It was quite difficult to put together all… Read more

10 comments, 105 reads

Posted in The Scary DBA on 24 September 2014

SQL Server Query Performance Tuning

The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition of the book, and the third edition that I’ve been responsible for. At the urging of my editor, Jonathan Gennick, I have completely restructured the book for this release. The… Read more

4 comments, 167 reads

Posted in The Scary DBA on 23 September 2014

Communication and the Board: #PASSVotes

The whole idea behind PASS is to build a community of people who can assist each other in their daily work lives. PASS succeeds at that wonderfully. Further, PASS, the organization, tries extremely hard to let you know what it’s doing and how it’s doing things. You can read the… Read more

1 comments, 126 reads

Posted in The Scary DBA on 22 September 2014

A Manager or a Community Person: #PASSVotes

I am running for the PASS Board. You can read more about what I’ve posted and what others have to say here on this page.

Today I want to ask you a question. Should someone on the board be a manger or should they be a community person? Let’s… Read more

4 comments, 134 reads

Posted in The Scary DBA on 19 September 2014

I Am Running For the PASS Board of Directors: #passvotes

This year, I submitted my application to run for the PASS Board and it was accepted. This then is my announcement to all of you and the beginning of my campaign for election. My name is Grant Fritchey and I’m running for the PASS Board.

It’s traditional to either make… Read more

2 comments, 5,696 reads

Posted in The Scary DBA on 17 September 2014

Older posts