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,308 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
2016-05-09
2,687 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
92 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,353 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
117 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,754 reads
A Beginners Look at Hadoop
Hadoop has been making a lot of noise in the Big Data world. Despite my lack of Linux experience I decided to take the plunge and this is what I found.
2015-01-01 (first published: 2013-06-05)
24,090 reads
Templates and teamwork
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
2014-11-27 (first published: 2008-05-20)
10,190 reads
RegEx for DBAs
RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions
2014-09-05 (first published: 2012-05-08)
20,462 reads
Mudita: Joy in the success of others
It is only when you start to take genuine pleasure in other people's successes that you experience the true rewards of being in a leadership position.
2014-07-11
151 reads
Blogs
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
A New Word: Opia
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
Friday Flyway Tips: Searching a Migration
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Forums
Sql Assignment Help
If you’re struggling with your SQL assignment help, you're not alone! SQL can be...
Best online minerals store in Pakistan
Fine Quality Minerals offers a premium selection of natural stones, minerals, and crystals, catering...
restore a cdc db from 2016
I'm backing up a SQL 2016 db and copying it to SQL Server 2022. ...
Question of the Day
Statistics Histograms
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers