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
401 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
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
87 reads
Regex With SQL Server - SQLSharp
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-11
176 reads
Improvements with SSMS 2016
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,622 reads
Glasswire: (Giveaway Included) Networking Monitoring even a caveman could use
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,466 reads
SQL Compare 12: Initial Look
I know there have been a few other folks going into more detail on SQL Compare 12 (beta), but I...
2016-06-25
467 reads
OmniCompare: A free tool to compare SQL Instances
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,867 reads
SSMS Tools Pack - A Handy Tool for generating CRUD
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,931 reads
The Mysterious Black Box of R - For the SQL Server Guy
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,939 reads
Continual Deployment of Visual Studio SqlProj
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,243 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