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

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