Additional Articles

All authors

Technical Article

Loving to Hate the Data Administrator

You can just hear it now: At the table down the hall, there’s a group of people having, (as it seems to you) yet another academic discussion on the merits of third-normal form and the structure of primary keys. You’ve heard many discussions like this before — it all seems so pointless. After all, doesn’t it just boil down to “create table” commands and a bunch of DDL? You mastered all that in your first DBA class. What could be so hard?

2005-10-31

3,688 reads

Technical Article

Accurate Numeric Identifiers: Using Verhoeff's Method for Check Digits

Check digits–not to be confused with checksums–are often added to numeric identifiers such as customer and product numbers to reduce the chance of incorrect entries. Sequences of numbers are notoriously easy to mistype, and constraints alone generally won't do the job. In this excellent article, Lynn Fields shows you how to implement the "Cadillac" of check digit methods–the Verhoeff Dihedral Group.

2005-10-26

2,735 reads

External Article

High Call Volume SQL Server Applications on NUMA Systems

One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced on NUMA systems than basic SMP systems. A NUMA system with 16 processors can have significantly lower throughput capability than an otherwise comparable 4-way SMP system.

2005-10-25

1,754 reads

Technical Article

VIEWS: The Key to Database Agility

There is an important technique for creating truly agile databases that I haven’t seen in his writings; one which is well-known to DBAs, but little understood in the application development community – the use of database views to create a layer of abstraction between the normalized relational tables and the applications that use the data.

2005-10-21

3,736 reads

Technical Article

The Steps to monitoring greatness

SQL Server Profiler can correlate Microsoft Windows System Monitor (Performance Monitor in Windows NT 4.0) counters with SQL Server or SQL Server 2005 Analysis Services (SSAS) events. Windows System Monitor logs system activity for specified counters in performance logs. The first thing to remember is in order to have correlating information you need to obviously be in sync - in other words you must start the perfmon trace and profiler trace at the same time or else they won't match up.

2005-10-19

2,508 reads

External Article

Database Geek of the Week - Gary Mallow

Database geeks are all around us. I met Gary Mallow on the email list of a cycling group run by a local church. After some conversation, I discovered that he is a director of a group of developers who build applications, sometimes using .NET and often using Oracle as a database. Like me, Gary is not entirely comfortable with his ability as a UI developer, and so finds database work a good fit.

2005-10-18

1,689 reads

External Article

Controlling Transactions and Locks in SQL 2000 and 2005 - Part 3

In the preceding articles of this series, Lock Granularity, Transactions, and ACID were introduced. Common lock types, such as Shared, Exclusive, and Update were explored, as well as using SP_Lock to obtain current system lock information. In this article, the normal internal SQL locking methods will be manipulated using Lock Hints in order to obtain finer lock control.

2005-10-14

4,123 reads

External Article

Automatically Running a Process When SQL Server or SQL Agent Starts

Have you ever had a need to run a query or a process as soon as SQL Server starts? Or run some set of tasks when SQL Server Agent Starts? Possibly you want to run a cleanup routine, a copy process or have some task started each time SQL server or SQL Agent is started. Well if this is the case then this article will discuss a couple of options you might consider using to accomplish automatically running your process.

2005-10-13

2,228 reads

All authors

Blogs

Finding Balance: Things Will Come Up

By

I have a presentation on finding balance in your career that got quite a...

Who Are You Doing It For?

By

But as I've matured over the years, I came to realize that I needed...

Presenting Twice in May 2026

By

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

Comments posted to this topic are about the item The day-to-day pressures of a...

Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025

By Deepam Ghosh

Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...

Identities and Sequences III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identities and Sequences III

Visit the forum

Question of the Day

Identities and Sequences III

When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?

See possible answers