In this article we will see the steps and options we have to enable the database auditing specification in SQL Server. Through the database auditing specification we can record who accesses and how... read more
How we set an Azure Storage Account as a Cloud Witness in Windows Failover Cluster Quorum
When we install a Windows Failover Cluster on Windows Server and we want to have automatic failover, we need to define a Witness. Witness's job is to communicate with both sites and in case any… read more
How do we add a database that has TDE Encryption enabled to a SQL Server Always On Availability Group?
In a previous article we have seen that TDE (Transparent Data Encryption) is the encryption of a database at a physical level. That is, it encrypts data files, log files and backups. When a database in SQL Server has enabled… read more
How to migrate a SQL Server database to Azure using Data Migration Assistant
Many times we will need to migrate databases to a newer version or move them to Azure. In such a transfer there is a possibility that some components are not compatible and need corrections before we start the migration. The tool… read more
How can we export daily data from SQL Server to Excel and email it
In the daily operations of companies it is often necessary to extract daily data from the database and give it to an Excel. In these Excels we usually want to have some specific name along with a date and to… read more
How we check the integrity of databases and how we fix any corruption in SQL Server
In a database there is always the possibility of corruption. This can be either physical e.g. from some disk damage or either logical e.g. wrong values in a table field. In the article we will see how… read more
How can we get emails whenever we have high CPU Usage in SQL Server
In this article we will see a script that creates a SQL Server Agent Job that will notify us by email whenever the CPU exceeds a threshold. It derives the information not from performance counters of the operating system but... read more
How do we limit the resources that a user can consume in SQL Server
Many times a user in the database can consume all the resources that the SQL Server instance has and no other work can be done by another user. In this article we will see how we can… read more
A disk is full of SQL Server datafiles, what should I do?
Sometimes a disk will suddenly become full. On this disk we may have one base or many, while we may have space on another disk, we must somehow find which datafiles are full. In this… read more
