The Fake Speakers
Someone generated a fake speaker profile for their conference, which Steve finds disturbing.
2023-12-02
143 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,300 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)
480 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,659 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
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers