Last week reading (2018-04-15)

Last week reading (2018-04-15)

Good day SQL folks!

Spring is everywhere all around us! You might not necessarily see this Monday morning at work… I hope you will have an easy start of the week with our weekly pack of great articles. Not necessary articles… Today I have posted more video links and also one GitHub code example.

Ingest, prepare, and transform using Azure Databricks and Data Factory
Nice article about ETL/ELT and what and how you can do this having Azure Databricks generally available with Azure Data Factory.

Common design patterns with Azure Cosmos DB
[Video, 15:47] Aravind Krishna stops by to chat with Scott Hanselman and take a look at common design patterns for building highly scalable solutions with Azure Cosmos DB. They are talking about data modeling and how to choose a proper partitioning key plus some common patterns like time series data.

How is SQL Server Statistics Histogram Computation Used by The Query Optimize
[Video, 10:22] First video out of 3 about insights of the SQL Server. You can check how the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Explanation how this is related to the EQ_ROWS & AVG_RANGE_ROWS information in the statistics.

Changing Cosmos DB Write Locations on a Schedule with Azure Functions and Managed Service Identity
Azure Cosmos DB can replicate a single account’s data to as many Azure’s regions as you desire. Applications around the world can read from the closest location to minimize latency. Write operations, however, are still sent to a single designated write region. However, this can be changed – read how to do this.

How to use ETAG to control Replace or Read Document in CosmosDB
[CODE] This is actually a code sample posted on GitHub. You have an example of how to do basic CRUD operations in CosmosDB

“Actual” Execution Plans – or are they…
[Video, 9:55] Brent Ozar talks about … a few bugs with “actual” execution plans on SQL Server 2017 and SSMS 17.6

 

Cheers,

Damian

Previous T-SQL Tuesday #101: My Essential SQL Server Tools
Next ASF 009: Pedro Lopes interview

About author

You might also like

Last Week Reading 0 Comments

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

Last week reading (2017-12-31) & Happy New Year!

Yeap, this is last day of the year 2017. So, I do not expect too many readers of this post – almost everyone is preparing to go to New Year

Last Week Reading 2 Comments

Last week reading (2018-04-08)

Good morning folks, We (me & Damian) are preparing our workshop which will take place at SQLDay conference in Wroclaw (time is ticking, sooooo fast), but in the meantime I’d

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

75 − 65 =

Protected with IP Blacklist CloudIP Blacklist Cloud