Use of RPC in Cluster
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is...
2014-12-22
1,514 reads
Blog Posts
[OT] Blog is in maintenance mode
I’m spending part of this holiday break repaying some technical debt on my website. Among other things, I am importing...
2014-12-21
653 reads
Change Tracking–an easy way to track your changes TIP#78
I am pretty much sure by the title of this post you had idea of the post content. Although I...
2014-12-21
719 reads
Easy way to reseed identity column ? TIP #77
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...
2014-12-20
539 reads
New Power BI stand-alone Designer, Dashboards, APIs & iOS App
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why...
2014-12-20
697 reads
Friday Followup For December 19, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-12-19
443 reads
Getting Started with the Power BI Dashboards Public Preview
If you’re currently an Office 365 customer that is using Power BI sites then you probably found an early Christmas...
2014-12-19
1,257 reads
Getting Your Worth the Struggles with Moving Ahead
I often get asked for advice on how to get started in a career as a DBA or in IT...
2014-12-19 (first published: 2014-12-10)
7,005 reads
I am joining SQLskills
I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to...
2014-12-19
1,316 reads
Offer – Any e-book for $5
Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5...
2014-12-19
491 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