Pages

▼
Monday, 14 November 2016

How to create new Logins and Users for an AlwaysOn Availability Group

›
(This tip also applies for Log Shipping and Database Mirroring) Surely, after setting up an AlwaysOn Availability Group (AG) we are going ...
3 comments:
Friday, 28 October 2016

How to monitor database file space usage in SQL Server

›
Undoubtedly, when it comes to monitoring database file space usage we need a simple way to do it. Fortunately, SQL Server has considerable q...
Friday, 30 September 2016

Creating alerts for monitoring proactively SQL Server AlwaysOn Availability Groups

›
When it comes to monitoring databases we have to do it proactively by using alerts implemented natively or via T-SQL code inside SQL Jobs ru...
Thursday, 29 September 2016

Using ‘sp_browsereplcmds’ to Diagnose SQL Replication Issues

›
When diagnosing transactional replication issues in SQL Server, we may need to examine pending commands within the distribution database. In...
3 comments:
Friday, 19 August 2016

Why is the .txt history detail file of SQL Backup Job not created?

›
Clearly, we always need to have some kind of history for SQL Backup jobs in order to check whether or not they were executed correctly. I pe...
Thursday, 21 July 2016

The 'SkipErrors' parameter for the Replication Distribution Agent

›
Having encountered numerous errors in SQL Server Replication, I can confidently say that the majority occur at the replication agent level, ...
Wednesday, 20 July 2016

How to query the windows users that access via windows groups from SQL Server

›
At times while monitoring a database server, we may need to know not only which SQL users are accessing, but also windows users for securit...
Saturday, 16 July 2016

SQL Mirroring Port could stop working unexpectedly

›
When it comes to diagnosing and fixing some SQL Mirroring issues we may have to face with bizarre causes that could stop working a database ...