UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius distance for events in North America beginning January 1, 2017. We will not include the back-to-back weekend restriction during this pilot…” Last month, PASS – the professional SQL organization that many of us are a member of […]
Category: sql server
Webinar: Minion Backup for SQL Server
We’re having a Minion Backup webinar on Wednesday, June 1 at 12:00 PM. Register here! Enterprises have increasingly complicated backup needs. With different data centers, high availability nodes, development refreshes, and more thrown into the mix, a DBA can almost keep a full time job simply making a backup routine that does everything it needs […]
Utility function: dbo.JobName(@job_id)
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly stunned that I’ve never done this before: CREATE FUNCTION dbo.JobName ( @job_id UNIQUEIDENTIFIER ) /* A little utility function to return a job name based on the job_id. No warranty or guarantee implied. Use at […]