Last Execution of a Proc

SQL Server is full of good stuff.  There are plenty of features to be used.  Plenty of applications to help...

Q and A With SQL MVP Chris Shaw

This has been a long time in the making, back in 2011 I attended a session at PASS Summit by...

SQL Code Guard v2.7 released

Hola!
SqlCodeGuard v2.7 is just released.
To be brief - major changes:1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be...

The Vacation Conundrum

Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum...

T-SQL – Read CSV files using OpenRowSet

We can directly access a CSV file using T-SQL.
Input file

Configure server to run Ad Hoc Distributed Queries
sp_configure 'Ad Hoc Distributed...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better, the killer feature for me is quickly deploying the...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...

Dealing with layered function calls

T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...

On Failure: Getting Up

In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...