Is 0% Downtime Possible?
Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.
2002-02-25
5,997 reads
Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.
2002-02-25
5,997 reads
2002-02-15
3,573 reads
A new T-SQL Bible that is a must have for SQL Server DBAs. Read a review of this book.
2002-01-23
14,674 reads
If you are like most DBAs, you have probably implemented some type of hash function for some of your tables at one time or another. This article takes a look behind the scenes as to how the Identity property works.
2002-01-17
6,551 reads
2002-01-11
3,471 reads
Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.
2002-01-08
8,440 reads
Things your non-technical friends don't want to hear in the lab...
2002-01-04
3,958 reads
If you use identity values, chances are that at some point you will need to find more information about the next value or reset the seed. This article looks at how you can accomplish this.
2001-12-31
7,175 reads
One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?
2001-12-04
6,247 reads
2001-11-16
2,515 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers