SQLRelay UK
With the Olympics coming to the UK next year what better way to get into the spirit of things than...
2011-08-23
606 reads
Blog Posts
TSQL Sudoku II
Learn how to solve Sudoku puzzles quickly with a TSQL Script.
Related Posts:
Puzzles and Daily Trivia May 14, 2019
Summiting that Technical Challenge Part II July 6, 2018
Passion, Challenges,...
2011-08-23
24 reads
TSQL Sudoku II
As luck would have it, today I came across this TSQL Challenge. It just so happens that I had already...
2011-08-23
1,112 reads
[Speaking] Lots of Speaking Engagements in September and October
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
799 reads
Define IOPs for all database servers
Purpose
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me...
2011-08-22
2,124 reads
Expert? Ha!
How do you define an expert? My personal definition: An expert is the person that is a chapter ahead of...
2011-08-22
1,254 reads
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...
2011-08-22
959 reads
Networking Dinner at the PASS Summit 2011
We’re repeating our event this year, a low key no sponsor dinner for those that arrive early and want to...
2011-08-22
683 reads
Outstanding DBAs Make Relationships a Priority
In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...
2011-08-22
1,045 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
13 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