SQL #55 – Data Types and Storage Reference

When we design a database, we usually need to do an estimate on the size of the database based on the...

Quick Audio Switching

I’ve got a semi complicated desktop setup, with multiple monitors, lots of USB stuff, and a few ways to record...

I am joining SQLskills

I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to...

Reblog: December 12 to December 18

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

“Pretty Plans vs. Performance” or “Grant Gets Pwned”

If you get an execution plan that looks like this:

I wouldn’t blame you for immediately thinking about query tuning. Especially...

XQuery - Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't...

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...

Whats New 2014

Hey all, Continue to my whats New series,  I am going through its new features and the more I am...

Friday Followup For December 19, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Offer – Any e-book for $5

Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5...