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,455 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,110 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,582 reads
sp_prepexec and nHibernate
SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.
2011-12-08
9,809 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,120 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,533 reads
2011-09-15
11,696 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,158 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,335 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,595 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
ALAMAT KANTOR BCA KCU SEMARANG Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers