PASS Summit Schedule
Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit. You...
2010-09-30
1,568 reads
No Guarantees
The keynote for SQL Saturday #52 in Denver, that didn’t go as smoothly as I’d like due to technical difficulties,...
2010-09-30
1,530 reads
Upcoming Florida Events
Lots of events in Florida, easy to lose track! The Tallahassee Code Camp is October 23, 2010, details at http://www.tallycodecamp.org/...
2010-09-29
1,688 reads
How to Prove a Fact (Again)
Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about...
2010-09-29
1,485 reads
Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild
Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...
2010-09-29
5,133 reads
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
2010-09-29
2,225 reads
A Small Selection of SQL Azure System Queries
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...
2010-09-29
1,614 reads
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,825 reads
Don’t Take me (too) Literally
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,541 reads
Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,795 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