Share via


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

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

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

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

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

Date: 07/12/2011

A day of Releases

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

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

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

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

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

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

Date: 12/03/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,...

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

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

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

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

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

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

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

Date: 02/24/2010

Where is SAC tool?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Date: 03/06/2007

Maintenance Plan Changes in SQL Server 2005 SP2

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

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

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

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

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

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

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

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

Date: 11/08/2006

SQL Server Best Practices Analyzer - Webcast - Resources

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

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

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

Date: 08/31/2006

Next>