October 2009 - Posts

• Prepping for PASS (apparently it is next week)

  Mercy, PASS is going to be a busy week for me.  My basic schedule is: Sunday: Arrive just after 4 PM. Bus to the Sheraton. Monday: Some Insiders stuff, some meetings, etc 6:30 or so, the Quiz Bowl 2009 (Celebrity Edition).  We have 3 star studded Read More... Posted Thursday, October 29, 2009 6:09 PM by drsql | 0 Comments

• Seventh pillar - Encapsulated

  The final numbered post in this version of my “pillar” series of posts ends in the most contestable part of the design/implementation process.  Encapsulation. The concept of encapsulation is not contested (or even contestable by sane programmers Read More... Posted Friday, October 23, 2009 5:50 PM by drsql | 0 Comments Filed under: Database Design, Best Practices, Design, Pillars

• Sixth pillar – Well Performing

  I guess eventually I had to admit that performance matters. Whenever I speak, and in all of my books, I try to stress over and over that performance is NOT the only thing. The fact is all too much time is spent trying to make database applications run Read More... Posted Tuesday, October 13, 2009 8:57 PM by drsql | 3 Comments Filed under: Best Practices, SQL Tools, Writing, Pillars

• Fifth pillar - Secure

  As I have mentioned in all of the previous posts, basic functionality is the foundation of any system. So it goes without saying that if you have just implemented a payroll system, everyone is getting paid.  To meet the basic bar that EVERYONE agrees Read More... Posted Tuesday, October 06, 2009 7:52 PM by drsql | 1 Comments Filed under: SQL Server, Database Design, Pillars, Security

• MVP Award Renewal

  On October 1, I received my email stating that I was again renewed as an MVP. One of the greatest honors I have ever received is the Microsoft MVP Award, certainly it is the greatest professional honor. And while there are some benefits to getting the Read More... Posted Sunday, October 04, 2009 3:50 PM by drsql | 3 Comments Filed under: MVP