When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when...
2023-06-28
153 reads
Blog Posts
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that aims to improve the performance of parameterized queries. It is part of the Intelligent Query...
2023-06-26 (first published: 2023-06-08)
329 reads
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up it in many various ways to run Ola’s Index Optimize and
The post Using Azure Automation...
2023-06-26 (first published: 2023-06-06)
444 reads
A New Word: Volander
volander: n. the ethereal feeling of looking down at the world through an airplane window, able to catch a glimpse of far-flung places you’d never see in person, free...
2023-06-23
87 reads
ChatGpt Experiments–Getting Documentation
I get asked questions by salespeople all the time. Usually this is because a customer is struggling and I try to educate the salesperson as well as give them...
2023-06-23 (first published: 2023-06-02)
400 reads
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal. Now, we can provision Microsoft fabric easily using Microsoft PowerBI premium per capacity or using...
2023-06-23 (first published: 2023-06-05)
434 reads
Notes from SQLSaturday Jacksonville 2023
Year 15 for Jacksonville! SQLSaturday Jax was held on May 6 this year, back at the usual location on the campus of the University of North Florida. At the...
2023-06-23 (first published: 2023-06-13)
163 reads
Agile West–How Do I Get Started with Database DevOps
This week I had the chance to deliver a talk at Agile West in Las Vegas. I linked some resources on my blog, and feel free to check them...
2023-06-21
51 reads
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it doesn’t require installation of an Oracle client. But because of this, you may not have...
2023-06-21 (first published: 2023-06-03)
364 reads
What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2023-06-21
305 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
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...
Forums
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
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:...
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