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  http://code.msdn.microsoft.com/Backup-SQL-Server-database-0824dbfb You can read about Backup to Windows Azure Storage Service  here – http://blogs.msdn.com/b/sqlagent/archive/2013/01/24/sql-server-backup-and-restore-with-windows-azure-blob-storage-service.aspx


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 : http://sqlblog.com/blogs/sqlos_team/archive/2013/01/24/backup-and-restore-to-cloud-simplified-in-sql-server-2012-sp1-cu2.aspx MSDN documentation, T-SQL, C# code samples:  http://msdn.microsoft.com/en-us/library/jj919148.aspx Please try out this…


SQL Server 2000 will no longer be supported

You can refer to section “SQL Server 2000 Support Information” in link –  http://www.microsoft.com/en-us/sqlserver/support/support-updates.aspx . If you are using SQL 2000, please consider upgrading to latest version of SQL Server as soon as possible.   Upgrade to SQL 2008 R2 – http://msdn.microsoft.com/en-us/library/bb677622(v=SQL.105).aspx Upgrade to SQL Server 2012 – http://technet.microsoft.com/en-us/library/bb677622.aspx