MySQL vs PostgreSQL JSON Data Types: Key Differences & Which ...
In this article, the latest in the MySQL vs PostgreSQL series, we’ll compare how they each handle […]
SQL
15 Practical Tips for Securing SQL Server
Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks […]
How to Monitor and Optimize Batched Deletion Processes in SQL ...
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, […]
5 Strategies to Refactor SQL Code
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality […]
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User ...
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The JOIN statement is one of the most common operations SQL developers perform. Yet in a world […]
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has […]
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes […]
How to Increase SQL Server Column Width Without IO (Input/Output) ...
One of the most hassle-prone changes that can be made in a SQL Server database is to […]
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous ...
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; […]
How to use pgAdmin with Azure Database for PostgreSQL flexible ...
Multiple tools are available for working with Azure Database for PostgreSQL flexible server. One of these is […]
How to Use the New PRODUCT() Function in SQL Server ...
With each version of SQL Server, there are always a few new features introduced that we applaud […]
Incrementally Loading Data into Parquet with Python
Parquet is a column-oriented open-source storage format increasingly used for “big data” analytics. Yet despite its growing […]
How to Script Dimensions with data build tool (dbt) Macros
In previous articles we introduced the popular data engineering tool dbt (data build tool). We showed you […]
Columnstore Index Improvements in SQL Server 2025
Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has […]
Understanding MERGE to Insert, Update, and Delete Data Simultaneously
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
Managed Instance Gotchas – Error Conditions
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]
Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Writing an Efficient Query
SQL is easy to start writing. The basic syntax to start returning data is very simple. This […]
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 […]
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]
Will AI end with SQL, Is this the end of ...
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI […]
SQL Window Functions Series: NTILE()
Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL Window functions! As we journey through the intricate labyrinths of databases […]
How to Use SQL to Analyze the Bitcoin Blockchain
Background The Bitcoin blockchain is a vast and complex database. It contains over 100 million blocks, each of […]