Hello Friends, This blog is to help the IT professionals who want to become a professional SQL Server DBA but don't know how and from where to start with. So, I am going to share my experiences and my learning in this blog. Will talk about what are the pre-requisite skills required to become a Professional SQL Server DBA, how much time it takes to be a good DBA and what are the additional skill sets are required to become a good DBA. Apart from that I will also post real time sql server settings on server level and database level, Configuring High Availability. Also will share the Client requirements with real time setups if possible I will provide you with screenshots.
SQL Connectivity Issues: You might have observed or attempted to resolve SQL connectivity difficulties as a DBA. So, I decided to post some tips here… Read More »SQL Server connectivity Issues Troubleshooting Steps
1. Quarantined nodes in Windows Failover Clusters: I’ve observed this issue on Windows Server 2016, where one of the nodes were quarantined after many node… Read More »AlwaysON Issues
SPN Registration: SQL Server can be started and operated using domain user accounts, local user accounts, managed service accounts, virtual accounts, and built-in system accounts.… Read More »SPN Registration Of Windows Service Accounts and Permissions
The steps listed below can be used to generate an SSL certificate for SQL AlwaysOn enabled servers: It’s also crucial to remember that before deploying… Read More »SSL certificate for SQL AlwaysOn configured servers
How can you tell if SQL Server successfully loaded the SSL certificate? select * from sys.dm_exec_connections where encrypt_option = ‘TRUE’ Note: Since all requests are… Read More »SSL Certificate not visible in SQL Configuration Manager Issue
Make a quick fix for automating database migration across SQL Server versions using PowerShell and T-SQL scripting. Before moving on to a set of customised… Read More »Automate SQL Database Migration Using PowerShell from Source to Destination
We had a strange issue with the Always on 3-Node replica today. I got onto the server to Implement a change, which was to apply… Read More »DISCONNECTED State Issue on Alwayson Secondary replica
As a DBA, we carry out all the fundamental checks, including examining CPU and memory consumption, any blockings, deadlocks, locks, fragmentation, statistics updating, and so… Read More »How to fix Slow running queries on SQL Server
SQL Server 2019 Requirements: the necessary conditions for installing SQL Server 2019 on Windows servers. Requirements for Hardware: Requirements for Software: Supported Operating systems for… Read More »Server Side and SQL Side Requirements for SQL Server 2019
You might have observed DBAs attempting to resolve SQL connectivity problems. So, I decided to post some tips here on how to fix SQL Server… Read More »Troubleshooting steps for SQL Connectivity Issues