Articles

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

You rated this post out of 5. Change rating

2008-05-12

2,214 reads

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.

(6)

You rated this post out of 5. Change rating

2008-05-09 (first published: )

15,703 reads

SQLServerCentral Article

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!

(53)

You rated this post out of 5. Change rating

2008-05-09 (first published: )

66,669 reads

SQLServerCentral Article

The Differences Between SQL Server 2000 and 2005

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.

(38)

You rated this post out of 5. Change rating

2008-05-08 (first published: )

110,790 reads

Blogs

Rambling about Data on Wheels – origins, branding, expansion

By

I have been asked many times about how the name “Data on Wheels” came...

Think Twice Before Enabling Fabric’s Inbound Network Protection

By

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By

Most apps that call an LLM send every request to the same model. That...

Read the latest Blogs

Forums

ALAMAT KANTOR BCA KCP Pulogadung Telp:083831618008

By Layanan.Bank.BCA

WhatsApp:0838-3161-8008 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo Gadung, Kota Jakarta...

Alamat Kontak Bank BCA KCP Balaraja Telp:08218154392

By layanan 24jam BCA

WA CS (08218154392)Jl. Raya Serang Km. 24, Kp. Cariu, RT 003/001, Talagasari, Kec. Balaraja,...

ALAMAT BCA KCU TANGERANG Telp:08218154392

By m4l4mt194

WA CS (08218154392) Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers