Azure SQL Retiring The No Minimum TLS Option

As part of the retirement of lower TLS versions 1.0 and 1.1 and the enforcement of 1.2 as the new default minimum TLS version, Azure SQL will be changing the...

techcommunity.microsoft.com

250 blog posts

Last week, I noticed that I published my 250th blog post. I'm not sure if it's something to celebrate (I'm not really someone who celebrates things), but it is an extra reason to write a new post. Endurance I started writing in 2018 after Brent Ozar suggested I do this. He also told me that the first blog posts wouldn't get that much attention, and that I had to sustain the effort to keep writing.

sqlreitse.com

Retro Data: Call for Speakers

Retro Data is brought to you by Andy Cutler and Justin Bird. As organisers, it's become increasingly apparent how quickly our industry moves from one ...

sessionize.com

GitHub - erikdarlingdata/claude-plugins: Claude Code plugins from Erik Darling Data

Claude Code plugins from Erik Darling Data. Contribute to erikdarlingdata/claude-plugins development by creating an account on GitHub.

github.com

Man Giggles with a Smile

Alt: Man Giggles with a Smile

static.klipy.com

AI Skills Navigator

aka.ms

Data Community Day Austria 2027: Call for Speakers

Data Community Day Austria (fka SQL Saturday Vienna) is back!Monday 18th January 2027 For 2027 we are going in-person again - and are organizing a fu...

sessionize.com

SQL Server 2025: Testing the JSON Index

In today's cloud era, Azure SQL is usually first with new functionality, while on-premises SQL Server follows. One of the new things is the JSON data type and accompanying JSON index. Because I had to learn how JSON works in SQL Server for my DP-800 exam, I decided to see how the JSON index works and when it works. I'll go into the execution plans, some details, and check out the statistics when a query runs.

sqlreitse.com

T-SQL Tuesday 200: When I Look at a Query …

First up, congrats to Adam Machanic and Steve Jones on reaching 200 episodes of T-SQL Tuesday; you can be proud of yourselves! I've always loved the variety of topics, the different views of the bloggers, and the learning that can be gained from all the posts. I've even had the honour of hosting. Anyway, Brent Ozar invites us this month to write about the most horrible things we've encountered in a query.

sqlreitse.com

DP-700 training: Monitor semantic model refresh

As you've probably heard and read before, monitoring your Fabric environment as a whole is quite important. It really does help to know what's going on. Now, one thing I've learned over all these years is that report users do quite like their data to be as fresh and up to date as possible. And, when the data seems stale, they tend to ask questions.

sqlreitse.com

Playful Golden Retriever Dog

Alt: Playful Golden Retriever Dog turning in circles

static.klipy.com

DP-800 Exam Experiences

Earlier this year, Microsoft released a new certification that combines AI and SQL Server knowledge: the DP-800: Developing AI-Enabled Database Solutions. As I still deeply care about SQL Server and am convinced it has a very central place in any data architecture (cloud or on-premises), this one sparked a lot of interest. Today, I took the exam, and now it's time to share my experience.

sqlreitse.com

Attending a Level 400 training at Microsoft.

This week, I was invited to the Microsoft office in London. The reason was a Level 400 training for Microsoft partners on Real-Time Intelligence. As I've been working with RTI on a large project for the last year, it felt natural to join this training. My objectives were not listed, but I wanted to see whether the way we set up the code was consistent with best practices, whether there were things we were overlooking, and what options we could add if it would make sense.

sqlreitse.com

Speaking at Data Ceili. Or, how to work with fast-changing software in your demo

Today I had the pleasure of presenting my session on Copilot for SQL at the Data Ceili event in Dublin. Somewhere between 50 and 60 people attended, having fun and learning how this Copilot works, what it can and can't do, and, very important today, how much it will cost you. The challenge While preparing this session, I tested some features in SSMS 22.6, and everything looked good.

sqlreitse.com

DP-700 training: Choose between query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence

A three-line title that promises a lot! So let's try to simplify this a bit. In essence, this blog will cover how to make OneLake data quicker in an Eventhouse using shortcuts. The process, at a high level, is quite simple. In your eventhouse, create a shortcut to a Lakehouse, for instance. Enable query acceleration, and you're done. If you're not using an Eventhouse, you can stay here just to read more, or take back some of your time to learn something else.

sqlreitse.com

SSMS 22.6: Custom Copilot instructions

When you start using SSMS with GitHub Copilot, there is no default set of instructions in place. The agent will just sort of do what it thinks is best. But you can make sure the agent has more knowledge of your local environment (yes, it can be a cloud database as well), how it should address you and maybe what not to do.

sqlreitse.com

DP-700 training: Configure Dataflow Gen2 workspace settings (Apache Airflow)

Welcome to another instalment in the DP-700 learn series. This time we're going to talk about Apache Airflow settings. It's a little bit of a misnomer in the header, maybe, but we have to follow the titles Microsoft offers in the official curriculum. Now, before we dig into the fun techy stuff, let's familiarise ourselves with what Apache Airflow is. I was hoping that it had something to do with air conditioning, but alas.

sqlreitse.com