Do you want to get a glimpse into how the Microsoft Field Engineers would go about troubleshooting performance issues on...
With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.
Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.
In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.
Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.