Saving and restoring session options settings
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations....
2017-09-25
502 reads
SQLStudies
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...
2017-09-20
444 reads
Uniquifier is a rather unique word isn’t it?
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Uniquifier is a rather funny name,...
2017-09-22 (first published: 2017-09-18)
1,663 reads
Help! My query is too fast!
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...
2017-09-20 (first published: 2017-09-14)
3,258 reads
Turn on/off Azure VMs with Powershell
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked...
2017-09-12
455 reads
There EXISTS a place where SELECT 1/0 doesn’t return an error.
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical...
2017-09-07
669 reads
SQL Homework – September 2017 – Create a home lab
As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something...
2017-09-05
401 reads
You might be a DBA if
I’d been trying to think of a fun post to write and an homage to Jeff Foxworth’s You might be...
2017-08-30
1,894 reads
Create an empty table from a SELECT statement but without the IDENTITY.
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like...
2017-09-11 (first published: 2017-08-28)
3,106 reads
Changing the version of an SSIS package.
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...
2017-09-06 (first published: 2017-08-23)
3,553 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