Last week reading (2018-03-04)

Last week reading (2018-03-04)

Good day SQL folks! Thanks for visiting our blog again!  It’s March already and we are looking for the Spring to come.


Columnstore Indexes – part 120 (“Merge Replication 2016-2017”)

If you are a columnstore index fan or if you use it on your daily basis than all Niko’s posts are just a must-read. I would like to remind you that Niko will have all day workshop during the sqlday conference in Poland. His workshop is on 14th May and the conference is on 15th and 16th May.

Use the Azure Cosmos DB Emulator for local development and testing

Finally! We can have an emulator to play with Cosmos DB locally. Once you are done with local development and satisfied with the result than you can just switch to your Azure account very easily!  Great thing.

SQL queries for Azure Cosmos DB

I know you know that you can query the Cosmos DB using the “TSQL like” language. That is not a new thing. In this article, you can read about how to do it plus there is a video explaining all that stuff. And of course, I share a link to the Cosmos DB playground where you can run queries without setting up the database at all

Create your first function in the Azure portal

Don’t be afraid of Azure Functions. They are there waiting for you. You must be familiar with them. The sooner, the better. The blog post shows you how to start with them.

Azure SQL Managed Instance

Video – 18 minutes. Jovan Popovic, Program Manager at Microsoft will explain do an introduction to the main features of Azure SQL Managed Instance


Check Chrissy LeMaires’s twitter (@cl) as she posts a ton of useful PowerShell scripts like this one. It automatically stops your XE Sessions at a specific time

Start-DbaXESession -SqlInstance sql2017 -Session 'Long Running Queries' -StopAt (Get-Date).AddMinutes(30)




Previous Last week reading (2018-02-25)
Next Last week reading (2018-03-11)

About author

You might also like

Last Week Reading 0 Comments

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

General 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 (2017-12-17)

How Can I Become A Microsoft MVP? Many people ask how to achieve the title, so Kevin Kline [T] answers. Forget, it’s not a recipe – just do what you


No Comments Yet!

You can be first to comment this post!

Leave a Reply

31 + = 33

Protected with IP Blacklist CloudIP Blacklist Cloud