Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
2019-03-26
152 reads
David Poole
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)
3,154 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,221 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)
3,655 reads
2018-03-12
86 reads
Vagrant and SQL Server 2017 on Linux
Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017
2017-11-14
783 reads
Some of my greatest mistakes
You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.
2017-05-18
3,227 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,813 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
2,236 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,163 reads
Blogs
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Function Issues
I have created the following function which is to be used for a check...
SQL Server health check
If I want to do a SQL Server health check, which aspects should be...
Ask SSC