// archive
Category: SQL Server
-
Visual Studio Database Projects and the Problem with Reference Data (Part Two)
In my previous post, I discussed the difficulties of saving reference data in a Visual Studio Database Project. In this post, I’ll go over the architecture of one way this problem can be solved. While doing some research on this topic I ran across this StackOverflow question “How do you store static data in your…
-
Visual Studio Database Projects and the Problem With Reference Data (Part One)
I’ll be honest. I wasn’t a fan of Visual Studio Database Projects. I still believe that designing databases using a data modeling tool like ER/Studio or ERwin is the very best way to build a database. But after taking a hard look at the Database Project project template I’ve changed my tune. There are some…
-
Why You Absolutely Need Alternate Keys: A Unique Constraint Story
Although often forgotten, alternate keys are an essential part of database design especially if you’re using surrogate keys. Alternate keys protect your database from duplicate data and can even speed up your application. For the past few years I’ve been presenting on the top database design mistakes that I’ve seen “in the wild”. One of those “mistakes”…
-
Summit 2013 In Review: The Good
The PASS Summit had a lot to live up to. I’ve heard so much about the Summit from my fellow PASS members I fully expected it to be located in the Land of Oz, staffed by the Kermit the Frog and the Muppets, and the speakers carried lightsabers while moving you to tears by just…
-
T-SQL Tuesday #41: How I Started Presenting
For my first T-SQL Tuesday post this is an appropriate title. I love speaking. It all started when the call for speakers came out for the very first South Florida IT Pro Camp. At the time I was a practicing project manager and was looking for excuses to keep my technical skills up-to-date. I was finding…