Reblog: October 10 to October 16
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-10-17
715 reads
Blog Posts
Untrusted Foreign Keys
Reading Time: 4 minutes
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between...
2014-10-17
330 reads
Why Haven’t You Changed Everything?
The first in what I hope will be many regular reports on what I’m doing on the PASS board.
To answer...
2014-10-17
608 reads
Analytics Platform System (APS) AU2 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2),...
2014-10-16
917 reads
Creating a SharePoint Server Farm on Azure from the Gallery
As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help...
2014-10-16
794 reads
Eliminate Overlapping Dates
I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...
2014-10-16
1,040 reads
Insufficient Space to Create Databases For SCOM 2012 R2
Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...
2014-10-16
717 reads
Learning Options in Seattle Next Month
The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...
2014-10-16
822 reads
Notes From The October 15, 2014 oPASS & MagicPASS Meeting (The Souza-Thon!)
Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go...
2014-10-16
772 reads
Query Performance Tuning in SQL Server
I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...
2014-10-16
687 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