Thoughts on Performance Tuning methodology

By | 2017-07-20T06:02:23+00:00 July 20th, 2017|Categories: Uncategorized|

This post is going to be a change of pace for the blog. I want to talk about how I approach performance tuning, specifically when talking about queries. This won't be a tutorial, just somewhat of a journal post. The other day, I was working on optimizing a query in a development environment with another database [...]

Using Live Query Statistics on older SQL Servers

By | 2017-06-12T16:56:28+00:00 June 12th, 2017|Categories: Uncategorized|Tags: , , , , |

First, thanks to everyone who attended my session at SQL Saturday #634 Iowa City! I spoke about execution plans and how to begin reading them. Here's a link to my session. I had an attendee come up afterwards who mentioned that Live Query Statistics could be used with the newest version of Management Studio to watch [...]

Presentation Demo Scripts

By | 2017-03-03T06:56:30+00:00 March 3rd, 2017|Categories: Uncategorized|

As promised in my session, I'm uploading my demo scripts here. You'll also need a copy of the AdventureWorks 2014 demo database. That can be downloaded from Microsoft's site. I've compressed the demos to one zip file. Execution Planning for Success Demos   Please comment here if you have any questions.

I’m presenting at Iowa SQL Server User Group!

By | 2017-02-22T19:16:19+00:00 February 22nd, 2017|Categories: Uncategorized|

I'll be at Gravitate (Link) on Thursday, 2/23/2017 at 6 PM for my first presentation! The subject is "Execution Planning for Success!" Click here to download my presentation: Execution Planning for Success I'll be posting the demos after the presentation for anyone who would like to run the demos themselves.

Dude, Where’s my (database) backups

By | 2017-04-10T05:59:45+00:00 December 19th, 2016|Categories: Uncategorized|

I'm writing this post for myself 3 years ago. I had just graduated college and received my first job offer, Associate BI Developer. I knew nothing about SQL Server as a product, I had just used Management Studio a lot. In this series of posts, labelled by day number, I want to talk about the things [...]