Adding File to Database in AlwaysOn Availability Group
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
6,248 reads
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
6,248 reads
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
3,064 reads
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
678 reads
If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...
2018-07-23
956 reads
Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...
2018-07-16
247 reads
SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS,...
2018-06-07
16,749 reads
As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...
2018-05-28 (first published: 2018-05-21)
7,268 reads
In my previous blog, I discussed about “Which are the queries using a particular index or table?“. Today’s post, I am...
2018-05-13
3,139 reads
The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
1,111 reads
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
1,890 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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