-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2016

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…

Read more

2 comments, 1,363 reads

Posted in SQL Awesomesauce on 28 March 2016

Catch The Enterprise Scripting Workshop in Orange County, Baton Rouge, Albany, or Atlanta this year!

Sean and I have put together our bazillion (read: like 30 combined) years of SQL Server DBA-ing into one big, shiny pre-conference session that’s coming at you in multiple states of the union! The Enterprise Scripting Workshop. What on earth is that about, anyway?  The short version is that we…

Read more

0 comments, 391 reads

Posted in SQL Awesomesauce on 16 March 2016