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
Incorporate Data Warehouse QA Checks into MOM 2005
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.
Database Visualization
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.
SQL Server 2005 Programmability Enhancements � Common Table Expressions
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.
User-Defined Functions: Powerful Alternatives to Views and Stored Procedures
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.
Storing Session State in a SQL Server Database
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 Videos
More...Latest CodeGuru Developer Columns

Control Statements and Basic Loops in C++/CLI
Become more proficient on the usage of statements to control the flow of execution through a C++/CLI application.

A .NET DNS Lookup Tool
Just by using a bit of code, you can find virtually any IP address and its "real" name.

Working with Windows 8.1 Control Panel Applets
Discover how to run all the various Control Panel applets from your own program.
Maker Project: Creating a Garage Door Opener
Have you ever wanted to control your garage door from your smartphone? Here is your chance. Get your hands dirty with an Arduino Garage Door Controller.






