How can I execute t-sql with a Proxy account

SQL Server Agent job failures with tighter security upon server migration Read more →

AWS-RDS SQL Server limitations

On-prem to AWS RDS SQL Server has some differences. Processes need to be reviewed Read more →

Array-based replication versus vSphere Replication

Thinking about how to approach large scale vSphere SQL Server migrations to new hardware Read more →

How to fix Invalid comparison due to NO COLLATION

Unusual no collation error on a SQL Server 2017 Read more →

How to fix BACKUP LOG cannot be performed because there is no current database backup

The Backup team shared a warning message for SQL Server backup of a read only db Read more →

How to recover SSMS auto recover scripts after crash

A developed asked me how to recover scripts after SSMS crashed Read more →

How to capture SQL Server database RESTORE details with Extended Events

Troubleshooting a slow restore using Extended Events Read more →