Managing Files and Folders with Python – Data Engineering with Fabric
In this article, learn how you can manage files and folders for both full and incremental loading situations.
2024-03-27
2,959 reads
Articles
What is Eventstream in Microsoft Fabric? - Part 1
Learn about Eventstream in Microsoft Fabric to ingest, transform, and route real-time data to certain destinations in a low-to-no-code SaaS fashion.
2024-03-27
Quick and Effective Migration Between CosmosDB Collections Using ADF
This document aims to explain the process of using ADF (Azure data Factory) to make a copy of a Cosmos DB (Instance A) collection into a new collection in another Cosmos DB Instance effectively and cost effectively. For example, here is our Instance A in the Data Explorer: Here is Instance B: We are looking […]
2024-03-25
571 reads
The Profiler Extension in Azure Data Studio (ADS)
This article covers the basics of the Profiler extension in Azure Data Studio, a handy way to trace your application calls.
2024-03-25 (first published: 2023-12-29)
2,378 reads
Tinkering with Fabric Data Factory Framework Functionality
I recently asked myself, “Self, is it possible to apply framework functionality to Fabric Data Factory?” I decided to investigate.
2024-03-25
How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer
Learn how to optimize the size of your Power BI semantic models with the free Vertipaq Analyzer tool. Extra tips & tricks included.
2024-03-22
2,627 reads
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code.
2024-03-22
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Learn how to get started with Microsoft Fabric along with the differences between managed and unmanaged tables.
2024-03-20
3,376 reads
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually on the box. Yes, we still exist, and we will for as long as we’re still using physical servers in data centers and even IaaS. Not everyone has transitioned to server core and full-on PowerShell remoting for everything
2024-03-20
Find Unused or Backup Tables
If you rename old or backup tables, learn how to find easily find and drop them.
2024-03-18
4,133 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
Check sequential order of status of items
There is a table tblItems with below structure ( i cannot change the below...
Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers