SQL Server
-
Check if Query Store is Enabled in SQL Server
The Query Store feature was introduced in SQL Server 2016 (13.x), which helps DBAs & Developers identify and…
-
SQL Server Management Studio (SSMS) v20.0 Preview
SQL Server Management Studio (SSMS) Version 20.0 is now in preview release. Lets check it out! Microsoft Docs:…
-
SQL Server Default Ports
The SQL Server default ports that the SQL Engine runs on is 1433. This is a useful thing…
-
Troubleshooting Database Mirroring Issues in SQL Server
Maintaining high availability and data integrity in a SQL Server environment is one of the main priorities as…
-
Get SQL Server Services Info from Command
As a SQL Server database administrator (DBA), one of your primary responsibilities is ensuring the smooth operation of…
-
Understanding Log Space Usage in SQL Server
In a SQL Server environment, monitoring database log space usage is crucial for maintaining database performance and ensuring…