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:/...

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...

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...

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....

Links for Latest service pack and cumulative updates for SQL Server - http://technet.microsoft.com/en-us/sqlserver/ff803383.aspx

You can download SQL 2012 SP1 from http://www.microsoft.com/en-us/download/details.aspx?id=35575 Please send us your feedback / any issues to SQL Server feedback http://connect.microsoft.com/SQLServer/feedback/

Wayne has published blog article explaining how you could use these new DMVs to Troubleshoot SQL Azure database http://blogs.msdn.com/b/wayneb/archive/2012/11/02/introducing-sys-database-connection-stats-for-troubleshooting-windows-azure-sql-database...

SQL Server 2012 SP1 CTP4 Now Available- http://blogs.technet.com/b/dataplatforminsider/archive/2012/09/20/sql-server-2012-sp1-ctp4-now-available.aspx Customers running SQL Server 2012 can download and test the SP1 CTP4 and send feedback to us at https...

You can view all data in Management data warehouse for all instances that upload collected data to the warehouse database using "Management Datawarehouse overview report" You can view this report by following these steps 1) Open SQL Server management...

You can use Power shell and SMO to script out objects and its dependents in a database along with object permissions. This blogs entry has a sample power shell script that you can use to generate script in automated way.

Tracking Extended Events for a SQL Agent Job

http://www.youtube.com/watch?v=7XY5vszCkTk&feature=youtu.be&a

Will Snavely did a great job of writing these blog posts. you may find it useful when you need to monitor AlwaysOn health in your automation scenarios Monitoring AlwaysOn Health with PowerShell - Part 1: Basic Cmdlet Overview http://blogs.msdn.com...

Issue: In SQL 2012, stored procedures that call any other stored procedures or extended stored procedures that return result sets should specify WITH RESULT SETS SQL Agent's stored procedure sp_help_job - returns single resultset if no parameters...

In SQL 2012, there was an issue with output string formatting that missed parameter replacement on the message that was sent as email for performance alerts. We have addressed this fix in SQL 2012 Cumulative update #2. You can download SQL 2012 CU2...

You could use the following code sample to create a SQL Agent Job using Managed C++ You can download the sample from MSDN http://code.msdn.microsoft.com/Create-SQL-Agent-job-using-f1ee5004

You could use the following code sample to create a SQL Agent Job using C#. You can download the sample from MSDN http://code.msdn.microsoft.com/Create-SQL-Agent-job-using-b95584e7

If you see this specific issue while launching SQL Configuration Manager, you can follow the workaround specified in this blog post Workaround: Open Command Windows as Elevated administrator user cd %ProgramFiles(x86)%\Microsoft SQL...

I would like to clarify how to reset a proxy used by specific job. Assuming that I have a job and for the first step of the job I’m using proxy, and the proxy Id = 3 If you want to reset the step proxy back to Null, how you will do it? ...

In SQL 2012, you can use stored proocedure [msdb].dbo] . [sp_syscollector_cleanup_collector] to remove the associated data collector objects that were created while enabling data collector. This stored procedure deletes SQL agent jobs that were created...

Hello In SQL Agent logs for SQL Server 2012 you may see following message that appears every 90 seconds: "Reloading agent settings". It's indeed painful behavior from the user perspectives, and we will address this issue in nearest Service Pack for...

Hey Folks Recently we fixed several issues in SQL Agent Scheduler, so if your scheduler is not working as expected probably we have a fix, so how you can make sure that you have latest and greatest. Here the guide SQL Server 2012 RTM has it SQL...

Index rebuild on a large database could take longer time. One of our customer was looking for a solution to rebuild index one by one when index fragmentation is greater than 30%. Related newsgroup thread: http://social.msdn.microsoft.com/Forums/en...

Our customers reported issue while launching Job step dialog on SQL 2008 R2 's Management Studio. Here is the related connection issue http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps Issue...

How to use this powershell script: - Launch SQL Server PowerShell ( Start -> Run -> sqlps.exe) - Copy the following powershell script and save to file (Ex c:\JobHistory.ps1) - in SQL powershell window, type in script file path ( Ex: c:\JobHistory...