Wednesday, November 22, 2017
 
Updates from SQL Server Tools Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

Connection Loss Errors in SSMS Query Editor

Monday, July 25, 2011

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 and SQL Azure instances are described here and here respectively. Until recently, the idle connection time-out period...

Recovery Advisor: Using SSMS to create/restore split backups

Tuesday, July 12, 2011

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 to split a backup file into multiple files....

Recovery Advisor: An Introduction

Tuesday, July 12, 2011

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 part 1 here. -- Backup Restore is...

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

Tuesday, July 12, 2011

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 the MRU list. Here is a blog post from Devesh Nagpal,...

Enhanced Keyboard Shortcuts in SSMS in Denali

Tuesday, July 12, 2011

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 what makes this cool. -- SSMS veterans out there can tell you in their...

A day of Releases

Tuesday, July 12, 2011

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 releases in the SQL Server Release Services Blog here. As...

T-SQL IntelliSense enhancements in SSMS –Denali

Tuesday, January 04, 2011

  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 IntelliSense enhancements that have been introduced in SSMS-Denali. They are as follows: a.)...

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

Monday, January 03, 2011

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 enhancements are mainly aimed at bridging the gap between T-SQL and C# debugging experience...

Before you install Denali CTP1 …

Thursday, December 02, 2010

  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 CTP1 from that DVD in your hand,...

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

Thursday, December 02, 2010

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 DATABASE MODIFY NAME” T-SQL. This now allows users to change the names of their database hosted...

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM