Security as a Fleeting Thought

Today we have another installment in what is known as TSQL Tuesday.  This month we have an invitation and topic given to us by the infamous Kenneth Fisher (...

Security as a Fleeting Thought

Today we have another installment in what is known as TSQL Tuesday.  This month we have an invitation and topic...

Excel BI Tip #20: Wingdings–an Excel Services Supported Indicator Alternative

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

T-SQL Tuesday #63 – Security

It’s T-SQL Tuesday time again and this month we look at security. Kenneth Fisher has chosen this as his topic...

TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...

T-SQL Tuesday #63 - Managing Security - Enforce SQL Login Policies

Today, February 10, 2015 is TSQL
Tuesday, no.63! (Click on the highlighted link for the Invitation.)
 Hosted this month, by Student of...

Managing Security – TSQL2sday # 63

A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a...

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

A VR Wielding Mentee

Hello!
This post is my submission to become one of Paul Randal’s mentee(s) in 2015: http://www.sqlskills.com/blogs/paul/want-mentored/
As I write this blog post,...

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