Technical Article


  • Article

Data modeling is no doubt one of the most important and challenging aspects of developing, maintaining, augmenting and integrating typical enterprise systems. More than 90% of functionality of enterprise systems is centered round creating, manipulating and querying data. It therefore stands to reason that individuals managing enterprise projects should leverage on data modeling to execute their projects successfully and deliver not only capable and cost effective but also maintainable and extendable systems


2,421 reads

Technical Article

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

  • Article

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.


2,735 reads

Technical Article

VIEWS: The Key to Database Agility

  • Article

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.


3,736 reads

SQLServerCentral Article

Understanding Object Ownership

  • Article

In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.

5 (8)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

54,042 reads

Technical Article

A New Way of Thinking

  • Article

Every organization both maintains and uses reference data sets within its enterprise. And in many of these organizations, there are standards about the definition and use of that reference data, although sometimes those standards are at best silently understood instead of specifically documented. Yet even in the best governed environment, that reference data is bound to eventually be abused, either through value set perturbation or extended usage expectations.


2,478 reads

Technical Article


  • Article

Even a cursory inspection of data management practice reveals that the majority of practitioners-–be they novices, or experienced, users or vendors--operate in a “cookbook”, product-specific mode, without really knowing and understanding the fundamental concepts and principles underlying their field, e.g. what data means, what data model, database, DBMS, data independence really are, and so on.


2,510 reads

Technical Article

Using ANSI SQL as a Conceptual Hierarchical Data Modeling

  • Article

This paper will explain and show how standard ANSI SQL processors can naturally model and automatically process complex multi-leg hierarchical data structures at a full conceptual hierarchical level. This also means the query user does not need to have structure knowledge of the hierarchical structures involved. The data modeling capability includes dynamically combining logical hierarchical relational and physical XML data structures at a full hierarchical level. This also includes the ability to link below the root of the lower level structure intuitively forming a valid unified hierarchical structure. As will be shown, ANSI SQL’s high level hierarchical data processing allows the flexible conceptual control of hierarchical node promotion, fragment processing, structure transformation, and variable structure creation.


2,567 reads


Migrating from EverNote to Joplin


Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames


A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft


looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs


SQL help with partition

By don075

With the following data, I need to create a column that will display a...

How can I show the last opening period for each project in my project dimension

By casagrandi

I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...

Upgrading from 2016 to 2019 with Encryption

By Richard Warr

Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers