How to get Power BI RLS to work with external users
Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this...
2016-10-06
3,428 reads
SQLDownSouth
Happy Birthday Power BI
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product...
2016-07-24
831 reads
Join me at SQL Saturday 531, Louisville, KY
So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday...
2016-07-21
648 reads
Using Power BI to list Enterprise Only SQL Features
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
670 reads
What’s wrong with the Power BI KPI Visual?
Over the past couple of weeks I have been asked several times about the KPI Visual that is native to...
2016-07-06
2,004 reads
Higher Education Retention Analytics using Power BI
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This...
2016-06-06 (first published: 2016-06-01)
2,391 reads
SQL Saturday 486: Richmond, VA Precon
Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend...
2016-03-14
1,091 reads
Refreshing KPI Data in SSRS 2016
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,164 reads
More SQL Saturday Precon News(Real-time Dashboards)!!!!
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...
2016-02-19
1,260 reads
Creating KPIs in SQL Reporting Services
In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016. Let’s...
2016-02-22 (first published: 2016-02-17)
6,872 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
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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