Niko Neugebauer is an expert in SQL Server, Columnstore indexes, and data platforms, sharing in-depth technical guides, performance optimization tips, and community insights on advanced database technologies.
125 articles from this blog
Explains Closeness Centrality, a key graph analysis metric, and demonstrates its calculation using SQL Server 2019's graph database features.
Explores the new Shortest Path algorithm support in SQL Server 2019's Graph Engine, a key feature for graph database functionality.
Overview of the new Learning Pathways concept at PASS Summit 2019, featuring structured educational tracks on AI, cloud, SQL performance, and Azure data engineering.
Author shares excitement about presenting two technical sessions on SQL Server Columnstore Indexes and Batch Execution Mode at the PASS Summit 2019 data platform conference.
Explains SQL Server 2019's Froid feature for inlining Scalar T-SQL UDFs to improve performance, with caveats and function type context.
A technical guide exploring workarounds to update SQL Server statistics on secondary replicas in Availability Groups, including scripts and methods.
Explores a new feature in SQL Server 2019's SET STATISTICS IO output, revealing detailed I/O metrics for INSERT operations into target tables.
An IT-focused article arguing that wisdom, not just knowledge, is the true goal for tech professionals, critiquing the industry's data obsession.
A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.
A detailed overview of the new Database Scoped Configuration options introduced for SQL Server and Azure SQL Database in 2018, leading into 2019.
A database expert reviews their 2018 speaking engagements and blog output, focusing on Columnstore Indexes, Graph Databases, and Batch Execution Mode.
Explores MERGE DML statement support for Graph tables in SQL Server and Azure SQL Database, focusing on UPSERT operations for node and edge tables.
Author offers 12 free hours of expert consultation on Columnstore Indexes and Batch Execution Mode in SQL Server throughout 2019.
Explores new SQL Server 2019 & Azure SQL Database preview features for derived tables and views in Graph databases, focusing on heterogeneous nodes and edges.
Announcing a new YouTube channel focused on SQL Server Columnstore Indexes and Batch Execution Mode, featuring technical videos and interviews.
Announcing a workshop on optimizing ETL processes for SQL Server and Azure SQL at the SQLBits 2019 conference.
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
Explains how to configure and use the Read Scale-Out feature for Azure SQL Database Premium tier to offload read workloads to secondary replicas.
Explores the new Edge Constraints feature in SQL Server 2019 and Azure SQL Database for enforcing data quality and directionality in graph database schemas.
Author's schedule and session highlights for the PASS Summit 2018, a major Microsoft Data Platform conference.
