Ready to head into the clouds and try your hand at a version of SQL quite different from those you know today? Sign up for a SQL Azure account, then grab this sample database to start you off. It appears that Microsoft has finally explained why there is no performance clustering in their SQL product……
Year: 2009
Sample Databases for SQL 2008
Now that many of us are upgrading to SQL 2008, we need a new sample database. If you’ve obtained a copy of SQL 2008 Developer Edition, if not, check out Amazon! I got my copy for $45! After you’ve obtained your copy, go to the link below and grab your sample databases! Reference: http://msftdbprodsamples.codeplex.com/releases/view/37109
Sample Databases for R2
..or as I call him, Ar-too. In case you haven’t heard, SQL 2008 R2 has been released as a preview. If you have downloaded it, and are looking for a sample database, codeplex has come to save the day. Hit the link below and you can download their latest sample database. Enjoy! Reference: http://msftdbprodsamples.codeplex.com/releases/view/24854
SQL Session – Execution Extract, Transform, and Load your Data Warehouse
If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
Surprise!!!!
Another year in the books. Time to take a break from the daily grind and go out into the world. I hereby declare this a holiday! On this day you should eat, drink, and be merry! Wait, that’s Christmas. OK, in that case, slack off, and have fun. How’s that? Play some video games, enjoy…
Another Year Older, But Am I Any Wiser?
A review of the past year. Have I learned any lessons…. we’ll see!
SQL Session – Execution Plan Caching and Reuse
If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
And Now For Something Completely Different
I’ve been debating what to do about my weight a lot lately. My doctor’s have always given me the helpful gems: “Eat healthier foods,” and “Go to the gym.” I know I have to do something about it. I’ve always tried diet and exercise, and always failed to become healthy. Sure, I could lose 10…
Find Stored Procedures Referencing…
Time and time again, I find myself trying to find all the stored procedures that reference a specific database object. It usually comes around when I’m working on changes to a table’s structure, or I’m replacing a table with a view. I’ll usually reach for the following query (or something like it. 1: SELECT ROUTINE_NAME…
My July 4th
Guess where I spent the evening of the 4th? I finally made it down to m5! It was awesome. There was even a simple piece of paper on the door, thanking fans for finding the place. It was late, and no one was around, but I figured they wouldn’t be working that week anyway.