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
azure, database systems, sql azure
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
hybrid query, MDX, ssas
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
#Powershell, Denali, powershell for