Last week reading (2018-02-18)

Good day SQL folks! Thanks for visiting our blog again!  Have a great week!

Bob Ward’s demos github repo

This is not for reading per se but I would definitely visit the page is you can find there Bob Ward’s demos.

Azure Data Lake Command-line Quickstart using Azure Cloud Shell

Short blog post about how to use the Azure Data Lake command line tool. This is important if by any chance you use Mac or Linux machine. And for other reasons…

SQL Server table hints – WITH (NOLOCK) best practices

I have put this article here on purpose. Even if you think that NOLOCK hint should never be allowed please read this. At least you ensure yourself in not using this hint anymore.

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

I do always read what Joe has to say. This time he takes you through an internally written service named MSAsset.

What’s New in CosmosDB

Video – 10 minutes.

Scott Hanselman talks to Kirill Gavrylyuk to find out what’s new in Azure Cosmos DB, such as the Cassandra API for applications that are written for Apache Cassandra, updates to the Azure Table storage API, the Apache Spark Connector, the Graph API, partitioned collections, 99.999% (five 9s) SLA.

At the end of the post – please do not forget that the February release of the SQL Operations Studio is now available.

Cheers,

Damian