Effective Permissions on a Database
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,347 reads
Blog Posts
How to move the TempDB Database
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the...
2011-07-14
769 reads
Office Work
I have been working at home for over 8 years, sharing an office with my wife for most of that...
2011-07-14
1,755 reads
Profiled on SQLPeople
I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going...
2011-07-14
533 reads
SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)
I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server...
2011-07-14
1,004 reads
Send SSRS subscription files to (Secured FTP) SFTP
We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the...
2011-07-14
3,942 reads
SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
620 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,358 reads
Backup and Restore SharePoint 2010 Site Collection with PowerShell
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool...
2011-07-13
1,892 reads
Bad Admins: Attacking via Group Membership
This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...
2011-07-13
1,881 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