TSQL Tuesday #84: Zip to Speaker
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...
2016-11-08
469 reads
SQLStudies
New indexes, hypothetically
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...
2016-11-02
880 reads
The Halloween Problem
DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really...
2016-11-07 (first published: 2016-10-31)
2,740 reads
It’s a small world
As I write this we are packing to leave for Disney World, where my family and I will spend close...
2016-10-26
378 reads
Synchronous vs Asynchronous
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...
2016-10-24
795 reads
Installing SQLCMD
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...
2016-10-19
1,369 reads
Using Snippets
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece...
2016-10-17
480 reads
Too many indexes!
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
621 reads
If backups are taken in silence can a recovery still take place?
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a...
2016-10-11
434 reads
Floor, Round, and Ceiling
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...
2016-10-05
661 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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