-->
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 #14: Modifying Data Through SSMS

I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data manipulation is not the preferred mechanism. T-SQL is the right way to manipulate the data in your database. For purposes of completion though, I will show the GUI methods in… Read more

2 comments, 112 reads

Posted in The Scary DBA on 16 October 2017

Database Fundamentals #13: Data Entry Through T-SQL

T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t be typing everything into T-SQL directly as we’ll do here. You’ll be able to use stored procedures and parameters to automate the use of scripts. These will also be generated… Read more

3 comments, 160 reads

Posted in The Scary DBA on 11 October 2017

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

2 comments, 158 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, 177 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

4 comments, 1,642 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

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

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

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

7 comments, 143 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, 171 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, 232 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, 840 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, 108 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, 252 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, 637 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, 36 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,207 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,926 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

Older posts