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.
Latest Database Articles - Page 6
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.
Table-valued user-defined functions (UDFs) are functionally similar to views but structurally similar to stored procedures, giving them all the important features of views and stored procedures and some additional functionality that they lack.
Learn to implement and OLE and IDispatch interface to access basic Excel functions from a C++ application.
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
It's essential to know the differences in these libraries and use them correctly. This brief tutorial will guide you.
Learn about a very nice combination of technologies: Entity Framework Core 1.0, SQLite, and a console application.
Learn how to build a basic plug-in framework into your existing applications.
Application Programming Interfaces (APIs) are where you have to be. It's not a matter of if as much as a matter of which.