Communication to Sql server
There are different ways you can communicate to sql server: 1. Shared memory: on the local server 2. Named Pipe:...
2010-10-21
557 reads
SQL Saturday Advice - Extra Food
No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday...
2010-10-21
687 reads
How Often Do You Run CHECKDB Against Your Databases?
I recently ran a poll, asking DBAs how often they ran DBCC CHECKDB against their databases. Compared to some of...
2010-10-21
3,090 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,445 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
755 reads
SQLRally Pre Con Update
The call for Pre Con speakers for the 2011 PASS SQLRally closed last Friday (Oct. 15) and I want to...
2010-10-20
394 reads
New Cumulative Updates for SQL Server 2005 and SQL Server 2008 R2
Late Monday night (October 18, 2010), Microsoft released the latest Cumulative Updates for SQL Server 2005 and for SQL Server...
2010-10-20
934 reads
Minutes of the September 2010 PASS Board Meeting Posted
Please take a few minutes to review the September 2010 minutes (login required). We just had our October meeting on...
2010-10-20
667 reads
SQLSaturday #49–The Poster!
Over the past few months I’ve been thinking that we don’t do enough to celebrate the people and the effort...
2010-10-20
601 reads
Boulder SQL Server User’s Group - Common SQL Server Mistakes
The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...
2010-10-20
990 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