THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Developer   (RSS)
Showing page 1 of 6 (55 total posts)
  • Database Design: 3-State Bits

    I can hear you thinking, “Andy, you’re off your old rocker. There are only two states for bit values!” And you are correct. Almost. What if I’m storing a truly binary value – a value that possesses only two possible states – but there’s the possibility of a third state to indicate that I do not know which state applies. Consider this ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 6, 2015
  • RichmondSQL Meeting Tonight! (12 Dec 2013) - Az Arunachalam on Extended Events

    When: Thursday, December 12th, 2013, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! SQL Server Extended Events Microsoft is deprecating Trace and Profiler, a staple for monitoring SQL server since forever, in favor of Extended Events, introduced in SQL 2008. Monitoring of some of the new features like AlwaysOn Availability Groups in SQL ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 12, 2013
  • Revisiting Test-Driven Database Development

    I received an email from a database professional asking about re-executable T-SQL. I directed the developer to my series at SQL Server Central on Test-Driven Development: An Example of Test-Driven Development An Example of Test-Driven Development, Part 2 An Example of Test-Driven Development, Part 3 An Example of Test-Driven Development, Part ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 7, 2012
  • SSIS Design Patterns, the Book

    For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 6, 2012
  • Presenting at Regina Technology Community 26 Apr 2011!

    Introduction I'm honored to deliver two presentations to the Regina Technology Community 26 Apr 2011! Part I - Database Design for DevelopersThis interactive session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 19, 2011
  • SSIS Training: From Zero To SSIS! 6-10 Jun 2011

    The next public delivery of my SSIS training course From Zero To SSIS! is scheduled for 6-10 Jun 2011 in Farmville Virginia! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on April 4, 2011
  • PASS Summit 2010 Presentation Feedback

    Introduction It's always an honor to present anywhere. Presenting at the PASS Summit is a special honor. I delivered three presentations last month: Database Design for Developers SSIS Design Patterns, Part 2 A Lightning Talk on SSIS Database Design for Developers First, a bit of explanation (defense): I submitted this abstract ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 22, 2010
  • An Example of Test-Driven Development, Part 5 republished!

    My friends at have republished the fifth article in my TDD series: An Example of Test-Driven Development, Part 5! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on November 26, 2010
  • Article: An Example of Test-Driven Development, Part 4

    SQL Server Central has graciously republished my article An Example of Test-Driven Development, Part 4 today! I also wrote the SSC Question of the Day about an interesting quirk when executing encrypted and non-encrypted SSIS packages. :{>
    Posted to Andy Leonard (Weblog) by andyleonard on November 19, 2010
  • Article: An Example of Test-Driven Development, Part 3

    Christy and I are enjoying our last full day in Seattle today. We miss the kids terribly and look forward to the last party or two this evening, followed by the long redeye home.   Today, SQLServerCentral republished another article in my Test-Driven Database Development series: An Example of Test-Driven Database ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 12, 2010
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement