6 min read
0
How To Check Free Space in Data and Log Files in SQL Server
In a database, data and log files are used to store the data and log records, respectively. It is important…
Category: MSSQL
3 min read
0
Attachment size limit in SQL Database Mail
Overview of Database Mail Are you looking for the quickest and most efficient way to check the attachment size limits…
2 min read
0
Operating system error 50 in Azure SQL Managed Instance
We encountered an error while taking a backup of a database from Azure SQL Managed Instance to Blob. This issue…
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…
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…