SQL Server Manageability Team Blog

Connection Loss Errors in SSMS Query Editor

Connection Loss Errors in SSMS query editor Under various situations, connection loss errors in...

Author: gcmouli Date: 07/25/2011

Recovery Advisor: Using SSMS to create/restore split backups

This is part 2 of a two part blog series that my colleague Vatsalya Agrawal wrote up on the new tool...

Author: gcmouli Date: 07/12/2011

Recovery Advisor: An Introduction

Vatsalya Agrawal is a colleague of mine, in the test team at SQL Server Manageability. This is part...

Author: gcmouli Date: 07/12/2011

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

In an earlier Denali CTP, we had introduced a mechanism for customers to delete the un-used/not...

Author: gcmouli Date: 07/12/2011

Enhanced Keyboard Shortcuts in SSMS in Denali

In SQL Server Code Named “Denali” CTP3, we introduced some enhancements in the way we...

Author: gcmouli Date: 07/12/2011

A day of Releases

Today we announced the next public CTP of Microsoft SQL Server Code Name “Denali". Download...

Author: gcmouli Date: 07/12/2011

T-SQL IntelliSense enhancements in SSMS –Denali

  Kamal Bhatt (kbhatt@microsoft.com), a colleague of mine in the SQL Server Manageability Team,...

Author: gcmouli Date: 01/04/2011

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

The debugger feature in SQL Server Management Studio gives us tools to debug T-SQL scripts, stored...

Author: Nitika N Date: 01/03/2011

Before you install Denali CTP1 …

  SQL PASS 2010 is over, and the first CTP of Denali is out. Lots of interesting stuff got...

Author: gcmouli Date: 12/03/2010

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

Microsoft SQL Azure Database periodically adds new features to its existing service offerings. A few...

Author: Sumesh Dutt Sharma Date: 12/03/2010

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

John Emmanuel Mandam (johnema@microsoft.com) is a colleague of mine in the SQL Server Manageability...

Author: Sanjay Nagamangalam [MSFT] Date: 12/03/2010

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

Bill Ramos Principal Program Manager, SQL Server Manageability If you missed SQL PASS or you didn’t...

Author: Bill Ramos Date: 11/14/2010

Microsoft SQL Server 2008 R2 Management Pack is now available

We've made some important improvements and investments in the SQL Management Pack for System Center,...

Author: Clifford Dibble - MSFT Date: 08/12/2010

Server Activity History Report–MDW Report Series Part 4

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 3 of the report series, I...

Author: Bill Ramos Date: 06/28/2010

Server Activity History Report–MDW Report Series Part 3

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 2, I added the hyperlink to...

Author: Bill Ramos Date: 06/21/2010

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

By Bill Ramos, Program Manager, SQL Server Manageability Team In this post, we’ll complete the...

Author: Bill Ramos Date: 06/19/2010

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

By Bill Ramos, Program Manager, SQL Server Manageability Team The Management Data Warehouse (MDW)...

Author: Bill Ramos Date: 06/06/2010

Viewing MDW Reports with a Low Privileged User Account

Just last week, one of our technical sales people asked me the question, when will we release the...

Author: Bill Ramos Date: 05/12/2010

DAC Powershell Samples

All the samples in this document are based on the DAC module that you can download from the attached...

Author: Shireesh Date: 04/28/2010

SQL Server 2008 R2 Management Studio Express and SQL Azure

If you want to get started right away using tools like SSMS against SQL Azure, you are in luck. It...

Author: Bill Ramos Date: 02/24/2010

Where is SAC tool?

Surface Area Configuration (SAC) tool will be removed in SQL 2008 release. This tool exposed two...

Author: gopsdwarak Date: 02/29/2008

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

I am assuming most of you must be familiar with jargons Facets, conditions and polices by now, if...

Author: gopsdwarak Date: 02/29/2008

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

Thanks for those who have attended this presentation. I have attached the demo policies and the demo...

Author: HongfeiG Date: 02/25/2008

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

Making a superb coffee wending machine is great and we can write volumes on how to use it. Trust me,...

Author: vindy-MSFT Date: 02/22/2008

The Wizard's Wand to Partitioning! Series Prelude

Hello Everybody! Its a pleasure to start blogging on this wonderful sunny morning at Seattle when...

Author: vindy-MSFT Date: 02/21/2008

Webcast - SQL Server 2008 Policy-Based Management (formerly known as DMF)

