PowerPivot – Commonly Used DAX Expressions
Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used...
2011-08-11
1,684 reads
Reset Identity Column in SQL
I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a...
2011-08-11
1,337 reads
SQL MCM Training – Day 3
Nothing to say about today, Jonathan did really a great job describing Extended Events
and Baselining/Benchmarking to us, and his boss...
2011-08-11
1,069 reads
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 - I'm Bringing Ugly Back
This blog entry is participating in T-SQL Tuesday #21,...
2011-08-10
1,101 reads
SQL Server “Denali”: Distributed Replay
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,606 reads
What It Means To Me To Be A Volunteer
Hi my name is Wes, and I am a volunteer
I am not unique. There are others like me, who give...
2011-08-10
1,343 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and bringing us oodles of failure. Adam Machanic is hosting...
2011-08-10
9 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and...
2011-08-10
737 reads
T-SQL Tuesday/Wednesday #21: A Crappy Workaround
A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...
2011-08-10
2,070 reads
Call for Speakers for the SQL Track at the Tallahassee Code Camp
The annual Code Camp is coming up on October 1st in Tallahassee and our local SQL group is trying to...
2011-08-10
801 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