Offline installation of SQL Server 2017 on Linux

SQL Server is now compatible with different Linux distributions, and there is a lot of excitement about it.
How ever one of the main questions when ever you say SQL...

PASS Summit 2018 – Call for Speakers

It is that time again. PASS has opened the Call for Speakers. I have submitted for the past 10 years, and have been selected the past 7 years. This...

Speaking at the 2018 Techno Security and Digital Forensics Conference

One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which...

What do recruitment agents do for contractors?

WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships

Are you...

A day in the life of a Sr DBA/Dev

If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points...

A gotcha when switching partitions

When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...

A Guide for Decrypting SQL Server Database Objects

Overview
The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from...

Automating Database Deployment: Part 4 Making Changes Using RoundhousE to Migrate the Database

With the Automating Database Deployment: Part 3 Running RoundhousE post we walked through running a RoundhousE deployment for the first time to create the database and several database objects.  Script naming...

Blocking Locks and Deadlocks

Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...

Blocking Locks and Deadlocks

Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...