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,269 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
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,634 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
162 reads
IT and the Older Generation
David Poole looks at the interactions of technology across generations in this guest editorial.
2014-06-02
238 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,656 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
376 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,567 reads
2013-09-12
6,012 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,585 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,624 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
PowerBI Question - Data Sources
I don't see a PowerBI forum, so I'm posting here. I have a need...
SQL Server Certificates
Comments posted to this topic are about the item SQL Server Certificates
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers