TGI SQL Friday – Weekly round up Friday 12 August 2016
This week has seen the launch of my new SQL Server newsletter in conjunction with Learning Tree. If you would...
2016-08-12
361 reads
Blog Posts
Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,448 reads
Current Running Queries
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,062 reads
Do YOU Checksum?
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
201 reads
Opening .SQL Files in SSMS 2016 by Default #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-11
10,891 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
173 reads
Tricky TSQL: NOT IN (NULL)
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means...
2016-08-11
1,034 reads
Write-Only permissions
Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other...
2016-08-11
616 reads
Feasel’s Grand Analysis of the PASS 600 mile radius rule
UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius...
2016-08-10 (first published: 2016-08-01)
1,191 reads
Inside the mind of a c# developer
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
620 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