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 SQL Server backup throttling issues in Azure VMs due to disk throughput limits exceeding VM caps, causing performance problems.
Analyzes limitations of SQL Server's Resource Governor IOPS_PER_VOLUME for I/O throttling in complex storage setups, like Azure VMs with multiple drives.
SQL Server 2019 introduces a new feature in Configuration Manager to simplify certificate import and management for TLS encryption.
A technical guide on configuring Workload Classifiers in Azure Synapse Analytics to map users and queries to specific workload groups for resource management.
Explains workload isolation and resource governance in Azure Synapse Analytics, covering static and dynamic resource classes for managing query performance.
SQLPort celebrates its 10th anniversary with a series of 10 technical webinars on Microsoft Data Platform topics like Always Encrypted and Azure Synapse.
A personal retrospective on founding and leading the SQLPort user group for SQL Server and Microsoft Data Platform over its first decade.
Explores methods for automatically deleting old SQL Server backup files stored in Azure Blob Storage, comparing tools like SQL Agent and Azure Automation.
Explains the evolution and technical details of striping SQL Server backups to Azure Blob Storage, covering performance improvements and limitations.
Announcement of a technical workshop on SQL Server Columnstore Indexes, covering versions, features, and practical techniques.
Explores SQL Server 2019's session context functions and their unexpected impact on query parallel execution plans.
Explains limitations of ONLINE rebuild for Rowstore indexes on tables with Columnstore Indexes in older SQL Server versions (2016, 2017).
A reflection on how abundance of resources, like online learning platforms, can paradoxically lead to devaluation and inaction in the IT field.
Announcement of a pre-conference workshop on SQL Server Columnstore Indexes at SQLSaturday Cincinnati, covering versions, batch mode, and Azure Synapse features.
Explores methods for copying data into Azure Synapse Analytics (SQL DW), focusing on the CTAS and new COPY INTO commands.
Overview of new Database Scoped Configurations in SQL Server 2019, including VERBOSE_TRUNCATION_WARNINGS and LAST_QUERY_PLAN_STATS.
Explains how to use query labeling in Azure Synapse Analytics (SQL DW) to identify and monitor specific query executions.
A data professional reviews their 2019 speaking engagements, presentations, and blog output, with a focus on SQL Server and Columnstore Indexes.
A technical guide on creating and managing Materialized Views in Azure SQL Data Warehouse, focusing on practical implementation and limitations.
Introduction to Materialized Views in Azure Synapse Analytics, explaining their purpose as a caching mechanism for data warehouse optimization.
