Soundex - Experiments with SQLCLR Part 3
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,386 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
Auto-suggesting foreign keys and data model archaeology
If you can understand the data model then you can understand the intent of the application developers.
2018-07-06 (first published: 2016-01-26)
4,509 reads
2018-03-12
177 reads
The Power of the Data Model
A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.
2017-02-14
1,872 reads
Bash for ETL pre-processing
People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today
2016-08-15
3,683 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,260 reads
RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
2016-05-09
2,516 reads
What’s in a name?
When a business does not have an agreed set of definitions for their every day terms slow burning chaos ensues.
2016-05-04
89 reads
Getting ready for Hadoop
Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.
2015-11-23
6,312 reads
Deploying tech to the cloud
There is a world of difference between technology originating in or designed for the cloud and technology that predates but can run in the cloud.
2015-10-12
115 reads
Blogs
Daily Coping 6 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
All jobs that ran during a given time frame.
Short post today. Simple query that will tell you every job that ran between...
Instructions for Handling Errors of MySQL and PHPMyAdmin
One of my clients, Justin Williams, is a blogger. He owns a website named...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
Self-Joined to Find if Archived Versions of Record Exist w/o Duplicate Records
I have a table keeping client notes that can be updated and the previous...
Licensing question
Thinking of getting a perpetual standard licensing with certain number of cores. Was wondering...
Ask SSC