Advice I Like: The Main Thing

The main thing is to keep the main thing the main thing. – from Excellent Advice for Living We can summarize this advice as focus on what’s important. I...

Counting Bits IV

More Supply Chain Attacks

Code is vulnerable to supply chain attacks, which aren't something many of us think about.

Tally Table Alternatives: #SQLNewBlogger

We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after...

A Strange Choice

DATEADD Truncates the Number Parameter: #SQLNewBlogger

This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them....

Lower Your Attack Surface Area

We all know security is important, but we sometimes make the job harder when we don't handle data appropriately.

A Couple Quick GENERATE_SERIES Tests

I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than...

Column Adds and Drops

Widespread New Technology Adoption

It can be hard to change peoples' habits and get them to adopt new technology.