Archive

Archive for May 23, 2012

SQL Azure Database Take Offline

May 23, 2012 1 comment

As everyone knows that database administrator can take SQL Server Database offline for maintenance purpose with following command Read more…

Categories: SQL, SQL Azure Tags: , ,

SQL+MDX in one Apartment (Hybrid Query).

May 23, 2012 3 comments
While replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means. Read more…
Categories: Business Intelligence, MDX, SQL, SSAS Tags: , ,

Powershell – Powershell Script to backup all user DBs in SQL Server

May 23, 2012 12 comments

Powershell is Microsoft’s task automation framework.

The following is a simple powershell script to take full backup of all users database of MS SQL Server, this script is tested on MS SQL Server 2008R2 and MS SQL Server 2012(Denali). Read more…

Categories: Denali, Powershell, SQL Server, SQL Server 2008 R2 Tags: , ,