Microsoft Certifications
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
527 reads
All About SQL
Azure SQL Database – TDE
I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...
2016-10-10
444 reads
SQL Performance Dashboards – update
SQL Server Performance Dashboards – update The first article that I ever wrote (http://www.sqlservercentral.com/articles/SQL+Server/127992/) was last year where I wanted to...
2016-10-07
624 reads
ALTER INDEX….ABORT!
I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...
2016-10-06
480 reads
Detaching corrupt databases
Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...
2016-10-04
597 reads
Query Store – Quick Tour
The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”....
2016-10-03
452 reads
My application to Microsoft
I have been eager to write this blog post for a while now. I want to share my experience of...
2016-09-29
878 reads
SSMS 2016& Azure SQL DBs
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,493 reads
Azure SQL Data warehouse
For this blog post I want to show you the steps required to setup an Azure SQL Data warehouse and...
2016-09-21
518 reads
SSMS Keeps Crashing
It is quite frustrating when SSMS (SQL Server Management Studio) randomly crashes, all too often for my liking. If you have...
2016-09-20
1,859 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