Nico Jacobs's Avatar

Nico Jacobs

@sqlwaldorf.bsky.social

Microsoft Fabric and SQL Server trainer at U2U

245 Followers  |  182 Following  |  78 Posts  |  Joined: 09.10.2023  |  2.0848

Latest posts by sqlwaldorf.bsky.social on Bluesky

Preview
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

05.11.2025 10:22 โ€” ๐Ÿ‘ 6    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

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? ๐Ÿค”

24.10.2025 12:44 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

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

18.09.2025 18:06 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image Post image

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

18.09.2025 18:04 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

#Fabcon announcements
The Fabric CLI is now open source!

Fabric MCP Service is coming.

CI/CD for all Fabric items

And more coming!

16.09.2025 07:26 โ€” ๐Ÿ‘ 4    ๐Ÿ” 2    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

@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

17.09.2025 07:40 โ€” ๐Ÿ‘ 3    ๐Ÿ” 2    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Post image

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/

16.09.2025 09:11 โ€” ๐Ÿ‘ 25    ๐Ÿ” 7    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 2
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

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

21.08.2025 08:49 โ€” ๐Ÿ‘ 12    ๐Ÿ” 8    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

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

14.08.2025 12:22 โ€” ๐Ÿ‘ 6    ๐Ÿ” 4    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
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...

14.08.2025 11:14 โ€” ๐Ÿ‘ 2    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

๐Ÿฅต๐Ÿ”ฅ
Early long weekend, I guess? ๐Ÿ˜

14.08.2025 12:07 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Ask the dog, they know the answer

13.08.2025 09:49 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

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

18.06.2025 13:18 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Semifinal of the bike contest at #techorama!
#u2u

28.05.2025 15:07 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

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

28.05.2025 05:28 โ€” ๐Ÿ‘ 0    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image Post image

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 ๐Ÿค”

20.05.2025 13:55 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

#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...

09.05.2025 08:14 โ€” ๐Ÿ‘ 3    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Develop a Fabric solution in a day | Techorama

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?...

05.05.2025 10:18 โ€” ๐Ÿ‘ 2    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
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...

25.04.2025 05:30 โ€” ๐Ÿ‘ 3    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
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...

25.04.2025 06:35 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
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...

25.04.2025 09:28 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Happy Birthday, SQL Server!

24.04.2025 17:55 โ€” ๐Ÿ‘ 32    ๐Ÿ” 5    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Preview
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...

18.04.2025 10:30 โ€” ๐Ÿ‘ 2    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Happy ๐…-day!

14.03.2025 08:05 โ€” ๐Ÿ‘ 15    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
The windows taskbar, hovering over the file explorer icon so a preview thumbnail displays

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? ๐Ÿ‘€

06.03.2025 13:55 โ€” ๐Ÿ‘ 78    ๐Ÿ” 11    ๐Ÿ’ฌ 12    ๐Ÿ“Œ 1

Streaming data that is...
I need an edit post option ๐Ÿซฃ

22.02.2025 08:39 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

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

22.02.2025 08:38 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

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

Voted

13.02.2025 08:41 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

@sqlwaldorf is following 19 prominent accounts