2005-12-21
1,845 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Salary Survey
SQL Server Magazine has just published its annual salary survey. I don’t really recall how they did it in past...
2005-12-17
1,572 reads
2005-12-13
2,204 reads
2005-11-30
2,303 reads
Get MAXimum functionality
SQL 2005 provides a the new max specifier to be used with varbinary, varchar and nvarchar data types. You can...
2005-11-12
1,305 reads
SQL Diagnostic Manager Review
SQL Diagnostic Manager from Idera is a great tool for troubleshooting issues with your SQL Server databases. Kathi Kellenberher puts this tool through it's paces and gives you some insight into how it fits in a busy SQL Server environment.
2005-11-08
16,170 reads
On vacation!
It was busy at work after returning from PASS which means my work day continued for 2 or 3 hours after I got...
2005-10-16
1,300 reads
Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,406 reads
Using the sa account -- Just say "NO!"
Aunt Kathi knows many of you do things you know are wrong, like rolling through stop signs, littering, and using the sa...
2005-10-04
1,319 reads
Thoughts about the future
So far my posts have been non-technical musings about my life outside of work. I guess it is time to...
2005-10-03
1,259 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