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:
