Be Cautious Offering Guidance
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,346 reads
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,346 reads
I’m trying out a new blog post series, mostly for myself as an exercise. I’m going to pick one speaker...
2013-08-02
637 reads
Psssttt!
Developers. Man, have I got something good for you.
Are your DBAs slowing down your development processes? Are they keeping you...
2013-07-29
1,753 reads
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more...
2013-07-24
575 reads
This is a long and convoluted post about my experiences at two hotels, but it has a point for DBAs...
2013-07-15
841 reads
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
732 reads
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,169 reads
It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...
2013-06-24
743 reads
Microsoft has been pretty clear about their commitment to the entire Azure infrastructure. The updates to Azure come out on...
2013-06-20 (first published: 2013-06-17)
2,265 reads
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are...
2013-06-10
825 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