Don’t let this little SQL slip delete your rows!

I came across this quick example that shows how easily the tiniest little mistake could end up deleting rows from your table. The solution to this bug? Always name & reference your tables, CTE, and subqueries! And now you can play: Spot the Bug™!

Agent Alerts Not Configured – Brent Ozar Unlimited®

Here is Brent Ozar’s SQL script to add important alerts: via Agent Alerts Not Configured – Brent Ozar Unlimited® This script sets up SQL Server Agent alerts for severity 16 through 25 as well as specific alerts for 823, 824 and 825 errors. Do a search & replace in this code and change ‘The DBA… Continue reading Agent Alerts Not Configured – Brent Ozar Unlimited®