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
6,004 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
6,004 reads
2002-02-15
3,576 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,687 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,574 reads
2002-01-11
3,481 reads
Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.
2002-01-08
8,442 reads
Things your non-technical friends don't want to hear in the lab...
2002-01-04
3,965 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,190 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,253 reads
2001-11-16
2,519 reads
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Comments posted to this topic are about the item Choose the Second One
How many types of DML triggers are there?
See possible answers