Does sp_rename on a column preserve the ms_description?
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
386 reads
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
386 reads
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
73 reads
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-11
163 reads
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However,...
2016-07-19 (first published: 2016-07-11)
3,609 reads
Giveaway details at the bottom for those interested
Dealing with development & sql servers, I like to know what type of network...
2016-07-01
1,041 reads
I know there have been a few other folks going into more detail on SQL Compare 12 (beta), but I...
2016-06-25
453 reads
comparing instances
When working with a variety of instances, you can often deal with variances in configuration that might impact the...
2016-06-22 (first published: 2016-06-14)
2,816 reads
So I've had this tool around for a while, but never found much usage out of it to be honest....
2016-06-17
2,458 reads
Took a class from Jamey Johnston @ SQLSaturday #516 in Houston. Lots of great information covered. Follow him for a much...
2016-05-20 (first published: 2016-05-14)
2,925 reads
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,186 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