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,568 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
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
152 reads
IT and the Older Generation
David Poole looks at the interactions of technology across generations in this guest editorial.
2014-06-02
230 reads
Oiling the gears for the data dictionary
Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.
2014-04-25 (first published: 2011-02-17)
14,599 reads
Big Data - Cost of acquiring skills
If your companies first foray into Big Data project starts with a big cheque then you are doing it wrong!
2014-04-14
367 reads
A genuine use for a SQL CLR Aggregate
When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.
2014-02-05 (first published: 2010-12-29)
17,470 reads
2013-09-12
5,958 reads
Antipathy for Entity Attribute Value data models
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
2013-01-21
8,485 reads
Eleven Challenges in Unifying Reference Data
Unifying the reference data across an enterprise can be a bigger job than expected. This article describes one approach to doing so.
2012-12-20
3,599 reads
Storage - A meeting of minds
Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead
2012-07-16
5,440 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers