Blogs Dennes Torres in Blogs Microsoft Fabric and the Delta Tables Secrets Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained in my introduction... 27 September 2023 10 min read
Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 5 – RLS Attacks As mentioned in previous sections, RLS is an addition to security and should not be used as the primary method... 25 September 2023 21 min read
Dennes Torres 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 a lakehouse are... 20 September 2023 5 min read
Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. This section covers... 17 September 2023 20 min read
Dennes Torres Microsoft Fabric: using Notebooks and Table Partitioning to Convert Files to Tables When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays we have an... 13 September 2023 5 min read
Blogs Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 3 – Performance and Troubleshooting Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how to implement RLS... 10 September 2023 24 min read
Blogs Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 2 – Setup and Examples The previous section in this series was an introduction to Row Level Security (RLS) and some use cases. This section... 03 September 2023 16 min read
Blogs Dennes Torres in Blogs 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. However, during this... 28 August 2023 9 min read
Blogs Louis Davidson in Blogs Yet Another Reason to Not Use sp_ in SQL Server Object Names In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with using the sp_... 25 August 2023 6 min read
Blogs Simple Talk Editor in Blogs How to Write a Technical Blog That Gets Read There is a relatively simple and quickly learned technique to writing a blog that people will want to read. We... 22 August 2023 10 min read
Blogs Dennes Torres in Blogs Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. In fact, I... 21 August 2023 2 min read
Blogs Dennes Torres in Blogs Discover the Microsoft Fabric Data Wrangler The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and activate it, but... 14 August 2023 6 min read
Blogs Louis Davidson in Blogs 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 in a long... 10 August 2023 2 min read
Blogs Aisha Bukar in Blogs A Beginners Guide to MySQL Replication Part 4: Using GTID-based Replication Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s replication capabilities in... 08 August 2023 11 min read
Louis Davidson in Blogs 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 you can read... 08 August 2023 7 min read
Blogs Dennes Torres in Blogs Managing Query Store Hints I wrote about query store hints before when they were first released in Azure SQL databases. However, there are some... 02 August 2023 6 min read
Blogs Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 1 – Introduction and Use Cases My initial goal of documenting and exploring SQL Server Row Level Security (RLS) was to show the basic functionality and... 01 August 2023 17 min read
Blogs Ben Johnston in Blogs Unmasking SQL Server Dynamic Data Masking, Part 5, Mitigations and Summary This is the fifth and final part of this series on SQL Server Dynamic Data Masking. The first part in... 30 July 2023 13 min read
Blogs Aisha Bukar in Blogs 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 your support! And... 18 July 2023 11 min read
Editorials Louis Davidson in Editorials It’s Only Summer, but I am ready for PASS Data Community Summit Now! The PASS Data Community Summit 2023 happens the week of November 12 in Seattle. WA. It will be my first... 13 July 2023 4 min read
