AlwaysOn_health Extended Event Session
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
3,004 reads
SQL Geek
AlwaysOn Dashboard uses System Policies
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
663 reads
Why Availability Databases Are Not Synchronizing?
If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...
2018-07-23
929 reads
Schedule an Extended Event to run at a Specific Time
When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or...
2018-08-01 (first published: 2018-07-18)
5,289 reads
Another MVP Award – 2018-2019
Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...
2018-07-16
239 reads
Enable SQLCMD Mode in SQL Server Management Studio
SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS,...
2018-06-07
16,146 reads
SQL Server Stress Testing Using OStress – RML Utilities
As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...
2018-05-28 (first published: 2018-05-21)
7,241 reads
Find Query with Implicit Conversion in the Plan Cache
In my previous blog, I discussed about “Which are the queries using a particular index or table?“. Today’s post, I am...
2018-05-13
3,052 reads
Which are the queries using a particular index or table?
The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
1,081 reads
Determine Referenced Objects in the Stored Procedures
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
1,767 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
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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
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