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

Database Fundamentals #12: Adding Data with SSMS GUI

In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing you how to use the GUI. What’s up?

Why the GUI?

It’s a very simple reason. I want to show you what it is so that I’m not hiding things.… Read more

0 comments, 80 reads

Posted in The Scary DBA on 25 September 2017

Azure, PowerShell, Databases and the PASS Summit

I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform conference in the world, PASS Summit 2017.

Now, I’m excited to say that I get to speak on three topics that are near and dear to my heart, Azure, PowerShell… Read more

3 comments, 152 reads

Posted in The Scary DBA on 19 September 2017

Database Fundamentals #11: Why Learn T-SQL

If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and a database with a table in it. You may have more if you’ve been practicing. Now would be the time to start adding data to the database, but first, I… Read more

1 comments, 1,459 reads

Posted in The Scary DBA on 18 September 2017

Speaking at IT/DevConnections 2017

If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at IT/DevConnections 2017 doing several talks.

First, I have an all day pre-con on the tools needed for query tuning. Then I have two regular sessions, DevOps for the DBA Read more

0 comments, 134 reads

Posted in The Scary DBA on 13 September 2017

Database Fundamentals #10: Modifying Tables

Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change or that you’ve made a mistake. Either way, you will need to modify the tables that you’ve created. Change is inevitable and luckily SQL Server takes that into account, providing… Read more

0 comments, 140 reads

Posted in The Scary DBA on 12 September 2017

Database Fundamentals #9: Schemas As Containers

Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas provide you with another tool to control how your database behaves.

Schemas

The tables created so far in this blog series have all been attached to a schema, dbo. Depending… Read more

0 comments, 1,782 reads

Posted in The Scary DBA on 6 September 2017

Luck and the PASS Summit

I recently read an article asking the question whether or not we downplay the role that luck plays in our lives and I immediately thought of the PASS Summit.

Obscenely Lucky

I am, quite frankly, embarrassingly, obscenely, stupidly lucky.

I just am.

I married WAY over my head. I stumbled… Read more

5 comments, 131 reads

Posted in The Scary DBA on 5 September 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, 154 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

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

4 comments, 792 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

1 comments, 95 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

1 comments, 234 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, 621 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, 29 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, 30 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,165 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

7 comments, 1,854 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, 27 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, 32 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, 258 reads

Posted in The Scary DBA on 14 August 2017

Older posts