T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,799 reads
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,799 reads
How Do I Spell #SQLFamily? #SQLNomz Of Course
Nomz (Doma Kun)
It’s time for Meme Monday again, and this month’s theme is...
2011-11-07
1,189 reads
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,433 reads
Presentation Files: 10 Things All BI Administrators Should Know
I sooooo remember this sign!
I was very excited to get to present...
2011-09-30
2,012 reads
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,110 reads
Auditing Users in a Failover Partner Database
SQL Audit is Watching
I read a question on a discussion list today asking if...
2011-09-20
1,648 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
914 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
830 reads
Session Files for Replication Magic Presentation to WSSUG
Replication Magic
I presented my session on Replication Magic: Initializing from Backup to the...
2011-08-26
1,386 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,404 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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