Click here to monitor SSC
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).

Presentations for SQL Server Beginners

Tired from all those blog posts

For my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a set of presentations from the PASS Virtual Chapters. This content is available online. It’s free. Most importantly for the person just getting started as a SQL Server data pro,… Read more

3 comments, 157 reads

Posted in The Scary DBA on 5 December 2016

Database Clone

There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is another. There are even third party tools that will help with that. However, each of these has a problem. It’s moving all the data, not just once, but twice. You… Read more

1 comments, 133 reads

Posted in The Scary DBA on 28 November 2016

PowerShell to Test a Query

So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not a problem. Here’s a very rough script that I use to do some recent testing.

This script to test a query is post #11 of the #enterylevel #iwanttohelp effort started… Read more

4 comments, 249 reads

Posted in The Scary DBA on 23 November 2016

SQL Server on Linux: Boring

As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of taking advantage of everything that SQL Server offers. Because we have Linux, we have opportunity for all sorts of new fun.

I first saw SQL Server running on Linux about… Read more

19 comments, 219 reads

Posted in The Scary DBA on 22 November 2016

Query Data Store Data

The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics of a query to the various plans in use by that query to being able to force a plan, it’s all controlled by the data within the Query Data Store… Read more

1 comments, 842 reads

Posted in The Scary DBA on 21 November 2016

Book Review: Marshmallow Test

Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough and I’m not good enough. Don’t get me wrong, I’ve got an ego (way too big of one really). I just know that there’s room for improvement. It’s one of… Read more

2 comments, 128 reads

Posted in The Scary DBA on 18 November 2016

Azure Data Platform Learning Resources

I know that more and more of you are moving more and more resources into the Azure Data Platform. In an effort to help you learn about all that Azure offers I created a GitHub repository of blogs, teachers, courses, etc. It’s open to the community to update. New material… Read more

1 comments, 294 reads

Posted in The Scary DBA on 9 November 2016

PASS Board Update: Post-Summit 2016

Monday

I got in on Sunday and chose to have a small dinner with a couple of friends, quiet, preparing.

Monday was a less hectic day than the others . The Board had the morning off, although Redgate had me go and give a session at an event. Monday afternoon… Read more

2 comments, 143 reads

Posted in The Scary DBA on 8 November 2016

sp_executesql Is Not Faster Than an Ad Hoc Query

This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You must parameterize your T-SQL because the lack of parameters in building up and executing strings is a classic SQL Injection attack vector. Using straight ad hoc T-SQL is an extremely… Read more

0 comments, 604 reads

Posted in The Scary DBA on 7 November 2016

Reinforcing the Importance of Statistics on Row Estimate

I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they are during my own work.

Bad Estimate

I hit a weird problem while I was setting up a query to illustrate a point (blog to be published next week).… Read more

1 comments, 848 reads

Posted in The Scary DBA on 3 November 2016

Stored Procedures Are Not Faster Than Views

A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”

<sigh>

Let’s break this down, just a little.

Definitions

A view is nothing but a query. The definition given by Microsoft is that it’s a virtual table that’s defined by a query. It’s a… Read more

3 comments, 2,429 reads

Posted in The Scary DBA on 1 November 2016

A Sub-Query Does Not Hurt Performance

The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”

Truly?

Where do people get these things?

Let’s Test It

I’ve written before about the concept of cargo cult data professionals. They see one issue, one time, and consequently extrapolate that to… Read more

8 comments, 914 reads

Posted in The Scary DBA on 24 October 2016

SQL Cruise as a Speaker and Sponsor

SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, several times, about the benefits of SQL Cruise. As an attendee of the cruise, you will get to sit in classes by amazing people (and me) talking about all aspects… Read more

2 comments, 759 reads

Posted in The Scary DBA on 18 October 2016

SELECT * Does Not Hurt Performance

I read all the time how SELECT * hurts performance. I even see where people have said that you just have to supply a column list instead of SELECT * to get a performance improvement. Let’s test it, because I think this is bunkum.

The Test

I have here two… Read more

10 comments, 3,782 reads

Posted in The Scary DBA on 17 October 2016

Pre-Summit PASS Board Update

Busy, busy, busy.

A lot of the work around PASS currently is getting ready for Summit. I’m prepping my part in the keynotes. I’m involved in lots of community discussions including SQLSaturday, Chapters and Regional Mentors. We’re setting up the Community Zone for all sorts of activities throughout the week.… Read more

0 comments, 130 reads

Posted in The Scary DBA on 11 October 2016

Statistics Are Vital For Query Performance

This is post #10 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.

When you send a query to your SQL Server database (and this applies to Azure SQL Database, APS, and Azure SQL Data Warehouse), that query is going to go through… Read more

1 comments, 1,675 reads

Posted in The Scary DBA on 10 October 2016

Where Do We Go To Share?

No one reads blogs any more.

Twitter is dying.

Facebook is broken.

LinkedIn? Please.

G+. Is that even on any more?

Where do we go to share?

I’m seeing it here on this blog. Traffic is down. Not just day-to-day traffic, but the search hits. That could just be that… Read more

10 comments, 214 reads

Posted in The Scary DBA on 5 October 2016

Correlated Datetime Columns

SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of Correlated Datetime Columns. They were evidently introduced as a database option in SQL Server 2005 to help support data warehousing style queries (frequently using dates and times as join criteria… Read more

1 comments, 1,239 reads

Posted in The Scary DBA on 3 October 2016

Azure Data Platform Resources

A few months ago I created a GitHub repository for the purpose of building and maintaining a list of resources for Azure Data Platform training. You can see it here. My goal in putting this into GitHub instead of just running it on my blog is to make it… Read more

2 comments, 283 reads

Posted in The Scary DBA on 30 September 2016

Volunteering With PASS

I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive one. That made me start thinking. At my very first Summit, I met a couple of volunteers for PASS (Allen Kinsel was one of them, I’ll blame him… Read more

0 comments, 169 reads

Posted in The Scary DBA on 29 September 2016

Older posts