Azure SQL Data Warehouse is now GA
The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available. Here is the official...
2016-07-13
585 reads
Blog Posts
Database Mail Breaks with TLS 1.0 Disabled
Discovery I ran across an issue where I had just configured database mail on a new server, went to send...
2016-07-13 (first published: 2016-07-05)
1,884 reads
Does my database have data type drift?
Over the years I have come to see that every database has what I call data type drift. Simply put,...
2016-07-13 (first published: 2016-06-28)
2,505 reads
Getting Started with Database DevOps, DLM, and New Tools
Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh...
2016-07-13
568 reads
Live from @LearningTree London - Security Day - Day 2
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-13
381 reads
Source Control for the Reluctant DBA
This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I...
2016-07-13
916 reads
SQL Server – How to retrieve SQL plans from Cache
Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache....
2016-07-13
656 reads
SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features...
2016-07-13
1 reads
SQL Server Desired Enhancements
Happy Belated Birthday
The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month...
2016-07-13
513 reads
Thanks, Karla
I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting...
2016-07-13
496 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