Last week reading (2018-07-08)

Last week reading (2018-07-08)

Good day SQL folks!

Monday morning is always tough to start working on serious tasks. I think it is a perfect time to read something interesting before you really go into tons of tasks. Now let me give you some things to read for the rest of the day.

This post was scheduled to be delivered on Monday – as usual. And Monday won with me just by sending too many tasks immediately in the morning. Now I can say that “Monday morning is always tough to start working on serious tasks. I think it is a perfect time to read something interesting before you really go into tons of tasks. Now let me give you some things to read for the rest of the day” .

Now (Tuesday early morning) let me give you some things to read for the rest of the day!

Predicate Pushdown and why should I care?

Pedro Lopes (check the interview with Pedro here) explains the concept of a predicate pushdown and its inplications during the optimization process.

What is the FCB_REPLICA_SYNC spinlock?

Paul Randal explains this wait type. You should not see much of it unless you use a database snapshot. Then you will see trillions of them

TEMPDB – Files and Trace Flags and Updates, Oh My!

Pam Lahoud’s blog post about our favourite topic – the tempdb. You can read about some recent changes that have been introduced to this database.

Deploy Azure SQL Managed Instance network environment using ARM

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. You would need to prepare Azure environment where SQL Managed Instance will be hosted before you create your Managed Instances. In this post you will see how to deploy configured Azure environment using ARM template

Modeling document data for NoSQL databases

Showing how different can be modelling documents for NoSQL databases from what you have known from the relational world

ASF 011: Grant Fritchey interview

Don’t forget to hear to this great interview we did with Grant!

Cheers,

Damian

Previous Last week reading (2018-07-01)
Next Getting the Data to Power BI

About author

You might also like

Last Week Reading (2019-06-02)

Hello data folks. Here you have some updates from the data world. Press Where should I clean my data? James Serra’s (T) guidance when using ADF, DW, maybe Databricks… How

Last Week Reading 0 Comments

Last Week Reading (2019-04-21)

Hello Data Folk! There is plenty of readings for this week, so grab a coffee and let’s start digging in! Press Smarter, faster, safer: Azure SQL Data Warehouse is simply

Last Week Reading 0 Comments

Last week reading (2018-12-30)

Good day SQL folks! Here is your weekly list of articles worth to read! The year is almost ended so I would like to wish you all the best in

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply