Category Archives: SQL Server DBA

Backup Compression in SQL Server 2008

Posted on March 16, 2011 by uday arumilli

Backup Compression in SQL Server 2008 Backup Compression in SQL Server 2008  is really a amazing feature. Earlier we used to use litespeed to compress the backup. As we are dealing with the backups that are in 2 GB to … Continue reading →

Posted in SQL Server DBA | Tagged , , , , | Leave a comment

How SQL Server Page Allocations Works

Posted on March 11, 2011 by uday arumilli

How SQL Server Page Allocations Works? This post helps us in understanding “How SQL Server Page Allocations Works”. When I drop an object SQL Server does not immediately re-use those extents for a new object. This is because the storage … Continue reading →

Posted in SQL Development, SQL Server DBA | Tagged , , , , | Leave a comment

Automating SQL Server instance and Database Inventory preparation

Posted on January 4, 2011 by uday arumilli

Automating SQL Server instance and Database Inventory preparation In our environment we have a requirement for Automating SQL Server instance and Database Inventory preparation. We tried different methods and came-up with the T-SQL scripts that helped us in creating the environment … Continue reading →

Posted in SQL Server DBA | Tagged , , , , | 2 Comments