Nico Jacobs

The New JSON Index in SQL Server 2025 Explore how to create and use a JSON index in SQL Server to improve query performance for tables that store JSON data.

New article: The New JSON Index in #SQLServer 2025 www.mssqltips.com/sqlservertip... #sqlserver2025 cc @sqlwaldorf.bsky.social it works! And hat tip to @dhma.ch for the suggestion to use JSON_CONTAINS

Hard Rock International is sponsoring the new White House Ballroom... Quite unique location for another Hard Rock Cafe! Would they open a shop as well? 🤔

Next Stijn is explaining embeddings, and how to use them in SQL server

Dataminds evening session at U2U.
First Jurgen shows how to do streaming ETL in databricks with the declarative pipelines

#Fabcon announcements
The Fabric CLI is now open source!

Fabric MCP Service is coming.

CI/CD for all Fabric items

And more coming!

@kimmanis.bsky.social and @kjonge.bsky.social showing off #OneSecurity in Fabric in a very fun and entertaining way: no matter which workload accesses the data (Power BI, SQL, Spark, Excel, etc.) the security definition is respected.

#fabconeurope25

We finally have 𝘂𝘀𝗲𝗿-𝗱𝗲𝗳𝗶𝗻𝗲𝗱 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 (𝗨𝗗𝗙) in DAX!

Don't make mistakes; this is not a user data function in Fabric.

This is a new DAX feature, the most important one in the last five years.

Read/watch more:
https://www.sqlbi.com/articles/introducing-user-defined-functions-in-dax/

The EightKB 2025 Schedule UTC Time Session Speaker Level Length 13:00 Welcome! EightKB Crew 15m 13:15 Fix your SQL database design with T-SQL static code analysis Erik Ejlskov Jensen 400 60m 14:30 Next-Gen High Availability with Contained Availability Groups Nader Sharara 400 60m 15:45 Resurrecting Lost Data: Mastering SQL Server's Transaction Logs and Row Internals Secrets Vladimir Afanasev 400 60m 17:00 The Language of Databases: A Deep Dive into MySQL and PostgreSQL Wire Protocols Sergey Olontsev 500 75m 18:30 Deep Dive into Memory-Optimized TempDB Haripriya Naidu 400 60m

Todays the day for #eightKB @eightkb.online

Whats that?

It's a free, fun and mind melting online conference covering topics around data internals.

eightkb.online

#sqlserver
#sql
#internals
#data
#azure
#mysql
#postgresql

One week to go until this year's edition of EightKB!

We have amazing in-depth technical sessions on SQL Server internals, delivered by expert speakers!

Registration is completely free and available here: -
eightkb.online

#sql #sqlserver #conferences #sql2025

A deep dive into hash tables, part 1 - SQLServerFast We all know the Hash Match operator. It joins or aggregates data, based on a hash table. That hash table is ideally stored in memory. But if the granted memory is insufficient, then Hash Match will sp...

It's been a long time since I last blogged. But today, I did!

Part 1 of a series that will probably be at least four parts, and where we'll be wasting our time to look into the internals of hash tables in #SQLServer. Geek out!

sqlserverfast.com/blog/hugo/20...

🥵🔥
Early long weekend, I guess? 😁

Ask the dog, they know the answer

Hope to hear from you in one format or another... and kept an empty spot on my laptop for the sticker 😍

Semifinal of the bike contest at #techorama!
#u2u

At #techorama?
Curious what's new in T-SQL?
I'll get you up to date. Room 7, 8:30!

When I use the CopyData activity in a #MicrosoftFabric pipeline, it allows for blanks in the column names. But then I try to append to the existing table from the lakehouse explorer, I get the error that blanks are not allowed... weird 🤔

#PowerBI DataMarts are now deprecated. Hope nobody wrote a book about it :) Read more: Unify Datamart with #MicrosoftFabric Data Warehouse! powerbi.microsoft.com/en-us/blog/u...

You want to learn the key features of Microsoft #Fabric in a hands-on one day workshop? #Techorama is the place to be!
Register soon, because ticket sales is closing soon...
techorama.us4.list-manage.com/track/click?...

Power BI April 2025 Feature Summary There are a lot of exciting features this month, including mobile optimized report layouts, the best way to view data in the general availability of Power BI mobile apps, editing your semantic models...

Power BI April 2025 Feature Summary by Patrick LeBlanc #PowerBI powerbi.microsoft.com/en-us/blog/p...

Power BI Mistakes to Avoid - Part 2 This tip discusses additional Power BI mistakes to avoid​ to ensure Power BI is being used to its fullest extent in the most beneficial way.

Power BI Mistakes to Avoid – Part 2 by Koen Verbeeck #PowerBI www.mssqltips.com/sqlservertip...

dataMinds Connect 2025: Call for Speakers dataMinds Connect is a 3 day in-person event in the wonderful city of Mechelen, Belgium. It's an IT related event with a specific focus on the Microso...

Call for Speakers for dataMinds Connect 2025 is open on Sessionize and I've just submitted a session! sessionize.com/dataminds-co...

Happy Birthday, SQL Server!

Mastering SKU Estimations with the Microsoft Fabric SKU Estimator | Microsoft Fabric Blog | Microsoft Fabric In today’s ever-changing analytics landscape it can be difficult to plan out your next project or your enterprise analytics roadmap. Designed to optimize data infrastructure planning, the Microsoft Fa...

Now, thanks to a brand-new Fabric SKU Estimator, it's much easier to determine the Fabric power your organization needs. Great work Microsoft!

Give it a try and let me know your thoughts.

blog.fabric.microsoft.com/en-us/blog/m...

Happy 𝝅-day!

The windows taskbar, hovering over the file explorer icon so a preview thumbnail displays

Did you know if you middle click the app preview thumbnail, it will close the window? 👀

Streaming data that is...
I need an edit post option 🫣

DataMinds Saturday is kicking off. A full classroom to discuss the fabric versus Azure decisions to process streaming days

Hey, don't make it too easy, else trainers like me would be out of a job! 😁

Voted