Saturday, February 7, 2009

MSSQL 2008 System View release!

Are you a DBA? Want to know how the overall architecture of MSSQL? Ever wonder how you can manage the databases easily? How you can create a version of simple MSSQL Management Console better than mine? Yes, now you can see how it works through the entity-relationship model (ERM) at here.

Start from sys.objects, sys.columns, ..., you can easily manipulate your T-SQL scripts within the following categories of component:
  • Objects, Types and Indexes
  • Trace and Eventing
  • Linked Servers
  • Common Language Runtime
  • Partitioning
  • Database Mirroring
  • EndPoints
  • Database and Storage
  • Execution Environment
  • Service Broker
  • Security
  • Transaction Information
  • Resource Governor
  • Server-Wide Information
  • Full Text Search
  • Extended Events

p/s: During last year PDC 2008, .NET FX team has released a selection of new types and namespaces introduce in FX4 at Brad Abrams's blog. From there, you can download 2 versions:

  1. PDF version
  2. DeepZoom version