Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
11 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
15 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
13 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
15 reads
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the...
2020-12-25
32 reads
Daily Coping 25 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-25
32 reads
Retrieving Log Analytics Data with Data Factory
I’ve been working on a project where I use Azure Data Factory to retrieve data from the Azure Log Analytics API. The query language used by Log Analytics is...
2021-01-05 (first published: 2020-12-24)
414 reads
Daily Coping 24 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-24
46 reads
DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2020-12-23
16 reads
DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it...
2021-01-01 (first published: 2020-12-23)
807 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
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