Microsoft 365 Security and Compliance for Administrators, a Book Review
I was asked to review the following book by the publisher, and I must say that it was a good experience for me. I used the book to help...
2024-07-22
14 reads
Blog Posts
Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics
This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how this works (and how it doesn’t). This is part of a series of posts on...
2024-07-22
70 reads
Set a Runtime Variable in an Azure DevOps Pipeline
Note: I DO NOT recommend this. Any changes to a pipeline should be in code and through a PR. That being said, I know this information is out there...
2024-07-22 (first published: 2024-07-05)
337 reads
A New Word: Solysium
solysium – n. the unhinged delirium of being alone for an extended period of time – feeling the hours stretch into days until a weird little culture begins to...
2024-07-19
31 reads
Not Selected for the PASS Data Community Summit 2024
I got this in an email about a week ago from the PASS Data Community Summit. There’s more to it, but essentially I submitted 3 talks (2 on deployments,...
2024-07-19 (first published: 2024-06-28)
167 reads
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But, you only want to capture them between 3AM and 4AM. Can you do it? Output...
2024-07-19 (first published: 2024-07-01)
197 reads
25 Years of Redgate
I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company started in 1999 and this is their 25th birthday. All of our offices are celebrating,...
2024-07-17
49 reads
Copilot in Microsoft Fabric
Microsoft Copilot is an app that uses AI to help you find information, create content, and get things done faster (see What Is Copilot? Microsoft’s AI Assistant Explained). Copilot is...
2024-07-17 (first published: 2024-07-10)
489 reads
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've been yearning for a risk-free environment to test, experiment, and refine your SQL queries against...
2024-07-17 (first published: 2024-07-06)
363 reads
The Annual SQL Saturday in Baton Rouge
I’ve been to quite a few of the SQL Saturday Baton Rouge events. There have been 10 with the 11th coming in a couple weeks. The crew down there...
2024-07-17
8 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
Form W-4 Updates 2026: What Employers and Employees Need to Know
Keeping up with Form W-4 updates doesn’t have to be complicated. In this practical...
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
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