Did You Really Name That Default?

Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:

SQL Server...

The Intersection Between DevOps and FinOps

DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster, deploy faster. But while we accelerate delivery, why not shorten the expense lifecycle as well?...

Why your data still can’t answer a simple question 

Every organization I talk to has the same problem dressed up in different clothes. Somewhere in the business, a decision maker is sitting on a question that the data...

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards or optimisation scripts. Tools can highlight waste, but culture determines whether anyone acts on it....

Fabric Mirroring doesn’t start copying Rows

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on Wheels blog for a long time and I appreciate all that he does, especially given...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not...

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

Hello, dear blog reader. Today’s post is coming to you straight from the home office, ready to talk about a topic that comes up more than you’d think: storing...

Case Studies: Real-World Success Stories of FinOps Implementation

Learning any kind of theory is easy, but adapting FinOps and watching it rescue a chaotic cloud environment is where it gets interesting. FinOps is about building a culture...

Finding the Next Sequence Value: #SQLNewBlogger

I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I...