Nico Jacobs
banner
sqlwaldorf.bsky.social
Nico Jacobs
@sqlwaldorf.bsky.social
Microsoft Fabric and SQL Server trainer at U2U
Reposted by Nico Jacobs
SQL Server 2025 Is Out, and Standard Goes Up to 256GB RAM, 32 Cores!

Today marks the official birthday of Microsoft SQL Server 2025. Here's where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature…
SQL Server 2025 Is Out, and Standard Goes Up to 256GB RAM, 32 Cores!
Today marks the official birthday of Microsoft SQL Server 2025. Here's where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature differences between 2025 Enterprise and Standard have been revealed, and the news for Standard Edition folks is spectacular: it now supports up to 32 CPU cores and 256GB RAM!
www.brentozar.com
November 18, 2025 at 4:24 PM
Yeah! Belgium Central is open for business. A new Azure zone at a few kilometers from the office... No more complaining about latency, I guess 😁💪
#Azure #Belgium
November 18, 2025 at 4:14 PM
Reposted by Nico Jacobs
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
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.
www.mssqltips.com
November 5, 2025 at 10:22 AM
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? 🤔
October 24, 2025 at 12:44 PM
Dataminds evening session at U2U.
First Jurgen shows how to do streaming ETL in databricks with the declarative pipelines
September 18, 2025 at 6:05 PM
Reposted by Nico Jacobs
#Fabcon announcements
The Fabric CLI is now open source!

Fabric MCP Service is coming.

CI/CD for all Fabric items

And more coming!
September 16, 2025 at 7:26 AM
Reposted by Nico Jacobs
@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
September 17, 2025 at 7:40 AM
Reposted by Nico Jacobs
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/
September 16, 2025 at 9:11 AM
Reposted by Nico Jacobs
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
August 21, 2025 at 8:49 AM
Reposted by Nico Jacobs
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
August 14, 2025 at 12:22 PM
Reposted by Nico Jacobs
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...
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...
sqlserverfast.com
August 14, 2025 at 11:15 AM
Semifinal of the bike contest at #techorama!
#u2u
May 28, 2025 at 3:07 PM
At #techorama?
Curious what's new in T-SQL?
I'll get you up to date. Room 7, 8:30!
May 28, 2025 at 5:28 AM
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 🤔
May 20, 2025 at 1:55 PM
Reposted by Nico Jacobs
#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...
May 9, 2025 at 8:14 AM
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?...
Develop a Fabric solution in a day | Techorama
techorama.us4.list-manage.com
May 5, 2025 at 10:18 AM
Reposted by Nico Jacobs
Power BI Mistakes to Avoid – Part 2 by Koen Verbeeck #PowerBI www.mssqltips.com/sqlservertip...
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.
www.mssqltips.com
April 25, 2025 at 6:35 AM
Call for Speakers for dataMinds Connect 2025 is open on Sessionize and I've just submitted a session! sessionize.com/dataminds-co...
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...
sessionize.com
April 25, 2025 at 9:28 AM
Reposted by Nico Jacobs
Happy Birthday, SQL Server!
April 24, 2025 at 5:55 PM
Reposted by Nico Jacobs
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...
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...
blog.fabric.microsoft.com
April 18, 2025 at 10:30 AM
Reposted by Nico Jacobs
Happy 𝝅-day!
March 14, 2025 at 8:05 AM
Reposted by Nico Jacobs
Did you know if you middle click the app preview thumbnail, it will close the window? 👀
March 6, 2025 at 1:55 PM
DataMinds Saturday is kicking off. A full classroom to discuss the fabric versus Azure decisions to process streaming days
February 22, 2025 at 8:38 AM