Database Mirroring Needs FQDNs
A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things,...
2017-07-03
469 reads
Toolbox - Where Did All My Space Go?
This is the first in a new series of blogs I am going to create talking about useful tools (mostly...
2017-07-14 (first published: 2017-07-03)
2,180 reads
SQL Homework – July 2017
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...
2017-07-03
413 reads
24 Hours of PASS, Summit Preview Session
I’m proud to announce that I’ve been selected to present a session in this year’s 24 Hours of PASS: Summit...
2017-07-03
349 reads
Creating the SSIS Catalog
If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually...
2017-07-03
705 reads
Building Always On Availability Groups - Part 1
Introduction
By David Postlethwaite
Ensuring that your databases can survive a major outage such as a server failure and can continue to...
2017-07-14 (first published: 2017-07-03)
2,194 reads
Monday Coffee: Alerts & Checks
Hope you all had a good weekend, the Lions won so I’m pretty happy.
Over the weekend I was thinking about...
2017-07-03
358 reads
Update SSMS With PS1
With how many updates are coming out I threw together a script to parse the latest version from the webpage,...
2017-07-12 (first published: 2017-07-03)
1,627 reads
Capture Important Parameters of the SQL Server Replication
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,702 reads
Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,956 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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