Cleaning Your #PowerBI Power Query Code
Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve...
2015-08-10
621 reads
SQL with Dustin Ryan
Twitter Analysis with #PowerBI & Plus One
Earlier this week Christopher Finlan put together this awesome Datazen dashboard using Plus One. Christopher has been doing a lot...
2015-08-07
725 reads
#PowerBI and #SSAS Tabular: A Natural Fit with the Power BI SSAS Connector
In late June last month, the Microsoft Power BI team released the Microsoft Power BI Analysis Services Connector. The Power...
2015-08-07
1,143 reads
Importing Excel Power View Dashboards into Power BI
If your organization is now a Power BI customer, congratulations. You’re now ready to create some very cool dashboards, integrate...
2015-08-04
1,118 reads
#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer
Power BI Desktop has been out for GA for over a week now and some of the pro’s out there...
2015-08-03
1,631 reads
#PowerBI Fantasy Football Player Stats Dashboards for Download
Every year at Pragmatic Works some coworkers, including consultants, marketing staff, support team members, software development staff and project management,...
2015-08-01
1,629 reads
Three Best Practices for #PowerBI
Since the release of Power BI Desktop this past week, I’ve been really spending my extra time digging into the...
2015-07-31
1,253 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