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

In today’s post, we will learn how to create an Inbound Marketing strategy with a few simple steps. The first question we must ask ourselves is, What is Inbound Marketing? What is it for? Surely many of you will have heard about it, but what is really its purpose? Will 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

Every year we try to improve our Christmas greeting, for years they were simple SQL Server scripts, last year we decided to do it with Power BI, and this year we wanted to try to do it with SQL Server Spatial Data. Although Spatial Data is a feature that Read More