T-SQL Tuesday #63: How do you manage security

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security.
Security is one of...

VMware vExpert 2015

VMware has announced the list of 2015 recipients of the vExpert award, and I am humbled and honored to have been...

Enough Is Enough! Why Do We Have To Be At Risk?

Reading Time: 2 minutes
When Do We Say Enough Is Enough?
Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information...

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

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

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