Google + Hangouts
I just finished hosting my third hangout on Google Plus. I’ve also attended one hosted by Andy Leonard (blog|twitter) and...
2011-08-11
1,388 reads
Blog Posts
Have the Time? Get in the Game.
This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...
2011-08-11
897 reads
Impact of manipulating SSRS parameter inside dataset
Recently I had to convert a report’s dataset, which was using Stored Procedure, into inline T-SQL commands. The dataset had 4...
2011-08-11
1,489 reads
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
Product Guide for SQL Server “Denali” released
Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...
2011-08-11
1,273 reads
Re-blog – August 5-August 11
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-08-11
475 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
Seeking Volunteers for the Nomination Committee
We have a few changes in the election process for PASS this year, one of them is that we have...
2011-08-11
655 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
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had...
2011-08-11
509 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