Connection Loss Errors in SSMS query editor Under various situations, connection loss errors in Query editor can cause SQL Server to drop the connection with the Client. Details regarding connection drop errors when working with on-premise server instances...

This is part 2 of a two part blog series that my colleague Vatsalya Agrawal wrote up on the new tool called Recovery Advisor. Recovery Advisor is a new tool, that we have introduced to make restoring databases easier for users. -- MS SQL Server has capability...

Vatsalya Agrawal is a colleague of mine, in the test team at SQL Server Manageability. This is part 1 of a two part series that he has written, on Recovery Advisor. This is a new tool, that we have introduced to make restoring databases easier for users...

In an earlier Denali CTP, we had introduced a mechanism for customers to delete the un-used/not required server names from the drop down in connection box in SSMS. There has been a big customer ask for helping them remove the redundant server names from...

In SQL Server Code Named “Denali” CTP3, we introduced some enhancements in the way we handled keyboard shortcuts in SSMS. My colleague Prachi Bora, a PM in the SQL Server Manageability team, has a crisp blog write-up on what’s new and...

Today we announced the next public CTP of Microsoft SQL Server Code Name “Denali". Download links are here . We are also excited to release SQL Server 2008 R2 SP1. Download links are here . You can gather a quick overview of what's new in these two...

  Kamal Bhatt ( kbhatt@microsoft.com ), a colleague of mine in the SQL Server Manageability Team, wrote up this useful blog post on some of the new Intellisense enhancements in SQL Server Code Name “Denali”. In this blog post, I will go over three...

The debugger feature in SQL Server Management Studio gives us tools to debug T-SQL scripts, stored procedures, functions and triggers. In this article, I am going to discuss some of the newly added functionalities in T-SQL debugger in SQL 11 CTP1. These...

  SQL PASS 2010 is over, and the first CTP of Denali is out. Lots of interesting stuff got announced and Demo’d at PASS. If you were part of the insider sessions, you probably got demos of some of the CTP1 features as well. But, before you install...

Microsoft SQL Azure Database periodically adds new features to its existing service offerings. A few months back, via the Service Update 2 and Service Update 3, the following features were made available to users of SQL Azure Databases: “ALTER...

John Emmanuel Mandam ( johnema@microsoft.com ) is a colleague of mine in the SQL Server Manageability team and he wrote up this useful blog on using WMI to query SQL Server Error Log Events in SQL Server code named “Denali”. Query SQL Server ErrorLog...

Bill Ramos Principal Program Manager, SQL Server Manageability If you missed SQL PASS or you didn’t get your copy of SQL Server code named “Denali”, you’re in luck. You can now download it from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID...

We've made some important improvements and investments in the SQL Management Pack for System Center, and the English language version just RTW-ed last week. You can read more about it here on the Release Services Team's blog. Keep an eye on that blog...

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 3 of the report series , I showed how to get CPU data from the MDW and display it as a thumbnail chart in the Server Activity History report. In part 4, I’ll show how to extract...

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 2 , I added the hyperlink to the MDW Overview report to launch the Server Activity History report. In this post, I’ll show how to get the data and display the thumbnails in...

By Bill Ramos, Program Manager, SQL Server Manageability Team In this post, we’ll complete the MDW Overview report from part 1 of this series and then start into the makings of the Server Activity report as shown below. The Server Activity...

By Bill Ramos, Program Manager, SQL Server Manageability Team The Management Data Warehouse (MDW) overview report that I mentioned in my previous blog post on Viewing MDW Reports with a Low Privileged User Account provides a list of database instances...

Just last week, one of our technical sales people asked me the question, when will we release the source RDL files for the Management Data Warehouse (MDW) feature that we shipped with SQL Server 2008. The reason that he asked was that his customer wanted...

All the samples in this document are based on the DAC module that you can download from the attached zip folder ( DACModule.zip) .To import the modules, Step 1) check your Module Path PS > dir Env:PSModulePath Step 2) chose any of the module...

If you want to get started right away using tools like SSMS against SQL Azure, you are in luck. It turns out that the SQL Server 2008 R2 November CTP release includes SSMS Express package for 32 and 64 bit systems. Check out the Tools Only section on...

Surface Area Configuration (SAC) tool will be removed in SQL 2008 release. This tool exposed two major functionalities. Surface Area Configuration for Services and Connections Surface Area Configuration for Features A. In SQL 2008, starting...

I am assuming most of you must be familiar with jargons Facets, conditions and polices by now, if you are hands-on over policy-based management framework. If you traverse to the facets node under Management->Policy Management in Object explorer...

Thanks for those who have attended this presentation. I have attached the demo policies and the demo script as promised. Note that the policy files only work for SQL Server 2008 CTP6 and above. Cheers, Hongfei

Making a superb coffee wending machine is great and we can write volumes on how to use it. Trust me, it wouldnt appeal if you dont quickly write about any feature of the machine that solves a day to day problem for a coffee drinker / Seller. This is exactly...

Hello Everybody! Its a pleasure to start blogging on this wonderful sunny morning at Seattle when the morning mist says good bye and the sun is happy to shine right above us. Everyone is smiling as the weather just turned from wet to pleasant. This is...