Technical Article

Tuning the Performance of Backup Compression in SQL Server 2008

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

SQLServerCentral Article

From DBA to DBAA

Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Metro Tanah Abang Telp/wa 085169998765

By technophilic11

Telp/wa 085169998765 Pusat Grosir Metro Tanah Abang 2 Lt. 7. 10, Jl. K.H. Wahid...

BCA KCP Panam No tlpon:083138717148

By phongthaydo8

Whatsapp:083138717148.Jl. H.R. Subrantas No.74 A & B, Sidomulyo Bar., Kec. Tampan, Kota Pekanbaru, Riau...

BCA KCP Sumberpucung No.Tlp.083179431643

By wiseenglishedu

Jl. Jend. Sudirman No.183, Dusun Pakel, Sumberpucung, Kec. Sumberpucung, Kabupaten Malang, Jawa Timur 65165

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers