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-16
396 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
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
812 reads
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
273 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
353 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
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,860 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
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,947 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...
2016-09-26 (first published: 2016-09-19)
1,758 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
100 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers