As the title of this post indicates, the Database Migration Service (DMS) could experiment with problems in very rare cases with the capacity to start/create a service due to not having enough resources in a specific region. It is interesting to start explaining why the provisioned number of Virtual Machines (VM) could impact DMS. If…
Setting up an Azure SQL Managed Instance
As every option available in Azure and particularly talking about SQL, for the classic question about What option is better for me? The classic answer is still valid and this is “It depends”. Your necessity or your business workload or architectural design would influence in a determinant way with your decision. In this article, I…
Book Review – How to speak so people really listen
I must confess that I was not a big fan of management books or those books that help you to improve your soft skills, but I reached a point in my career where I realize potentially miss out on progressing and promotions due to the lack of these soft skills. Nonetheless, primarily I saw myself…
Introduction to Scalar UDF inlining in MS SQL Server 2019
Historically the use of User Defined Functions aka UDF has represented a great option to encapsulate logic into Database reusable objects, nonetheless, during the implementation of scalar UDF (a variation based on the function’s output) for MS SQL Server we have been suffering painful performance penalties until the arrival of version 2019, so in this…