T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you...
2011-05-10
12 reads
To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you...
2011-05-10
12 reads
To CTE or not to CTE, that is the Question
So my post really has nothing to do with the title....
2011-05-10
697 reads
After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting. Meeting Time is 6:30PM PST Erika Bakse (blog | twitter) has...
2011-05-03
11 reads
After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting.
Meeting Time is...
2011-05-03
588 reads
Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter) has started. Today he has started things off with a list of things that...
2011-05-02
18 reads
Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter) has started. Today he has started...
2011-05-02
921 reads
SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s. You can see this evidenced in many ways in the product. A couple...
2011-04-29
21 reads
SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s. You can see this...
2011-04-29
3,835 reads
Today I had a bit of regret slap me in the face. That face slap came from participation in a SQL Quiz on twitter that was hosted by Paul...
2011-04-29
9 reads
Today I had a bit of regret slap me in the face. That face slap came from participation in a...
2011-04-29
1,371 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