Speaker of the Month: May 2015
When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I...
2015-06-09
531 reads
The Scary DBA
Parallelism and Columnstore Indexes
Columnstore indexes are fascinating and really cool. Unfortunately, they’re adding an interesting new wrinkle to an old problem.
What’s the Cost...
2015-06-01
828 reads
PASS Board Update: May 2015
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...
2015-05-27
551 reads
Database Engine Tuning Advisor
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...
2015-05-26
833 reads
Book Review: Connected
I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?)....
2015-05-29 (first published: 2015-05-19)
5,097 reads
Come to Us or We’ll Come to You
No, that’s not a threat. It’s an offer to help out.
Redgate Software is very serious about the efforts we’re putting...
2015-06-01 (first published: 2015-05-18)
1,427 reads
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
510 reads
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,106 reads
Effects of Persisted Columns on Performance
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,939 reads
Speaker of the Month: May 2015
I finally got out to some community events last month and got to see a bunch of great speakers. Not...
2015-05-01
514 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