The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,235 reads
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,235 reads
There are two really great features just added to Power BI that I wanted to blog about: Composite models and...
2018-07-27
812 reads
There are a number of options to monitor Azure SQL Database. In this post I will briefly cover the built-in...
2018-07-23 (first published: 2018-07-06)
2,458 reads
I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...
2018-07-20
22 reads
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement.
In short, ADLS Gen2 is...
2018-07-10 (first published: 2018-06-28)
2,587 reads
Big news! The next generation of Azure Data Lake Store (ADLS) has arrived. See the official announcement. In short, ADLS Gen2 is the combination of the current ADLS (now called...
2018-06-28
22 reads
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that...
2018-06-20 (first published: 2018-06-11)
3,585 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is...
2018-06-18
650 reads
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU7), which is...
2018-06-18
614 reads
Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that...
2018-06-11
440 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