2004-02-02
1,510 reads
2004-02-02
1,510 reads
2004-01-30
1,627 reads
In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
2005-11-04 (first published: 2004-01-30)
35,565 reads
2004-01-27
1,814 reads
Andy continues writing about replication, this week discussing the many options available when creating a snapshot publication. As we noted on his last article, this one may take longer than usual to load due the large number of images but we think the readability of having it all one page is worth while.
2004-01-27
12,844 reads
2004-01-22
1,867 reads
2004-01-21
2,080 reads
2004-01-20
1,863 reads
We've asked Andy to put together some articles that tackle replication from a beginner perspective, a tutorial type approach PLUS comments on what you should or should not do. This week he covers the steps needed to set up a server for replication. More images than usual so the page may take a little longer to load, but we think worthwhile so that you can see every step along the way. Let us know what you think.
2004-01-20
13,088 reads
2004-01-19
1,748 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