SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression
Comprehensive Database Performance Health Check Cl...
2019-05-22
Administration
2019-05-22
SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)
I recently had a very simple and interesting error received while I was working with Docker and Persistence Storage for my upcoming SQL Server Performance Tuning Practical Workshop. The...
2019-05-20
DIY Open Source NAS: How to Install FreeNAS
Open source NAS isn’t appropriate for every use case, but it can be ideal for lab deployments, smaller workgroups or active archive data.
2019-05-20
When Was SQL Server Last Restarted? – Interview Question of the Week #225
Question: When Was SQL Server Last Restarted?
First appeared on When Was SQL Server Last Restarted? – Interview Question of the Week #225
2019-05-20
A Self-Serve System to Refresh Databases (Part 3)
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
2019-05-16
3,039 reads
Underused sp_WhoIsActive capabilities: @delta_interval
Great Ghost In the last post, we looked at how to see if your query is misbehaving, or if things…
2019-05-10
Log File Expansion Automation
SQL Server Database Log file expansion can be fairly tedious if you need to make the log bigger in many reasonably-sized growth increments. It can be tedious because you...
2019-05-10
Access is denied – Using DTCPing utility between two Windows Server 2016
Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from...
The...
2019-05-10
Life behind a proxy server: downloading content for SSMS Help Viewer
Life behind a proxy server can be problematic. Not every software out there is tested correctly for proxy interaction and oftentimes the experience for the corporate user is a...
The...
2019-05-09
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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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