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
399 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
818 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
277 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
356 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
112 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,867 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
145 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,948 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,764 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
103 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers