Monthly Archives: July 2012

Backups in SQL Server Analysis Services

Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI: Connect to the SSAS service in SQL Server management studio. Right click on the database and select backup. The … Continue reading

Posted in Disaster Recovery, SSAS | 1 Comment

Quick tip: configure SQL Server authentication mode using T-SQL

SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands xp_regread and xp_regwrite. Step 1: Construct our registry key path, run the following query and record the result: DECLARE @InstanceName … Continue reading

Posted in Security, SQL Server, T-SQL | Leave a comment