Capturing Queries Can Be a Pain
The moment you decide you want to monitor your SQL Server instance for query behavior, you’re going to be forced to make a bunch of choices. Further, all these...
2020-08-11 (first published: 2020-08-03)
452 reads
Blog Posts
Daily Coping 11 Aug 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-08-11
20 reads
My T-SQL Tuesday #129 Time Capsule
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last fall, along with her husband, into hosting this year. She came through, with a great...
2020-08-11
25 reads
Things That Shouldn’t Be Normal in Database Development (28 minute video/podcast episode)
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I...
2020-08-11 (first published: 2020-07-30)
756 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
8 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
21 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
15 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
18 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
15 reads
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month. This month we are building a Time Capsule. I decided to make mine...
2020-08-11
14 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