Centralized Management Server 101
Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...
2016-10-24 (first published: 2016-10-16)
5,112 reads
Sheldon Hull
Diff All Files - Reviewing Changesets Quickly
Update: 2017-07-14
Still find this incredibly awesome! Developer just updated for Visual Studio 2017 after a lot of hard work. Github...
2016-10-12
268 reads
Diff All Files - Reviewing Changesets Quickly
If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension...
2016-10-12
800 reads
Migrating Database Collation - The Red Gate Way
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
110 reads
Migrating Database Collation - The Red Gate Way
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
350 reads
Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
143 reads
Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
3,839 reads
SQL 2016 - Configuration Manager Not Showing in Start Menu
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-21
95 reads
SQL 2016 - Configuration Manager Not Showing in Start Menu
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-30 (first published: 2016-09-21)
1,933 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)However, once the SQL instance is restarted this flag...
2016-09-19
145 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers