The Basic TRY..CATCH

Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct...

Speaking at SQL Saturday #389 – Huntington Beach

I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM...

SQL Cop and SQLServerCentral

Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.

Career Ratings

I wrote the other day about measuring your career, and I gave some general advice, but I wanted to give...

Microsoft and R

R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.

Backing up from SETUSER

ALTER SCHEMA TO ADD PERMISSIONS

I’m sure some of you have wanted to do this:
ALTER SCHEMA Steve AUTHORIZATION Steve

You realize this doesn’t work, and you...

Filestream storage

Nested Break

Computational Biologist

A job Steve Jones has never heard of is using data to improve medical treatments.