Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine...
2018-05-09 (first published: 2018-05-01)
3,043 reads
The Data Files
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
50 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
23 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
23 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
19 reads
SQLSaturday Madison – “Data Security for the Cloud” and “Three Steps to Lasting Encryption”
In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...
2018-03-23
237 reads
“Data Security for the Cloud”: A New Pre-Con at SQLSaturday Chicago
More and more companies are considering a move to the cloud, but one aspect of such a migration that may...
2018-02-07
342 reads
An open letter to the PASS community (2017)
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
363 reads
Replacing an expiring SQL Server encryption key
So you’re using encryption in SQL Server, but you’ve discovered that the expiration date of a certificate is expiring. What...
2017-05-17 (first published: 2017-05-05)
5,733 reads
24 Hours of PASS is coming up!
Another installment of 24 Hours of PASS is coming up next week on May 3-4! This semiannual event features 24...
2017-04-27
613 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