Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
2019-03-26
1,367 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
GDPR - A guide for the perplexed
If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?
2019-02-18 (first published: 2018-01-11)
4,531 reads
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,508 reads
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,822 reads
2018-03-12
222 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,904 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
4,652 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,276 reads
RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
2016-05-09
2,594 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
90 reads
Blogs
Honored to be a Microsoft MVP Again
By Steve Jones
I was renewed this week as a Microsoft MVP. This is my 15th award...
Daily Coping 6 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Establishing a Connection to PostgreSQL with GoLang
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
SSIS - Name of Excel Sheet - How to Clear Dropdown List?
I am trying to create an SSIS package inside Visual Studio 2019. This package...
How to create a linked service to a VM where I will copy files from Blob storage
I have files in Blob Storage that I'd like to copy over to a...
Ask SSC