Powering Up RavenDB Indexes With NuGet Packages
DZone In RavenDB 5, you can use third-party NuGet packages and load binary data (or “attachments”) within your indexes without…
Extend Your Existing SQL Server Failover Cluster Instance to the Cloud for Disaster Recovery
DZone I get asked this question all the time, so I figured it was time to write a blog post,…
Tackling Gender Bias Using Analytics
DZone Introduction Chances are when you hear “0.77 cents on the dollar,” an increasingly contentious subject — the gender pay…
Visualizing Covid-19 PostgreSQL Data With Arctype
DZone Introduction As competing cogs in one of the fastest-growing industries within the technology sector, data analysis companies are constantly…
Does Product-Led Growth Produce Better Companies?
DZone After serving two years in the Peace Corps, I knew I wanted to join a startup, but I immediately…
Learn How to Write Secure SQL Common Table Expressions
DZone One powerful feature of Microsoft SQL Server is common table, which lets you store a temporary result and execute…
Rule-Based Query Optimization
DZone The goal of the query optimizer is to find the query execution plan that computes the requested result efficiently.…
A Hitchhicker's Guide to SQLite With Python
DZone Introduction to SQLite and Embedded Databases SQLite is a small, self-contained, client/embedded database written in the C Programming language…
Resolving the MySQL Active-Active Replication Dilemma
DZone Multi-writer replication has been a challenge in the MySQL ecosystem for years before truly dedicated solutions were introduced –…
Cross-database Computing Methods
DZone For some reason, data is sometimes divided into segments to be stored in different databases. This will involve mixed…