SQLServerCentral.com Articles tagged Data Modeling

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Fri, 05 Oct 2012 06:00:00 UT

Changing the structure of a very large table doesn't need to require a maintenance window.

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

Fri, 14 Sep 2012 06:00:00 UT

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.

PASS Data Architecture Virtual Chapter presents Audrey Hammonds – Database Makeover: Renovate You Data Model

Thu, 19 Jan 2012 07:00:00 UT

On Thursday January 19th at 12 noon Central, Audrey Hammonds will discuss renovating your data model while keeping you’re the production system humming

Going Beyond the Relational Model with Data

Thu, 13 Oct 2011 06:00:00 UT

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw inferences, to make predictions, or to tease out subtle correlations. To provide ever more sophisticated inferences to businesses, the race is on to combine the power of the relational model with advanced statistical packages. Both IBM and PostGres are ready with solutions. And SQL Server? Hmm...

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Fri, 05 Oct 2012 06:00:00 UT

Changing the structure of a very large table doesn't need to require a maintenance window.

Naturally Increasing Data Value with Hierarchical Structures

Wed, 23 Mar 2011 06:00:00 UT

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

Extending Hierarchical Data Modeling Demonstrated in SQL

Fri, 16 Jul 2010 06:00:00 UT

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.

Overusing Identities

Mon, 01 Mar 2010 07:00:00 UT

Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.

How Oslo can you go?

Mon, 30 Nov 2009 07:00:00 UT

Some developers have reacted with dismay to the recent news that Microsoft’s Oslo project is being integrated into the SQL Server platform and renamed SQL Server Modeling. The overwhelming feeling seems to be that their DSL dream is being snatched away.

Enforcing Data Quality while using Surrogate Keys

Tue, 08 Sep 2009 06:00:00 UT

Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.

The Joy of Data Modelling.

Mon, 17 Aug 2009 06:00:00 UT

You may think that the task of teasing out the exact nature of the data and processes within a company...

The 10-Minute Data Model Review, Part 2

Tue, 26 Aug 2008 06:00:00 UT

Data modeling is based on the precept of knowing your data and knowing how the data is interrelated with other data. Everyone knows their data – right? If so, then why do we have so many problems building systems that do what the users want?

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Data Lineage: The Next Generation

Tue, 19 Aug 2008 06:00:00 UT

Bill Lewis describes the benefits of an application development environment in which all data dependencies begin and remain clearly, precisely and explicitly defined.

Achieve Flexible Data Modeling with the Entity Framework

Fri, 01 Aug 2008 06:00:00 UT

Here the author answers questions regarding the Entity Framework and provides an understanding of how and why it was developed.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Dimensional Model Components: Dimensions Part II

Thu, 06 Mar 2008 07:00:00 UT

Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.

The Stewardship Approach to Data Governance: Chapter 8

Thu, 06 Mar 2008 07:00:00 UT

This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.

The Stewardship Approach to Data Governance: Ch 7

Thu, 28 Feb 2008 07:00:00 UT

This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.

The Stewardship Approach to Data Governance: Ch. 6

Thu, 21 Feb 2008 07:00:00 UT

This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.

5 Tips for Becoming a Better Data Modeler

Tue, 19 Feb 2008 07:00:00 UT

5 quick tips to help you become a better data modeler and increase your value to your team and organization.

The Data Stewardship Approach to Data Governance: Chapter 5

Thu, 14 Feb 2008 07:00:00 UT

Part 5 looks at beginning with a Data Governance Best Practice Assessment

The Data Stewardship Approach to Data Governance: Chapter 4

Thu, 07 Feb 2008 07:00:00 UT

If you have considered deploying a Data Governance program at your organization, the chances are that you have asked the following question: "Where does Data Governance fit into the Organization?"

Designing an Entity Data Model

Fri, 01 Feb 2008 07:00:00 UT

The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility.

The Data Stewardship Approach to Data Governance: Chapter 3

Thu, 31 Jan 2008 07:00:00 UT

In this article I will settle down a little bit and share with you tools that I have used as part of the data governance trade.

Enterprise Architecture – Connect-the-Dots for Adults, Part 4

Tue, 29 Jan 2008 07:00:00 UT

This article, part 4 in a series, discusses how to use, publish, maintain and govern the enterprise architecture.

The Data Stewardship Approach to Data Governance: Chapter 2

Thu, 24 Jan 2008 07:00:00 UT

Data governance is NOT a methodology. Data governance is about authority and discipline over the management of data but not THE method in which the data is governed.

The Data Stewardship Approach to Data Governance: Chapter 1

Thu, 17 Jan 2008 07:00:00 UT

The definitions of data governance and data stewardship that I use have changed, albeit slightly, over the years of providing data governance and stewardship solutions.

It's All About the Data

Tue, 15 Jan 2008 07:00:00 UT

It would be wonderful to be able to simple purchase a tool or technology and have your data challenges disappear. It is time to step back and take a much needed different look at data.

Toward Integrity Part 5

Thu, 03 Jan 2008 07:00:00 UT

An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.

Toward Integrity Part 4

Thu, 27 Dec 2007 07:00:00 UT

An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.

Toward Integrity Part 3

Mon, 17 Dec 2007 07:00:00 UT

An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial