Browse by Tags

Tagged Content List
  • Blog Post: Multiple Server Query Execution in SQL Server 2008

    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...
  • Blog Post: 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 Server 2005 Best Practices Analyzer . It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools. And...
  • Blog Post: 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. 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...
  • Blog Post: 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. I'm announcing the official release of SQL Server 2005 Best Practices Analyzer as an independently serviceable tool. What do I mean by independently serviceable? Software is a rapidly changing...
  • Blog Post: 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 blog, the engine team has introduced the VarDecimal storage format. They have just published a whitepaper on how to reduce your database size. Check it out: http://msdn2.microsoft.com/en-us/library/bb508963...
  • Blog Post: 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 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...
  • Blog Post: 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 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...
  • Blog Post: SQL Server Manageability Webcast - SP2 Improvements - Resources

    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...
  • Blog Post: SQL Server Manageability Webcast - SP2 Improvements

    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...
  • Blog Post: SQL Server 2005 Performance Dashboard Reports -- Now Available!

    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...
  • Blog Post: Maintenance Plan Changes in SQL Server 2005 SP2

    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...
  • Blog Post: 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 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...
  • Blog Post: 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 address some of the most common questions. SP2 When will SQL Server 2005 Service Pack 2 be available? SQL Server 2005 SP2 is currently available as a Community Technology Preview. This is a pre-release...
  • Blog Post: 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 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...
  • Blog Post: 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, find out what changes and determine if it's right for you/your team. For some environments, it will take a great amount of effort to investigate and adopt SQL Server 2005. We in the SQL Server Product Team...
  • Blog Post: Custom Reports in Management Studio

    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...
  • Blog Post: SQL Server 2005 Service Pack 2 - November CTP

    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...
  • Blog Post: SQL Server Best Practices Analyzer - Webcast - Resources

    Resources for today's webcast. Webcast: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032306503&EventCategory=4&culture=en-US&CountryCode=US Upgrade Advisor Tool: http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang...
  • Blog Post: 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 Best Practices Analyzer. You can follow the link below to register for the event. I will try to address the questions and concerns that were brought up in previous blog entries. If you'd like to ask questions...
  • Blog Post: 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 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...
  • Blog Post: Management Studio Reports – Part 2 – Disk Usage Report

    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...
  • Blog Post: Management Studio Reports – Part 1 – Finding the Reports

    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...
  • Blog Post: Overview of SSMS-E Webcast URLs and Code Snippets

    As part of my web cast, there are several URLs and sample scripts that I’d like to share with you. Demo 0 – Downloading. The URL that I use to find the download site for SQL Server Express is to start at: http://msdn.microsoft.com/sql/ . It’s not direct, but it gets you close. Over in the...
  • Blog Post: SQL Server Best Practices Analyzer - Progress

    Thank you to everybody who posted comments in newsgroups, forums, and on the first SQL Server™ Best Practices Analyzer blog entry . We have been able to complete a lot of your requests already. We’ve had some great short-term success with SQL BPA 2.0. Thanks to a lot of help from the Exchange Best...
  • Blog Post: Best Practices Analyzer for SQL Server 2005

    I’ve seen a few posts in forums and newsgroups requesting Best Practices Analyzer support for SQL Server 2005. Good news… we just started developing a new version that will work with SQL Server 2005! If you aren’t familiar with this type of utility, check out Best Practices Analyzer Tool for Microsoft...
Page 1 of 1 (25 items)