When DBCC DROPCLEANBUFFERS doesn’t work…

Here’s an interesting question that came up in our IEPTO1 class in Chicago this week (paraphrasing): I was doing a demo recently where I was demonstrating physical I/Os occurring. I used DBCC DROPCLEANBUFFERS, then enabled SET STATISTICS IO ON and performed a SELECT operation. I was expecting to see physical reads occurring but I only saw logical […]

SQLintersection coming up in May

We’re just about to leave for three weeks of Immersion Events in Chicago, starting next week, and if that wasn’t enough, we’ve got our Spring 2015 SQLintersection conference right after that! This time we’re in Scottsdale (Phoenix), Arizona (May 18-21), which I’m really looking forward to as I’ve never been to Arizona (it’ll be the 23rd […]

New SQLskills Pluralsight courses

We’ve released a couple of new Pluralsight courses recently: The first is the conclusion of Glenn’s DMVs course series, SQL Server 2014 DMV Diagnostic Queries – Part 3, based on the very popular set of DMV queries he publishes every month. The second course is Jonathan’s long-awaited SQL Server: Change Data Capture course. The short abstract is: Learn […]

REPLICATION preventing log reuse but no replication configured

Last week, for the second time in as many weeks, I was sent a question in email from someone who had a transaction log that was growing out of control. He’d already queried log_reuse_wait_desc for the database (see this post for some more background) and the result was REPLICATION. The problem was, there was no […]

PASS 2014 top-10 sessions available to watch online

PASS has just released the top-10 rated sessions from the 2014 PASS Summit for everyone to watch for free! My Advanced Data Recovery Techniques session is in there, as is Erin’s session on Five Execution Plan Patterns To Watch For. Congratulations to everyone who made the top-10, and very cool to see that SQLskills is […]