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

ExpressProfiler - new build published

Just published new signed build of ExpressProfiler - few nice improvements like advanced search, stay on top window, transparency - just to make...

Powershell to Robocopy files (say, to back up your computer to protect against CryptoWall trojan)

We were having a good time on DBAs@Midnight, when Sean got a weird pop up message that said all his...

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

Timed SQL Server tracing

Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...

Protected: Has it come true?

There is no excerpt because this is a protected post.

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

Friday Followup For February 6, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

2015 - the year of upgrade

2015 should be a very busy year for most DBAs, due to the end of support of SQL server 2005...

SQL Server – Endpoint Authentication Error in AlwaysOn Availability Group Setup

According to MSDN: If the SQL Server service is running as a built-in account, such as Local System, Local Service,...