-->
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: September 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, 157 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,637 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, 153 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,860 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, 142 reads

Posted in The Scary DBA on 5 September 2017