Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
105 reads
Blog Posts
Removing servers from the SSMS connection dialog (Day 36)
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
1,791 reads
See you at SQLSat Dallas!
Looking forward to making the road trip on Friday and joining the #SQLFamily at SQLSat Dallas 2018 this Saturday. It's my first SQLSat Dallas since my last trip to...
2018-05-16
6 reads
Tea with Kalen! An interview with Kalen Delaney (#DBAsAtMidnight)
We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years...
2018-05-16
353 reads
The trials and tribulations of REVERTing from impersonation
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
378 reads
Thoughts on the 2018 (and beyond) PASS Elections – Part 1
Last week Wendy Pastrick of the PASS Board posted PASS Election 2018 Timeline. It’s a good post for a few...
2018-05-16
315 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed...
2018-05-16
10 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2....
2018-05-16
381 reads
When Simple Parameterization…Isn’t
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,584 reads
Change SSAS Tabular Data Source using TOM
We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server...
2018-05-15 (first published: 2018-05-08)
1,918 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers