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
386 reads
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
386 reads
If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension...
2016-10-12
758 reads
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
252 reads
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
343 reads
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
108 reads
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
3,642 reads
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
139 reads
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,872 reads
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,718 reads
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-21
90 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers