To DBA or Not to DBA (DBA Jumpstart)
This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart.“If you could give a DBA...
2013-12-10
831 reads
Jason Brimhall
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write...
2013-11-12
14 reads
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host...
2013-11-12
786 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2013-11-05
14 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2013-11-05
792 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for...
2013-10-31
15 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different...
2013-10-31
1,285 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to data. Sometimes it is in the capacity of a...
2013-10-31
14 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to...
2013-10-31
1,246 reads
Exporting Execution Plans - SQL Spackle
A short SQL Spackle article to fill in your knowledge of SQL Server. In this one, Jason Brimhall shows how to export execution plans when you ask for query tuning help.
2013-10-29
5,183 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