Weekly reading #26

Good morning! It was a tough weekend as we supposed to be in Goteborg on #SQLSatGothenburg but unfortunatelly the flu hit us hard. The talk was handed over by Hugo Kornelis (thank you). Now we are preparing for #SqlSatPrague – for workshops and sessions!

SQL Server Data Tools for Azure DW

Finally! The missing part is in the SSDT! I have been working with quite big Azure DW and it was a problem for me not having my DW structure inside the solution. I am going to test it very well this week!

Global data distribution with Azure Cosmos DB – overview

This is a good overivew of how to build your application that is responsive and has data distributed across teh world

Regional endpoints for Azure Cosmos DB Graph account

You know Azure Cosmos DB is a distributed database across the world. It runs on many machines. You can configure your app to read from many endpoints to speed the performance.

[Video] Connection Types in Power BI Import Data or Scheduled Refresh A Detailed Look Inside and Out

Reza covers everything about Import Data or Scheduled Refresh type of connection. He has shown how Power BI stores data into xVelociy in-memory engine, and what are pros and cons of this method in detail.

SQL Server 2019 Intelligent Performance

I think you might have heard about Adaptive Query Processing or Intelligent Query Processing. Now this is called Intelligent Performance. But there is more in the Intelligent Performance than AQP or IQP. For exampel you should know about In-Memory Database and Lightweight Query Profiling. If you would like to know more – go and read Bob’s article.

Cheers,

Damian

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.