Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve...

It's Not Just Poor Coding

It's not just poor coding that threatens security, as a new survey shows.

Database Master Keys

Double Up During Trips

When you develop software, it pays to write efficient code. However it doesn't seem that many companies truly believe this as they aren't always investing in their staff.

T-SQL Tricks – Templates in SSMS

There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s...

Connection Issues

The lack of a network caused a number of problems recently for Steve Jones.

T-SQL Tuesday #60 – Something New Learned

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...

Expected Variables–T-SQL Testing

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...

PASS Keynote–Dr. Rimma Nehme

I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.
We begin with a...

Pay It Forward

Steve Jones looks at the dilemma of training developers and having them leave, or maybe, just having them stay untrained.