[OT] Blog is in maintenance mode

I’m spending part of this holiday break repaying some technical debt on my website.  Among other things, I am importing...

Change Tracking–an easy way to track your changes TIP#78

 
I am pretty much sure by the title of this post you had idea of the post content. Although I...

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why...

Easy way to reseed identity column ? TIP #77

 
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...

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...