.jpg)
Book signing photos from SQLPASS 2012: launches of SQL 2012 Functions, SQL Queries 2012 Joes 2 Pros Volume 1 and Tim Radney’s SQL Backup and Recovery.
Checking Certificates That Expire Soon in Every Database
Nobody remembers who created that certificate. Here is a short loop that lists every certificate expiring soon, and what to ask about each one.
Window Functions Over GROUP BY Results: SUM of SUM Explained
Why does SUM(SUM(Amount)) OVER () work? Because the window runs after GROUP BY. A short demo with shares, ranks and a filter trap.
Ordering a Maintenance Window: Backups, CHECKDB and Index Work
Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.
SQLAuthority News – #SQLPASS 2012 Seattle Update – Memorylane 2009, 2010, 2011
The first day of SQLPASS 2012 in Seattle, and a trip down memory lane: the city I never managed to visit as a student, and my PASS trips of 2009 to 2011.
Find SQL Server Agent Job Failures Before Users Do
Agent job failures hide in msdb until someone reads the history. This post builds three demo jobs, then finds the failed step and its message, the job that runs too long, the job that never starts, and the jobs that notify nobody.
Walking Foreign Key Chains to Find a Safe Delete Order
Map foreign key chains from a parent table with a recursive catalog query, then list deepest children first and flag cascade rules.