Sign in

iiinova is part of the Atmosphere — an open, public network where you own your identity.

Niko Neugebauer

@nikoneugebauer.bsky.social
469 followers 152 following 257 posts

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.

PostsRepliesMedia
Niko Neugebauer @nikoneugebauer.bsky.social · 19/07/2026
[blog] The Odyssey of Hekaton (SQL Server 2025): www.nikoport.com/2026/07/19/t... #sqlserver #hekaton #sqlserver2025
nikoport.com
The Odyssey of Hekaton (SQL Server 2025)
Over the years, I have contributed with a reasonably big number of posts on the topic of In-Memory OLTP (aka Hekaton) and I did a couple of focused presentations on this wonderful feature as well. …
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 18/07/2026
I just have added a Databricks & Claude categories to my blog.
110 1
Niko Neugebauer @nikoneugebauer.bsky.social · 18/07/2026
[blog] On being wrong* -https://www.nikoport.com/2026/07/18/on-being-wrong-with-asterisk/
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 22/04/2026
On my way to #sqlbits
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 18/01/2026
Columnstore post 136 is landing tonight
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 02/01/2026
[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
nikoport.com
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…
030 3
Niko Neugebauer @nikoneugebauer.bsky.social · 02/01/2026
The blog post is coming out tonight.
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 02/01/2026
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.
131 3
Niko Neugebauer @nikoneugebauer.bsky.social · 01/01/2026
[blog] Master Data Services in SQL Server 2025: www.nikoport.com/2025/12/31/m... #sqlserver2025 #mds #masterdataservices #bi #excelwriteback
nikoport.com
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…
130 3
Niko Neugebauer @nikoneugebauer.bsky.social · 25/12/2025
Columnstore Indexes – part 134 (“Vectors and Columnstore Indexes”): www.nikoport.com/2025/12/25/c... #columnstore #batch #vector #sqlserver2025
nikoport.com
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…
052 5
Niko Neugebauer @nikoneugebauer.bsky.social · 24/12/2025
a further update - it seems like a simple overflow bug that was not handled. Yeah - run "Preview" features on RTM on your own risk ;)
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 24/12/2025
a funnier update - removing Columnstore and running the average against the "precious int PK column" results in the same error. This is definitely some weird Vector data type bug. A minor one, but still a bug.
100 1
Niko Neugebauer @nikoneugebauer.bsky.social · 24/12/2025
INSERT INTO dbo.vectors (id, v) SELECT TOP (5000000) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)), CAST(JSON_ARRAY(ABS(CHECKSUM(NEWID())) % 1000) as Vector(1)) FROM sys.all_objects a CROSS JOIN sys.all_objects b;
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 24/12/2025
CREATE TABLE dbo.vectors ( id INT PRIMARY KEY NONCLUSTERED, v VECTOR(1) NOT NULL ); CREATE CLUSTERED COLUMNSTORE INDEX CCI_vectors on dbo.vectors;
100 1
Niko Neugebauer @nikoneugebauer.bsky.social · 23/12/2025
the funnier thing is that MIN(id) works just fine.
110 1
Niko Neugebauer @nikoneugebauer.bsky.social · 23/12/2025
SELECT avg(id) from dbo.vectors; -- the table has 5 million rows ... and [id] is a simple INT. -- the second column has a VECTOR column with a single dimension (full precision float)
210 2
Niko Neugebauer @nikoneugebauer.bsky.social · 23/12/2025
I am just running some aggregates on the table with Vector data type - aggregating with AVG against an INT column ...
110 1
Niko Neugebauer @nikoneugebauer.bsky.social · 03/12/2025
[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
nikoport.com
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…
020 2
Niko Neugebauer @nikoneugebauer.bsky.social · 03/12/2025
Just wrote "Continuation from the previous 131 parts, the whole series can be found at www.nikoport.com/columnstore/...
nikoport.com
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…
153 5
Niko Neugebauer @nikoneugebauer.bsky.social · 16/11/2025
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 ...
media.tenor.com
Im Thinking Im Back John Wick GIF
ALT: Im Thinking Im Back John Wick GIF
1111 11
Niko Neugebauer @nikoneugebauer.bsky.social · 26/10/2025
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/...
penguinrandomhouse.com
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...
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 26/10/2025
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
Madrid
Data Saturdays website
031 3
Niko Neugebauer @nikoneugebauer.bsky.social · 21/09/2025
Thank you!
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 16/09/2025
3rd week on the new gig - off for a first business trip, to Madrid.
190 9
Niko Neugebauer @nikoneugebauer.bsky.social · 31/08/2025
Same here. Keep up the spirit of challenging the status quo.
110 1
Reposted by Niko Neugebauer
buckwoodymsft.bsky.social @buckwoodymsft.bsky.social · 31/08/2025
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.
041 4
Niko Neugebauer @nikoneugebauer.bsky.social · 31/08/2025
Thank you - let’s see if the wind will be favorable for our paths to cross in the future!
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 31/08/2025
Danke dir, Klaus!
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 31/08/2025
media.tenor.com
a man with dreadlocks and a bandana on his head is holding a sword
ALT: a man with dreadlocks and a bandana on his head is holding a sword
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 31/08/2025
Thank you my friend. You were one of the great people who cared deeply about the customer impact and the company owes you more than most can imagine.
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
:)
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
Thank you Glenn!
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
Thank you, Anthony!
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
Thank you, Reitse!
120 2
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
Thank you
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
Thank you!
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 30/08/2025
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!
media.tenor.com
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 .
151294 129
Niko Neugebauer @nikoneugebauer.bsky.social · 05/06/2025
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?...
youtu.be
Taylor Swift - Robin (Official Lyric Video)
YouTube video by Taylor Swift
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 05/06/2025
[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-...
linkedin.com
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...
131 3
Niko Neugebauer @nikoneugebauer.bsky.social · 22/05/2025
[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
aka.ms
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.
041 4
Reposted by Niko Neugebauer
Glenn Berry @glennalanberry.bsky.social · 19/05/2025
New blog post: SQL Server 2022 CU19 glennsqlperformance.com/2025/05/19/s... #SQLServer2022 #SQLServer
SQL Server 2022 CU19
131 3
Reposted by Niko Neugebauer
Joey D'Antoni @joeydantoni.com · 16/05/2025
Going to be a lot of good content from moi on @redmondit.bsky.social next week. Stay tuned.
052 5
Niko Neugebauer @nikoneugebauer.bsky.social · 16/05/2025
[newsletter] Azure SQL Managed Instance Newsletter to accompany the month of May 2025: www.linkedin.com/pulse/azure-...
linkedin.com
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...
010 1
Reposted by Niko Neugebauer
Arvind Shyamsundar @arvisam.bsky.social · 16/05/2025
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
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)...
022 2
Niko Neugebauer @nikoneugebauer.bsky.social · 16/05/2025
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. 😃
054 5
Niko Neugebauer @nikoneugebauer.bsky.social · 02/04/2025
[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
linkedin.com
[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…
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 01/04/2025
[observation] The key 5 sources of #AzureSQL monitoring information are: Activity Log, Resource Health, Metrics, Diagnostic Logs & Azure Advisor. If you are collecting their information - you are largely covering the most important space. #azuresql #sqldb #sqlvm #sqlmi
000 0
Niko Neugebauer @nikoneugebauer.bsky.social · 19/03/2025
Was one of the original versions. Btw Cluster requirement is only 2016, 2017+ do not need a cluster to function for MI Link.
010 1
Niko Neugebauer @nikoneugebauer.bsky.social · 19/03/2025
MI Link supports 2016-2025 for one way replication and both ways for 2022 and SQL Mi using 2022 update policy.
110 1
Niko Neugebauer @nikoneugebauer.bsky.social · 18/03/2025
Query Store!
010 1