SQL Server test data generation testing tools
Question: How do I generate test data for SQL Server ? I don’t want to buy a benchmarking tool, but I...
2011-09-02
954 reads
Question: How do I generate test data for SQL Server ? I don’t want to buy a benchmarking tool, but I...
2011-09-02
954 reads
Note: This post was originally posted on October 29, 2009. In the interest of the upcoming conference season, I’m republishing...
2011-09-02
718 reads
Note: This post was originally posted on October 29, 2009. In the interest of the upcoming conference season, I’m republishing...
2011-09-02
822 reads
I have only interviewed for a handful DBA jobs over the years, but they have ranged all the way from...
2011-09-01
655 reads
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to...
2011-09-01
449 reads
Primate Labs has released Geekbench 2.2.0, which is a free upgrade for Geekbench 2.1.x users. The release notes are here.
Here...
2011-09-01
951 reads
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
15 reads
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little...
2011-09-01
603 reads
I saw a post recently where someone was asking about the restore sequence for a series of backups. The scenario...
2011-09-01
826 reads
I was trying to write an article for a long time. Every time I start writing one, I would put...
2011-09-01
1,258 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