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 Azure SQL Data Warehouse's Result Set Caching feature, its benefits for data warehousing, and how to enable it.
Explores the availability and configuration of Columnstore Indexes across various Azure SQL Database tiers, including General Purpose, Serverless, and Hyperscale.
Announcing a SQLBits 2020 workshop on migrating, optimizing, and running SQL Server workloads on Azure Virtual Machines.
Announcement for a full-day workshop on SQL Server Columnstore Indexes at SQLSaturday Vienna 2020, covering practical techniques across multiple versions.
Argues that raw data is overvalued without proper context and conversion into meaningful information and knowledge.
Analyzes the current state and future of SQL Server's In-Memory OLTP technology, highlighting new features in SQL Server 2019 and persistent limitations.
Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.
Explains SQL Server 2019's new support for creating database snapshots that include in-memory (Hekaton) filegroups, a previously unsupported feature.
Explains the new Resumable TDE Scan feature in SQL Server 2019 and Azure SQL Database, detailing its commands and benefits for system availability.
Summary of key new features in SQL Server 2019 Standard Edition, including Transparent Data Encryption (TDE) and performance enhancements.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
The article critiques the overuse and devaluation of the titles 'Engineer' and 'Scientist' in modern IT, focusing on data science and engineering roles.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
An exploration of predictive analytics, its historical roots in human nature, and its modern implementation through data science and AI technologies.
Explains Accelerated Database Recovery (ADR) in SQL Server 2019/Azure SQL, a feature designed to drastically reduce transaction rollback and database recovery times.
Announcing a SQLSaturday Lisbon 2019 workshop on deploying and managing SQL Server on Kubernetes, covering containers, orchestration, and high availability.
A data professional argues for attending PASS Summit over Microsoft Ignite to support the non-profit community, despite Ignite's value.
Announcement for SQLSaturday Lisbon 2019 and Porto 2019, including dates, call for speakers, and workshop topics.
Explores SQL Server 2019's new 'Feature Restrictions' security feature, designed to help prevent SQL injection attacks.
Performance analysis of SQL Server 2019's Batch Execution Mode on TPC-H queries using rowstore indexes and compressed data.
