Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
12 reads
Blog Posts
Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
14 reads
Sharding Mongodb
Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput operations.(more...)
2020-11-20
30 reads
The Silliness of a Group
Recently we had a quick online tutorial for Mural, a way of collaborating online with a group. It’s often used for design, but it can be used for brainstorming...
2020-11-20
31 reads
Adding a user to an Azure SQL DB
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t ... Continue reading
2020-11-19 (first published: 2020-11-05)
372 reads
Announcing EightKB 2021
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees! We were honestly blown away by how successful the...
2020-11-19
70 reads
Announcing EightKB 2021
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees!
We were honestly blown away by how successful the first...
2020-11-19
22 reads
Daily Coping 19 Nov 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-11-19
29 reads
Microsoft Power BI Quick Start Guide – Second Edition
Earlier this week I announced the release of a new Power Platform book. While I’m super excited about that book I’m also excited to announce
2020-11-19 (first published: 2020-11-06)
710 reads
[Video] Azure SQL Database – Failing Over (Failover Groups)
Quick video showing you how to failover your Azure SQL Database between your primary and secondary location.
2020-11-18
98 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