For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
68 reads
Thoughts On A State of the Chapter Statement (and Doing More)
This is a follow up to a thought I voiced on Twitter last week – the value of a once a...
2014-11-18
583 reads
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...
2014-11-28 (first published: 2014-11-18)
7,164 reads
More on that Cyberwar
As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...
2014-11-18
589 reads
What Are You Thankful For
Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful...
2014-11-18
529 reads
Community is Everything
I don’t care what technology or technologies you enjoy using in your daily job. If there’s an enthusiastic community behind...
2014-11-18
713 reads
Essentialism: The Disciplined Pursuit of Less by Greg McKeown
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
468 reads
2014 PASS Summit 2014 Board Q&A Notes
As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session...
2014-11-17
721 reads
Vital Statistics and Health Checks
This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a...
2014-11-26 (first published: 2014-11-17)
6,244 reads
Thoughts on Speakers and Topics for PASS Chapters
After wrapping up my part of SQLSaturday Orlando this year I’ve been thinking on what if anything we might do...
2014-11-17
763 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