What is Policy-Based Management? How does it make SQL Server administration easier? What are the...

Author: HongfeiG Date: 02/18/2008

Multiple Server Query Execution in SQL Server 2008

SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor....

Author: erickang Date: 02/04/2008

Ken Henderson – We Will Always Remember You

We are mourning the loss of Ken Henderson who passed away this Sunday evening. We don’t know any...

Author: Bill Ramos Date: 01/28/2008

SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!

It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL...

Author: PaulMest Date: 01/18/2008

Performance Data Collector for SQL Server 2008 - Revealed

I’ve been getting many requests on what is this new Performance Data Collector tool and how does it...

Author: Bill Ramos Date: 01/17/2008

November CTP News: Workaround fix for query execution issue

SQL Server 2008 November CTP (CTP5) has a known issue that any query execution hangs indefinitely....

Author: erickang Date: 01/15/2008

SQL Server 2005 Best Practices Analyzer (July 2007) is available

This week we celebrate independence. No, I'm not referring to Independence Day in the United States....

Author: PaulMest Date: 07/04/2007

Reducing Database Size by Using Vardecimal Storage Format

In addition to the improvements to the management tools in Service Pack 2 that I've outlined on this...

Author: PaulMest Date: 05/29/2007

How do you like to learn? or SQL Server Agent Proxy Accounts

One of my favorite parts of my job as a Program Manager is evangelizing our products. I love...

Author: PaulMest Date: 04/10/2007

SQL Connections 2007 (Orlando, FL) -- Follow-up

After one heck of a trip to Orlando, FL for SQL Connections, I'm back in Redmond. Here is a quick...

Author: PaulMest Date: 03/28/2007

SQL Server Manageability Webcast - SP2 Improvements - Resources

Thank you to those who attended today's webcast. As promised, here are links to the resources...

Author: PaulMest Date: 03/20/2007

SQL Server Manageability Webcast - SP2 Improvements

I'll be giving a webcast in one week on the manageability improvements introduced in SQL Server 2005...

Author: PaulMest Date: 03/13/2007

SQL Server 2005 Performance Dashboard Reports -- Now Available!

Have you ever noticed one of your SQL Server instances running unusually slowly? Have you had...

Author: PaulMest Date: 03/07/2007

Maintenance Plans Changes -- Knowledge Base Article

For all of those who are coming to my blog looking for the latest Maintenance Plan information,...

Author: PaulMest Date: 03/06/2007

Maintenance Plan Changes in SQL Server 2005 SP2

Update (2007-Mar-06):...

Author: PaulMest Date: 02/24/2007

SQL Server 2005 Best Practices Analyzer (February 2007 CTP)--Now Available

The much-anticipated SQL Server 2005 Best Practices Analyzer is now available on the Microsoft...

Author: PaulMest Date: 02/21/2007

SQL Server 2005 Service Pack 2--Now Available

After working on SQL Server 2005 Service Pack 2 for the past 9 months, I am elated to see it be...

Author: PaulMest Date: 02/19/2007

SP2/BPA Frequently Asked Questions

I have been getting a lot of questions and hearing a lot of speculation about SP2 and BPA. Let me...

Author: PaulMest Date: 01/12/2007

SQL Server 2005 Service Pack 2 - December CTP

Before I go on vacation, I'd like to send a quick thank you to the community for giving us their...

Author: PaulMest Date: 12/19/2006

SQL Server 2005 - Service Pack 2 - Web Chat

Whenever something you use every day changes, it's not always easy to put down what you're doing,...

Author: PaulMest Date: 11/20/2006

Custom Reports in Management Studio

One of the improvement areas we've introduced in Service Pack 2 is the ability to run your own...

Author: PaulMest Date: 11/20/2006

SQL Server 2005 Service Pack 2 - November CTP

SQL Server 2005 Service Pack 2 - November CTP is available for download. For more information please...

Author: PaulMest Date: 11/08/2006

SQL Server Best Practices Analyzer - Webcast - Resources

Resources for today's webcast. Webcast:...

Author: PaulMest Date: 09/07/2006

SQL Server Best Practices Analyzer - Webcast

There will be a webcast on Thursday, September 7, 2006 at 9:30am on the next version of SQL Server...

Author: PaulMest Date: 09/01/2006

Management Studio Reports - Part 3 - Standard Reports

Sorry for the delay for part 3. I have not been able to take our existing standard reports and make...

Author: PaulMest Date: 08/31/2006

Next>