Administrative Logins and Users
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give...
2015-11-02
530 reads
Looking at SSDT upgrade scripts
I have been using SSDT seriously for a couple of years now and have really been impressed with the code...
2015-11-01
541 reads
Looking at SSDT upgrade scripts
I have been using SSDT seriously for a couple of years now and have really been impressed with the code that is generated to upgrade schemas and over that...
2015-11-01
9 reads
Looking at SSDT upgrade scripts
I have been using SSDT seriously for a couple of years now and have really been impressed with the code...
2015-11-01
28 reads
Looking at SSDT upgrade scripts
I have been using SSDT seriously for a couple of years now and have really been impressed with the code...
2015-11-01
35 reads
Pass 2015 – Overall Thoughts
I know I only posted one other blog about Pass but I’ve been way too busy over the last couple...
2015-11-01
336 reads
PASS 2015 Session Report – Azure SQL DW Integration with the Azure Ecosystem & End of PASS 2015
PASS 2015 continues (and finishes up today!) in Seattle. Its been an amazing conference this year with a few things really hitting home; Amazing technology announcements around SQL 2016 CTP3...
2015-10-31
15 reads
PASS 2015 Session Report – Azure SQL DW Integration with the Azure Ecosystem & End of PASS 2015
PASS 2015 continues (and finishes up today!) in Seattle.
Its been an amazing conference this year with a few things really...
2015-10-31
1,035 reads
Scripts and Slide Deck: The Data Loading Performance Presentation at PASS Summit
I have just finished delivering my session, The Data Loading Performance Presentation at PASS Summit 2015. It went very well,...
2015-10-30
1,070 reads
Freaky statistics feature
SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a...
2015-10-30
1,583 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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