Encryption in Colorado Springs – Encrypting in the Application?
Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I...
2014-11-20
932 reads
Blog Posts
FUD Makes Security Harder
The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported...
2014-11-20
693 reads
How to disable constraints of a table ? TIP #74
You are reading this post just because of two reason
1) You are curious whether it is possible or not...
2014-11-20
301 reads
In-Memory Virtual Chapter Co-Lead
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters...
2014-11-20
289 reads
Nominated for Author of the Year
I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at...
2014-11-20
539 reads
Practical Problems with CI
I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more...
2014-11-20
815 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
28 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place and you want to add Sql Server tests it...
2014-11-20
21 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
72 reads
Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
58 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
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