Dynamic Data Masking
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2015-03-11 (first published: 2015-02-26)
8,920 reads
Blog Posts
Using Solutions in SSMS
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...
2015-03-11
1,241 reads
Why I don’t (yet) recommend In-Memory OLTP to my customers
Ok, some of you will hate me after this blog posting, but it has to be said. Over the last...
2015-03-11
807 reads
Azure Data Factory
What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing. It allows...
2015-03-10
1,407 reads
Exam Prep 70-463: Variables and Parameters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-10 (first published: 2015-02-23)
8,079 reads
Monitor Query Statistics
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....
2015-03-10 (first published: 2015-02-26)
8,473 reads
SQL Nexus Might Just Save Your Bacon
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it...
2015-03-10
1,709 reads
SQLRally Nordic 2015
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
633 reads
A Comprehensive Manual to Manage SQL Server Database
SQL Server is a uniquely designed Relational Database Management System developed by Microsoft. Its basic functionalities include storing, manipulating and...
2015-03-09
743 reads
Solving a slow running query issue with UNION
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...
2015-03-09 (first published: 2015-02-25)
8,832 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