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)

 

Cheers,

Damian

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

Warning: count(): Parameter must be an array or an object that implements Countable in /homepages/43/d674154319/htdocs/app914990832/wp-content/themes/trendyblog-theme/includes/single/post-tags-categories.php on line 7

About author

You might also like

Last Week Reading 0 Comments

Last week reading (2018-03-18)

Good day SQL folks! Thanks for visiting our blog again! Here is the information you need to calmly start the new week. Indexing and partitioning An interesting example was done

Last Week Reading 0 Comments

Last week reading (2018-07-22)

Good day SQL folks! Now and it is almost Tuesday morning, let me give you some things to read for the rest of the day! Execute all SSIS packages in

Last week reading (2017-12-24) aka. Merry Christmas!

Thanks for visiting the page. This is a special week – the Christmas Week! Hope you will find some time to read great articles I have found for you. Here you

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply