In today’s post we are going to talk about Query Store, the repository that we find within our SQL Server databases. First of all, we are going to learn more about the main objective of this tool. What is Query Store Query Store was born Read More
As we know all versions of SQL Server have a start date and an end date. In today’s post we are going to talk about the end of Support for SQL Server that will be effective as of July 12, 2022. Why migrate to the Read More
In this serie of monitorization that i will start today, we are going to see through various posts how to create a free and interactive monitoring system. The first post will deal with one of the most important tasks, which is the configuration and installation Read More
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
Usamos cookies propias y de terceros para que podamos mejorar su navegación. Si continua navegando consideramos que acepta el uso de cookies. AceptarMás información
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.