Reading Your Execution Plans
I’m putting the finishing touches on the all day seminar on execution plans that I’ll be putting on at DevConnections this...
2015-08-06
936 reads
The Scary DBA
PASS Needs You!
It’s time.
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for...
2015-08-05
584 reads
Differences Between Actual & Estimated Plans
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The...
2015-08-03
894 reads
Hey Kids! Let’s Put on a Show at the Old Barn
Alternate Title: I’m traveling a bunch. Let’s get together and talk.
A bunch of trips and presentations coming up, so I...
2015-07-29
984 reads
Grant’s Fly-by-night Leadership Course – The Plan
Get a better nameDefine my personal goals for the courseI won’t be sharing these with you. I may share them...
2015-08-07 (first published: 2015-07-28)
1,900 reads
SQL Server Management Studio – Footloose and Fancy Free
That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact,...
2015-07-20
736 reads
How Do You Know You’re Good At Your Job?
You’ve been working as a DBA for X number of years. How do you know you’re good at it? Heck,...
2015-07-13
615 reads
But I Don’t Have a Test Server…
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to...
2015-07-10 (first published: 2015-07-06)
3,152 reads
Speaker of the Month: June 2015
With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I...
2015-07-03
581 reads
Leadership Training Possibility
I know a few people in the SQL Server community who have been involved in Scouting. A couple of them...
2015-06-30
1,001 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