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,309 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,691 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,357 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
118 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,759 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,108 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,200 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,477 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
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers