-->
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 2015

PASS Summit 2015: So Far

It’s Kilt Day!

I want to give a quick assessment on how the Summit has been for me so far. Monday, as is true for the rest of the week, I served two masters. In the morning I went to the Redgate SQL in the City event. In the afternoon… Read more

1 comments, 459 reads

Posted in The Scary DBA on 29 October 2015

Talk to Me at PASS Summit

If you’re going to PASS and you want to have a chat, I want to talk to you. If it’s about the Board of Directors for PASS, PASS Chapters, execution plans, crossfit or something else, here are a few places where I’ll be doing my best to make myself available: Read more

0 comments, 372 reads

Posted in The Scary DBA on 23 October 2015

ZOOMIT!

Guilty.

I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.

I want to take a moment and explain why I did it and why it was wrong.

I was frustrated. I’m watching a presentation on a HUGE screen, from about mid-way in the… Read more

9 comments, 414 reads

Posted in The Scary DBA on 22 October 2015

Statistics for the New Data Pro

Next week at the PASS Summit I’ll be presenting a session called Statistics for the New Data Pro.

You can read the abstract at the link. I just want to emphasize that this is a beginner level session. I think way too many people who are just starting out… Read more

0 comments, 263 reads

Posted in The Scary DBA on 20 October 2015

Getting Started With DocumentDB

I’ve put this off for too long. It’s time to get my feet wet with some new tech.

Step 1 is easy. Go to the Azure portal and start the process for creating a DocumentDB:

While that’s running, let’s see what’s on the interwebs about getting started in DocumentDB…

Nice.… Read more

2 comments, 370 reads

Posted in The Scary DBA on 14 October 2015

Argenis Without Borders: Fun For a Good Cause

This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we hit the fund-raising goal and I wore the rainbow fuzzy leggings at the PASS Summit. This year, it feels like we’re a little behind the goal. We need you to… Read more

2 comments, 337 reads

Posted in The Scary DBA on 12 October 2015

Trace Flags in Azure SQL Database

One of the ways that you take more direct control over your SQL Server instances is through the use of trace flags. There are a number that people recommend you enable by default. Prior to Extended Events for example, I’d say you should turn on trace flag 1222 in order… Read more

1 comments, 835 reads

Posted in The Scary DBA on 5 October 2015

Speaker of the Month: October 2015

Working on my third year of “Speaker of the Month” posts now. The good news, I haven’t run out of people to award it to. Most months, if I’ve been able to go to a community event or two, I have three or four candidates.  Same this month.

Speaker of… Read more

5 comments, 337 reads

Posted in The Scary DBA on 2 October 2015