Advanced

Technical Article

PART 8: ESTIMATION

  • 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

2006-01-09

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.

2005-10-26

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.

2005-10-21

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,392 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.

2005-07-15

2,478 reads

Technical Article

MODELS, MODELS EVERYWHERE, NOR ANY TIME TO THINK

  • 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.

2005-06-17

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.

2005-06-03

2,567 reads

Blogs

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

A New Word: Aesthosis

By

aesthosis– n. the state of feeling trapped inside your own subjective tastes – not...

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Read the latest Blogs

Forums

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

Indexing strategy very long text strings

By aaron.reese

Hey guys,  Just looking to see if anyone has any bright ideas how to...

Visit the forum