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 (2018-06-03)

Modern data warehouse See how a modern data warehouse works from beginning to end. Load confidently with SQL Data Warehouse PolyBase Rejected Row Location Great news for all Azure SQL

Knowledge 0 Comments

Last week reading (2018-04-01)

Good day SQL folks! It’s April Fool day! But don’t worry. All the cool stuff you find here is real & has been read already. The Challenge Is on: Maintain

Last Week Reading 3 Comments

Last week reading (2018-05-14)

Good day SQL folks! SQLDay has just started! We have a workshop about DevOps and Kamil promises to publish a great series of posts about SSDT and topics around that.

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

− 1 = 5

Protected with IP Blacklist CloudIP Blacklist Cloud