Technical Presentations - What happen's behind the scene
A while ago I wrote a piece on public speaking assignements over here and promised to write what it takes to...
2016-10-27
400 reads
SQL and SQL Only
Query Store – Part 2 - Configuration Settings
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
Query Store is configured at the...
2016-10-24
990 reads
Query Plan's Compile Time Parameter Values
Most of you would know how to get the query plan from the cache via "sys.dm_exec_cached_plans" or "sys.dm_exec_query_stats" DMV or...
2016-10-17
973 reads
Check Database Server Workload - Batches/ Sec
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
3,157 reads
SQL Server 2016 Query Store - Gentle Introduction - 1
Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give...
2016-10-09
557 reads
Sp_recompile doesn't recompile!!!!
Many of us use the stored procedure "sp_recompile" to mark the stored procedure for recompilation, so that next time it...
2016-10-06
1,132 reads
Current Running Queries
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,100 reads
Speaking at SQL Server Geeks Annual Summit 2016
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual...
2016-07-25
424 reads
SQL Community n Speaking Assignments
Dear All,
It has been a while since I became less active on this blog. Reason for the same being that,...
2016-06-12
406 reads
Cardinality Estimator - Part 2- Out of Date Statistics
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,020 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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