Murilo Miranda is a blogger, speaker, and SQL Server MVP from Portugal. Nowadays he's a Database Consultant at Pythian, a company from Ottawa - Canada. Murilo’s passion for working with people, coupled with his honesty, have helped him establish effective and meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive. … Read more11 August 2016
You've heard of Azure SQL Database, you've nodded wisely in discussions and you might even have tried it out on some sample data. However, you have some nagging basic questions that would seem slightly ridiculous to ask in public. For all those questions that you're too shy to ask, Murilo gives a reassuring answer. … Read more22 July 2016
So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? You need a simple guide to get started.… Read more04 May 2016
There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes. Murilo Miranda continues his series by explaining how such an index is unlike a conventional index… Read more04 May 2016
How do you get started with In-memory OLTP? Murilo Miranda first advises on the setup of the server and the other prerequisites, and, after explaining about the two alternative types of memory-optimised table and their stucture, then provides sufficient explanation to enable you to create your first Memory-optimised tab… Read more26 January 2016
In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.… Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Want more? Subscribe to our fortnightly newsletter