Backup/Restore vs Detach & Attach
You want to move a database from one server to another. There are two options to do that.
1) Detach/Attach: To...
2011-10-04
1,031 reads
Nagaraj Venkatesan
Reading SQL Error log
SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...
2011-08-25
435 reads
ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
997 reads
Altering Table structure - SSMS - Timeout Expired
Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...
2011-06-17
396 reads
Database Owner - Error Message
Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.
You...
2011-06-12
420 reads
I am back
I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...
2011-06-11
346 reads
Finding last database growth date and time
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
507 reads
Server Side trace
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...
2010-12-24
517 reads
Perfmon counters list - Quest poster
Stumbled upon this PDF from quest which lists the important Perfmon counters and their acceptable values. A must print and...
2010-12-08
506 reads
Lock escalation : SQL Server 2008
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...
2010-11-29
1,350 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