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