• Okay but why? I have worked with computers since I was old enough to remember. The first computer I had in my room was a Commodore 64/128 (you held down the C= key on boot to switch). It was an elderly machine by the time I got it in the 1990s, but it started me…

    Read more

  • As I’ve mentioned before, running MongoDB on Windows can present a unique set of challenges since MongoDB is, for all intents and purposes, Linux native. Recently, I was tasked with creating a method by which the following could be done in a Windows environment via automation: The purpose of this is two-fold. We want to…

    Read more

  • I was rummaging through some old software of mine a few weeks ago and taking stock of the old operating systems that I had commercially. I noticed that along with some older versions of Redhat and Ubuntu Server, I owned every version of Windows since 95, including quite a few server versions. I wondered what…

    Read more

  • And the Case of the Fist-Fighting Log Readers Every once in a blue moon, you run across a problem that no one has seen before. Sometimes you can’t find anything all. Sometimes, you can only find unanswered forum questions. Sometimes, you find the worst thing imaginable: a forum post with someone replying to their own…

    Read more

  • About four months ago I was handed an already existing MongoDB infrastructure and told to take care of it. It’s been a long road, and I’ve had to train up quite quickly on this system. While I’m certainly no expert at this point, it is what I’ve been spending the bulk of my time doing.…

    Read more

  • So yes, I am a little late to this party, but I did this two–post blog for SQL Server 2017, and then completely ignored 2019. So I’m filling out this gap with a list of the things that SQL Server 2019 brought to the table that I care about. This is by no means an…

    Read more

  • I’m always looking for a way to save space in SQL Server. From archiving old data to just flat out deleting unused objects, I take great joy in removing superfluous stuff. The less junk in the system, the easier it is to focus on the things that matter. ..and fit it in a 10 kg…

    Read more

  • We needed a way to archive data.  I have seen this request multiple times in my career and the most common solutions I have seen either used: All of these options are great, but they all have drawbacks that we weren’t happy with. We needed our process to meet the following criteria: Once again, all…

    Read more

  • FETCH NEXT 5 About a week ago I posted about the Top 5 Things I’m most excited to see in SQL Server 2017. As you may have noticed, I just focused on the Engine/Agent and not on anything else. To be fair (and I’m always fair to myself), most of the big exciting changes were…

    Read more

  • New Year, New Database Engine It’s finally here! A few days ago as of this writing, SQL Server 2017 was released for Windows, Ubuntu, RedHat and Docker. There are a lot of new things in SQL Server 2017 from Python support in Machine Learning* to better CLR security. But I thought I’d narrow down the…

    Read more