DBA Art

/Arthur Daniels

About Arthur Daniels

This author has not yet filled in any details.
So far Arthur Daniels has created 7 blog entries.

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 [...]

Setting up your own (free) local SQL Server for testing

By | 2016-12-12T09:23:34+00:00 December 12th, 2016|Categories: Tutorials|Tags: , , , , , |

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 [...]