Determine the last database backup in SQL Server with T-SQL

Problem: T-SQL code to obtain the last database backup time, the last backup location, the last backup size and check if the file exists on the disk or not. Note: Result will only include database backups that were taken on disk. SELECT A.[Server], A.database_name, A.last_db_backup_date, B.backup_size/1024/1024 as backup_size, B.physical_device_name , 'Yes' as 'file_exists' into dbo.##BackupReport … Continue reading Determine the last database backup in SQL Server with T-SQL

Monitoring Azure Data Factory, Self Hosted IR and Pipelines

Architecture Diagram For effectively monitoring ADF pipelines we are going to use Log Analytics, Azure Monitor and Azure Data Factory Analytics Solution. The above illustration shows the architectural representation of the monitoring setup. The details of setting up log analytics, Alerts and Azure Data Factory Analytics Solution are further discussed in this section. Send to … Continue reading Monitoring Azure Data Factory, Self Hosted IR and Pipelines

SQL Server Storage Review using PowerShell

Problem There's no doubt that storage is one of the key components to SQL Server performance and availability for both large and small SQL Server instances. With today's increases in server and virtual server processing power and large-scale memory support, storage and I/O can easily become the bottleneck for overall system throughput. To gain the … Continue reading SQL Server Storage Review using PowerShell

SQL Server Security review using PowerShell

Problem How often do we do Security Reviews for your SQL Server Instances? We aim to stay on top of security and to be able to so we need to regularly review your Instance security configurations. It’s helpful to build a checklist to be used as part of an internal security audit review, and follow that checklist every time you conduct … Continue reading SQL Server Security review using PowerShell