Getting started Someone calls you at 1 AM on Saturday and says, "Is there an issue with SQL?" First, breath and take a look at your logs. This post is about two places you can take a look to see if there's an issue, quick, so you can get back to sleep. Especially when I was [...]
Why pick my session? Hi, I'm Arthur Daniels. I'm presenting Reading Execution Plans Successfully at SQL Saturday Nashville. If you're considering attending my session, I'd really like to see you there! I deal with execution plans daily. They can be really gnarly, and it takes a lot of time to work through the larger execution plans. I [...]
Well, this is my first T-SQL Tuesday! Here's the original post: link. I'm very excited to participate. The host for this month is Ewald Cress (blog | twitter ) and the subject is talking about people who've made a difference. I've been working with SQL Server for a few years and I have many people to [...]
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 [...]