Back to Basics: Why not parameterize?
I think sometimes those of us that have been doing database administration/development for a while take it for granted that...
2015-12-23
275 reads
CISL Roadmap
The year 2015 is coming to an end and I wanted to publish my currently planned roadmap for the CISL...
2015-12-23
448 reads
Advent of Code
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice, you call it a “challenge”. This is what the...
2015-12-23
45 reads
Advent of Code
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice,...
2016-01-04 (first published: 2015-12-23)
1,558 reads
‘Twas 4:45 Friday
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents...
2015-12-23
510 reads
How to use CISL – the Columnstore Indexes Scripts Library
Around 3.5 Months ago in September of 2015, I have announced the first public release of the CISL – Columnstore Indexes...
2015-12-22
887 reads
CISL 1.0.4 is released
I am glad to share that the latest version of CISL – Columnstore Indexes Scripts Library 1.0.4 is finally released.
By all...
2015-12-22
481 reads
Reflections and Looking Forward
Time is slowly ticking toward 0:00 on the clock. As I look around I couldn’t help but reflect back on...
2015-12-22
507 reads
$10 to Support Wikipedia Too
I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that...
2015-12-22
575 reads
The transaction log for database 'ABC' is full due to 'ACTIVE_BACKUP_OR_RESTORE'
I have recently had a client with a problem each morning where they were having processes fail with this message...
2015-12-22
20,081 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