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,172 reads
David Poole
2018-03-12
106 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,830 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,844 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,239 reads
RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
2016-05-09
2,395 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
88 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,281 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
Soundex - Experiments with SQLCLR Part 2
Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms
2015-07-06
3,372 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Convert date value
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Partitioning table techniques which one is best way?
Hello All, I am about to do partitioning for my DW tables based on...
MAXDOP and cost threshold for parallelism settings
Hi All, On one of our newly migrated sup-prod azure vm which is running...
Ask SSC