Computed Columns and Divide by Zero

I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...

Feedback and Big Data

Continuous improvement comes from measurement, analysis, and changes. Steve Jones talks about how we should be doing that with our data collection, analysis, and storage.

SQL Agent Roles

Insider Security Threats

The biggest security threat always seems to come from insiders and today Steve Jones talks about the need to monitor your environment.

Change Management

This Friday Steve Jones asks about change control for the Friday poll.

Old Dog, New Tricks

Steve Jones learns a new trick working with T-SQL, and is surprised how easy it is. He recommends you work on updating your skills over time as well.

Returning Results from an Insert – OUTPUT clause

I needed to return an identity value recently from an insert for use in another piece of code. For a...

INSERT OUTPUT

A few quick time calculations

Have you ever needed to do a quick time calculations of the amount of hours/minutes/seconds that have passed? Suppose you...

Disk Drives in the Sky

Steve Jones talks today about storage innovations from the large cloud vendors and how that can relate to your job as a database professional.