Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – […]
simple-talk.com
Building a Culture of Data: The Technical Aspects
In the first part of this two-part series, I covered the mostly non-technical aspects of building a […]
Database Subsetting and Data Extraction
Let’s start by defining a subset and why you would require a data subset? When dealing with […]
Exploration Experience: Saving and Creating Datasets
I have been talking about Data Exploration in Power BI on many of my sessions, specially the […]
Snake draft sorting in SQL Server, part 2
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […]
Snake draft sorting in SQL Server, part 1
I recently had a restore job where I needed to split the work up into multiple parallel […]
Fabric and Azure SQL in a few clicks: Mirroring a ...
Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for […]
How to Use Any SQL Database With Rust
Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t […]
Azure OpenAI and RAG Security
The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […]
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, ...
In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in […]
Giving Feedback on Microsoft Data Platform Tools
As a data professional, there is a set of tools that you use on pretty much a […]
Dynamic Partitioning and a Simple Incremental Load
Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode(« overwrite »).format(« delta »).partitionBy(« Year », »Month », »Day »).save(« Tables/ » + table_name) […]
Building MongoDB Aggregations in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are […]
Pagination and ordering by large values
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on […]
Department of Redundancy Department
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think […]
The Benefits of Volunteering at SQL Saturdays
Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […]
Transforming and Analyzing Data in PostgreSQL
In our data hungry world, knowing how to effectively load and transform data from various sources is […]
Get the most out of SQL Server Agent logs
If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on […]
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
Writing your 2024 PASS Data Community Summit Submission
It is time again for the PASS Data Community Summit Call For Speakers. Some of you are […]
Serverless Authentication methods in web apps.
Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional […]
The Value of Conference Speaking
Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, […]
Building MongoDB Aggregations
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Friendly Deletes in SQL Server
One of the first things you learn when working with SQL Server, and other transactional based SQL […]
Find and Replace Text in Strings in T-SQL
String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts […]
Upgrade SQL Server on your workstation
Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. […]
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. […]
Functions and Procedures: Learning PostgreSQL with Grant
One of the most useful constructs in SQL Server is the stored procedure. It gives you a […]
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually […]
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to […]
Feature Flags in Data Projects
My motivation for writing this summary was an interaction with a project owner that didn’t understand why […]
Adding a new AI usage policy to Simple-Talk
I used to think plagiarism was my worst thing to deal with as an editor. That is […]
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make […]
State of the Database Landscape Results 2024
Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […]
Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […]
The Importance of Retention
It is always an afterthought. New objects are created that start off small and current. New feature […]
Working on Technology Off the Clock
I have always spent time learning relational databases on my own, non-work time. As the years have […]
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
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 […]
Being A Bit Less Comfortable in 2024
I hate coming up with ideas for editorials, but my last editorial of the year gives me […]
Two-Dimensional Interval Packing Challenge
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […]
Warehouse Load Patterns – Part 2 – Load Patterns
This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […]
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 […]