I am speaking at SQL Saturday Pittsburgh 2016!
I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016.
My session, Stretch Database...
2016-08-23
180 reads
Blog Posts
I am speaking at SQL Saturday Pittsburgh 2016!
I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud Services for your SQL...
2016-08-23
6 reads
Query Store, Force Plan and Dropped Objects
I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL...
2016-08-23 (first published: 2016-08-15)
1,803 reads
SSMS - Connection Color with SQL Prompt & SSMSBoost
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
1,108 reads
SSMS - Connection Color with SQL Prompt & SSMSBoost
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
223 reads
This Idera ACE Has Been Busy
This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what...
2016-08-23
289 reads
Bigger Fact Table for Wide World Importers
Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary...
2016-08-22 (first published: 2016-08-12)
3,123 reads
Cloud Security
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those...
2016-08-22
647 reads
DBCC CLONEDATABASE in SQL Server 2014
In SQL Server 2014 SP2 an interesting new DBCC command was included, DBCC CLONEDATABASE
This command creates a “clone” of a...
2016-08-22 (first published: 2016-08-17)
2,795 reads
Power BI Custom Visuals Class (Module 13 – Aster Plot)
In this module you will learn how to use the Aster Plot Power BI Custom Visual. The Aster Plot is...
2016-08-22
1,083 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
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
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...
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