Power BI Made Simple
In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...
2015-02-18
1,116 reads
In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...
2015-02-18
1,116 reads
Ever wonder about Microsoft’s product roadmap? With Microsoft rapidly releases products and services, they realized the need to provide better...
2015-02-12 (first published: 2015-02-04)
8,359 reads
Advanced Analytics, or Business Analytics, refers to future-oriented analysis that can be used to help drive changes and improvements in...
2015-02-11
1,589 reads
Long has the question been asked “Which Microsoft tool do I use for dashboards?”. SSRS, Excel, PowerView, Report Builder and PerformancePoint...
2015-01-14
2,288 reads
The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on...
2015-01-07
2,265 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU3),...
2014-12-17
1,327 reads
The traditional data warehouse has served us well for many years, but new trends are causing it to break in...
2014-12-10 (first published: 2014-12-03)
11,575 reads
The Azure Data Factory is a service designed to allow developers to integrate disparate data sources. It is a platform...
2014-11-26
2,089 reads
I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server...
2014-11-19
1,632 reads
Should you move your data to the cloud? That is the question. The answer is not simple. While moving data...
2014-11-12
760 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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