• An Unlimited Token Budget

    I don’t like unbounded situations. I’m always wary of “unlimited” or “lifetime” offers, as I think they’re entirely too optimistic. A few people on an endless cruise recently learned this. An unlimited offer is only as good as the company that provides it, and many companies have either gone bankrupt, failed, or had to alter the terms of their amazing offer (T-Mobile, American, Red Lobster, Movie Pass). Similarly, I’ve always been worried about giving developers unlimited resources,…


  • Advice I Like: Overnight Success

    “Most overnight successes – in fact any significant successes – take at least 5 years. Budget your life accordingly” – from Excellent Advice for Living I’ll use a friend as an example, since I’ve had a few people say that they wished they had Brent Ozar’s success. A bunch of people think he found a secret to marketing, picked a nice niche in performance, and started making all this money, taking cruises, buying cars, etc. It’s not…


  • Data Lost in the Cloud

    There’s been a war in the Middle East for many months now. As different countries battle, there have been attacks on infrastructure, including businesses that have facilities in the region. Among the casualties were a few Amazon data centers, and Amazon has acknowledged that some data is permanently lost. This isn’t to ignore the loss of life or horrific events, but for data professionals, where is a portion of this that is applicable. The cloud providers will…


  • Should You Use CHOOSE(): #SQLNewBlogger

    I was experimenting with CHOOSE() recently after I was asked a question. In a previous post, I found it can take a (ridiculous) number of arguments. In this post, I’ll look more practically at how this works and where you might use it. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The Setup Let’s create a quick table with some data. In this case,…


  • Pay for Performance

    There’s a new TPC-H benchmark from Microsoft; this one running on cloud infrastructure in Azure. It’s the top-performing SQL Server benchmark at the 1TB level, getting to 1,667,428 QphH (roughly queries per hour). This value exceeds the next highest on-premises setup from HPE, which has 1,531,016 QphH@1000GB. This is the 2nd-ranked TPC-H benchmark, though the top slot is from an Exasol database. Notably, the benchmark comes in at $558.17 in the Price/QphH price performance column. The other…