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-01-14)

The top 7 business benefits of establishing DevOps in your organization No comments, find and understand the benefits. Columnstore Indexes – part 116 (“Partitioning Specifics”) What do you need to

Last Week Reading (2018-12-23)

The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a few articles to feed up our brains (before we

Last Week Reading (2019-05-05)

Hello folks! Another set of information about the Microsoft Data Platform. This time: Spark, SQL Edge(!), Power BI, Big Data, Pester, DevOps, YAML. Press Microsoft brings Azure SQL Database to

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

Protected with IP Blacklist CloudIP Blacklist Cloud