31 Days of SSIS – Pivot Transformation (10/31)
A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation. ...
2011-01-10
1,198 reads
Top 10 SQL #Awesomesauce for 2010
Here at MidnightDBA.com, we’re all about you! And us! It’s just us, and you. Which is why I’ve put together...
2011-01-10
813 reads
Speaking at SQLSaturday #62–Tampa
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting:
Why I Use Stored Procedures
With the proliferation...
2011-01-10
775 reads
SSC Editorial: Clouds in our Future
I wrote Clouds in our Future to see if I could spark a good conversation about the mental shift required...
2011-01-10
613 reads
How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,390 reads
Updated SSMSDeploy Demo Video
This is just a quick note before I head off for work that I have made a new demo video...
2011-01-10
650 reads
SSAS – Hiding Unknown Member
You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that...
2011-01-10
14,913 reads
PASSMN Call for Presenters and Sponsors
Before the year gets going too far and things are too planned out, I thought I would see if there...
2011-01-10
425 reads
My First Sandy Bridge Desktop System
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,422 reads
Thinking about goals for 2011
The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With...
2011-01-10
1,035 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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