Category: Admin

Utility function: dbo.JobName(@job_id)

Post author By Jen McCown
Post date March 28, 2016
Categories In Admin, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
2 Comments on 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 […]

Well that’s just neat: Row Level Security, new in SQL Server 2016

Post author By Jen McCown
Post date February 25, 2016
Categories In Admin, Security, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
4 Comments on Well that’s just neat: Row Level Security, new in SQL Server 2016

SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while, but the on-prem version is getting it, now. Securing Rows Okay, so: row level security (or RLS as the MSDN article so groovily puts it). What’s that, then? In short, it’s a method of securing […]

Shrink a log file…AUTOMATICALLY?

Post author By Jen McCown
Post date February 22, 2016
Categories In Admin, Beginner, Intermediate, Minion by MidnightDBA, sqlserverpedia-syndication, SSC, Tech and Learning
2 Comments on Shrink a log file…AUTOMATICALLY?

Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First things first: why would you want to shrink a log file in the first place? Haven’t we heard that shrinking files is bad? Well, no and yes. No, shrinking log files – […]