Backup and Housekeeping with Maintenance Plans
Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.
2014-02-17 (first published: 2011-01-26)
14,472 reads
Gethyn Ellis
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-18
2,146 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-22
1,997 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
Blogs
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Forums
String or Binary Truncation Error Strange Behavior (SQL 2019)
Forgot I posted a similar issue back in 2020, String or Binary Truncation Error...
Transactional Replication from Read replica
If I have Read replica (in Azure SQL MI), can it be used as...
SQL availability group and file server role answering from the same name
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers