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
387 reads
Sheldon Hull
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
164 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-17 (first published: 2016-08-11)
3,256 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,610 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,046 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
454 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,507 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,819 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,195 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,925 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers