Using Managed Identities to authenticate Function Apps
Updated
•1 min readI have a video detailing how to use Managed Identities to authenticate function apps in Azure.
Command Palette
Search for a command to run...
More from this blog
Analysis Services models in Azure Fabric -- METADATA$ROW_ID gotcha
For those of you entering the Microsoft Fabric foray, there is a big caveat you must be aware of. If you are using Fabric Mirroring or Delta Lake tables you will see an additional column in your data source: METADATA$ROW_ID. This column is added auto...
Sep 8, 20252 min read13
Permissions required for user defined table types in Microsoft SQL Server
This has bitten me so many times, I’m putting this here where I can find it in the future. You might want to bookmark this page :) I rely heavily on stored procedures for interaction both internally and externally. The improve performance and efficie...
Jun 25, 20251 min read113
Azure Data Factory utcNow() nuances
For those of you who work with Azure Data Factories I thought I’d help you out with, what I would consider a bug in how pipelines work. For the record, I work with pipelines on almost a daily basis, but I am generally pushing data into Microsoft SQL ...
Jun 3, 20252 min read75
Microsoft SQL Server permission chaining
Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta...
Jun 2, 20251 min read35
Using a stored procedure as a source for PowerBI Paginated reports
If the reports that you are building do not need to be interactive, you can use Microsoft Paginated Reports (or SSRS). One of the benefits of a paginated report is that it’s source(s) can be stored procedures. I really, really like that option.In Mic...
May 22, 20252 min read175
