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

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