Columnstore Indexes – part 127 (“Batch Mode on Rowstore – is it a Columnstore Killer?”)
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
Author discusses increasing false positives in Gmail's spam filter, causing legitimate emails like security alerts to be missed, and expresses frustration with Google.
Overview of new features, changes, and fixes in PHP-ML 0.7.0, a machine learning library for PHP developers.
SQL Server 2019's Master Data Services (MDS) finally replaces the Silverlight-based web interface with a modern, browser-agnostic HTML front-end.
A developer shares their experience and practical tips for successfully preparing for and passing the Certified Kubernetes Administrator (CKA) exam.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
A developer details troubleshooting Windows Media Center on Windows 10, explaining DLL Hell and a COM-based workaround for a broken system component.
A mathematical optimization problem to find the ideal speed bump shape that minimizes vertical acceleration, using calculus of variations.
Explores typographic tempo experiments with Adobe, adjusting whitespace dynamically and discussing smart defaults for typesetting.
A tutorial replicating a Python experiment on creating a biased AI sentiment classifier, but using R, GloVe embeddings, and glmnet for logistic regression.
Explores Microsoft's new Columnstore compression estimation in SQL Server 2019, comparing it to a custom system stored procedure.
Explains npm's evolving naming rules to combat typosquatting attacks, detailing case sensitivity and character restrictions for package names.
Guide on configuring JMX metrics access for Apache Kafka and related services running in Docker containers from the host machine.
A technical guide explaining the upper() interpolation function in Terraform, including its syntax, usage examples, and practical applications.
Explains the substr() function in Terraform for extracting substrings, including examples and use cases.
Explains the Terraform timestamp() function, its usage, and important considerations like ignoring changes.
A technical tutorial on implementing and managing Azure Virtual Networks using PowerShell and CLI, including subnet creation and VM deployment.
A technical guide on splitting delimited text into a table using DAX functions like PATH, GENERATESERIES, and PATHITEM for Power BI data modeling.
Explains the Terraform replace() function for string manipulation, including regex usage and practical examples.
Explains key Azure concepts: Tenants, Subscriptions, Regions, and Geographies for cloud infrastructure management.