Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
559 reads
Blog Posts
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
941 reads
Who’s using that database?
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else...
2015-03-17 (first published: 2015-03-09)
7,462 reads
“Thing IS NOT NULL” isn’t the same as “Thing != NULL”
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
584 reads
How To Speak At SQL Saturday Events
The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism...
2015-03-16
853 reads
Keep VM snapshot growth from wrecking your day
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot...
2015-03-16 (first published: 2015-03-09)
5,265 reads
Making Sense of PCIe SSD Use with SQL Server
When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to...
2015-03-16 (first published: 2015-03-10)
6,053 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-16
644 reads
Statistics on UNIQUEIDENTIFIER columns
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on...
2015-03-16
1,092 reads
The Demo Setup–Attaching Databases with Powershell
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,584 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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