Happy New Year!
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
18 reads
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
18 reads
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays...
2019-12-27
79 reads
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-27 (first published: 2019-12-13)
320 reads
Some of the most eagerly anticipated features now available in SQL Server 2019 relate to expanded data virtualization capabilities. Data virtualization enables you to bring all your data together...
2019-12-20
78 reads
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-13
37 reads
A few weeks ago I attended the annual PASS Summit conference in beautiful Seattle, Washington. This is an event that I look forward to every year. Being able to...
2019-12-06
14 reads
Yesterday was Thanksgiving for those of us living in the United States. If you celebrate this particular holiday, I hope that it was a day full of love and...
2019-11-29
16 reads
Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019,...
2019-11-22
43 reads
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
480 reads
Hiring consultants is like buying a new washing machine. In other words, you get what you pay for some times. A couple of months ago, my washer and dryer...
2019-11-15
13 reads
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
By James Serra
(This is the second post in a three-part series on how AI is changing...
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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