Windows Cluster : Understanding the Quorum settings
In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...
2012-07-18
4,022 reads
PracticalSQLDba
SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox
In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...
2012-07-17 (first published: 2012-07-16)
5,626 reads
SQL Server: Instant Blocking Alert Using WMI in Your Mailbox
As a DBA, it is important for all of us to get real time alert on various issues in our...
2012-07-13
6,760 reads
SQL SERVER : SQL Server Scheduler
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,767 reads
SQL SERVER:How Can I Get Notification Alert When Fail Over Happened ?
It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...
2012-07-16 (first published: 2012-07-05)
5,080 reads
SQL SERVER : The Scene Behind NOLOCK
I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...
2012-07-12 (first published: 2012-07-04)
6,782 reads
How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,446 reads
SQL Server : Parameter Sniffing
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....
2012-06-29 (first published: 2012-06-25)
9,019 reads
Connection Pooling :At a Glance
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...
2012-06-15
8,155 reads
SQL Server : Moving System, resource and User Databases to New SAN disk
In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive...
2012-06-18 (first published: 2012-06-12)
4,261 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