Optimizing joins in Redshift
Visualizing a sample analytics query Recently at Affinity, we accelerated our analytics workloads on Redshift by optimizing our use of joins. In this blog post, Read More
Category: SQL
Seven Must-Have Security Policies for Your APIs
What security policies are you missing in your gateway layer? API architects and designers spend a lot of time discussing the latest security standards and Read More
How and why I built Real time data Syncing
About me I have 7+ years of experience as database and SSIS developer. The problem I wanted to solve Syncing of data in real time. Read More
25+ JSON Parsing and Validation Tools
JSON has become a standard structured data format for transferring information using web APIs. However, sometimes JSON needs a little polishing up. Below, we’ll give Read More
Databricks and Coursera Launch Data Science Specialization for Data Analysts
Earlier this year, Databricks made a massive investment in training by providing free self-paced courses to all of our customers. Databricks furthers this investment by Read More
A Simple Approach to Complicated Database Defaults
Database tables rarely stay the same over the course of a project. We often need to add tables, add or rename columns, or break up Read More
Announcing Azure Databricks Power BI Connector (Public Preview)
Databricks and Microsoft Power BI customers will be delighted to know that an enhanced Azure Databricks PowerBI connector is now natively integrated into Power BI Read More
Analyzing Algorand Blockchain Data with Databricks Delta
Algorand is a public, decentralized blockchain system that uses a proof of stake consensus protocol. It is fast and energy-efficient, with a transaction commit time Read More
Build a Go App with upper/db and CockroachDB
Today’s blog is a guest post by José Nieto, creator of upper/db. upper/db gives you tools for the most common operations with databases, and is Read More
NoSQL vs. NewSQL vs. Distributed SQL: DZone’s 2020 Trend Report
Databases are evolving. For the past decade, we’ve read thinkpiece after thinkpiece taking firm stances on the “SQL vs. NoSQL” debate–some of which declaratively pronounce Read More