Browse by Tags

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

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 the Nov CTP download page . Once you configure your...

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

SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. This feature intends to increase the productivity of running same query against multiple servers at once. Some of useage include: · Configure group of servers or server farm · Generate report or document...

I’ve been getting many requests on what is this new Performance Data Collector tool and how does it work. First off, Performance Data Collector is simply a component as one of the tools in Management Studio (SSMS) involved in performance troubleshooting. These tools include the new Data Collector, System...

SQL Server 2008 November CTP (CTP5) has a known issue that any query execution hangs indefinitely. Fortunately, there is a quick and simple workaround to fix the issue. Cause & Problem: User changes the default setup directory to a custom one during the initial setup. Query Editor hangs...

One of my favorite parts of my job as a Program Manager is evangelizing our products. I love teaching people how to be more effective by introducing them to new features or tying many existing features together in an end-to-end scenario. I like to learn about technology and I'd imagine that the majority...

After one heck of a trip to Orlando, FL for SQL Connections, I'm back in Redmond. Here is a quick re-cap of my sessions and links to session content... SMS312 -- Be More Productive with SQL Server 2005 Tools SMS313 -- Deep Dive into Database Mail SMS315 -- Solving Common Scenarios with Management...

Thank you to those who attended today's webcast. As promised, here are links to the resources associated with the demos. Downloads: SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Feature Pack (February 2007): http://www.microsoft.com/downloads/details.aspx?familyid...

I'll be giving a webcast in one week on the manageability improvements introduced in SQL Server 2005 Service Pack 2. Feel free to post questions/comments to this blog that you'd like me to address during the webcast. Date: Tuesday, March 20, 2007 1:00 PM Pacific Time Event Overview In...

Have you ever noticed one of your SQL Server instances running unusually slowly? Have you had difficulty quickly identifying what areas could be affecting its performance? One of our customer support Escalation Engineers, Keith Elmore, specializes in understanding these types of problems. He has...

Update (2007-Mar-06): http://blogs.msdn.com/sqlrem/archive/2007/03/06/Maintenance-Plan-Changes-Update.aspx Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools. Who is affected? You...

After working on SQL Server 2005 Service Pack 2 for the past 9 months, I am elated to see it be officially released to the web. This service pack will not only address the most common bugs reported from customers, but it also introduces some cool new functionality. I am meeting with Kimberly Tripp today...

Before I go on vacation, I'd like to send a quick thank you to the community for giving us their thoughts on the November CTP of SP2. There were many thousands of downloads and a lot of people have started posting their suggestions and bug reports on Microsoft Connect . I'd like to call out a few...

One of the improvement areas we've introduced in Service Pack 2 is the ability to run your own reports inside Management Studio. Here is a draft of the Books Online topics. This is subject to change at any time. The November CTP of Service Pack 2 can be obtained here: http://www.microsoft.com/sql...

SQL Server 2005 Service Pack 2 - November CTP is available for download. For more information please visit: http://www.microsoft.com/sql/ctp.mspx . Over the next few weeks, we will be posting blogs on some of the improvements the SQL Server Manageability team has made in Service Pack 2. Visit the...

Sorry for the delay for part 3. I have not been able to take our existing standard reports and make them work properly in a Reporting Services environment. I'm going to release the files anyway, in case one of you can figure out what is wrong. I'm not a Reporting Services guru, but I hope that somebody...

One of my favorite reports is Disk Usage. It prepares two useful graphs breaking down the MDF and LDF space usage. It also provides information about disk space used by tables, partitions, and indexes. This data can also be exported to Excel so you can perform your own calculations. (To export, right...

Did you know that there is a set of pre-made reports in Management Studio that can help database administrators gather information in many common areas? There are reports for CPU, memory, disk, sessions, queries, transactions, and more baked right into Management Studio. You can access these reports...