Building a Culture of Data: The Technical AspectsIn the first part of this two-part series, I covered the mostly non-technical aspects of building a […] 19 avril 2024 dans Sites anglophones étiqueté Blogs / Culture / Data culture / Homepage par simple-talk.com
Exploration Experience: Saving and Creating DatasetsI have been talking about Data Exploration in Power BI on many of my sessions, specially the […] 17 avril 2024 dans Sites anglophones étiqueté Blogs / Data Exploration / Microsoft Fabric / Power BI par simple-talk.com
Azure OpenAI and RAG SecurityThe most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […] 10 avril 2024 dans Sites anglophones étiqueté Azure / Blogs / openai / Security par simple-talk.com
Dynamic Partitioning and a Simple Incremental LoadLet’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) […] 3 avril 2024 dans Sites anglophones étiqueté Blogs / lakehouse / Microsoft Fabric par simple-talk.com
The Benefits of Volunteering at SQL SaturdaysEditor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […] 14 mars 2024 dans Sites anglophones étiqueté Blogs / Career par simple-talk.com
Reverse Creating the PBIP file from Source ControlOn my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […] 6 mars 2024 dans Sites anglophones étiqueté Blogs / Git / Microsoft Fabric / Power BI / Source Control / Uncategorized par simple-talk.com
Friendly Deletes in SQL ServerOne of the first things you learn when working with SQL Server, and other transactional based SQL […] 1 mars 2024 dans Sites anglophones étiqueté Blogs / DELETE Statement / Performance / SQL Server par simple-talk.com
Feature Flags in Data ProjectsMy motivation for writing this summary was an interaction with a project owner that didn’t understand why […] 1 février 2024 dans Sites anglophones étiqueté ADF / Blogs / CI/CD / Feature Flags / Power BI / SSIS / SSRS par simple-talk.com
Adding a new AI usage policy to Simple-TalkI used to think plagiarism was my worst thing to deal with as an editor. That is […] 26 janvier 2024 dans Sites anglophones étiqueté Blogs par simple-talk.com
Working on Technology Off the ClockI have always spent time learning relational databases on my own, non-work time. As the years have […] 16 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
Semantic Model: More than a Simple Name ChangeThe animation on the top of this article tries to track the evolution of the enterprise architecture […] 10 janvier 2024 dans Sites anglophones étiqueté Blogs / Data Warehouse / lakehouse / Microsoft Fabric / Power BI / Semantic Model par simple-talk.com
Being A Bit Less Comfortable in 2024I hate coming up with ideas for editorials, but my last editorial of the year gives me […] 3 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
Warehouse Load Patterns – Part 2 – Load PatternsThis continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […] 31 décembre 2023 dans Sites anglophones étiqueté BenJohnston_ETL / Blogs / ETL / load patterns par simple-talk.com
Fabric Notebooks and Deployment PipelinesOn my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […] 13 décembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Deployment Pipelines / Microsoft Fabric / notebook / Power BI par simple-talk.com
SQL Server: Optimize for Ad Hoc Workloads – use or ...I used to believe this option was something almost absolute: it should be enabled as best practice. […] 6 décembre 2023 dans Sites anglophones étiqueté Blogs / optimization / SQL Server par simple-talk.com
Microsoft Fabric: Extended Source Control FeaturesThe source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […] 29 novembre 2023 dans Sites anglophones étiqueté Azure DevOps / Blogs / Git / Microsoft Fabric / Power BI par simple-talk.com
Warehouse Load Patterns – Part 1 – Requirements and General ...No matter the ETL tool used, there are some basic patterns to follow when transferring data between […] 26 novembre 2023 dans Sites anglophones étiqueté Blogs / Data Warehouse / ETL / requirements analysis par simple-talk.com
Updates about Database Projects for Microsoft Fabriccomp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […] 26 novembre 2023 dans Sites anglophones étiqueté Azure Data Studio / Blogs / Data Warehouse / Database Project / Microsoft Fabric par simple-talk.com
Back home from the PASS Data Community SummitWhat a week it was. While it wasn’t my first in person conference this year, it felt […] 21 novembre 2023 dans Sites anglophones étiqueté Blogs / PassDataSummit2023 par simple-talk.com
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...Last but not least, the Community Keynote. Hang on to your hats, this is going to be […] 17 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
PASS Summit 2023 – Redgate Keynote – The New Database ...Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […] 16 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […] 15 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Autonomous Databases?I was talking to some people today about the concept of Autonomous Databases. The idea is that […] 15 novembre 2023 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
An editor’s biggest headache: PlagiarismAs an editor working with other people’s technical writing for many years, you might guess that either […] 10 novembre 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Fabric Data Warehouse News you need to knowMicrosoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […] 8 novembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Data Warehouse / Microsoft Fabric / Power BI par simple-talk.com
Creating an Azure PostgreSQL cluster and connecting to itOne of the technologies that my new job brought with it was learning about all the various […] 4 novembre 2023 dans Sites anglophones étiqueté Azure / Blogs / PostGreSQL par simple-talk.com
Database Projects for Microsoft Fabric Data WarehouseDatabase Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […] 25 octobre 2023 dans Sites anglophones étiqueté Blogs / Data Warehouse / Database Project / Microsoft Fabric / Power BI par simple-talk.com
SQL Server Security PrimerSQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it […] 15 octobre 2023 dans Sites anglophones étiqueté Blogs / Security and Compliance / SQL Security par simple-talk.com
Fabric: My Content compilationMicrosoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […] 4 octobre 2023 dans Sites anglophones étiqueté Blogs / Data Lake / Data Warehouse / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
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. […] 3 octobre 2023 dans Sites anglophones étiqueté Auditing / BenJohnston_RLS / Blogs / RLS par simple-talk.com
Microsoft Fabric and the Delta Tables SecretsMicrosoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […] 27 septembre 2023 dans Sites anglophones étiqueté Blogs / Data Lake / Delta / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
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 […] 25 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / RLS / Side-channel attack par simple-talk.com
Microsoft Fabric: Checking and Fixing Tables V-Order OptimizationDownload the notebook used on this blog I explained in a previous article how the Tables in […] 20 septembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Delta / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
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. […] 17 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / Power BI / RLS / SSRS par simple-talk.com
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 […] 10 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / RLS / RLS Performance / RLS Troubleshooting par simple-talk.com
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 […] 3 septembre 2023 dans Sites anglophones étiqueté Access Predicate / BenJohnston_RLS / Blogs / RLS / Security Policy par simple-talk.com
Microsoft Fabric: Loading On-Premises and External DataLoading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. […] 28 août 2023 dans Sites anglophones étiqueté Blogs / Data Warehouse / dataflow / Gateway / lakehouse / Microsoft Fabric / pipeline par simple-talk.com
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 […] 25 août 2023 dans Sites anglophones étiqueté Blogs / T-SQL Programming par simple-talk.com
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. […] 21 août 2023 dans Sites anglophones étiqueté Blogs / lakehouse / Microsoft Fabric / Spark par simple-talk.com
Discover the Microsoft Fabric Data WranglerThe Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and […] 14 août 2023 dans Sites anglophones étiqueté Blogs / data engineering / Data Lake / Data Wrangler / lakehouse / Microsoft Fabric par simple-talk.com
Going to a conference where hardly anybody knows my nameOn Friday and Saturday August 11 and 12, I am going to do something I haven’t done […] 10 août 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
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 […] 8 août 2023 dans Sites anglophones étiqueté Blogs / Uncategorized par simple-talk.com
T-SQL Tuesday #165 – My Experience with Database Job TitlesThey mean very little. More on that after nothing that this is part of T-SQL Tuesday, and […] 8 août 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
Managing Query Store HintsI wrote about query store hints before when they were first released in Azure SQL databases. However, […] 2 août 2023 dans Sites anglophones étiqueté Blogs / query optimization / Query Store / SQL Server 2022 / Uncategorized par simple-talk.com
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 […] 30 juillet 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
A Beginners Guide to MySQL Replication Part 3: Multi-Source ReplicationWelcome back to the world of MySQL Replication! If you’ve been following this series, thank you for […] 18 juillet 2023 dans Sites anglophones étiqueté Blogs / MySQL / Uncategorized par simple-talk.com
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 […] 13 juillet 2023 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
What Counts for a DBA – DiscretionI was looking at the list of topics I have talked about in my “What Counts for […] 12 juillet 2023 dans Sites anglophones étiqueté Blogs / Editorials / What Counts For A DBA par simple-talk.com
Simple-Talk RSS FeedsRecently, we have made a few changes to the simple-talk.com website’s RSS feeds that I am pretty […] 7 juillet 2023 dans Sites anglophones étiqueté Blogs par simple-talk.com
On the Road Again, Next Up ColumbusJanuary 18, 2020, was the last time I stood in front of a live group of people […] 27 juin 2023 dans Sites anglophones étiqueté Blogs / Speaking par simple-talk.com