IT and the Older Generation
David Poole looks at the interactions of technology across generations in this guest editorial.
2014-06-02
221 reads
David Poole looks at the interactions of technology across generations in this guest editorial.
2014-06-02
221 reads
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,481 reads
If your companies first foray into Big Data project starts with a big cheque then you are doing it wrong!
2014-04-14
359 reads
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,078 reads
2013-09-12
5,834 reads
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
2013-01-21
8,063 reads
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,580 reads
Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead
2012-07-16
5,390 reads
Switching from 32 BIT SQL Server to a 64 BIT edition illustrates how removing a bottleneck from a system can have a detrimental affect overall
2012-01-31
16,918 reads
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
2011-12-23 (first published: 2009-07-20)
40,370 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers