In the company we have been working with Azure SQL Database Managed Instance for more than 1 year and in general terms we can say that we are very happy with the technology, because as a PaaS tool we no longer have to worry about Read More

I’m sure all of us who work with Office365 have wondered if it’s possible to extract a report directly from the Teams tool. So in today’s post, I bring you the answer to this question: Yes, it is possible to extract a report directly from Teams. We will see Read More

As many of you already know, the Office365 platform can perform tasks automatically, which means simplification and time savings. In today’s post  I will explain how to register users in Office365 , as well as their allocation of licenses with PowerShell. In this way, it will be much more comfortable to register Read More

When we work with multinational companies, one of the key parts of our model is the Conversion to different Currencies, since, payments are made from different countries with different currencies and the users who view the reports must be able to see them in the currency they choose. Read More

Hi everyone! In this post we will learn how to deploy alerts using Azure Monitor. The alerts are useful to know when occur a performance failure in our resources. In this way, we can solve the problem quickly and more accurate. Before starting to create Read More

In my first blog post, I will talk about one of the processes that I use almost every day. This is how we can archive the data of different Excel files in a SQL Server database, all this through SQL Server Integration Services (SSIS) rename them with the date and Read More

In our day to day as DBA we must create indexes to improve the performance of the queries launched against the production tables. A necessary tool would be to know what percentage of creation our index has. In many cases, we do not have an Read More