15 Characters or Less: The Challenge of SQL Server Listeners Name
There is a hard limit on how long your AlwaysOn listener name can be. That...
2025-01-27 (first published: 2025-01-14)
337 reads
How to clear the SSMS cache?
If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...
2025-01-13 (first published: 2025-01-10)
1,229 reads
How to Find Where Your Databases Reside In The File System
SQL Script:
Copy
/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.
It is dynamic...
2024-12-27 (first published: 2024-01-31)
544 reads
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database
As one of the preventive database maintenance tasks, performing database integrity checks on almost every database you...
2024-07-01 (first published: 2024-06-13)
511 reads
Search and Export Script for SQL Server Databases
Plainly speaking, this article is about searching for a specific value inside all tables and their columns of a SQL database and...
2024-04-24 (first published: 2024-04-09)
415 reads
Finding the Latest Backup Timestamps for Your Databases
I wanted to find out the most recent date and time each database was last backed up, focusing specifically on full, differential,...
2024-04-08 (first published: 2024-03-29)
450 reads
Understanding and Using xp_sqlagent_enum_jobs in SQL Server
What is xp_sqlagent_enum_jobs?
xp_sqlagent_enum_jobs is an undocumented, extended stored procedure in Microsoft SQL Server. It is used to provide information about the jobs that are...
2024-02-12 (first published: 2024-01-31)
942 reads
SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
As we know, the SQL Server buffer cache is an area or region inside the server's memory where SQL Server...
2024-02-05 (first published: 2024-01-24)
503 reads
Best Practice Tip #1: Beware of Best Practices
It may sound contractionary that the first item of a best practices list is to be wary of...
2024-02-02 (first published: 2024-01-18)
719 reads
A Primer on Attaching Databases with PowerShell Method AttachDatabase
Attaching a SQL Server database using PowerShell can be straightforward. Here's an effective and easy approach using the...
2024-01-31 (first published: 2024-01-16)
448 reads
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Hi folks I have two tables, both with a NAME, START and END fields...
I am in the process of migrating from MySQL to SQL Server. I have...
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers