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)
377 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)
3,033 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)
856 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)
573 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)
671 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)
659 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)
1,129 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)
536 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)
748 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)
474 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers