Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […]
Homepage
The Importance of Retention
It is always an afterthought. New objects are created that start off small and current. New feature […]
Optimized locking in Azure SQL Database
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for […]
PowerShell Dynamic Parameters and SQL Server
Have you ever been in a situation that you want to call a cmdlet or a function […]
Two-Dimensional Interval Packing Challenge
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […]
Eager Aggregation in SQL queries
Aggregation is a widely used way to summarize the content of a database. It is usually expressed […]
Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is […]
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […]
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where […]
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address […]
MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect […]
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […]
Understanding SQL Join Types
Understanding how to join the data in one table to another is crucial for any data analyst […]
When an update doesn’t update
Tell me if you’ve heard this one before: I changed data from my application, but when I […]
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present […]
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity […]
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
Getting Started with MongoDB
MongoDB is a scalable database management system that stores data as documents in a collection, rather than […]
The NTILE Function
The SQL NTILE() is a window function that allows you to break a table into a specified […]
Moving SQL Server To The Cloud: Modernizing Stack Overflow for ...
Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a […]
Getting connected to PostgreSQL for the first time
PostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source […]
SQL Endpoints and Lakehouse UI Differences and Access Secrets
There are some differences and secrets between the UI of a SQL Endpoint and the UI of […]
Pike’s Market to Pikes Peak: The PASS Summit is Worth ...
Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes […]
Exporting and Importing Data into SQL Server Using Files
There are plenty of applications and tools available that allow for the movement of data in and […]
Don’t use DISTINCT as a “join-fixer”
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […]
A Beginners Guide To MySQL Replication Part 6: Security Considerations ...
This article is part of Aisha Bukar’s 6 part series: A Beginners Guide to MySQL Replication. The […]
PostgreSQL Indexes: What They Are and How They Help
In the previous blog in this series, we learned how to produce, read and interpret execution plans. […]
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […]
Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]
T-SQL Fundamentals: Controlling Duplicates
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time […]
MySQL joins
Tables in a MySQL database are commonly related to one another, often in multiple ways, and it […]
Analyze and Tune SQL Server Statistics
Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […]
Alternatives To SQL-2022 Built-in function GREATEST
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure […]
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
Orchestrating a MySQL Container on Kubernetes
If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, […]
A Beginners Guide to MySQL Replication Part 5: Group Replication
This article is part of Aisha Bukar’s 6 part series on MySQL Replication. The entries include: Part […]
Learning PostgreSQL With Grant: Introducing VACUUM
While there are many features within PostgreSQL that are really similar to those within SQL Server, there […]
How much has data technology changed over the years?
The simple answer to this question is “a lot.” The funny part, however, is that everyone who […]
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
Database Concurrency in PostgreSQL
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs […]
What Is an Execution Plan and How to Find It ...
In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans […]
Building REST APIs in Go with Mux and GORM
In modern software development, Application Programming Interfaces (APIs) are essential for building scalable and flexible systems. APIs […]
Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to […]
Exporting data from a MySQL database using SELECT…INTO OUTFILE
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all of the […]
Querying PostgreSQL: Learning PostgreSQL with Grant
Writing queries to retrieve the data from a database is probably the single most common task when […]
Optimizing Queries in MySQL: Optimizing Updates
In the previous parts of these MySQL optimization series, we’ve told you how queries work on a […]
Managing Test Data for Database Development
In coming up with a strategy for managing test data, first you need to understand what the […]
The GROUP BY Clause
When you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […]
When Parameter Tuning is not the Answer
So much about parameters tuning, but does it always help? Welcome to the third and final blog […]