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
76 reads
Blog Posts
Remember the Alamo (with a SQL Saturday nearby)
This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance...
2016-08-15
553 reads
SQLSaturday Indianapolis Wrap-Up
This weekend, I attended SQLSaturday in Indianapolis for the first time. It’s one of the larger events in the Midwest...
2016-08-15
467 reads
Temper, Temper
Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a...
2016-08-15
1,049 reads
What is Enterprise Architecture?
This is an interesting question. Lets look at couple of definitions starting with Wikipedia’s definition
“Enterprise architecture (EA) is "a well-defined...
2016-08-15
501 reads
CJIS and the Microsoft Cloud
Having a cloud you can trust is important. Microsoft takes security and compliance extremely seriously in both the commercial and government...
2016-08-12
590 reads
Dreaming of SQL Saturday
I’m truly stunned at the responses I received to my post asking how far people have traveled for a SQL...
2016-08-12 (first published: 2016-08-03)
1,422 reads
Next for the PoSh VC: PowerShell, SQL and Power BI
That’s right, PowerShell & Power BI. How does this work you ask? Well back in July, Rob Sewell ( b | t ) gave us a preview of this,...
2016-08-12
6 reads
Next for the PoSh VC: PowerShell, SQL and Power BI
That’s right, PowerShell & Power BI.
How does this work you ask?
Well back in July, Rob Sewell ( b | t ) gave us...
2016-08-12
236 reads
Slash star, dash dash: Be obsessive about comments
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the...
2016-08-12 (first published: 2016-08-08)
1,992 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers