SQL 2012 SP1 available for download

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/  

1

Troubleshooting Windows Azure SQL Database

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.aspx   MSDN Reference : http://msdn.microsoft.com/en-us/library/windowsazure/ee730906.aspx


SQL Server 2012 SP1 CTP4 Now Available

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://connect.microsoft.com/SQLServer/Feedback SQL Server 2012 SP1 CTP4 SQL Server 2012 SP1 CTP4 Express SQL Server 2012 SP1 CTP4 Feature Pack

1

Management Data Warehouse overview report

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 steps1) Open SQL Server management Studio, Connect to  SQL Server instance that is hosting Management data warehouse database (MDW) 2) Right click…

1

Monitoring AlwaysOn Health with PowerShell and SQL Agent

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 Overviewhttp://blogs.msdn.com/b/sqlalwayson/archive/2012/02/13/monitoring-alwayson-health-with-powershell-part-1.aspx Monitoring AlwaysOn Health with PowerShell – Part 2: Advanced Cmdlet Usagehttp://blogs.msdn.com/b/sqlalwayson/archive/2012/02/13/monitoring-alwayson-health-with-powershell-part-2.aspx Monitoring AlwaysOn Health with PowerShell –…


Workaround: SQL Server 2012 – OPENROWSET on sp_help_job throws "The metadata could not be determined"

Issue:In SQL 2012, stored procedures that call any other stored procedures or  extended stored procedures that return result sets should specify WITH RESULT SETSSQL Agent’s stored procedure sp_help_job  – returns single resultset if no parameters are passed to stored procedure.  – returns 3 resultsets if job_id or job_name is specified. MSDN linkWhen RESULTSET is not…