A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data. This setting is called network packet size … Read More →
Welcome back for day 26 of my series 31 Days of Disaster Recovery. Today I want to share a tale of a mysterious backup that was running too long, and as the SAN admin reported, nothing had changed in terms of configuration of the SAN or our LUNs. We eventually tracked down the issue, and … Read More →
My series 31 Days of Disaster recovery has been on hiatus due mostly to illness. I’ve been battling a chest cold that became bronchitis. I’m still fighting cough, but even that has improved to the point that I’m now sleeping longer at night than night. It wasn’t so much that I was too sick to … Read More →
Recent Presentation Session Files I’ve been a little tardy about getting my session files posted, and I’m a little behind. So I’m going to try to catch up in one blog post. So here are my session files for SQL PASS Summit 2012, various recent SQL Saturdays, and 24 Hours of PASSe. Please let me … Read More →
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery? I was having a discussion with Idera (@idera_software) dev lead Vicky Harp (blog|@vickyharp) about minimizing log impact when performing schema changes on really large tables. One option discussed was using SELECT INTO to create a new table and populate it in a minimally logged operation. … Read More →
Whitepaper: Demystify Tempdb Performance & Management There are many misconceptions and myths about tempdb and purported best practices are inconsistent at best. It’s hard to know which advice to follow when one resource says to always do it one way and another tells you to always do it the opposite way. Many times, both resources … Read More →
[Shameless Plug] Can We Have Your Vote? Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL Rally 2012 in Dallas, TX called “Demystifying Database Administration Best Practices”. We think it’s going to be an epic session with just loads and loads of tips and best practices on multiple aspects of Database Administration, from … Read More →
Breaking Down TempDB Contention (part 2) I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me about the script. Jonathan said that he thought the math was off just a little bit … Read More →
Webcast: Putting a Better SQL Server in Production Webcast: Putting a Better SQL Server in Production Date: Wednesday, January 18, 2012 3:00 PM to 4:00 PM Eastern Time / 2:00 PM CT / 12:00 PM PT Problems come up everyday that could have been avoided by simply configuring SQL Server appropriately before using it. The … Read More →
The Barking Dog Analogy A discussion started today on Twitter about CXPacket waits. There had been a heated debate on the subject on Twitter the previous night (wow, does that sound geeky), so many of us got looped into today’s discussion. Someone had experienced a problem with a delete query on a large table causing … Read More →
My SQL Server Magazine Articles
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS
Facebook