Have you ever wonder why Log Send Rate doesn’t show against Primary Replica on the AlwaysOn Dashboard?
Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to...
2018-08-01
454 reads
Dharmendra Keshari
Schedule an Extended Event to run at a Specific Time
When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or...
2018-08-01 (first published: 2018-07-18)
4,165 reads
Failed to join local availability replica to Availability Group – SQL Server error 41106 and 41158
When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary...
2018-07-31
15,573 reads
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
3,994 reads
AlwaysOn_health Extended Event Session
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
2,438 reads
AlwaysOn Dashboard uses System Policies
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
534 reads
Why Availability Databases Are Not Synchronizing?
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
837 reads
Another MVP Award – 2018-2019
Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...
2018-07-16
231 reads
Enable SQLCMD Mode in SQL Server Management Studio
SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS,...
2018-06-07
10,342 reads
SQL Server Stress Testing Using OStress – RML Utilities
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,174 reads
Blogs
Daily Coping 1 Feb 2023
By Steve Jones
Today’s coping tip is to decide to lift people up rather than put them...
Tempdb Performance Improvements in SQL Server 2022 are Dramatic
Tempdb is always a topic for me whether it’s in my sessions or blogs...
Recovering a TDE Database Without the Certificate
If you don’t have the backups of the certificate and private key from the...
Forums
Memory Issue With A SQL Server Express 2019 Server Database Application
Hi, I have just moved a DB from an old HP laptop, to a...
Use Zonal RIs for less than 100% utilization?
We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...
query multiple sql tables and alert last record written datetime
I'm trying to develop a script that connects to SQL pulls in a list...
Ask SSC