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 SQL Server Articles - Page 4
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.
In ASP.NET 2.0, you can customize the session state store as per your requirement. Explore one of the scalable and reliable approaches for storing session variables—SQL Server.
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
The Transactional File System (TxF), which allows access to an NTFS file system to be conducted in a transacted manner through extensions to the Windows SDK API. MFC 10, has been extended to support TxF and related technologies. This support allows existing MFC applications to be easily extended to support kernel transactions.
The original release of the .NET Framework included collections as .NET was introduced to the Microsoft programming world. The .NET Framework 2.0 introduced generics to complement the System.Collections namespace and provide a more efficient and well performing option. Read on to learn more...
Learn how to use a for loop to loop through all of the images found on a web page and save them via the DownloadFile method of the WebClient object.
SOLID principles form the base for writing good and clean object oriented code in C#. Learn about the S.O.L.I.D principles and explore C# coding samples for each.