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
32 reads
Blog Posts
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
78 reads
Execution Plans: Statistics
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
Last week...
2019-07-30
26 reads
Execution Plans: Statistics
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
Last week...
2019-07-30
12 reads
Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets
Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
2019-07-30
206 reads
Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets
Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
The post Make Sure Your SQL Servers...
2019-07-30
44 reads
Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets
Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
The post Make Sure Your SQL Servers...
2019-07-30
11 reads
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
10 reads
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
16 reads
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
14 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers