If you followed the last video, I showed you how to set up windows perfmon for ongoing performance metric collection on all of your critical SQL Server machines. However,...
2020-10-21
129 reads
I’ve been meaning to write something this post for a while but the stars have aligned this week. Garry Bargsley (blog | twitter) published a post about making a...
2020-10-21
21 reads
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics over the past 11 years, inviting bloggers to share their thoughts on a particular theme...
2020-10-21
35 reads
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2020-10-21 (first published: 2020-10-13)
275 reads
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like ... Continue reading
2020-10-20 (first published: 2020-10-13)
481 reads
A very common approach is to query data straight from Databricks via Power BI. For this you need Databricks token and the JDBC address URL. This is found within...
2020-10-20
51 reads
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-10-20
31 reads
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading
2020-10-20
22 reads
Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...
2020-10-20 (first published: 2020-10-13)
684 reads
Based on Microsoft Documentation <The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as...
2020-10-20
55 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
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
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