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.
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
1 2 3 |
Start-DbaXESession -SqlInstance sql2017 -Session 'Long Running Queries' -StopAt (Get-Date).AddMinutes(30) |
Cheers,
Damian
Warning: count(): Parameter must be an array or an object that implements Countable in /homepages/43/d674154319/htdocs/app674669209/wp-content/themes/trendyblog-theme/includes/single/post-tags-categories.php on line 7
About author
You might also like
Last week reading (2018-02-25)
It’s was very busy and pleasant week for me. Tenth SQLBits which has taken in London this year finished yesterday. I have been working as a volunteer (one of the
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 (2018-08-26)
Processing Petabytes of Data in Seconds with Databricks Delta Delta is a unified data management system that brings data reliability and performance optimizations to cloud data lakes. Monitor Azure Data
0 Comments
No Comments Yet!
You can be first to comment this post!