You can leverage SQL 2005 Server Service Broker with existing technologies such as SQL Server 2000 and MSMQ. BizTalk and SSB external activation are viable options, but a simple polling solution is easier.
Latest Database Articles - Page 6
Learn about a pair of stored procedures that can dump all users, role memberships, and permissions in a database, or copy them from one database to another.
Utilizing design patterns with SQL Server 2005 Service Broker enables you to assess and select appropriate solutions for all of your SQL Server 2005 asynchronous messaging needs.
Microsoft Operations Manager 2005 (MOM) is a very capable monitoring tool, but it's limited when it comes to quality assurance. Learn how to use WMI and MOM's rules and notification capabilities to run automated data warehouse QA checks.
When handling a project with hundreds of tables, it takes some time to understand the flows. Learn how to create a simple tool for Visualizing database tables and relations.
There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them specifically, Common Table Expressions (CTE), because they often come in handy.
Latest CodeGuru Developer Columns
Learn to implement exception handling mechanism in C++.
Learn to use generics in TypeScript the same way as you would with C#.
Menus allow you to arrange commands in a logical and easy-to-find fashion. Use VB to fashion your own menus.
Explore Microsoft Graph, a developers' API platform to connect to the data that drives productivity.