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,163 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,207 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,742 reads
This article discusses an often-overlooked feature of SQL Server called user-defined data types.
2002-12-17
8,185 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,958 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,915 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,310 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,089 reads
2002-11-27
7,424 reads
2002-11-22
14,521 reads
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers