One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it.
SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.
A short review of the WROX red covered book that looks at Integration Services for the DBA.
SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers