Bill Anton explains how to tell if your app suffers from unknown SSAS performance issues, and why Analysis Services need not be a black box. Notes from the Field #109.
SQL SERVER – Taking Backup Without Consuming Disk Space
Taking backup without consuming disk space is possible with the NUL device, but it is dangerous. Here is how it works and why never to do it in production.
SQL SERVER – Steps to Backup to Windows Azure storage
Steps to backup to Windows Azure storage with T-SQL: create a credential for your storage account, then back up to a blob, with no extra tools needed.
SQL SERVER – Identify Time Between Backups Calculation
A DBA whose latest tape backup was corrupt wanted to know the possible data loss. This script uses backup history to calculate the time between backups.
SQL SERVER – Configure the Backup Compression Default Server Configuration Option
Backup compression is off by default. Here is how to view or configure the backup compression default server option using SSMS or Transact-SQL.
SQL SERVER – Are Power Options Slowing You Down? – Notes from the Field #095
John Sterrett explains how Windows power options, like the default balanced power plan, can slow SQL Server down. Notes from the Field #095.
SQL SERVER – A Stored Procedure for Executing SSIS Packages in the SSIS Catalog – Notes from the Field #092
SSIS expert Andy Leonard shares a stored procedure for executing SSIS packages in the SSIS Catalog, from the book SSIS Design Patterns. Notes from the Field #092.