Congratulations to Brian McDonald who has triumphed as the winner of this month's Zune contest. Brian achieved more than 700 points on BIDN over the past 30 days and was also promoted to Jedi Knight status because of that :).
Read More
Microsoft Business Intelligence Summer School Upgrade Your Resume in 1 Day In this full-day virtual workshop, you'll learn from author team Brian Knight and Devin Knight how to build a data warehouse for your company and support it with the Microsoft business intelligence platform. What you'll learn in this online workshop : How to design a data warehouse How to load a data warehouse with Integration Services How to create slice-and-dice reports with Analysis Services How to create beautiful das...
The contest for the ZuneHD is about half way over ( http://www.bidn.com/blogs/BrianKnight/ssis/784/zune-contest-for-community-participation-in-july). So far, you can see the contest is a close one with the numbers showing a rolling 30 days. PatrickLeBlanc 329 Padawan briankmcdonald 305 Padawan SMcDonald 245 Padawan DustinRyan 216 Jedi Knight AdamJorgensen 200 Jedi Knight indupriya 160 Padawan BrianKnight 136 Padawan DevinKnight 130 Jedi Knight MarkGStacey 125 Padawan MikeMollenhour 100 Padawan
It's always funny when I go 12 years in this industry and don't know some basic trick about writing T-SQL until weeks ago. So, in today's installment of Doh' that's Cool, I wanted to share with you a trick I learned from watching another DBA (Patrick LeBlanc) recently and then said, "How'd you do that?!". This trick will help you write queries much faster and hopefully get you out of the bad habit of typing SELECT *. To do the trick, simply open your query window in Management Studio. Then, when...