Format Disk for SQL Server
Managing large SQL Server inventories requires standardisation. Do your research , create the scripts , and apply.
Occasionally, custom changes are required . This...
2011-09-28
4,141 reads
Blog Posts
Online index rebuilds
G’day,
I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases,...
2011-09-28
1,058 reads
Posting This Week
I just wanted to do a quick post to let everyone know that I am in fact going to be...
2011-09-28
504 reads
RTO in Disaster Recovery
When you have a disaster, the time that you have to restore service is usually referred to as the RTO...
2011-09-28
1,283 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…! It’s time for another SQL Saturday at the beautiful University of Iowa campus. The speaker lineup looks great....
2011-09-28
48 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!
It’s time for another SQL Saturday at the beautiful University...
2011-09-28
747 reads
SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,656 reads
SQL University SSIS : Named Pipes -- Consumer
Welcome to the third and last day of the Named Pipes seminar. Today we will get into the consumer portion...
2011-09-28
561 reads
SSIS Merge with Duplicate Rows
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,341 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,592 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