Storage savings with Table Compression

In one of my recent assignments, my client asked me for a solution, to reduce the disk space requirement, of the staging database of an ETL workload. It made me study and compare the Table Compression feature of SQL Server. This article will not explain Compression but will compare the storage and performance aspects of … Continue reading Storage savings with Table Compression

SSDT – The untold story

Every SQL Server database developer is aware of SQL Server Management Studio (SSMS) but there is one more important tool SQL Server Data Tools (SSDT) that can bring a lot of benefits to them. SSDT is based on Visual Studio There are many ancillary jobs that a database developer performs apart from writing T-SQL queries, … Continue reading SSDT – The untold story