By Thomas Davidson – Take advantage of query recompilation to optimize your SQL Server performance.

DSN less connections don’t require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. We will now see how to connect to a database via ASP using Connection String in place of DSN name.

By Tore Bostrup – This is the first of a two-part article that will provide an introduction to relational databases and the SQL language. This first part describes some of the key elements of the technology with an emphasis on database normalization. The second part will describe a less theoretical

This is yet another FAQ from Microsoft public SQL Server newsgroups. Lot of SQL Server developers are used to using @@IDENTITY to retrieve the value of the IDENTITY column immediately after inserting a row. We are missing that functionality when it comes to inserting rows with GUIDs as keys. Unfortu

By Alexander Chigrik – As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends using the sp_lock system stored procedure to report locks information. This very useful procedure returns the information about SQL Server process ID, which lock the data, about loc

By Andrew Georgopulos – The first step in my initiation as a SQL Server admin came after only a week or two on the job. I was confronted with a message that made my palms sweat. The error read something like this:

by Peter Wayner – Find out how one-way functions can be used to help protect sensitive data in your SQL Server databases.

By Michael Otey – Here are seven facts that reveal why SQL Server’s market share is increasing so quickly.

Thursday, June 6, 2002: 10:00 A.M. Pacific time – The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying arc

By Vyas Kondreddi – There is lack of information on this topic of “Implementing security at row level”. So, I decided to propose a solution for this issue through this article. I hope it gives you a head start, if you are planning to implement row level security.