Doing Good Isn’t Easy Some Days
A few weeks back I was on a short trip with my family and as some trips go, it had...
2011-05-23
679 reads
SQL Azure Query Tuning
SQL Azure is still SQL Server at the end of the day. This means it is entirely possible to write...
2011-05-23
1,396 reads
Let’s Get Visual – The Art of Report Design
Paul Turley
Mentor, SolidQ
This article is based on my session at TechEd on May 18th, 2011
Report styles vary depending on the...
2011-05-23
3,621 reads
SQL Joins and Subqueries
A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...
2011-05-22
1,127 reads
Find your Enabled SQL Server Network Protocols Using PowerShell
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
2,167 reads
SQL Rally 2011 Recap
As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the...
2011-05-21
1,122 reads
Forum Fun: Running Calculation SQL
A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...
2011-05-21
682 reads
MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you get the gist. I announced that I would...
2011-05-20
20 reads
MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you...
2011-05-20
723 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,897 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