Data Dude (Visual Studio "DBPro") has generally been an expensive tool - only in the "Team Systems" Edition of Visual Studio. But, that's all going to change in VS 2010. Here's a picture of the new editions and which components of Data Dude are where:

This is a HUGE improvement (after the clarification isn't not quite as huge but still VERY useful that the tools are in different editions) and is going to allow many of you to use/leverage these key features (such as Data Generation and Static Code Analysis - those are some of my favorites :)) in smaller shops - without having to purchase the full-on Team Systems Edition of VS. If you're interested in more info - check out the following:

CLARIFICATION!!

In 2010 “Team System” goes away (as a brand), and it's been replaced with VS 2010 Ultimate and Premium (VS Pro is still there). Basically VS Premium is similar to VSTS Development Edition + Database Edition (and is priced the same). Ultimate is similar to Team Suite. 

The functionality didn't really move down the product line (or the price point), the big different is that there's more than only DB Pro tooling in there now!

Thanks to Doug "D7" Seven for setting me straight!

Enjoy!
kt

Categories:
Tips | VS DBPro

This is a bit overdue as Kevin Kline tagged me in a meme post to help people get ready for their travel to PASS. However, we were too busy with travel (we were in Australia at the time) to get to it. And, while this year's PASS has past, it's not too late for travel in general OR for next year! I suspect that a few folks are already planning for PASS, or Connections, or other business travel! So, here we go - my travel recommendations/tips.

Travel tips:
  • Join the frequent flyer program even if you're not a frequent flyer. As long as you travel within another 12 months (and sometimes even longer) your miles won't expire... Miles (for upgrades or free tickets) are always good :) and even if you're only a 2 or 3 times a year flyer - they'll add up (again, as long as you keep traveling).
  • Try to pick an airline and stick with it. The more you fly, the higher the bonuses. In fact, I'm so focused on flying just one airline that I'll often fly two flights (for example, SEA -> DEN, DEN->MCO [Orlando]) even when another airline (like American) has a direct SEA->MCO. This happens more than I would like but it also means that I get things like extra bonuses as the end of the year. For example, as I hit each 25K after 100K (ah, I really do fly *A LOT*), I get 2 extra systemwide upgrades. These allow me to upgrade (at the time of booking) for any international flight from departure to destination. So, I can upgrade SEA->MEL (even though that's actually SEA->LAX, LAX->SYD and SYD->MEL). But, systemwides are only given at the highest levels... so, you really have to fly a lot and you MUST stick with the same airline. My airline of choice: United. Also, to help you earn points faster - be sure to check the airline promotions REGULARLY. For example, many airlines offered a "double your EQM (Elite Qualifying Miles)" for Sept to Dec flight... all solely for registering. This might get you to the next level with little work! Here's United's page on promotions: http://www.united.com/page/article/1,,52102,00.html?navSource=Dropdown07&linkTitle=earnmiles.
  • When you book, start by doing some research online. Try general travel sites (Expedia, Travelocity, etc.) first but be sure to check the specific airlines as well. And, you *might* need to get creative if your itinerary is messy. Paul and I recently had to travel to Dublin and then Warsaw on the same trip but when we booked the entire set of flights the tickets were OUT OF CONTROL expensive. We ended up booking SEA->DUB and then WAW->SEA (it's called an open jaw) and we saved over 60% (no, I'm NOT kidding). Now, don't get me wrong - we spent something like 5 hours coming up with different options/combinations both online and on the phone. And, in many cases this kind of thing costs more not less so it can get tricky; it really isn't all that common but can really help. One thing of which to be aware is that connecting flights on a different ticket may cause you A LOT of grief (even though they can save you $$$). If your final destination if DUB and you purchase one RT ticket (let's say SEA to LHR) and then a separate RT ticket LHR to DUB but you plan to connect in LHR to fly immediately to DUB... some airlines/partners do NOT allow the baggage to be checked all the way through - this means that you'll need to pick up baggage in LHR and check-in again (and since this is international - it means going through customs/immigration). What this means is that you'll need more time (so pick those connections with 2-3 hours - maybe more). And, if there are any delays, etc. you won't be a high priority for them... this is where it can get messy. But, I have to admit this is something I do OFTEN. I always *try* to fly on partner airlines (meaning Star Alliance) as I have "Gold" privileges BUT, this doesn't always help (when checking in). However, it can help while en route. Again, fly the same airline/group and it does have its benefits.
  • Seats – when you book, try and get your seats assigned. And, be sure to check out your seat on SeatGuru (http://www.SeatGuru.com). If you book online (which can often offer discounts) be sure to follow up by calling the specific airline to get your seats assigned. In fact, if the price isn’t all that much better you might be MUCH better off using the specific company’s website and/or phone system so that you CAN get your seats assigned. And, in the worst case, if you can’t get your seats assigned – get to the airport EARLY (really target the 1.5-2 hour rule) and then be VERY nice to the folks that check you in… see if you can get an exit row or bulk head. Hmmmm, bulkhead seating is debatable. On some planes, bulkhead
Getting ready for travel:
  • A couple of weeks prior – go through all of your dates and itineraries and double-check everything. Once, I arrived at an airport for a flight and I had been booked on the wrong day. I remember the phone call well – I had been going back/forth about specific dates (and costs) and in the end, my E-ticket was wrong. Had I double-checked it, it wouldn’t have been a problem… Luckily, seats were available and all was well (and, I had elite status) otherwise, it could have been a nightmare!
  • Is there anything special you’re taking? Does it need to make it to the cleaner, etc.? Are you going to remember to pick it up in time? Really, planning a bit for this is important. I’ve forgotten to go to the cleaner the night before a trip only to realize that my flight is so early that I can’t even stop on the way to the airport. Now I need to go to plan b. This is why Paul creates a comprehensive “Pack List” and he’s got it online. When he thinks of something he wants to take on a trip, he updates this doc. Then, the day before he packs – he double-checks it, prints it and then starts packing. I’m pretty good at remembering most things so I haven’t done this but I have forgotten a few things over the years and travels. So, I’d really recommend this and I’m probably going to do this moving forward too!
Making the travel less painful:
  • Sleeping. Does melatonin work for you? Or, have you even tried it? If you’re crossing many time zones, you might want to pick up a bottle of this. It’s an anti-stress/herbal sleep aid and taking it right before bedtime might help you sleep better and adjust more quickly.
  • Sinus rinse. I swear by this and I honestly think this helps me avoid getting sick on some flights. I rinse my sinuses twice daily regardless of travel but given that you’re traveling with so many other folks and breathing recycled air – rinsing your sinuses can’t hurt. And, you might want to pick up some saline solution for in-flight moisture. Here's a link for the specific sinus rinse I recommend: http://www.neilmed.com/usa/products.php#isotonic. And, they have a nasal moisturizer as well: http://www.neilmed.com/usa/products.php#nasogel.
  • Flight socks. Honestly, I just recently found out about these and I LOVE them. My feet can swell up a bit while flying (I just recently had foot surgery) and now, I wear these even for shorter flights.
  • Slippers. Yes, I actually travel with wool slippers. Seriously, I get cold...really cold... And, when I travel with these they make a HUGE difference. Especially for long haul flights. These aren't hard slippers - more like thick socks (easy to pack).
  • Snack. Even if you do get an upgrade – having a snack with you might make an otherwise hungry time a lot more bearable.
  • Water. I buy water in the airport prior to boarding so that I’m never without. Flying can be very dehydrating and that will only help you get sick.
  • Entertainment. Have something ready for you to read, watch, work-on… whatever. This is always my excuse to buy the trashy mags at the airport before I board. However, I have to admit that I know fewer and fewer of the stars referenced. Not sure how I’m supposed to feel about that?! J

Well… I’ll plan to come back to this and update it with other tips/tricks as I think about them!

Safe – and happy – travels to all! And, I look forward to seeing you at an event sometime soon…if not, at PASS, or Connections again next year.

Thanks for reading!
kt

Categories:
Conferences | Opinions

At PASS we hung out with Sean McCown and Jen McCown (of MidnightDBA) and chatted... and, despite our better judgement, it was recorded. ;-) These aren't overly technical but they are fun! Enjoy!!

And, our favorite "travel tip" from the video is to know your plane and check your seat on http://www.seatguru.com/. In fact, I have a few other travel tips and I'm overdue on a meme that Kevin Kline tagged me in so I'll post that shortly as well.

Enjoy!
kt

Categories:
Interviews | Resources

Well... it's finally been released and last week was the book launch. This book came together first as a goal by Paul Nielsen who was motivated by Steve Ballmer's request that MVPs "give back" even more and even outside of the direct technical community. Paul had the idea of a book - written for charity - and contributed to by MVPs. Well, here it is!

The book contains content from 53 MVPs with Paul Nielsen, Kalen Delaney, Greg Low, Adam Machanic, Paul S. Randal and I as editors. It was great fun going through all of the content and we're really happy that it's now available!

To purchase, click on the book (to the left) and purchase directly from Manning. When purchased through Manning a larger amount of the proceeds go to WarChild.

Finally, many of us were able to get together at PASS and "launch" the book. We gathered around a long table and people (if interested) had their copies signed. It was great fun! When it was all done - we took the group shot below.

Thanks for a great week (to all that were at PASS) and for great fun working on this title!

UPDATE November 16, 2009: After a few comments, I realized that a few people were tagged incorrectly in my facebook post of this photo and as a result, I had a few names switched around too. So, I just completely started over again and double-checked all the names... Also, I've added links to their websites so you can find out more information about the authors and editors of this title. Finally, I added that purchases should be made through the Manning website instead of other sites (so that more money goes to WarChild). And, finally, I added the entire chapter list with as many links as possible to everyone's websites. I'll keep this up-to-date as folks send me corrected lnks, etc. ENJOY!!

 

Present for the photo

Here's the full chapter list from the book - along with links to the authors/editors websites:

PART I

DATABASE DESIGN AND ARCHITECTURE
Paul Nielsen, Editor

 1. Louis and Paul's 10 relational database design rules by
Paul Nielsen and Louis Davidson 
 2. SQL Server tools for maintaining data integrity by Louis Davidson
3. Finding functional dependencies by Hugo Kornelis


PART II

DATABASE DEVELOPMENT
Adam Machanic, Editor
4. Set-based iteration: the third alternative by Hugo Kornelis 
5. Gaps and islands by Itzik Ben-Gan
6. Error handling in SQL Server and applications by Bill Graziano
7. Pulling apart the FROM clause by Rob Farley
8. What makes a bulk insert a minimally logged operation? by Denis Gobo
9. Avoiding three common query mistakes by Kathi Kellenberger
10. Introduction to XQuery on SQL Server by Michael Coles
11. SQL Server XML frequently asked questions by Michael Coles
12. Using XML to transport relational data by Matija Lah
13. Full text searching by Robert C. Cain
14. Simil: an algorithm to look for similar strings by Tom van Stiphout
15. LINQ to SQL and the ADO.NET Entity Framework by Bob Beauchemin
16. Table-valued parameters by Don Kiely
17. Build your own index by Erland Sommarskog
18. Getting and staying connected—or not by William Vaughn
19. Extending your productivity in SSMS and Query Analyzer by Pawel Potasinski

20. Why every SQL developer needs to have a tools database by Denis Gobo
21. Deprecation feature by Cristian Lefter
22. Placing SQL Server in your pocket by Christopher Fairbairn
23. Mobile data strategies by John Baird



PART III

DATABASE ADMINISTRATION
Kimberly L. Tripp and Paul S. Randal, Editors

24. What does it mean to be a DBA? by Brad McGehee
25. Working with maintenance plans by Tibor Karaszi
26. PowerShell in SQL Server by Richard Siddaway
27. Automating SQL Server management using Server Management Objects by Allen White
28. Practical auditing in SQL Server 2008 by Jasper Smith
29. My favorite DMVs and why by Aaron Bertrand
30. Reusing space in a table by Joe Webb
31. Some practical issues in table partitioning by Ron Talmage
32. Partitioning for manageability (and maybe performance) by Dan Guzman
33. Faster, smaller, and more energy-efficient backups without indexes by Greg Linwood
34. Using database mirroring to become a superhero! by Glenn Berry
35. The poor man's SQL Server log shipping by Edwin Sarmiento
36. Some understated changes found in SQL Server 2005 replication by Paul Ibison
37. High performance Transactional Replication by Hilary Cotter
38. Successfully implementing Kerberos delegation by Scott Stauffer
39. Running SQL Server on Hyper-V by John Paul Cook

PART IV

PERFORMANCE TUNING AND OPTIMIZATION
Kalen Delaney, Editor
40. When is an unused index not an unused index? by Rob Farley
41. Speeding up queries with index covering by Alex Kuznetsov
42. Tracing the deadlock by Gail Shaw
43. How to optimize tempdb performance by Brad McGehee
44. Does the order of columns in an index matter? by Joe Webb
45. Correlating SQL Profiler with Windows Performance Monitor by Kevin Kline
46. Using correlation to improve query performance by Gert-Jan Strik
47. Dr. DMV: how to use Dynamic Management Views by Glenn Berry
48. Query performance and disk I/O counters by Linchi Shea
49. XEVENT: the next event infrastructure for SQL Server by Cristian Lefter



PART V

BI DEVELOPMENT
Greg Low, Editor
50. BI for the relational guy by Erin Welker
51. Unlocking the secrets of SQL Server 2008 Reporting Services by William Vaughn
52. Reporting Services tips and tricks by Bruce Loehle-Conger
53. SQL Server Audit: change tracking or change data capture? by Aaron Bertrand 
54. Introduction to SSAS data mining by Dejan Sarka
55. To aggregate or not to aggregate: is there really a question? by Erin Welker
56. Incorporating data profiling in the ETL process by John Welch
57. Expressions in SQL Server Integration Services by Matthew Roche
58. SSIS performance tips by Phil Brammer
59. Incremental loads using T-SQL and SSIS by Andy Leonard

Categories:
Conferences | Resources

Theme design by Nukeation based on Jelle Druyts