Last week reading (2018-01-28)

SQL Server 2017 CU3 adds CXCONSUMER waits, doesn’t mention it
New wait is not visible everywhere, but check where you can find it.

Sabbatical and the search for a dream job
Basia Fusinska about her last few months of unemployment but busy time and plans how to be happy at work.

Microsoft SQL Server – Notes for Professionals
Very helpful cheat sheet in book form. For those who always forget a syntax, like me.

Shortcut: When did my T-SQL query finish?
Quick reminder about thing we use every day.

GDPR – A guide for the perplexed
General Data Protection Regulation comes into full force soon. Have a look into reasonably clear summary and guidelines for implementing GDPR.

What is database DevOps, and why is it important for DBAs?
Welcome to DevOps for databases. Take effect the same principles as for application development: Source Control, Unit testing, Repeatable deployments and Continuous delivery.

PASS Summit 2017 Video: “But It Worked in Development!”
75 minutes of Brent Ozar’s session from PASS Summit 2017 where he shows symptom of problems during heavy load or concurrency.

Getting started with machine learning in SQL Server
SQL Server 2016 brings R language on board. 2017 brings Python. Start here if you want to get to know Machine Learning in SQL Server.

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017
Planning SQL Server migration? Create your own checklist, that one may help.

How I designed my VMware vSAN based Home Lab
Data center at home? Nothing easier – do it yourself. Like Klaus [T] did.