Use the WordPress Revision Counter to Keep Shipping Posts

Use the WordPress Revision Counter to Keep Shipping Posts

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!).  There is no getting around it – blogging is time consuming.  Especially technical blogging.  My first few posts were fairly long, […]

By March 24, 2015 0 Comments Read More →
Combating the CXPacket Wait Type

Combating the CXPacket Wait Type

Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of the list.  If this is the case for you as well, chances are your server isn’t on fire, but there could be room for improvement. What Does It Mean? Books Online defines the CXPacket wait type as: […]

By March 17, 2015 5 Comments Read More →
Making Sense of PCIe SSD Use with SQL Server

Making Sense of PCIe SSD Use with SQL Server

When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to achieve 100,000 IOPS, the IT world went wild.  While Fusion IO certainly is a pioneer in the PCIe SSD space, this technology has come a long way in its short life, and they aren’t the […]

By March 10, 2015 0 Comments Read More →
Configuring a Complete Memory Dump

Configuring a Complete Memory Dump

Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform a root cause analysis and hopefully find a solution.  What you get instead is this: “Unfortunately, all we were able to capture was a mini dump that doesn’t provide us enough information.  Lets configure your […]

By November 6, 2014 4 Comments Read More →
Database Maintenance Plans: A Primer

Database Maintenance Plans: A Primer

Databases and newborns have a lot in common.  They both require constant care.  They both require constant monitoring.  They also may both puke on you in the middle of the night.  Unlike newborns, however, you can set up automated maintenance plans for databases.  If you’re starting a new gig as a DBA, making sure your […]

By October 14, 2014 0 Comments Read More →
Why I’m Not Excited About Hekaton (In-Memory OLTP)

Why I’m Not Excited About Hekaton (In-Memory OLTP)

A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure why, Hekaton is much more fun to say), and while I am certainly still excited about this new feature, it does have some significant barriers to entry.  Here’s a quick hit list of a […]

By September 17, 2014 5 Comments Read More →