SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly,
May 3, 2018 Update: I have added a SQL Server 2016 SP2 version of the queries, since Microsoft back-ported so many new queries from SQL
This month, there are more minor updates to the SQL Server 2014 and newer versions of the queries, primarily in the comments and documentation. I
The third week of March 2018 has seen a plethora of SQL Server related software updates from Microsoft. These include: SQL Server 2017 CU5 SQL
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I have made
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I have developed
If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you should be doing to protect your systems
Over the last couple of days, you have probably heard quite a bit of chatter and speculation about some newly disclosed ways to attack various
Background Since the SQL Server 2005 release, SQL Server has had the default ability to collect metrics about what the query optimizer thinks are “missing”
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. There is also
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I often make
This month, I have added a set of diagnostic queries for Azure SQL Database. These are very much a work in progress, and they will
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.