Category: sql server

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 […]

Fun with Operator Precedence

Post author By Jen McCown
Post date December 31, 2015
Categories In Beginner, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL
2 Comments on Fun with Operator Precedence

Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause says “WHERE This AND That OR Something AND that”, without any clarifying parenthesis? Let’s play around with this. The simplest test scenario is a SELECT 1. If I get a 1 back, that means my WHERE clause evaluated […]

A year long blog

Post author By Jen McCown
Post date December 17, 2015
Categories In sql server

Tuesday, February 17 Wil Wheaton’s Radio Free Burrito is back on the air, and it always gets me in a creative frame of mind. Thus, the (nearly) year long blog, where I will write regularly whenever I remember to. I’ve set this to auto-publish on December 17, 2015. Today’s project is a personal one, ish. I […]