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,476 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
Fun with sp_executeSQL
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
17,135 reads
Intersect, Except, Union, All and Any
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,617 reads
sp_prepexec and nHibernate
SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.
2011-12-08
9,834 reads
Mind mapping software - How it can help the DBA
Mind mapping software allows the rapid capture of thoughts and ideas. It is a killer app that can easily help a busy DBA capture their thoughts
2011-12-01
8,132 reads
Pascals Triangle, Home Work and Root Cause Analysis
A lively comparison of Pascal's triangle to root cause analysis from David Poole.
2011-10-19
4,552 reads
2011-09-15
11,712 reads
An nHibernate Head Scratcher
An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.
2011-04-11
6,173 reads
Excel with Stored Procedures
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
2010-08-13 (first published: 2008-08-13)
61,377 reads
A Quick Look at the MPP World
David Poole takes a look at the Massively Parallel Processing world for database servers.
2010-08-11
4,603 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
BCA KCP Millennium Centennial Telp:0821-8200-233
Telp/Wa 62 8218200233 Gedung Millennium Centennial Ground Floor Unit C, Jl. Jenderal Sudirman No.Kav....
Alamat BCA KCP Pasar Cipulir Telp:0821-8200-203
Telp/Wa 62 8218200203 Komp. Cipulir Permai, E Jl. Ciledug Raya No.9, RT.9/RW.5, Ulujami, Kec....
Alamat Kantor BCA KCP Manhattan Tlp:0821-8200-233
Telp/Wa 62 8218200233 The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers