Advertisements

Archive

Archive for May 23, 2012

SQL Azure Database Take Offline

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

Advertisements

SQL+MDX in one Apartment (Hybrid Query).

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…

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

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…

%d bloggers like this: