Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2017-08-09 (first published: 2017-07-25)
7,704 reads
SQL Server Management Studio: Video Tutorial
SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server....
2017-07-25
465 reads
Sudden Differential Backup Failures after an Availability Group Failover
As so many stories do, this story starts with a failover - in this case an Availability Group (AG) failover.
https://cdn.meme.am/cache/instances/folder984/400x/59300984.jpg
There were...
2017-07-24
1,601 reads
Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl
This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will...
2017-07-24
299 reads
FizzBuzz–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-07-24
545 reads
Database Fundamentals #6: Create a Table with the SSMS GUI
The whole idea behind databases is to store information, data, in order to look at it later. The place where...
2017-07-24
536 reads
SQL Summer Vacation–SentryOne
We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL...
2017-07-24
412 reads
SQL Server on Linux Series: Additional Drives
One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if...
2017-08-09 (first published: 2017-07-24)
1,655 reads
Upcoming SQL Server User Group Presentations
I’ll be speaking at two New England area SQL Server user groups in the next few days! First, tonight I’ll...
2017-07-24
302 reads
Default SQL Agent Reports – Top Jobs
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several...
2017-07-24
464 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers