Service Broker is message queuing for SQL Server: it sends asynchronous, transactional messages, and Database Mail relies on it. How it works, in simple terms.
SQLAuthority News – Updated My Personal Book Mark Pages
I refreshed my personal book mark pages with my favorite SQLAuthority articles. Tell me which of your favorites I missed for a new readers list.
SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting
I will speak on SQL Server Best Practices at the Ahmedabad SQL Server Usergroup meeting on July 19, 2008. Come meet fellow developers and DBAs.
SQL SERVER – Readers Contribution to Site – Simple Example of Cursor
A reader wanted to join values from several rows into one record. Imran Mohammed answered with a simple example of cursor code in SQL Server 2005.
SQL SERVER – Deferred Name Resolution
Why can a stored procedure with a wrong table name be created, but not one with a wrong column name? Deferred Name Resolution explains it.
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Part 2 on SPARSE Columns in SQL Server 2008: how they are stored as one XML column, plus the main advantages and the limits you should know about.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
SQL Server has many features you can turn on or off. Use sp_configure to display or change global configuration settings, including the advanced options.
SQL SERVER – 2008 – User Account – sa or sysadmin
SQL Server 2008 treats sysadmin as the modern home for the old sa account rights. Here is what changed and why sa now needs a password.
SQL SERVER – 2005 – Two Important Security Update
Two security update packages for SQL Server 2005 Service Pack 2, KB948108 and KB948109, fix an issue that could let an attacker take control of your system.
SQL SERVER – 2008 – Introduction to SPARSE Columns
A quick introduction to SPARSE Columns in SQL Server 2008, which take almost no space for NULL and zero values. Learn the basics and the 100,000 column limit.