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 0 Comments

Last week reading (2018-02-11)

Good day SQL folks! Thanks for visiting our blog again!  I have just come back after almost 2 weeks of vacations and here you are – fresh, good content for

Last Week Reading 0 Comments

Last week reading (2018-05-06)

Good morning all, This week only a few things as the SQLDay conference will commence next week and we both (Damian and I) are preparing our workshop and regular session

Last Week Reading 0 Comments

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

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

78 − = 69

Protected with IP Blacklist CloudIP Blacklist Cloud