Neil Boyle explains the mechanisms SQL Server uses to secure itself from unauthorized access, and discusses best practice for selecting..
A trigger is a database object that is attached to a table. In many aspects it is similar to a..
A few months ago I wrote an article for SQLTeam called An Introduction to Triggers -- Part I. The article..
Gregory A Larsen explains a few things that need to be understood about mixing collations, now that it is possible..
This article demonstrates an email queue system using SQL Server and VB Script. This overcomes the limitations of the Sending..
I bet almost every DBA has at times desperately wanted to be able to compare data and structure between database..
In this article, I want to tell you about data page structure in MS SQL Server 6.5, which are substantially..
This article comes from Jeff Smith. Jeff writes "It can be difficult in a set-based language such as SQL to..
You give so much to your database . . . sometimes you just want something back. What do you give..
*Site Registration RequiredIf you are like most DBAs, you have probably implemented some type of hash function for some of..