More SQL Conferences coming up, including SQL Bits and SQL Down Under

I know I won’t be there, as I’m a million miles away in Australia, but being from the UK myself, I always have an interest in the UK SQL community and in particular, events like SQL Bits. This is the fifth SQL Bits conference, and they keep getting larger and larger. I’ve heard it’s now … Continue reading More SQL Conferences coming up, including SQL Bits and SQL Down Under

Still learning… foreign keys don’t need to reference a primary key

…but you should still have a primary key on every table of course. It’s just that I only recently discovered that you can have a foreign key that references something else, so long as it’s known to be unique through a unique index / constraint. The scripts here demonstrate this in SQL Server 2005 and … Continue reading Still learning… foreign keys don’t need to reference a primary key

SSRS: Removing the Navigation link using an Expression

There are times when you want to have a Navigation property of a textbox (typically providing a link to a URL or other report), but you don’t always want the link to be there. Sometimes you just want it to be an ordinary textbox. This particularly applies when you’re using a Matrix, and you don’t … Continue reading SSRS: Removing the Navigation link using an Expression