AD Authentication and Azure SQL Database
Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...
2017-05-22
424 reads
Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...
2017-05-22
424 reads
Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By...
2017-05-18
435 reads
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
400 reads
Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...
2017-05-11
371 reads
I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was...
2017-05-09
355 reads
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...
2017-05-08
419 reads
A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...
2017-05-04
325 reads
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...
2017-05-02
487 reads
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
504 reads
I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...
2017-04-25
464 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
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