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
A technical guide on configuring SQL Managed Instance on Azure Arc, covering parameters for creation, resource allocation, and storage options.
A technical guide on deploying and connecting to a SQL Managed Instance using Azure Arc enabled Data Services on Kubernetes.
Explains how to manually report consumption and metrics for Azure Arc Data Services in Indirectly Connected Mode, covering prerequisites and CLI commands.
Explains unexpected 'shakes' or health events in Azure VM Availability Groups, covering CPU, host, and IO contention issues.
A technical guide on customizing and deploying an Azure Arc Data Controller via command line, focusing on configuration details for Kubernetes.
Technical analysis advising against using Basic and Standard (S0 & S1) tiers in Azure SQL Database, citing performance, permissions, and feature limitations.
Analysis of Database Scoped Configuration changes in SQL Server and Azure SQL Database for the year 2020, noting new options and stability.
A technical deep dive into the internal pods and components of an Azure Arc Data Controller deployed on Kubernetes.
A technical guide on configuring Azure Active Directory Service Principals for consumption reporting in Azure Arc enabled Data Services.
A technical guide on configuring Azure Arc enabled Data Services on Azure Kubernetes Service (AKS), covering cluster setup and deployment steps.
A tech blogger reviews their 2020 conference presentations and blogging output, discussing challenges and future plans for AI and Azure topics.
A technical guide on configuring Azure Arc Data Services on a standard Kubernetes cluster, covering prerequisites, setup steps, and storage considerations.
SQLPort community group returns with an online meeting on Azure DevOps deployments for database professionals.
Explores the requirements and tools needed to deploy Azure Arc enabled Data Services on a Kubernetes cluster, including hardware specs and CLI tools.
Introduction to Azure Arc for Data Services, explaining how it extends Azure management to on-premises and multi-cloud Kubernetes environments.
Explains the need for write permissions on Azure Blob Storage files when restoring SQL Server backups and the implications for lifecycle management.
Announcing two technical sessions at the virtual PASS Summit 2020: migrating SQL Server to Azure VMs and using Columnstore Indexes.
Analyzes SQL Server disk caching on Azure VMs, questioning Microsoft's best practices with performance data.
Azure Elastic Job Agent, a long-awaited SQL Agent alternative for Azure SQL Database, is approaching General Availability after years in preview.
A guide to essential security practices for protecting SQL Server instances running on Azure Virtual Machines, focusing on encryption and access controls.
