-
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…
-
Flyway Tips: More Object History
I wrote about Flyway Desktop Object History in a previous tip. This feature has been enhanced, so I wanted to write an update. More History The changes now can be looked at from a project level. Note the new history button at the top of the schema mode. This didn’t exist in the previous post. If I click this, I get the same view of committed and uncommitted changes, but from a project view. You can see…
-
Helping an English Student with R
I got an interesting message from my daughter recently. She’s doing graduate studies in Belgium at KU Leuven. Her field is literature and linguistics, and as part of that, she has to analyze various writings. While visiting with her last month, she mentioned that her professor was using R (R Language) and giving them scripts to run to look at language usage. The other day she texted that her R script wasn’t running and could she get…



