Collecting Server Performance Metrics: PowerShell
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-07-30
27 reads
Create New Azure VM with PowerShell
Every so often I set out to create new resources in my Azure subscription using the command line tools (PowerShell or CLI) just to keep up to date on...
2019-07-25 (first published: 2019-07-09)
476 reads
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics...
2019-07-23
139 reads
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key....
2018-06-12 (first published: 2018-06-05)
1,898 reads
Azure PowerShell – List Virtual Machine Sizes
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that...
2018-06-07 (first published: 2018-05-29)
1,793 reads
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your...
2018-06-05
13 reads
Azure PowerShell – List Data Center Locations
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came...
2018-05-30 (first published: 2018-05-22)
2,190 reads
Azure PowerShell – List Virtual Machine Sizes
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that you need to get right but are unsure of...
2018-05-29
123 reads
Azure PowerShell – List Data Center Locations
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do...
2018-05-22
54 reads
Bring Your Own Key to Azure SQL Database TDE
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure...
2018-05-22
14 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