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,757 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
467 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,605 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
539 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
413 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,657 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
466 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers