Earlier I talked about dealing with the difficult forum user from the perspective of providing help. Now let us look at from the flip side of the coin. You are asking for help and you aren't getting what you want or need. The first thing you have...
2009-04-07
1,735 reads
Earlier I talked about dealing with the difficult forum user from the perspective of providing help. Now let us look...
2009-04-05
2,004 reads
I was looking through some of the active threads on SQLServerCentral.com tonight, and I ran across one with some code...
2009-04-04
3,661 reads
I was recently asked by a co-worker on my team at work what he should do to keep up with...
2009-03-31
1,894 reads
It has happened to us all at one time or another. We are trying to help someone on an online...
2009-03-25
1,568 reads
I'm sure that these routines are available in a variety of locations, this just adds one more place that people...
2009-03-25
39,951 reads
T-SQL calculations can get tricky at times, and since you often work with multiple rows, it's good to be exact in your data manipulation. New author Lynn Pettis brings us an article about calculating ages.
2009-03-13 (first published: 2008-06-30)
26,199 reads
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
2009-01-27
12,443 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