Depending on your database server, including its configuration and maintenance, you may or may not be able directly restore a database to any previous point in time. However, even with applications to help with log file management and presentation it is not practical to use restored copies of a data

This article serves as a quick reference as well as provide you with some background information on the Microsoft SQL server’s Sa account and how to change the password even if the currently set password is unknown.

By Jon Rubin – The typical midsize-to-large enterprise today has a number of relational database management system (RDBMS) products, running on multiple platforms, with dozens of distinct instances–some of which host multiple database applications.

By Brian Moran – Here’s how to provide feedback to Microsoft about the code snippets in SQL Server “Books Online” (BOL) and other SQL Server documentation sources.

SQL Server installations can have differences in configuration settings and server properties, which can lead to subtle changes in code behavior. Therefore, you should inspect the configuration before beginning to code to a given SQL Server 2000 server. Ron Talmage provides tools and techniques for

By Alexander Chigrik – In this article, I want to tell you about general details of SQL Server 7.0 locking, about Transaction Isolation Level, what kinds of Transaction Isolation Level exist, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hint

Archiving is the process of getting rid of old data (or data that is not valid anymore) from the main production databases. There is no built-in command or tool for archiving databases. In this article I’m going to show you how to implement this process.

By AjarnMark – When you are ready to make the jump to SQL 2000, you will find that there are several ways that you can do this. Of course, each method has its advantages and disadvantages, and which one you choose will be based on a number of factors. I will attempt to introduce these factors and ho

By Paul Krill – MICROSOFT released a JDBC driver enabling Java developers to utilize Microsoft’s SQL Sever 2000 database as a data management system for Java applications.

By Michael Otey – Query Analyzer is one of the most frequently used utilities in SQL Server’s tool set. Here are seven keyboard shortcuts that make Query Analyzer a more effective and productive tool.