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,829 reads
SQL Geek
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
638 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
898 reads
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)
5,076 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
232 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
14,468 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,229 reads
Find Query with Implicit Conversion in the Plan Cache
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
2,802 reads
Which are the queries using a particular index or table?
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,021 reads
Determine Referenced Objects in the Stored Procedures
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
1,266 reads
Blogs
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Data Governance: The Invisible AI Accelerator
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
Forums
Azure SQL vs SQL Server – Key Topics for DP-300 Exam
When preparing for the DP-300 exam, understanding the differences and similarities between Azure SQL...
Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
PK violation in replication but only one subscriber
We have a publication with three subscribers; it's basically a part list with around...
Question of the Day
Data API Builder Operations
What types of database operations does the Data API Builder support?
See possible answers