SQLServerCentral.com Articles tagged Data Qualityhttp://www.sqlservercentral.com/Articles tagged Data Quality posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)InterfacesThe interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.]]>http://www.sqlservercentral.com/articles/Editorial/66694/Tue, 05 Nov 2013 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/66694/Bad Data Costs LivesEither data is right or it is wrong. There is no in-between. Phil Factor examines a recent scandal that hit the health care system in the UK to highlight why it's so important that we, as data professionals, ensure responsible use of data and respect for data quality.]]>http://www.sqlservercentral.com/articles/Editorial/98339/Mon, 15 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/98339/Data QualityToday we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.]]>http://www.sqlservercentral.com/articles/Editorial/72364/Tue, 15 Feb 2011 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/72364/Enforcing Data Quality while using Surrogate KeysData 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.]]>http://www.sqlservercentral.com/articles/Data+Modeling/67684/Tue, 08 Sep 2009 06:00:00 UThttp://www.sqlservercentral.com/articles/Data+Modeling/67684/Data DegradationThe other day at a conference, the subject of data degradation/corrosion arose. The speaker at the conference said that data in a database degraded or corroded over time. The statement was made as if degradation over time applied to all databases. I found this blanket statement to be misguided. Indeed, I think that data does degrade in some databases, but not all.

"A real time saver" Andy Doyle, Head of IT ServicesAndy and his team saved time by automating backup and restores with SQL Backup Pro. Find out how much time you could save. Download a free trial now.

]]>http://www.sqlservercentral.com/redirect/articles/66772/Thu, 14 May 2009 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/66772/InterfacesThe interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.]]>http://www.sqlservercentral.com/articles/Editorial/66694/Tue, 05 Nov 2013 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/66694/InterfacesThe interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.]]>http://www.sqlservercentral.com/redirect/articles/66697/Wed, 22 Apr 2009 22:00:43 UThttp://www.sqlservercentral.com/redirect/articles/66697/InterfacesThe interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.]]>http://www.sqlservercentral.com/redirect/articles/66696/Wed, 22 Apr 2009 21:48:36 UThttp://www.sqlservercentral.com/redirect/articles/66696/InterfacesThe interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.]]>http://www.sqlservercentral.com/redirect/articles/66695/Wed, 22 Apr 2009 21:41:01 UThttp://www.sqlservercentral.com/redirect/articles/66695/Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)]]>http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65616/Wed, 04 Mar 2009 07:00:00 UThttp://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65616/Getting A Clue About Your DatabasesGot a new database you know nothing about? Here's my basic proposal on how to find interesting tables in it.

How to track every change to your SQL Server databaseSee who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more.

]]>http://www.sqlservercentral.com/articles/Data+Quality/65326/Fri, 09 Jan 2009 07:00:00 UThttp://www.sqlservercentral.com/articles/Data+Quality/65326/Data Quality and Data ProfilingDavid Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management. ]]>http://www.sqlservercentral.com/redirect/articles/65342/Thu, 01 Jan 2009 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/65342/Finding Available Keys When Merging Two TablesFind available keys when merging two tables with duplicate keys.]]>http://www.sqlservercentral.com/articles/T-SQL/62698/Mon, 26 May 2008 06:00:00 UThttp://www.sqlservercentral.com/articles/T-SQL/62698/Taking the Temperature of Your DataEnhanced model performance comes from extracting as much information content as possible… relative to the specific performance metrics you are using to measure success.]]>http://www.sqlservercentral.com/redirect/articles/61868/Tue, 12 Feb 2008 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/61868/Principles of ROI Development for Data Quality ProjectsThis article outlines 15 principles of ROI development for data quality (DQ) projects that can be leveraged across any industry.]]>http://www.sqlservercentral.com/redirect/articles/61867/Tue, 05 Feb 2008 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/61867/