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
Josef Richberg
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
6 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)
499 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
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....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers
