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

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

2 comments, 149 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

3 comments, 103 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, 102 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, 89 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, 4,359 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, 110 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, 101 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, 106 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, 105 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

20 comments, 88 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

2 comments, 125 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, 109 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, 112 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,521 reads

Posted in The Scary DBA on 17 September 2014

PASS Summit 2014 Pre-Conference Seminar

I’m putting on a pre-conference seminar (also known as a pre-con) at the PASS Summit this year. I’m really honored to be able to present this and I’m pretty excited about it. So, if you want to talk query tuning, let’s get together at the Summit. For a few fun… Read more

0 comments, 135 reads

Posted in The Scary DBA on 16 September 2014

Podcast on Devops and the Database

I’ve been attempting to expand my reach to get back to my roots in development. I’m doing this because I really believe in the concepts behind devops, that these walls we’ve erected between development and dba, between dba and san admin, et, ad nauseum, cetera, need to come to an… Read more

2 comments, 123 reads

Posted in The Scary DBA on 15 September 2014

Statistics in SQL Server

I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those for SQL Server 2014. The changes in the cardinality estimator can’t be ignored. If you want to talk about statistics, I’ll be presenting at Live360 in November on that topic… Read more

0 comments, 6,607 reads

Posted in The Scary DBA on 10 September 2014

It’s All Fundamentals

I’m learning how to speak German. Interestingly enough, you don’t start off reading dissertations. Instead, you begin by learning the names of things, Teller for plate, Buch for book. The fundamentals. I’m a third degree black belt in Ken Ryu Kenpo. But you don’t start that, or continue it, by… Read more

6 comments, 166 reads

Posted in The Scary DBA on 9 September 2014

Speaker of the Month: September 2014

This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to meet a lot of new people and see presentations by people that just don’t hang around SQL Server specific events. It was great. I’m going to apply next year (depending… Read more

0 comments, 125 reads

Posted in The Scary DBA on 5 September 2014

Left or Right?

No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a canard that still makes the rounds occasionally. Please, help me put this statement to sleep for once and all:

A function on the left side of the equals…

Read more

10 comments, 5,849 reads

Posted in The Scary DBA on 3 September 2014

Older posts