Blocking Is Not Bad
When dealing with SQL Server databases we have to deal with locking, and blocking within our application databases. All to often we talk about blocking as being a bad thing. How ever in reality blocking isn’t a bad thing. The SQL Server uses blocking to ensure that only one person is accessing some part of […]
Nolock and your financial application
The NOLOCK indexing hint gets used way, way to frequently. The place that I hate seeing it the most is in financial applications, where I see it way to often. Developers who are working on financial applications need to understand just how important not using NOLOCK is. Using NOLOCK isn’t just a go faster button, […]
Preventing Locking, Blocking and Deadlocks in the vCenter database
As our VMware environments become larger and larger with more and more hosts and guests more thought needs to be given to the vCenter database that is typically running within a SQL Server database. With the vCenter database running within Microsoft SQL Server (which is the default) their will be lots of locking and blocking […]
Recommended reading from mrdenny for July 05, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Bootstrapping SQL Server bloggers and blog readers with Twitter! Whiteboard Wednesday #1: Top Visualization Mistakes The Accidental Architect Personally Identifiable Information (PII) and Data Encryption Traversing the Facebook Graph using Data Explorer […]