Connection Pooling :At a Glance

What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...

PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint

Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...

Running for the #SQLPass #NomCom

Guess, what?  I’ve thrown my hat in to the elections for the Nomination Committee for PASS.  That means that I...

Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices

With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...

NomCom, what it’s all about

I submitted my application for the NomCom last week and the polls opened up yesterday.  I’ve seen an amazing amount...

JSON and the NoSQL “advantage” over SQL Server

First what is JSON?

JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...

Indexed view deadlocking

Deadlocks can be a really tricky thing to track down the root cause of.  There are lots of articles on...

Database Tables

Today I was asked for "a list of all tables in all databases" on a particular instance of SQL Server. ...

PASS 2012 NomCom

I’m officially on the slate and running for the PASS 2012 Nomination Committee!
I love the SQL Community and everything it embodies. ...

PASS Nomination Committee

For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...