Niko Neugebauer
@nikoneugebauer.bsky.social
Flawed human being. Lover of nature and music.
Community, Columnstore, Teach/Learn.
My opinion is always my own & I am mostly wrong. He/Him.
I am NOT working for Microsoft corporation.
Community, Columnstore, Teach/Learn.
My opinion is always my own & I am mostly wrong. He/Him.
I am NOT working for Microsoft corporation.
Columnstore post 136 is landing tonight
January 18, 2026 at 1:29 PM
Columnstore post 136 is landing tonight
[blog] Columnstore Indexes – part 135 (“JSON type and JSON Index with Columnstore Indexes”):
www.nikoport.com/2026/01/02/c...
#json #jsonindex #columnstore #batch #sqlserver2025
www.nikoport.com/2026/01/02/c...
#json #jsonindex #columnstore #batch #sqlserver2025
Columnstore Indexes – part 135 (“JSON type and JSON Index with Columnstore Indexes”)
Continuation from the previous 134 parts, the whole series can be found at Not since SQL Server 2008 that Microsoft has added a new base data type to SQL Server, but in SQL Server 2025 they have ad…
www.nikoport.com
January 2, 2026 at 6:43 PM
[blog] Columnstore Indexes – part 135 (“JSON type and JSON Index with Columnstore Indexes”):
www.nikoport.com/2026/01/02/c...
#json #jsonindex #columnstore #batch #sqlserver2025
www.nikoport.com/2026/01/02/c...
#json #jsonindex #columnstore #batch #sqlserver2025
New JSON data type and its relationship to Columnstore Index is disastrous in SQL Server 2025 RTM.
Not just like XML data type it cannot be part of the NCCI, but the requirement of the Clustered Primary Key makes it incompatible with Clustered Columnstore Indexes.
Not just like XML data type it cannot be part of the NCCI, but the requirement of the Clustered Primary Key makes it incompatible with Clustered Columnstore Indexes.
January 2, 2026 at 4:36 PM
New JSON data type and its relationship to Columnstore Index is disastrous in SQL Server 2025 RTM.
Not just like XML data type it cannot be part of the NCCI, but the requirement of the Clustered Primary Key makes it incompatible with Clustered Columnstore Indexes.
Not just like XML data type it cannot be part of the NCCI, but the requirement of the Clustered Primary Key makes it incompatible with Clustered Columnstore Indexes.
[blog] Master Data Services in SQL Server 2025: www.nikoport.com/2025/12/31/m...
#sqlserver2025 #mds #masterdataservices #bi #excelwriteback
#sqlserver2025 #mds #masterdataservices #bi #excelwriteback
Master Data Services in SQL Server 2025
I have worked with Master Data Services (aka MDS) extensively, especially during the engagement at OH22 around a decade ago, and I my interest in the area and that specific is documented in my blog…
www.nikoport.com
January 1, 2026 at 9:27 PM
[blog] Master Data Services in SQL Server 2025: www.nikoport.com/2025/12/31/m...
#sqlserver2025 #mds #masterdataservices #bi #excelwriteback
#sqlserver2025 #mds #masterdataservices #bi #excelwriteback
Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”):
www.nikoport.com/2025/12/25/c...
#columnstore #batch #vector #sqlserver2025
www.nikoport.com/2025/12/25/c...
#columnstore #batch #vector #sqlserver2025
Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”)
Continuation from the previous 133 parts, the whole series can be found at In this post we are going to test one of the more promising technologies in SQL Server-based offerings – Vector data…
www.nikoport.com
December 25, 2025 at 11:17 PM
Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”):
www.nikoport.com/2025/12/25/c...
#columnstore #batch #vector #sqlserver2025
www.nikoport.com/2025/12/25/c...
#columnstore #batch #vector #sqlserver2025
I am just running some aggregates on the table with Vector data type - aggregating with AVG against an INT column ...
December 23, 2025 at 11:30 PM
I am just running some aggregates on the table with Vector data type - aggregating with AVG against an INT column ...
[blog] Columnstore Indexes – part 132 ("What's missing in Columnstore indexes in the year 2026"):
www.nikoport.com/2025/12/03/c...
#sqlserver #columnstore #azuresql #wishlist
www.nikoport.com/2025/12/03/c...
#sqlserver #columnstore #azuresql #wishlist
Columnstore Indexes – part 132 (“What’s missing in Columnstore indexes in the year 2026”)
Continuation from the previous 131 parts, the whole series can be found at After spending some time thinking about the best way to come back to writing about Columnstore Indexes, after 5 and half y…
www.nikoport.com
December 3, 2025 at 10:38 PM
[blog] Columnstore Indexes – part 132 ("What's missing in Columnstore indexes in the year 2026"):
www.nikoport.com/2025/12/03/c...
#sqlserver #columnstore #azuresql #wishlist
www.nikoport.com/2025/12/03/c...
#sqlserver #columnstore #azuresql #wishlist
Just wrote "Continuation from the previous 131 parts, the whole series can be found at www.nikoport.com/columnstore/...
Columnstore
I am deeply fascinated by the Columnstore Indexes, and I have open some Connect Items to suggest their important improvements: – Implement Batch Mode Support for Row Store – Multi-threaded rebuilds…
https://www.nikoport.com/columnstore/."
December 3, 2025 at 9:34 PM
Just wrote "Continuation from the previous 131 parts, the whole series can be found at www.nikoport.com/columnstore/...
Working on my #Columnstiore session for the #datasaturday Madrid ... I feel like I have an easy 20-25 blog posts to write and I have quite a lot to say ... so yeah ...
Im Thinking Im Back John Wick GIF
ALT: Im Thinking Im Back John Wick GIF
media.tenor.com
November 16, 2025 at 4:58 PM
Working on my #Columnstiore session for the #datasaturday Madrid ... I feel like I have an easy 20-25 blog posts to write and I have quite a lot to say ... so yeah ...
I have heard about that book for years and just finished it - and what a treat! Highly recommended - "Only the paranoid survive" by Andy Grove. Feels so relevant today
www.penguinrandomhouse.com/books/72469/...
www.penguinrandomhouse.com/books/72469/...
Only the Paranoid Survive by Andrew S. Grove: 9780385483827 | PenguinRandomHouse.com: Books
Andy Grove, founder and former CEO of Intel shares his strategy for success as he takes the reader deep inside the workings of a major company in Only the Paranoid Survive. Under Andy Grove's leader...
www.penguinrandomhouse.com
October 26, 2025 at 5:32 PM
I have heard about that book for years and just finished it - and what a treat! Highly recommended - "Only the paranoid survive" by Andy Grove. Feels so relevant today
www.penguinrandomhouse.com/books/72469/...
www.penguinrandomhouse.com/books/72469/...
Will be presenting in around a month at #DataSaturdayMadrid 2025. The topic is the Columnstore and I will do my best to deliver the session in Spanish
datasaturdays.com/Event/202511...
datasaturdays.com/Event/202511...
Madrid
Data Saturdays website
datasaturdays.com
October 26, 2025 at 5:19 PM
Will be presenting in around a month at #DataSaturdayMadrid 2025. The topic is the Columnstore and I will do my best to deliver the session in Spanish
datasaturdays.com/Event/202511...
datasaturdays.com/Event/202511...
3rd week on the new gig - off for a first business trip, to Madrid.
September 16, 2025 at 7:44 AM
3rd week on the new gig - off for a first business trip, to Madrid.
Reposted by Niko Neugebauer
If you have kids/grandkids/kids you are involved with, here's a tip:
Teach them *how* to learn, how memory works, and how to take notes. I'm finding a lot of schools are not teaching these basics, and I'm having to re-teach that in my college classes.
Teach them *how* to learn, how memory works, and how to take notes. I'm finding a lot of schools are not teaching these basics, and I'm having to re-teach that in my college classes.
August 31, 2025 at 12:06 PM
If you have kids/grandkids/kids you are involved with, here's a tip:
Teach them *how* to learn, how memory works, and how to take notes. I'm finding a lot of schools are not teaching these basics, and I'm having to re-teach that in my college classes.
Teach them *how* to learn, how memory works, and how to take notes. I'm finding a lot of schools are not teaching these basics, and I'm having to re-teach that in my college classes.
Last night I have returned my badge.
From Monday on, I am no longer an employee of Microsoft.
I am grateful for the experience - for the good, the bad and the ugly.
Onwards & upwards!
From Monday on, I am no longer an employee of Microsoft.
I am grateful for the experience - for the good, the bad and the ugly.
Onwards & upwards!
a man with a beard wearing a cowboy hat and a black shirt .
ALT: a man with a beard wearing a cowboy hat and a black shirt .
media.tenor.com
August 30, 2025 at 12:49 PM
Last night I have returned my badge.
From Monday on, I am no longer an employee of Microsoft.
I am grateful for the experience - for the good, the bad and the ugly.
Onwards & upwards!
From Monday on, I am no longer an employee of Microsoft.
I am grateful for the experience - for the good, the bad and the ugly.
Onwards & upwards!
Long may you roar
At your dinosaurs
You're a just ruler
Covered in mud, you look ridiculous
And you have no idea
...
Way to go, tiger
Higher and higher
Wilder and lighter
For you
youtu.be/FQyEZZPbOb0?...
At your dinosaurs
You're a just ruler
Covered in mud, you look ridiculous
And you have no idea
...
Way to go, tiger
Higher and higher
Wilder and lighter
For you
youtu.be/FQyEZZPbOb0?...
Taylor Swift - Robin (Official Lyric Video)
YouTube video by Taylor Swift
youtu.be
June 5, 2025 at 8:22 PM
Long may you roar
At your dinosaurs
You're a just ruler
Covered in mud, you look ridiculous
And you have no idea
...
Way to go, tiger
Higher and higher
Wilder and lighter
For you
youtu.be/FQyEZZPbOb0?...
At your dinosaurs
You're a just ruler
Covered in mud, you look ridiculous
And you have no idea
...
Way to go, tiger
Higher and higher
Wilder and lighter
For you
youtu.be/FQyEZZPbOb0?...
[newsletter] Happy to share with you the very last Azure SQL Managed Instance Newsletter. Paul Popovich Jr and I have had a great pleasure of sharing with you the news of the product.
www.linkedin.com/pulse/azure-...
www.linkedin.com/pulse/azure-...
Azure SQL Managed Instance Newsletter for June 2025
Editor's Note Welcome to the Azure SQL Managed Instance Newsletter. In this edition we are looking over previous months before June 2025, sharing some of the latest service updates & materials that ca...
www.linkedin.com
June 5, 2025 at 7:53 PM
[newsletter] Happy to share with you the very last Azure SQL Managed Instance Newsletter. Paul Popovich Jr and I have had a great pleasure of sharing with you the news of the product.
www.linkedin.com/pulse/azure-...
www.linkedin.com/pulse/azure-...
[announcement] The free offer of Azure SQL Managed Instance is now Generally Available by Strahinja Rodic. Learn more at: aka.ms/sqlmi-free:
#azuresql #freesql
#azuresql #freesql
Free SQL Managed Instance offer is now generally available
Try Azure SQL Managed Instance for FREE now! Get a SQL Managed Instance free for up to 12 months, supporting up to 100 databases.
aka.ms
May 22, 2025 at 3:29 PM
[announcement] The free offer of Azure SQL Managed Instance is now Generally Available by Strahinja Rodic. Learn more at: aka.ms/sqlmi-free:
#azuresql #freesql
#azuresql #freesql
Reposted by Niko Neugebauer
May 19, 2025 at 2:28 PM
Reposted by Niko Neugebauer
Going to be a lot of good content from moi on @redmondit.bsky.social next week. Stay tuned.
May 16, 2025 at 5:30 PM
Going to be a lot of good content from moi on @redmondit.bsky.social next week. Stay tuned.
[newsletter] Azure SQL Managed Instance Newsletter to accompany the month of May 2025:
www.linkedin.com/pulse/azure-...
www.linkedin.com/pulse/azure-...
Azure SQL Managed Instance Newsletter for May 2025
Editor's Note Welcome to the Azure SQL Managed Instance Newsletter. In this edition we are looking over previous months before May 2025, sharing some of the latest service updates & materials that can...
www.linkedin.com
May 16, 2025 at 5:19 PM
[newsletter] Azure SQL Managed Instance Newsletter to accompany the month of May 2025:
www.linkedin.com/pulse/azure-...
www.linkedin.com/pulse/azure-...
Reposted by Niko Neugebauer
A significant milestone - enabling customers to migrate to #AzureSQL while ensuring gr8 price / perf. Using elastic pools for migrations ensures both isolation (security) of different workloads, and resource pooling. Read Ajith's blog post for details!
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
Elastic Pools SKU recommendations in DMS Automation - Azure Powershell and CLI | Microsoft Community Hub
We are excited to announce the addition of Azure SQL Database Elastic Pools (Elastic Pools) SKU recommendation in Azure Data Migration Service (DMS)...
techcommunity.microsoft.com
May 16, 2025 at 4:35 PM
A significant milestone - enabling customers to migrate to #AzureSQL while ensuring gr8 price / perf. Using elastic pools for migrations ensures both isolation (security) of different workloads, and resource pooling. Read Ajith's blog post for details!
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
Dear recruiters - some of the best people in Microsoft have been laid off (some of whom were top performers), here is your chance to grab them.
Be fast, cause supply is limited. 😃
Be fast, cause supply is limited. 😃
May 16, 2025 at 5:04 PM
Dear recruiters - some of the best people in Microsoft have been laid off (some of whom were top performers), here is your chance to grab them.
Be fast, cause supply is limited. 😃
Be fast, cause supply is limited. 😃
[Feedback Needed] I invite customers engaged in Database Administrator tasks using Azure SQL (SQL Server on Azure VMs, Azure SQL Database, or Azure SQL Managed Instance) to provide feedback regarding their access to the Azure Platform:
www.linkedin.com/feed/update/...
#azuresql
www.linkedin.com/feed/update/...
#azuresql
[Feedback Needed] I invite customers engaged in Database Administrator… | Niko Carvalho Neugebauer
[Feedback Needed] I invite customers engaged in Database Administrator tasks using Azure SQL (SQL Server on Azure VMs, Azure SQL Database, or Azure SQL Managed…
www.linkedin.com
April 2, 2025 at 3:35 PM
[Feedback Needed] I invite customers engaged in Database Administrator tasks using Azure SQL (SQL Server on Azure VMs, Azure SQL Database, or Azure SQL Managed Instance) to provide feedback regarding their access to the Azure Platform:
www.linkedin.com/feed/update/...
#azuresql
www.linkedin.com/feed/update/...
#azuresql
[observation] An essential part of the observability is to be able Diagnose and solve problems - and there is a tool for that on the Azure Portal.
It lists recent Azure Health Events, any eventual configuration changes, & 15 tools and guides (with videos).
#ObservAbility #azuresql #sqlmi
It lists recent Azure Health Events, any eventual configuration changes, & 15 tools and guides (with videos).
#ObservAbility #azuresql #sqlmi
March 18, 2025 at 9:20 PM
[observation] An essential part of the observability is to be able Diagnose and solve problems - and there is a tool for that on the Azure Portal.
It lists recent Azure Health Events, any eventual configuration changes, & 15 tools and guides (with videos).
#ObservAbility #azuresql #sqlmi
It lists recent Azure Health Events, any eventual configuration changes, & 15 tools and guides (with videos).
#ObservAbility #azuresql #sqlmi