Tag Archives: sql server

MS14-044–Security Alert for SQL Server

Posted on August 12, 2014 by way0utwest

I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL Server. Here’s the bulletin: MS14-044 There are QFE and GDR patches for versions since 2008, but you need to read … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on MS14-044–Security Alert for SQL Server

The Brittleness of Replication

Posted on August 12, 2014 by way0utwest

I’ve used replication for years in different positions. I first discovered it in SQL Server 6.5, using it to simulate a queuing system to keep two disparate applications in sync without requiring transactions between the applications and causing errors. As handy as … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Brittleness of Replication

Monitoring for Non Existent Events

Posted on July 31, 2014 by way0utwest

I was catching up on work recently, reading the third installment of The 5 Worst Days in a DBA’s life, starring The DBA Team. Someone had asked me if I enjoyed having Paul Randal (b | t) of SQLskills join them team. The piece had been … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Monitoring for Non Existent Events

T-SQL–Converting Seconds to Time

Posted on July 23, 2014 by way0utwest

I was working on a small piece of code the other day that was calculating the seconds for an event. I had a function that returned me the seconds as an integer. That’s good, but I wanted to get that … Continue reading →

Posted in Blog | Tagged , , | 2 Comments