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…
2025-09-08
6 reads
SQLRunner
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...
2025-06-25
5 reads
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...
2025-06-03
5 reads
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…
2025-06-02
9 reads
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…
2025-05-22
9 reads
How to Skip Rows in Azure Data Factory Pipeline's Excel Source
I was building a data factory source the other day and I needed to skip the first 5 rows. This is intuitive and easy within a text (csv) source...
2024-07-19
6 reads
Why Bit Masks?
Publishing is one of those industries where the possibilities are endless. This translates into 'endless combinations' as well. To sell a book you need 4…
2024-07-03
8 reads
Prevent SQL Injection Attacks Using SQL Server Stored Procedures
Learn how to prevent SQL injection attacks using SQL Server stored procedures for secure database interactions
2024-06-04
4 reads
Extracting Azure Analysis Services Metrics from your Log Analytics workspace into PowerBI
We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will...
2024-02-21 (first published: 2024-02-06)
273 reads
About those Read-Only Replicas
In a post, I wrote last month I showed how you can take advantage of your replicas in SQL Sever by adding a single attribute to your connection string...
2023-11-13 (first published: 2023-10-26)
498 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers