04Feb 2009 by Grant Fritchey 1 Comment

VSTS:DB Composite Projects

Tools, Visual Studio
I've seen several searches go by from people who are looking for how to create composite projects. Here's a quick run-down. In the example, I'm going to create a main database project called BaseDB, a server project called MyServer, and a composite project that combines the two called Comp. This project is just another database project as you can see in Figure 1: [caption id="attachment_379" align="alignnone" width="450" caption="New Database Project"][/caption] Once the new project is created, you need to right click on the References object in the Solution Explorer. Figure 2: From the pop-up menu select Add Database Reference. The window in Figure 3 will pop up: [caption id="attachment_383" align="alignnone" width="450" caption="Add Database Reference"][/caption] You can select the other projects for a dynamic view into their changes, or for a…
Read More
03Feb 2009 by Grant Fritchey 2 Comments

SQL Server 2008 Management and Administration

Uncategorized
I just got a book in the mail from a friend, Todd Robinson, who was the technical editor. The name of the book is Microsoft SQL Server 2008 Management and Administration. The book was written by Ross Mistry and Hilary Cotter. I don't know Ross Mistry and I think I met Hilary Cotter once, although I know who he is. However, since Todd was involved, I'm pretty sure this is going to be a high-end, must read. I just started and the initial chapter's discussion on using Windows Server 2008 sparked a few questions for my local admin team. I'm looking forward to more. Thanks Todd.
Read More
02Feb 2009 by Grant Fritchey 3 Comments

Visual Studio Team System Database Edition Best Practices

Visual Studio
Barclay Hill, Program Manager for Visual Studio Team System Database Edition at Microsoft has just launched a new blog that I'm excited about. He's going to be blogging on best practices for VSTS:DB. His initial post outlines the topics he hopes to address and it's an impressive list. I responded immediately with an offer to help because I'm using the tool and struggling a bit to get it to do everything we need and because I really like all that VSTS:DB has done for me and my team already. Any one else interested in pitching in should go over there and get involved. Here's what I sent as an initial message: I saw your blog post and request for interest and participation and decided to pitch in. The company where…
Read More
29Jan 2009 by Grant Fritchey No Comments

PASS Board Summary

PASS
Andy Warren posted a summary of how he saw the PASS Board Meeting that recently took place. If you're a volunteer for PASS, I'd strongly suggest going over and reading it. SQLBatman also posted on this a few days ago. It's absolutely worth a read too. As a volunteer, I have to say, I really enjoy having some knowledge of what's going on, the processes behind the decisions, and the intent of those decisions. This knowledge makes it easier to maintain a level of enthusiasm that will help to keep me involved. I'm sure it'll work the same way for others. By the way, helping the community is one reason to get involved, but an even better reason is the great people you'll have an opportunity to work with.
Read More
27Jan 2009 by Grant Fritchey 3 Comments

New England Data Camp Evals

PASS, T-SQL, Tools
Anyone reading this who attended the New England Data Camp and filled out an eval, for any of the sessions, thanks. For those 63 evals between the two sessions that I received, thanks. Here are the aggregates on my sessions: Using Visual Studio Team System Database Edition: Average of Knowledge 8.344827586 Average of Presentation 8.482758621 Average of Preparation 8.103448276 Average of Interesting 8.172413793 Average of Overall 8.275862069 Number of Submissions 29 Understanding Execution Plans Average of Knowledge 8.647058824 Average of Presentation 8.617647059 Average of Preparation 8.705882353 Average of Interesting 8.529411765 Average of Overall 8.625 Number of Submissions 34 These are all on a scale of 1-9. I'm really quite happy with the results. Here are the average results for all the speakers and all the sessions at the Data Camp:…
Read More
26Jan 2009 by Grant Fritchey 2 Comments

Apress Alpha Program

Uncategorized
Apress has a new program called Alpha where they make available books in progress. You can download, for a price, an e-copy of some of the chapters of the book for early review. It allows you to get in on the action a bit and you can post comments to the author to influence the final work. My new book, SQL Server 2008 Query Performance Tuning Distilled, just got added to the Alpha program. They have 10 of the 16 chapters posted. Additionally, they've got a publication date set for March. I've only seen the production copy of three of the chapters and I'm on the second draft of chapter 16, so I think that seems tight, but they're the pros.
Read More
26Jan 2009 by Grant Fritchey 14 Comments

New England Data Camp v1.0 Results

Misc, PASS, SQL Server
I believe that the very first New England Data Camp was a success. We had about 185 attendees. There 18 sessions from 16 speakers. Both the sessions I gave and the one I sat in on were full. Credit goes to to Adam Machanic who did 90% of the work pulling this together. Amazing job Adam. My personal thanks to our sponsors.  First, Microsoft, who provided us with a magnificent facility, nice swag, a full AV suite, coffee and donuts and in the morning, and a lot of help. It wouldn't have come out as well as it did without you guys. Next, the Professional Association of SQL Server Users (PASS), who supplied us with money, without which we could not have eaten lunch, a few posters to decorate the…
Read More
22Jan 2009 by Grant Fritchey 7 Comments

SQL Server 2008 Management Studio Trick

Tools
I just had a Tremors moment. "Everybody knows about 'em Earl, we just never told you." Except that no one I showed it to has ever seen it before. So maybe this is something a little new. I had a database selected in the Object Explorer window and I had the Object Explorer Details window open. I noticed a little icon at the bottom of the screen: Then I saw that the bar above it was a moveable bar. So I moved it and saw this: Whoa! So then I tried a table, HumanResources.Department from AdventureWorks2008: Which caused me to check a procedure: Each line has a little icon on the side that lets you copy it, line by line. It's really just a way to display the basic properties…
Read More
20Jan 2009 by Grant Fritchey 2 Comments

Incremental Deployments using Visual Studio Database Edition GDR

Tools, Visual Studio
I'm stuck. I've been advocating that our company use composite projects for our deployments using the VSTSDBE GDR (Visual Studio Team System Database Edition, General Distribution Release for those not instantly geeky).  In a nutshell, VSTSDBE offers two mechanisms for deployment across multiple environments. Both of these work wonderfully well for automation when you are doing a full tear-down and rebuild. When you're doing incremental deployments, they both fail. Option 1: Use SQL Command variables to set environment specific variables such as file location, etc., and post-deployment scripts to set security. This works. It's the method we used prior to the GDR. Unfortunately, security and other environment specific information is hidden inside scripts rather than visible to a given configuration directly within the VS interface. Option 2: Create a composite…
Read More