In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
2 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
17 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
1 reads
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations - whether they be Azure SQL or the traditional on-premises SQL Server.
The post...
2021-03-26 (first published: 2021-01-05)
331 reads
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-13 (first published: 2021-01-04)
197 reads
Linked Servers can certainly provide an enigma to your finely tuned Database environment. In this article, I share how to decrypt that enigma via XEvents.
The post Powerful Monitoring...
2021-01-08 (first published: 2021-01-02)
345 reads
This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.
The post Firewall Ports You Need to...
2021-01-06 (first published: 2020-12-31)
3,020 reads
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations - whether they be Azure SQL or the traditional on-premises SQL Server.
The post...
2021-01-05
3 reads
In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server.
The post Simple Method to Add A...
2021-01-04 (first published: 2020-12-28)
522 reads
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
23 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers