Performance Problem When Using OR In A JOIN
I recently had a developer come to me with a poorly performing query. As you will see below, it’s a fairly straight forward query, consisting of one table with one …
Using PowerShell To Store sp_BlitzIndex Results In A Table
I really like Brent Ozar’s sp_BlitzIndex procedure. It offers a lot of great insight into the indexes in your databases. If you are not currently using it, you should check it …
Finding Recurring Index Fragmentation Issues
One of the nice things about Ola Hallengren’s maintenance solution is that it has the option to log its operations to a table. This gives you ability to do a …
Survey Results From My Adobe ColdFusion Summit 2016 Session
One of the really cool things that Adobe did at this year’s ColdFusion Summit was to have a mobile app for the conference that allowed attendees to rate sessions and …
Slides From Adobe ColdFusion Summit 2016
The slides from my session, Building Better SQL Server Databases, are attached here. As always, I try to put a good deal of content in the slides so people …
Discover Which Deprecated Features Are Being Used
With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated. These deprecated features are not immediately disabled …
Slides From Dev Data Day 2016
Dev Data Day 2016 wrapped up yesterday, and I really enjoyed it. The organizers did a fantastic job, and I think everything flowed exceptionally well, especially considering that this was …
Speaking At Dev Data Day 2016
If you’re in the Birmingham, AL area this Saturday (August 20, 2016), come join me at Dev Data Day at Samford University, where I’ll be presenting SQL Server Tips For …
You Can Now Specify MAXDOP For DBCC CheckDB!
I just stumbled on this today. According to the DBCC CheckDB documentation, as of SQL Server 2014 Service Pack 2 you can now specify MAXDOP when running DBCC CheckDB! The documentation states: …
Speaking At Adobe ColdFusion Summit 2016
I’m excited to announce that I will be speaking at the 2016 Adobe ColdFusion Summit! The conference is October 10th-11th, in Las Vegas. I am honored to have been asked to speak at this conference, as …
Stored Procedures Ignore User’s Permissions
So, that title may be a little misleading to some. It is not meant as a blanket statement about all procedures and all permissions, but rather a specific situation that …
Resolving Write Error When Backing Up Database Master Key
This blog post is more for my own personal notes so that I don’t bang my head against the wall so much next time, but hopefully it will help someone …
Deploy An SSIS Project To A Different Domain
Occasionally I run into a situation where I need to deploy an SSIS Project to a server on a different domain than my local PC is on. A lot of …
Slides from dev.Objective() 2016
dev.Objective() 2016 was last week and I have to say I really enjoyed it. It was good to get back in touch with some old friends as well as make …
Speaking at dev.Objective() 2016
I’m happy to announce that I have been selected to speak at dev.Objective() 2016! The conference, which covers a wide variety of topics relating to web and software development, will be held in Minneapolis, …
List All Foreign Keys Referencing A Table In SQL Server
There may be times that you need to get a list of tables that have foreign key constraints back to a table that you’re working on. Fortunately, SQL Server has a built …
What Features Are Disabled Between Compatibility Levels In SQL Server?
Have you ever wondered what features may or may not be available when your database is running in a different compatibility level than your SQL Server version? I recently came …
Index Basics: Nonclustered Indexes, Part 1
In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …