On February 17, 2021 at 6:00pm Pacific time Derrick Bovenkamp and I will be presenting a webcast training on SQL Server Database Corruption. After repairing… Read More »Announcing Feb Webcast – Introduction to Database Corruption
Have you tried out Database Health Monitor and the Quick Scan report? The Quick Scan report does a quick check (sometimes not so quick depending… Read More »Have you tried the Quick Scan Report?
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you… Read More »Checking job history log size with TSQL
Babelfish for Aurora PostgreSQLDecember 1, 2020Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of… Read More »2020 Blog Post Summary
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick… Read More »TSQL Query to find the user the SQL services run as