4 min read
0
Password reset of SQL service account
Impact of resetting password for SQL Server service account Resetting the password of your SQL Server service account is a…
Month: November 2022
2 min read
0
Customizing the Status Bar Color in SQL Server Management Studio
Introduction In database management, it is common to work with multiple environments, such as development, staging, and production. Each environment…
4 min read
0
How and Why to become a SQL Server DBA?
What is a SQL server dba? A database administrator (DBA) is responsible for the performance, integrity, and security of a…
4 min read
0
Get CPU Utilization Data from SQL Server
Monitoring the CPU utilization of a SQL Server instance is crucial for maintaining optimal performance and identifying any potential bottlenecks.…
6 min read
0
Driver could not establish a secure connection to SQL Server
Driver could not establish a secure connection to SQL Server Recently windows patching was done on a server and also…
3 min read
0
Migrating SQL Server Database Mail Settings
Migrating SQL Server Database Mail Settings Migrating SQL Server Database Mail profiles, accounts and settings can be a complex and…
2 min read
0
Checking SQL Server Job History by Script
Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains all major information regarding the SQL Server job and its running status and history. We…