PASS Update #49–SQLRally
I get a lot of questions about how SQLRally is going, which tells me that there is a lot of...
2011-01-20
644 reads
SSMSDeploy 1.1 Now Available
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
735 reads
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca. ...
2011-01-20
21 reads
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,213 reads
31 Days of SSIS – DTSConfig Configuration (19/31)
31 Days of SSIS
The last two posts in the 31 Days of SSIS talked about the use of environmental variables...
2011-01-20
1,263 reads
New Book: Introduction to SQL Server
Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...
2011-01-19
610 reads
Who do you want to see at SQLRally and 24HOP?
I dig democracy: I like all this voting for SQL sessions at events.
Voting is open this week, Jan17 – 23, for...
2011-01-19
622 reads
How to find the SQL server port number
Advertisements
One day I got a call from my junior DBA. She asked me, how can I find out the port...
2011-01-19
587 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,092 reads
Time To Get Your #SQLRally Vote On!
It’s week two of voting for the upcoming SQLRally. This week, we are voting for the Database & Application Development sessions...
2011-01-19
457 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