Data Quality

External Article

SQL Server Best Practices for Data Quality

  • Article

Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?

2020-01-03

Technical Article

Data Degradation

  • Article

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

2009-05-14

2,180 reads

Blogs

A First Look at Redgate’s Subsetter

By

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

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

By VAI

If anyone used artificial intel like Gee-Pee-Tee for writing T-SQL (MS SQL server) code...

Syntax Problem

By charliedurnin@gmail.com

I think that I am almost there but I am getting one red squiggle...

Excel Source [24]] Error: System.Exception: SqlTruncateException:

By yrstruly

Please assist. I am using SSIS to read data from an Excel sheet into...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers