ADO Connection Resiliency

It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection string to enable retries on connections that were established (in the connection pool) but have since failed. I suspect many apps will cover this in the code that handles deadlocks and other SQL errors, […]

Read more "ADO Connection Resiliency"

Only as Good as Your Auditor

I wrote Only as Good as Your Auditor for SQLServerCentral because its something I’ve explained to people over and over again. For most of us in IT audits are something we tolerate and try to get done as quickly as we can, a test to pass, and because of that we don’t get to see […]

Read more "Only as Good as Your Auditor"