SQL Server 2005 High-Availability Options (Distilled)

Have you ever been asked by a high-level architect or CIO what Microsoft’s approach is to a given scenario?  If you have, then you know the challenges faced because as you read through MSDN and TechNet and even at the Microsoft.com site level, you find a lot of material which is very large and complex. …

0

Creating the Infrastructure for Capturing a Data Model

At this point, all I’ve given you is a set of tables that can store metadata about database tables and their relationships – they pretty much reflect a subset of what you can get from the system views.  Let’s take a look at the process for capturing this information as the database is modified.  The…

0

Monitoring Data Model Changes

Have you ever wanted to view how a database model has evolved over time?  It’s not that hard to setup an infrastructure for supporting this.  In this series of articles, I’ll go over the process for this.  For a jump start on the whole process, I’ve provided a PowerPoint and a paper that I wrote…

0

Welcome Back, again…

After a false start a couple months back, I’m determined to get more involved in the community and start blogging daily and not let all the distractions get me away from this.  My background includes over 22 years in software development.  I am currently working for Microsoft as a Sr. Consultant working in the Department…

0