Increasing deadlocks with NoLock
One of my personal pet issues is with inappropriate use of the NOLOCK hint (and read uncommitted) . Don't get me...
2010-04-23
767 reads
Script of the week
Every week I will scour the internet for useful SQL scripts and post my favorite on here.
This weeks comes from...
2010-04-23
400 reads
A DMV a Day – Day 23
The DMV for Day 23 is sys.dm_os_process_memory, which is described by BOL as:
Most memory allocations that are attributed to the...
2010-04-23
2,406 reads
Book Review: Knives at Dawn: America’s Quest for Culinary Glory at the Legendary Bocuse d’Or Competition
Another find from the new book shelf at the local library, Knives at Dawn: America’s Quest for Culinary Glory at...
2010-04-23
480 reads
Rules to Live By: Do the Hard Things First
I can’t say I stick to this one 100 percent of the time, but it’s definitely a deeply held belief....
2010-04-23
516 reads
Adding Administrator
I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was...
2010-04-23
801 reads
Book Review - Rework
I have been a fan of 37 Signals for some time, and I read their blog regularly. I think they...
2010-04-23
801 reads
Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
424 reads
Results of Microsoft Certification Poll
In a recent poll at www.bradmcgehee.com, I asked website visitors if they had any Microsoft SQL Server certifications, and if...
2010-04-23
1,199 reads
PASS Summit Content Survey Results
The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their...
2010-04-22
636 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers