Working with Documents in the MongoDB Compass GUI
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
simple-talk.com
Hot off the press
Every day an avalanche of news hits us from all directions in all kinds of media. So […]
It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how […]
T-SQL Tuesday #176: One piece of advice you wish Past ...
After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One […]
Extending Get-Process to show the Process Chain using PowerShell Proxy ...
A proxy function or wrapper function allows you to deploy a custom version of a function or […]
Saving Data Historically with Temporal Tables: Part 1: Queries
In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in […]
Deleting Documents from a MongoDB Collection
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes […]
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services […]
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as […]
Sails.js for web development
Sails.js is a robust web development framework that runs on top of Node.js and uses JavaScript’s asynchronous […]
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
The signs of a new era: Prompt Injection
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
Effective Strategies for Storing and Parsing XML in SQL Server
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, […]
Powershell and SQL on the River
We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of […]
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I […]
The CHECK() Constraint
One of the many ways a relational table differs from the file structures used by pre-relational storage […]
Exploring MVCC and InnoDB’s Multi-Versioning Technique
In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing […]
Optimizing MySQL: Deleting Data
In the previous parts of these MySQL optimization series, we told you how query optimization works on […]
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]
T-SQL Tuesday #174: Your Favorite Job Interview Question?
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for […]
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, […]
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined […]
PySpark Secrets to use with Fabric
PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […]
Updating Documents in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Database technology learning resources
Before I started as the editor of Simple Talk, I worked on SQL Server. Only. (Ok, I […]
Building RESTful APIs in Rust With Actix and Diesel
There are many packages and tools that you can use to facilitate your API development with Rust. […]
Working with IAsyncEnumerable in C#
IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of […]
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 – […]
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 […]