Installing Ola Hallengren SQL Server Maintenance Solution on AWS RDS

A DBA asked if the Ola Hallengren SQL Server Maintenance Solution is adaptable to the AWS RDS environment Read more →

Get free disk space for mount points using Powershell

A DBA asked how to view mount point disk space with Powershell Read more →

How to check SSAS service status with Powershell

A DBA asked me how to view SSAS service status with Powershell Read more →

How to check SSRS service status with Powershell

A DBA asked me how to get the SSRS service status with Powershell Read more →

How to get count of GROUP BY columns

A developer wanted to know about GROUP BY and COUNT. Read more →

How to fix operating system error code 80(The file exists.) in SQL Agent Job during BULK LOAD

SQL Server Agent job failure with an Operating system error code 80(The file exists.) error Read more →

How to check a SQL Server connection is encrypted with SSL

Security team requested information about SQL Server encrypted connections and SSL Read more →