This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed.
2002-12-23
11,273 reads
As a new DBA, you will probably walk into an environment that is poorly documented and nobody has any idea of how many SQL Servers are on the network. In the first series of articles, Haidong Ji talks about how to audit logins in your SQL Server.
2002-12-20
19,677 reads
A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.
2002-12-19
12,872 reads
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
2002-12-17
8,211 reads
Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.
2002-12-13
3,969 reads
Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!
2002-12-11
9,994 reads
EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.
2007-09-22 (first published: 2002-12-09)
32,481 reads
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
2002-12-04
8,129 reads
2002-11-27
7,450 reads
2002-11-22
14,597 reads
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
Comments posted to this topic are about the item How Clustering can be Used...
Comments posted to this topic are about the item Moving the Error Log
Comments posted to this topic are about the item A Security and AI Fail
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers