Code sample: Compressed SQL Server database backup to Windows Azure Storage

SMO code sample to perform a compressed SQL Server database backup  to Windows Azure Storage is available at You can read about Backup to Windows Azure Storage Service  here –

Activity Monitor in SQL Server 2012 SP1

In SQL Server 2012 Service Pack 1 few changes were made in Activity Monitor. We had to stop using PerformanceCounterCategory class to get information about number of logical CPUs on the remote machine and switched to using more accurate information available via WMI (Win32_ComputerSystem.NumberOfLogicalProcessors if you’re looking for technical details). Unfortunately it caused problems for…

SQL Server Backup and Restore with Windows Azure Blob Storage Service

In SQL Server 2012 SP1 Cumulative Update 2, new feature is available to backup, restore SQL Server databases to Windows Azure Blob store. T-SQL Sample:   C# Sample using SMO:       You can read more about this feature here: Team Blog : MSDN documentation, T-SQL, C# code samples: Please try out this…

SQL Server 2000 will no longer be supported

You can refer to section “SQL Server 2000 Support Information” in link – . If you are using SQL 2000, please consider upgrading to latest version of SQL Server as soon as possible.   Upgrade to SQL 2008 R2 – Upgrade to SQL Server 2012 –