Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
Blogs
SQL Server Row Level Security Deep Dive. Part 6 ...
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Microsoft Fabric and the Delta Tables Secrets
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
SQL Server Row Level Security Deep Dive. Part 5 – ...
As mentioned in previous sections, RLS is an addition to security and should not be used as […]
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
Download the notebook used on this blog I explained in a previous article how the Tables in […]
SQL Server Row Level Security Deep Dive. Part 4 – ...
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […]
SQL Server Row Level Security Deep Dive. Part 3 – ...
Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how […]
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. […]
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. […]
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and […]
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 […]
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
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 […]
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 […]
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 […]
Simple-Talk RSS Feeds
Recently, we have made a few changes to the simple-talk.com website’s RSS feeds that I am pretty […]
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people […]
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 […]
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 […]
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: 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 […]
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 […]
One use case for NOT using schema prefixes
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. […]
A Beginners Guide To MySQL Replication Part 2: Configuring Source ...
A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part […]
A Beginners Guide to MySQL Replication Part 1
MySQL Replication is a process where data from one MySQL database known as the source (formerly called […]
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, […]
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar […]
Synapse Serverless and Dedicated Pool: The differences no one told ...
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store […]
Optional Code in T-SQL Scripts using SQLCMD
When you are writing T-SQL scripts to save away, for example one to create a new database, […]
How to ask for programming help
Over the past 25 years, I have answered a lot of programming questions in online forums, from […]
Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I […]
Synapse Serverless: CETAS requires DFS to work
CETAS is the acronym for Create External Table As Select. This allow us to export the result […]
What’s new on Power BI DataMarts UI
I wrote an article about Power BI Datamarts which was released together the feature, on the exact […]
Backing up MySQL Part 8: Zmanda Backups for MySQL & ...
“A Backup as Revolutionary as You Are.” Ever heard that phrase before? If you did, you’re no […]
Dealing with the Bits of a Binary Value in SQL ...
How you used to do it For example, say you want to find all the read-write database […]
Backing Up MySQL Part 7: MySQL Enterprise Backup
MySQL Enterprise Backup is a known tool for everyone inside of the world of MySQL, no matter […]
Backing Up MySQL Part 5: Backing Up Big Data
According to research made by Statista in 2022, the amount of data that is being worked with […]
Backing up MySQL Part 4: mydumper
There are many tools we can use to back up our MySQL databases. Some are well-known and […]
SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Backing up MySQL Part 3: mysqlpump
In the MySQL world, there are a couple of ways to take backups of your data. Backups […]
Backing Up MySQL Part 2: Percona XtraBackup
There’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as […]
Optimizing MySQL: The Basics of Query Optimization
MySQL is a very interesting beast to deal with – both junior developers and expert database administrators […]
The PASS Data Community Sessions I Am Most Excited For
Note: Edited to add more sessions… So many The PASS Data Community Summit is coming up in […]