SQL Server

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

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

Continuing with the post of my colleague Fran Lens’ about Instance Pools, today I am going to teach you Step by Step how to create Instance Pool in Azure using Powershell. Next, I show you the steps to follow to carry out this process: 1. Creation of a Valid Virtual Read More

For more than a year we have been working and migrating clients to Managed Instance in Azure, that’s why when last September 4, 2019 Microsoft made the news of a new option for this, called Instance Pools, we wrote it to the list ” We have to prove Read More

Hello again! This post is the continuation of Learning to deploy Kubernetes in Azure (1/2) in which we deploy the necessary resources to use Kubernetes in Azure, if you have not seen this entry which I encourage anybody to read it. In this post we will learn Read More

Today, we are back with another post related to the Microsoft Azure Cloud platform, this time we are going to talk about a new service, a service that will mark a before and after in the migrations from SQL Server to Azure, we will talk about Managed Read More