Wild West Day
One of the things I’m missing today is Wild West Day at Red Gate. It’s not just because I don’t...
2011-07-04
1,602 reads
Blog Posts
Creating Icons Files
While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so...
2011-07-03
690 reads
Non-Convergence of Replicated Data
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
876 reads
Bloopers
An early peak at the bloopers going out on Monday. Feel free to enjoy today. I’ve included the editorial and...
2011-07-01
1,372 reads
Book Review: Hour of the Horde
Hour of the Horde by Gordon R. Dickson ($1-5 @ Amazon) is an interesting story. The basic plot is that one...
2011-07-01
436 reads
FileLinking Using SSIS
A user recently asked how to generate a file link using SSIS so that it could be inserted into the...
2011-07-01
1,032 reads
July Question: What Do You Think are the Most Common DBA Pain Points?
While being a DBA is challenging and often rewarding, we often experience a lot of pain points that we wish...
2011-07-01
696 reads
MVP Award
Today on July 1st 2011, I was pleasantly surprised to be recoginzed as a Microsoft Most Valuable Professional for contributions to the PowerShell technical...
2011-07-01
595 reads
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
433 reads
Re-blog – June 24-June 30
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-01
531 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