SQL Server Manageability Team Blog

Connection Loss Errors in SSMS Query Editor

gcmouli — Mon, 25 Jul 2011 18:18:00 GMT

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...(read more)

Recovery Advisor: Using SSMS to create/restore split backups

gcmouli — Wed, 13 Jul 2011 04:01:25 GMT

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...(read more)

Recovery Advisor: An Introduction

gcmouli — Wed, 13 Jul 2011 03:58:02 GMT

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...(read more)

Deleting Old server names from "Connect to Server" dialog in SSMS

gcmouli — Wed, 13 Jul 2011 03:45:24 GMT

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...(read more)

Enhanced Keyboard Shortcuts in SSMS in Denali

gcmouli — Wed, 13 Jul 2011 03:37:00 GMT

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...(read more)

A day of Releases

gcmouli — Wed, 13 Jul 2011 03:34:43 GMT

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...(read more)

T-SQL IntelliSense enhancements in SSMS –Denali

gcmouli — Tue, 04 Jan 2011 16:25:53 GMT

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...(read more)

SQL Server Code-Named “Denali” - T-SQL Debugger Enhancements in CTP1

Nitika N — Tue, 04 Jan 2011 07:25:00 GMT

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...(read more)

Before you install Denali CTP1 …

gcmouli — Fri, 03 Dec 2010 09:19:10 GMT

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...(read more)

Cumulative Update 3 for SQL Server Management Studio 2008 R2: What’s in it for managing SQL Azure Databases?

Sumesh Dutt Sharma — Fri, 03 Dec 2010 09:08:00 GMT

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...(read more)

SQL Server Code-Named “Denali” - Viewing SQL Error Logs from WMI/SSMS when SQL Server is offline

Sanjay Nagamangalam [MSFT] — Fri, 03 Dec 2010 08:29:53 GMT

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...(read more)

SQL Server Code-Named “Denali”–Getting Started with Availability Groups and Keyboard Customization

Bill Ramos — Sun, 14 Nov 2010 18:40:45 GMT

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...(read more)

Microsoft SQL Server 2008 R2 Management Pack is now available

DibZ — Fri, 13 Aug 2010 00:04:00 GMT

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...(read more)

Server Activity History Report–MDW Report Series Part 4

Bill Ramos — Mon, 28 Jun 2010 15:46:00 GMT

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...(read more)

Server Activity History Report–MDW Report Series Part 3

Bill Ramos — Mon, 21 Jun 2010 16:50:00 GMT

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...(read more)

MDW Overview Report for Data Collector (Server Activity) – MDW Report Series Part 2

Bill Ramos — Sun, 20 Jun 2010 03:20:00 GMT

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...(read more)

MDW Overview Report for Data Collector – MDW Report Series Part 1

Bill Ramos — Mon, 07 Jun 2010 02:47:00 GMT

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...(read more)

Viewing MDW Reports with a Low Privileged User Account

Bill Ramos — Thu, 13 May 2010 03:20:04 GMT

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...(read more)

DAC Powershell Samples

Shireesh — Wed, 28 Apr 2010 17:10:00 GMT

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...(read more)

SQL Server 2008 R2 Management Studio Express and SQL Azure

Bill Ramos — Wed, 24 Feb 2010 23:42:06 GMT

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...(read more)

Where is SAC tool?

Gops Dwarak — Sat, 01 Mar 2008 02:55:00 GMT

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...(read more)

Some nodes in OE do not have "Policies" context menu - But I need them to author policies !

Gops Dwarak — Sat, 01 Mar 2008 02:50:00 GMT

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...(read more)

Uploaded Demo Scripts for TechNet Webcast - Using the New Policy-Based Management Framework in SQL Server 2008

HongfeiG — Tue, 26 Feb 2008 03:26:00 GMT

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...(read more)

The Wizard's Wand to Partitioning! Creating Staging Tables - adroitly simple

vindy-MSFT — Fri, 22 Feb 2008 10:43:00 GMT

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...(read more)

The Wizard's Wand to Partitioning! Series Prelude

vindy-MSFT — Thu, 21 Feb 2008 10:14:00 GMT

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...(read more)