On Transactions, errors and rollbacks
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...
2011-05-17
13,303 reads
Blog Posts
PASS SQLRally Orlando–We took the Checkered Flag
We did it! SQLRally happened and, from everything I heard, it was a success! That’s not to say that there weren’t some glitches and lessons learned, but we accomplished...
2011-05-17
13 reads
PASS SQLRally Orlando–We took the Checkered Flag
We did it! SQLRally happened and, from everything I heard, it was a success! That’s not to say that there...
2011-05-17
848 reads
Presenting at Denver SQL Server User’s Group on May 19
I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May...
2011-05-17
604 reads
SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one...
2011-05-17
1,537 reads
SQL Server News, Upcoming Local Events & Webinars.........
Wow! It's only Tuesday, and there's so much going on in the SQL Server World! I wanted to share some...
2011-05-17
671 reads
SQLbits recap
It’s already a long time ago, since I spoke at SQLbits (first week of April), but
yesterday the speakers got their...
2011-05-17
737 reads
SQLRally Nordic
With all the talk about SQLRally Orlando you may have missed that we’ve got another SQLRally event in the pipeline...
2011-05-17
690 reads
Updated SQLSaturday Advisory Council
About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...
2011-05-17
703 reads
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,146 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