Category: SSC

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

Issues and opinions on the PASS anti-harassment policy (#sqlpass)

PASS just published an anti-harassment policy reminder, quickly followed by a  blog by Wendy Pastrick (about a bad experience at last month’s conference, and why it took a while to report it). We’ve had some conversation on Twitter about it all, and a couple of jokes, and some back and forth. Here are a few related items, and […]

A Data Age proclamation

Twice in two days now, I’ve gotten in discussions with people about the state of data usage…the idea that we have absolutely massive amounts of data at our disposal – especially us, as if you’re reading this, you’re likely a DBA or at least an IT professional – but that people are not using data to its fullest extent. […]