ApexSQL Backup is a command center to create, schedule and monitor backup, restore and log shipping jobs across many servers. Here is how it automates the work.
SQL SERVER – Boosting User Experience with Analysis Services Perspectives – Notes from the Field #116
Analysis Services Perspectives let a designer show users only the parts of a data model they need. Notes from the Field #116 explains how they help users.
SQL SERVER – FIX Error 3169 – The database was backed up on a server running version
Restoring a SQL Server 2016 backup on a 2014 instance fails with Error 3169, backed up on a server running a newer version. Here is why and what you can do.
SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)
Error 22022 says SQLServerAgent is not currently running so it cannot be notified of this action. Here is what causes it and how to fix it.
SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109
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.