-->
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: August 2017

Ich werde Deutschland beriesen

Guten Tag!

OK, switching back to English for the rest of this.

I’m going to be spending a few weeks in Germany on a private tour, no work. That means that, no, I’m very sorry, I can’t speak at your user group, even though I’d love to. Next time.

However,… Read more

2 comments, 175 reads

Posted in The Scary DBA on 30 August 2017

Database Fundamentals #8: All About Data Types

SQL Server provides all different kinds of data types in order to give you more flexibility and control for how you store your data. You define these data types as you define the columns in your tables. If you wanted to store information about the date and time that a… Read more

6 comments, 238 reads

Posted in The Scary DBA on 29 August 2017

Database Fundamentals #8: All About Data Types

SQL Server provides all different kinds of data types in order to give you more flexibility and control for how you store your data. You define these data types as you define the columns in your tables. If you wanted to store information about the date and time that a… Read more

6 comments, 846 reads

Posted in The Scary DBA on 29 August 2017

Speaking at Live360 Orlando

Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak at SQLServerLive, part of the Live360 event. It takes place November 12-17 at the Royal Pacific Resort at Universal Studios in Orlando.

I’m going to be presenting three different… Read more

2 comments, 109 reads

Posted in The Scary DBA on 28 August 2017

Speaking at Live360 Orlando

Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak at SQLServerLive, part of the Live360 event. It takes place November 12-17 at the Royal Pacific Resort at Universal Studios in Orlando.

I’m going to be presenting three different… Read more

2 comments, 254 reads

Posted in The Scary DBA on 28 August 2017

Redgate Hub LiveStream

Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub. Check it out. To help you understand this new resource, and to show off some cool new material, we’ve decided to host a livestream event, Redgate Hub Launch on… Read more

0 comments, 638 reads

Posted in The Scary DBA on 23 August 2017

Redgate Hub LiveStream

Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub. Check it out. To help you understand this new resource, and to show off some cool new material, we’ve decided to host a livestream event, Redgate Hub Launch on… Read more

0 comments, 35 reads

Posted in The Scary DBA on 23 August 2017

Runtime Metrics In Execution Plans

Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re using SQL Server 2016 SP1 or better in combination with SQL Server Management Studio 2017. When you capture an actual plan (using any method), you get the query execution time… Read more

3 comments, 37 reads

Posted in The Scary DBA on 22 August 2017

Runtime Metrics In Execution Plans

Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re using SQL Server 2016 SP1 or better in combination with SQL Server Management Studio 2017. When you capture an actual plan (using any method), you get the query execution time… Read more

3 comments, 1,212 reads

Posted in The Scary DBA on 22 August 2017

Bad Parameter Sniffing Decision Flow Chart

Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to help with this, I’m going to try to make a decision flow chart to walk you through the process. This is a rough, quite rough, first draft.

I would love… Read more

8 comments, 1,931 reads

Posted in The Scary DBA on 15 August 2017

Bad Parameter Sniffing Decision Flow Chart

Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to help with this, I’m going to try to make a decision flow chart to walk you through the process. This is a rough, quite rough, first draft.

I would love… Read more

7 comments, 32 reads

Posted in The Scary DBA on 15 August 2017

PASS Summit 2017

Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet? Sure you do.

PASS Summit 2017 is coming up. Now is the time to register for this unique event.

This year I’ve been honored to be able to present a… Read more

1 comments, 36 reads

Posted in The Scary DBA on 14 August 2017

PASS Summit 2017

Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet? Sure you do.

PASS Summit 2017 is coming up. Now is the time to register for this unique event.

This year I’ve been honored to be able to present a… Read more

1 comments, 282 reads

Posted in The Scary DBA on 14 August 2017

IT/Dev Connections 2017

I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San Francisco. I’m not just speaking there, I’m presenting an all day seminar on the tools needed for query tuning.

The title does say SQL Server 2016, but most of the… Read more

0 comments, 175 reads

Posted in The Scary DBA on 9 August 2017

IT/Dev Connections 2017

I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San Francisco. I’m not just speaking there, I’m presenting an all day seminar on the tools needed for query tuning.

The title does say SQL Server 2016, but most of the… Read more

0 comments, 27 reads

Posted in The Scary DBA on 9 August 2017

Database Fundamentals #7: Create a Table Using T-SQL

The syntax for creating a table logically follows many of the same steps that you did when using the GUI, but it will all be done with the statements. This script will exactly replicate everything that you did with the GUI:

CREATE TABLE dbo.Person (
PersonID int IDENTITY(1,1) NOT…

Read more

1 comments, 36 reads

Posted in The Scary DBA on 7 August 2017

Database Fundamentals #7: Create a Table Using T-SQL

The syntax for creating a table logically follows many of the same steps that you did when using the GUI, but it will all be done with the statements. This script will exactly replicate everything that you did with the GUI:

CREATE TABLE dbo.Person (
PersonID int IDENTITY(1,1) NOT…

Read more

1 comments, 138 reads

Posted in The Scary DBA on 7 August 2017

There Is a Magic Button, a Rant

OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest of you. We know something that you don’t. I don’t think we should hide this secret from the world any more.

Illuminati? Incompetents. Free Masons? I am one, so I… Read more

10 comments, 276 reads

Posted in The Scary DBA on 1 August 2017

There Is a Magic Button, a Rant

OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest of you. We know something that you don’t. I don’t think we should hide this secret from the world any more.

Illuminati? Incompetents. Free Masons? I am one, so I… Read more

10 comments, 24 reads

Posted in The Scary DBA on 1 August 2017