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 it.  And there is even plenty of metadata within...

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

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

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