Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure […]
simple-talk.com
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, […]
SQL Server Row Level Security Deep Dive. Part 2 – ...
The previous section in this series was an introduction to Row Level Security (RLS) and some use […]
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. […]
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 […]
Yet Another Reason to Not Use sp_ in your SQL ...
In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with […]
Fabric Lakehouse: Convert to Table feature and Workspace Level Spark ...
I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. […]
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 […]
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and […]
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 […]
Going to a conference where hardly anybody knows my name
On Friday and Saturday August 11 and 12, I am going to do something I haven’t done […]
A Beginners Guide to MySQL Replication Part 4: Using GTID-based ...
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s […]
T-SQL Tuesday #165 – My Experience with Database Job Titles
They mean very little. More on that after nothing that this is part of T-SQL Tuesday, and […]
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 […]
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to […]
Unmasking SQL Server Dynamic Data Masking, Part 5, Mitigations and ...
This is the fifth and final part of this series on SQL Server Dynamic Data Masking. The […]
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 […]
A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication
Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for […]
Managing Test Data for Database Development
In coming up with a strategy for managing test data, first you need to understand what the […]
It’s Only Summer, but I am ready for PASS Data ...
The PASS Data Community Summit 2023 happens the week of November 12 in Seattle. WA. It will […]
What Counts for a DBA – Discretion
I was looking at the list of topics I have talked about in my “What Counts for […]
The GROUP BY Clause
When you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […]
Simple-Talk RSS Feeds
Recently, we have made a few changes to the simple-talk.com website’s RSS feeds that I am pretty […]
When Parameter Tuning is not the Answer
So much about parameters tuning, but does it always help? Welcome to the third and final blog […]
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted ...
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of […]
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people […]
Using a Subquery in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […]
Snowflake: A Cloud Warehouse Solution for Analytics
This article explains what Snowflake data warehouse is and how it is different from other traditional data […]
Working with MySQL transactions
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible […]
Unmasking SQL Server Dynamic Data Masking, Part 3, Security Concerns
This is the third part of a series on SQL Server Dynamic Data Masking. The first part […]
Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant
So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, […]
A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, […]
Unmasking SQL Server Dynamic Data Masking – Part 2 – ...
This is the second part of a series on SQL Server Dynamic Data masking. The first part […]
Power BI Connections Management
Some time between January and now, a new preview feature was included in Power BI Portal. It’s […]
SQL Server 2022: Capture SQL Anti-Patterns
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended […]
T-SQL Gap-Filling Challenge
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
Unmasking SQL Server Dynamic Data Masking, Part 1, Intro
This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
.In this blog I will illustrate how we can ingest data from a blog storage to a […]
Data Intelligence on light speed: Microsoft Fabric
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
Self Review: Practical Graph Structures in SQL Server and Azure ...
I just finished writing this book a few weeks ago, and as I read it, I thought […]
Optimizing MySQL: Adding Data to Tables
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the […]
PostgreSQL Basics: A Template for Managing Database Privileges
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, […]