Initial Thoughts on Dremio
I’ve been working on a project for the last few months with a client who has chosen to implement Dremio in Azure. Dremio is a data lake engine that...
2021-03-23 (first published: 2021-03-18)
127 reads
Summarizing a Script with SQL Prompt
I have never used this feature, but someone was asking for feedback on Prompt, and I noticed this in the menu: Summarize script. I had guessed that it might...
2021-03-22 (first published: 2021-03-17)
90 reads
Daily Coping 17 Mar 2021
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...
2021-03-17
35 reads
T-SQL Tuesday Retrospective #012: Why DBA skills are necessary
This is my ongoing series of answering T-SQL Tuesday posts far too late to be of any use. Click here if you want to read previous entries. Paul Randal...
2021-03-17
155 reads
Daily Coping 16 Mar 2021
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...
2021-03-16
37 reads
Lesser-known facts of Explicit Transactions
Transactions are of various kinds in SQL Server such as Autocommit, Implicit, Explicit and Batch-scoped. I personally found this article quite helpful if you wish to understand Implicit Transactions....
2021-03-22 (first published: 2021-03-16)
247 reads
?????????????????????????? ???????????????????? ?????????????????? ???? ?????????????????? ?????? – DP 300
?????????????????????? ???? ??????’?? ?????? ???? ?????????? ?????????????????? I have a very important announcement to make to all of you. Today on my birthday(16th March), I feel delighted and proud...
2021-03-16
27 reads
Rebuilding SQL Saturday–Picking a Board of Directors
With Redgate planning to donating the SQL Saturday brand, trademarks, and domain to a non-profit foundation, there is a need to build a group of individuals to voluntarily manage the...
2021-03-19 (first published: 2021-03-15)
288 reads
Daily Coping 15 Mar 2021
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...
2021-03-15
34 reads
My new Home Studio Setup
It’s now more than 1 year ago since I was sitting the last time in a real airplane. All my SQL Server related work happens these days entirely online:...
2021-03-15
28 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
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
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