Last week reading (2018-01-28)

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.

Previous SQLBits 2017
Next SCD type 1 & type 2 in MERGE statement

About author

Kamil Nowinski
Kamil Nowinski 120 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last Week Reading (2019-01-20)

Hello folks! Good morning on Monday morning and let’s go through some interesting news from the #data world. Press Using Docker to run Integration Tests for dbachecks This time, my friend

Last week reading (2018-03-11)

SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea How dangerous IMPLICIT_TRANSACTIONS might be What is a Managed Instance (preview)? Yaay! Microsoft has just introduced Managed Instance which allows

Auditing in Azure SQL Data Warehouse

The first article in a series on “Security Intelligence in Azure PaaS” inspired me to write something on auditing in Azure SQL Data Warehouse. To put it simply for anyone

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

Protected with IP Blacklist CloudIP Blacklist Cloud