Confessions of a DBA - Part 1
Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with...
2011-04-08
1,517 reads
Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with...
2011-04-08
1,517 reads
This series of blog is to give a general idea what you could look at when setting up a new...
2011-04-07
1,505 reads
Part 1 of this blog talked about the bad experience we had with a badly configured SQL Server. The second...
2011-04-06
1,624 reads
There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....
2011-04-05
1,650 reads
April 1st is a fun day for almost everyone. Playing tricks or just enjoying the tricks played by others. For...
2011-04-04
1,267 reads
I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...
2011-02-03
1,760 reads
This article is a basic guide line to chapter leaders who are planning to have Net meetings as part of the User Group meetings.
2011-01-20
1,103 reads
There is one thing that have been bothering me for quite some time. I thought I would blog about it....
2010-12-27
1,300 reads
So far I have seen lots of blogs about SQLPASS regarding the Slate for this years BoD. I do not...
2010-08-25
724 reads
Today twitter is buzzing with news about MVPs being confirmed. Some new and some old getting renewed. I am sure...
2010-07-01
580 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