Delayed durability, the TURBO button for your transaction log
As noted in the previous post, this month I got my learn on at Tech Outbound’s SQL Cruise Alaska. Which was awesome in so many ways, but I’m only...
2018-08-29
19 reads
MAXDOP Calculator
Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance...
2018-08-28
14,267 reads
What is Automatic Tuning in Azure SQL Database
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
524 reads
How Do Azure Accounts and Subscriptions Work Together?
Azure accounts vs. Azure subscriptions – often a topic that brings some confusion to Azure newbies. Are they the same? What’s...
2018-08-28
212 reads
Upcoming Performance Tuning Webcast
On September 13, 2018, at 3 PM Eastern (USA), I’ll be giving a webcast for MSSQLTips.com on finding and correcting...
2018-08-28
217 reads
Redgate Lives DevOps
At Redgate, we release a lot of changes to our products. In fact, this is the “About Redgate” slide I’ve...
2018-08-28
1,117 reads
Generating a Constrained Random Date–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-08-28
1,231 reads
Ignoring NULLs with FIRST_VALUE
Watch this week’s episode on YouTube.
The SQL Server FIRST_VALUE function makes it easy to return the “first value in an...
2018-08-28
8,993 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
26 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
19 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers