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 [...]
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 [...]
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'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.
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 [...]
This post is designed for anyone who wants instructions on creating a SQL Server instance on any computer you'd like. At the time of writing this post, none of these steps cost any money, just some of your time and disk space on your computer. You'll need: A free Microsoft account Access to the Internet Disk [...]