Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that...
2011-07-11
1,070 reads
Blog Posts
How to move the Master database
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,402 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,148 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,101 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement....
2011-07-11
497 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement. Most people probably will see no difference in...
2011-07-11
12 reads
Meme Monday in July - PearlKnows All
It’s time for July’s Meme Monday, and below is my entry, Star date 07:11:11. Started by Twitter|@SQLRockstar, Thomas LaRock, today’s...
2011-07-11
1,269 reads
Meme Monday SQLstrology – Table Valued Zodiac Function
It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...
2011-07-11
957 reads
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter
It’s time for July’s Meme Monday post, and...
2011-07-11
2,517 reads
Misleading Error 1475 While Setting Up Database Mirroring
Misleading Error 1475 While Setting Up Database Mirroring
Wrong Way -->
I was doing some practice work yesterday testing out some mirroring...
2011-07-11
1,169 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
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