Columnstore Indexes – part 129 (“Compatibility with the New Features of Sql Server 2019”)
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
An exploration of predictive analytics, its historical roots in human nature, and its modern implementation through data science and AI technologies.
Explains the role and implementation of 'stubs' or 'thunks' within the .NET Runtime, detailing their purpose in method dispatch and indirection.
A developer shares how they built a low-cost Azure game using Logic Apps and Face API for event engagement, with code on GitHub.
A technical note on calculating denominator degrees of freedom in survey-weighted generalized linear models (svyglm) for complex sample designs.
Explains Events Driven Architecture for iOS using MERLin, focusing on decoupling components, producers, listeners, and benefits like testability.
Explores how multiple dispatch in Julia enables mathematically correct code, using complex number division as a key example.
An analysis of Cohesity's evolution from a backup appliance vendor to a data aggregator, using aggregation theory to explain its cloud strategy.
Learn how to submit your Gatsby site to the official showcase for free publicity, open-source contribution, and swag.
Explains why pow() is slower than ** in Python using the dis module and introduces the concept of constant folding.
Troubleshooting guide for resolving a silent error when launching ASP.NET Core applications in IIS Express during development.
A detailed review of the book 'Reactive Programming in Spring 5', covering reactive streams, Reactor, WebFlux, and Spring's reactive ecosystem.
Analyzes security risks in npm package installation, highlighting the dangers of arbitrary code execution and advocating for cautious dependency management.
Explores optimal sampling design for logistic regression in case-control studies, analyzing Neyman allocation and two-phase sampling variances.
Explores a fast algorithm for estimating principal components via subsampling, analyzing its application to genetics and statistical tests.
A hands-on workshop from AWS re:Invent 2018 on using PowerShell to automate AWS infrastructure, featuring practical challenges.
Explores SQL Server 2019's improved DBCC CLONEDATABASE command for automatically extracting Columnstore Index statistics into a cloned database.
A talk exploring strategies for implementing rate limiting and request throttling in web applications to handle user traffic and prevent abuse.
A technical guide on setting up a self-hosted video livestream using ffmpeg, DASH, and nginx, bypassing services like Twitch.
Announcing two full-day SQL Server workshops at SQLSaturday Lisbon 2018, featuring Query Store troubleshooting and performance tuning.