During the process of developing a script to make copies of local SQL database and transaction log backups, I needed to come up with an easy way of locating the backup files. This script queries the SQL2000 backup tables in the msdb database and returns backup start dates, types (D=database, L=Log, I=Differential) and the location […]
2004-02-25
604 reads
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
If I have Read replica (in Azure SQL MI), can it be used as...
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers