The Fake Speakers
Someone generated a fake speaker profile for their conference, which Steve finds disturbing.
2023-12-02
497 reads
Data Quality
Email Validation Simplified with Web API and SSIS
Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.
2020-12-14
SQL Server Best Practices for Data Quality
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
Data Quality
Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks about data quality and where the issues tend to happen.
2018-12-20
2,693 reads
Data Quality - Addressing non-stated requirements
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
2016-07-28
1,315 reads
Design : Find table with Identities with missing unique constraints
In an OLTP DB, other than an autogenerated Identity , there should be something else on the table which makes the non-identity data unique, as in, unique if you had to drop the ID column.
2016-02-03 (first published: 2016-01-22)
490 reads
Data Degradation
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
Getting A Clue About Your Databases
Got a new database you know nothing about? Here's my basic proposal on how to find interesting tables in it.
2009-01-09
10,727 reads
Taking the Temperature of Your Data
Enhanced model performance comes from extracting as much information content as possible… relative to the specific performance metrics you are using to measure success.
2008-02-12
2,257 reads
Principles of ROI Development for Data Quality Projects
This article outlines 15 principles of ROI development for data quality (DQ) projects that can be leveraged across any industry.
2008-02-05
1,747 reads
Blogs
Index Maintenance Can Change NORECOMPUTE Settings
By Steve Jones
I had a customer recently ask about a change in one of their constraints...
So You Think You Should Get a Radio
This is not database related, so if you’re not interested in hearing about something...
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Forums
fetch an execution plan from SQL Server's buffer cache
Comments posted to this topic are about the item fetch an execution plan from...
A way for the team to keep track of changes made
Is there a best practice way for the team to keep track of changes...
SQL Query Performance with Left Join
I have a query that is performing poorly It has a left join to...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers