Installing SQL Server 2014 CTP1 – Step by Step
Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your...
2013-06-25
2,978 reads
Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your...
2013-06-25
2,978 reads
Cloud is the future and moving there is now as easy as few mouse clicks.
Today we will see how an...
2013-06-21
1,456 reads
One of the most exciting news which got announced yesterday was related to Windows Azure. When Scott Guthrie mentioned that billing...
2013-06-04
701 reads
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the...
2013-06-03 (first published: 2013-05-24)
2,309 reads
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...
2013-06-03
1,383 reads
Today I will talk about a book titled ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.
When I...
2013-05-23
945 reads
That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds...
2013-05-20
712 reads
This is my first SQLSaturday and I’m super excited to attend this event.
SQLSaturday’s are always a great opportunity to learn something exciting,...
2013-05-16
639 reads
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,449 reads
Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...
2013-04-19
1,332 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