PASS Log Reader Awards
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
733 reads
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
733 reads
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
605 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-07
3,203 reads
Ohio?
I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again)....
2009-10-06
547 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,214 reads
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
732 reads
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,396 reads
There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...
2009-09-30
1,921 reads
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...
2009-09-29
1,582 reads
I presented last night at the Cape Cod .NET User’s Group. What a great bunch of people. About 20 people...
2009-09-24
730 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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