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-04-07)

Good morning guys and gals! This time many updates and articles from ADF field, so keep reading once you sit comfortably with coffee in a hand. Press Handling Schema Drift

Last week reading (2018-01-21)

Good day SQL folks! Thanks for visiting our blog again!  Here you can find some great articles I have found for you. Here you are – this week readings. Start

Last week reading (2018-11-18)

No, you don’t need a blockchain Thomas LaRock (T) says: “Don’t buy a blockchain solution unless you know for certain you need one.” Anatomy of a spool Hugo (T) collected

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

Protected with IP Blacklist CloudIP Blacklist Cloud