SQL Server (RSS)

04 February 2008
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 Read More...
7 Comments  
18 January 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 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 Read More...
14 Comments  
15 January 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. 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 Read More...
2 Comments  
Attachment(s):Workaround for SQLCE Setup issue.docx
04 July 2007
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? ... Read More...
9 Comments  
29 May 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 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 Read More...
1 Comments  
10 April 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 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 of my readers are also technology enthusiasts by profession. The problem I have now is that I do not have enough time in the day to learn about everything that could be cool and figure out how it could be useful. I recently watched a video by Brian Knight from JumpStart TV on SQL Server Agent Proxy Accounts. I thought it was a great way to quickly learn about one piece of SQL Server Agent without reading lots of documentation. To reach the broadest audience most effectively, I'm considering putting together short videos like the folks at JumpStart TV to give you an overview of how to use our features. My questions to you are... Read More...
12 Comments  
28 March 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 re-cap of my sessions and links to session content... Read More...
2 Comments  
20 March 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 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=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en Read More...
0 Comments  
12 March 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 Service Pack 2. Feel free to post questions/comments to this blog that you'd like me to address during the webcast. ... Read More...
0 Comments  
07 March 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 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 worked with customers all over the world on diagnosing their toughest and most critical performance bottlenecks. Keith has put together a set of Reporting Services reports ... Read More...
46 Comments  
24 February 2007
Maintenance Plan Changes in SQL Server 2005 SP2
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. ... Read More...
18 Comments  
19 February 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 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 to show her some of the cool scenarios that are now possible with SP2. ... Read More...
4 Comments  
12 January 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 address some of the most common questions. SP2 When will SQL Server 2005 Service Pack 2 be available? I see there are a lot of great features in the December CTP of SP2. I can’t upgrade my DB engine, yet. Can I upgrade only the tools on my client workstation? Will this still work with SQL Server 2005 RTM and SP1? When will SQL Server 2005 Best Practices Analyzer be available? BPA What are some of the new features in SQL Server 2005 Best Practices Analyzer? Will we be able to create our own rules? Who is the target audience for SQL Server 2005 Best Practices Analyzer? We used SQL Server 2000 Best Practices Analyzer 1.0 to check our T-SQL code. It is very useful in our development process. Why are you getting rid of it? Read More...
10 Comments  
19 December 2006
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 MVPs for their reviews/feedback on the features in my area... Read More...
9 Comments  
20 November 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, 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 Read More...
1 Comments  
More Posts Next page »
Page view tracker