A gentle introduction to dbt
In a typical data warehouse project, data is loaded, transformed and stored into a data store using […]
Featured
Introduction to Oracle Database for Database Professionals
Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used […]
MySQL Index Deep Dive: Clustered B-Tree Indexes
If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered […]
Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along […]
Working with MongoDB Indexes
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Essential Strategies for Optimizing Snowflake Performance and Reducing Costs
In today’s data-driven enterprise environment, businesses increasingly rely on Snowflake’s cloud data warehouse for handling large-scale data […]
Hiring and Motivating Technical Polyglots in Data Analytics
In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who […]
Breaking Down Ignite: A Pragmatic Look at the Conference’s Best ...
The amount of news brought by Ignite is huge. I was not expecting to find so many […]
Reading and Writing Parquet Files in SQL Server
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place […]
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
Demystifying Continuous Integration vs. Continuous Delivery: Part 2
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series. In Part 1 of […]
Connecting to MongoDB through Python
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
AI and Databases
Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s […]
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost […]
MySQL Index Overviews: FULLTEXT B-Tree Indexes
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and […]
How To Embed Your Azure Logic Apps in a Metadata-driven ...
In this article, I am going to explain how you can dial your productivity up to 11 […]
Consistency and Concurrency in NewSQL Database Systems
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data […]
Creating Views in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Quick Tricks to Make Your Power BI Model Smaller, More ...
Power BI has been a leading data visualization tool in the market for years. It can be […]
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part ...
In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. […]
Rounding Numbers
I would hope by now everybody has figured out when you see a price like $39.99 that […]
Boosting Database Development Efficiency Using AI SQL Code Generators
Database development has become more complex over the years due to the introduction of new data and […]
How To Use Managed Identities in your Azure Logic Apps
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your […]
AWS Services Using SQL for Big Data Analysis
SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can […]
Working with Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Companies of all sizes and across industries are struggling to cope with an explosion of data never […]
Making Temporal Databases Work. Part 3: Saving Data
The temporal database is a database that can keep information on time when the facts represented in […]
Uniqueness, Keys, and Identity
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as […]
PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL ...
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring […]
Storing and Retrieving the Initialization and Configuration Data for Applications
All developers hit the problem of how and where to store and set their configuration, profile, or […]
MySQL Index Overviews: Composite B-Tree Indexes
Indexes in MySQL are one of the primary ways to enhance query performance and they are especially […]
Bad Data and Dirty Databases
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at […]
EsProc SPL and SQL, Complimentary , But Different Technologies
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your […]
Effective Strategies for Storing and Parsing JSON in SQL Server
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
Introducing Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and […]
PostgreSQL Partitioning: The Most Useful Feature You May Never Have ...
Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often […]
Change Data Capture Pipeline Automation in Snowflake
This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC […]
MySQL vs PostgreSQL: Which Open-Source Database is right for you?
When I joined a growing startup company as a backend developer, we were at crossroads choosing between […]
MySQL Index Overviews: B-Tree Indexes
In this first entry in a multipart series on indexes, I will cover the most important index […]
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
5 Ways to Spend Your 2024 Learning and Development Budget ...
Not many data professionals get a personal Learning and Development (L&D) budget that we can use at […]
How to Stream Data from Azure Event Hubs into a ...
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for […]
SQL Server 2022 is now generally available
Part of theSQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the […]