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 to monitor the free space in these files to ensure…
Read FullYear: 2022
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 in your SQL Database Mail? Database Mail is a powerful…
Read Full
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 is not specific to Azure Managed Instance (MI), but error…
Read FullPassword 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 critical security measure that should not be taken lightly. In…
Read Full
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 has a different purpose, and making changes to the wrong…
Read Full
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 database. They may also be involved in the planning and…
Read Full
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. In this blog post, we will explore how to analyze…
Read FullDriver 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 SQL server security got update with the same patch. Later…
Read FullMigrating 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 time-consuming process. This article will provide an overview of what…
Read Full
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 may directly query both objects and get the details or…
Read Full