While the SQL Server Management Studio (SSMS) offers a graphical interface for configuring Database Mail, T-SQL provides detailed insights into the configuration through various system stored procedures and views. Here&…
Read Tutorial
While attempting to attach a database on one of my test servers, I encountered an error. Recognizing the potential value in sharing solutions to common database issues, I've decided to document the steps to troubles…
Read Tutorial
Slow running queries can drag down application performance and degrade user experience. As a DBA, it's important to monitor and optimize long running SQL statements. In this post, I'll demonstrate how to find que…
Read Tutorial
The SQL Server Query Store is an incredibly useful feature for monitoring and troubleshooting query performance issues. One of the handiest aspects of the Query Store is the ability to easily retrieve execution plans an…
Read Tutorial
The Query Store is a feature in SQL Server that collects and stores information about queries that are executed. This information can be used to troubleshoot performance problems, identify queries that are causing probl…
Read Tutorial
UDL file for SQL connectivity check A UDL (Universal Data Link) file is a text file that stores connection information for a data source. UDL files can be used to test connectivity to a variety of data sources, includin…
Read Tutorial