October speaking schedule: Two Saturdays and a Summit
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
380 reads
The Data Files
Speaking at SQLSaturday Omaha
In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there. It’s been a while since...
2015-08-07
410 reads
Speaking at 24 Hours of PASS
I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The...
2015-05-14
477 reads
Monitoring Your Backups [T-SQL Tuesday #66]
Cathrine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday, and the topic she chose is monitoring. All of us, whether...
2015-05-12
1,128 reads
SQL Server 2016 announced… and it’s gonna rock
In what spare time I’ve had this week, I’ve been watching the news coming out of Microsoft Ignite (formerly Tech...
2015-05-06
4,747 reads
Speaking at Iowa Code Camp on May 9
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
421 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
Part...
2015-04-29
2,142 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking
For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...
2015-04-21
745 reads
Teach Something New: PowerShell Providers [T-SQL Tuesday #065]
Mike Donnelly (b|t) invited the SQL New Blogger Challenge participants to join in this month’s T-SQL Tuesday, and I’m happy...
2015-04-14
557 reads
Documentation: Are You Ready?
Would your coworkers know how to handle your job if you weren’t there?
This question was top-of-mind for me last week...
2015-04-07
1,109 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