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 » SQL Server » Database Developer   (RSS)
Showing page 1 of 2 (14 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
  • 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
  • Article: An Example of Test-Driven Development

    Today, SQLServerCentral republished the first article in my Test-Driven Database Development series: An Example of Test-Driven Database Development. (Thanks SSC!)
    Posted to Andy Leonard (Weblog) by andyleonard on October 29, 2010
  • SQL Saturday #48 Recap

    Introduction I got to attend SQL Saturday #48 2 Oct 2010 and was honored to present. ''I'm Andy, and I'm a session-hopper.'' There. I said it. When I'm not presenting, I often wander between sessions. I want to learn a little something from everyone. Here are some sessions I wandered through and some notes from them: Alejandro Mesa - ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 4, 2010
  • Presenting Database Design for Developers for PASS AppDev - Today!

    I am honored to present Database Design for Developers to the PASS AppDev Virtual Chapter today at noon EDT via LiveMeeting! Details here. :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on June 8, 2010
  • The Database Design Process

    Introduction Buck Woody (Blog - @BuckWoody) recently blogged about his Database Design Process and I see Grant Fritchey has a (Blog - @GFritchey) post on the same topic. I figured I'd throw my two cents into the mix. ADD I often joke that I practice ADD (Andy-Driven Design... what'd you think I meant?). I'm expecting a ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 21, 2010
  • Speaking in Richmond - Tonight!

    I am honored to present Database Development to the Richmond SQL Server Users Group this evening! I'm looking forward to the presentation and our upcoming Richmond Code Camp 2009.1 this Saturday! :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on April 23, 2009
  • Who Thinks Like Database Professionals?

    Introduction I was talking to my team this morning and we were wondering about some design decisions. One of the things that came out of the discussion was: Database professionals think differently. Differently? How? A little story: Before I was a database person I did web development. That's a little misleading because I wrote very little ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 31, 2009
  • New SSIS 101 Article

    My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on August 21, 2008
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement