Email Alerts
-
SQL Service Broker and Microsoft Message Queuing
SQL Server 2005 expert Adam Machanic discusses SQL Server 2005's native, queued messaging system, SQL Service Broker. Ask the Expert
-
SQL Server 2005 DDL vs. DML triggers
SQL Server 2005 adds a new type of trigger -- DDL (Data Definition Language) triggers. Find out how they compare to "normal" DML triggers in this expert response. Ask the Expert
-
SQL Native Client
Don't know what SQL Native Client is and how it can help you? SQL Server 2005 expert Adam Machanic discusses what it can do for you. Ask the Expert
-
What are Event Notifications?
SQL Server 2005 expert Adam Machanic discusses the similarities between Event Notifications and DDL triggers. Ask the Expert
-
What is the SQLCMD tool used for?
In this expert response, SQL Server 2005 expert discusses SQL Server 2005's command-line query tool. Ask the Expert
-
SQLCLR permission sets
SQL Server 2005 expert Adam Machanic discusses SQL CLR permission sets in this expert response. Ask the Expert
-
Forced parameterization database option
In this expert response, expert Adam Machanic discusses a new SQL Server 2005 setting called forced parameterization. Ask the Expert
-
Overcoming SQL Server's 8060-byte row limit
SQL Server 2005 expert Adam Machanic discusses an important feature called row overflow, which greatly relaxes the 8060-byte restriction. Ask the Expert
-
Relationship between SQL Service Broker and Microsoft Message Queuing
SQL Server 2005 expert Adam Machanic discusses the relationship between SQL Server Broker and Microsoft Message Queuing. Ask the Expert
-
Free version of SQL Server 2005 tops list of downloads
The five most popular picks on Microsoft's SQL Server downloads site include its free SQL Server 2005 Express, MSDE 2000 and the most recent service packs for SQL Server 2000. Article