Return Indexes for a Particular Table using TSQL
I posted a blog recently about returning a listing of all indexes for database, which is good if you want...
2010-10-16
1,168 reads
Scary DBA Takes Over the World
Or, at least gets translated into Russian.
I realize I’m effectively a 10 year old, but, come on, HOW COOL IS...
2010-10-15
611 reads
Inappropriate PASS Sessions – SOLD OUT!
I’m sorry, but the Inappropriate PASS Sessions event (an after-hours event during the PASS Summit in Seattle) is SOLD OUT.
This all...
2010-10-15
759 reads
Inappropriate PASS Sessions – nearly SOLD OUT!
If you want to get into the Inappropriate PASS Sessions event during the PASS Summit in Seattle this year, you’d better...
2010-10-15
624 reads
S-3-X Talk Week: Wrapup
Image is conjecture; accuracy of percentages not guaranteed (but likely)
We’ve discussed thinking about 53x (Women: whenever it comes up; Men:...
2010-10-15
600 reads
SQLSaturday #49 tomorrow!
This is just a quick note to let you know SQLSaturday #49 in Orlando is tomorrow! If you’re in the...
2010-10-15
404 reads
SQLSaturday#59 Speaker Interview Series #4 – with Janakiraman Sattainathan
SQLSaturday #59 Speaker Interview Series #4 – with Janakiraman Sattainathan
So far, we went Way out West, NYC local, we were waiting...
2010-10-15
814 reads
Free SQL Server Training for the Week of October 18, 2010
Tuesday
PASS - 24 Hours of PASS - LATAM: All Sessions in Spanish or Portuguese
Pragmatic Works - SQL Statement Tuning with Indexing Strategies - Kevin...
2010-10-15
794 reads
Kindle v iPad
I don’t have either, but I ran across this comparison on the devices. It says get both, if you’re a...
2010-10-15
903 reads
Using Symlinks in PowerShell Scripts
Symlinks are heavily used in Linux/Unix environments to provide an abstraction for file and directory locations and with the introduction...
2010-10-15
1,558 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
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