Entity Data Modeling with Visual Studio

While there are a lot of tools out there for data modeling, there is one option that is free if...

Final December Giveaway!

Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...

Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!

TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...

Kissing 2013 Goodbye

The end of the year is here, which means it’s time to look back and review my goals and reflect...

Last Weeks Top “Reading” Links #64

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Memory Timeouts

Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...

SSIS For Loop Skip Files

When running a For Each Loop through a set of files, sometimes you will have specific files that you do...

SSRS Interactive Sorting a Matrix

Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...

Wishing all visitors a very happy new year 2014

Wishing all visitors 

A Very Happy & Prosperous

 New Year 2014

Happy New Year! Thanks to visit queryinqsql.com.
Last year I started this Blog,and post...

Day 5 – Peer Identity

This is the fifth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...