In a Managed Instance with multiple databases in Azure we can have high availability. More specifically, we can have an asynchronous second read-only Managed instance in the same or in a different region. We can at any time do… read more
Why doesn't SQL Server use all CPU Cores?
Having a SQL Server Instance installation we can face the following strange situation, while there is a need for CPU usage that never reaches this 100%. In the article we will see what may be the reason and how... read more
What is collation and how it changes in SQL Server
In one sentence, collation is the way characters are encoded in a database. That is, you define whether they will be case sensitive (uppercase, lowercase), in which language the varchar and text fields are. Fields like nvarchar which are in unicode format are not affected… read more
How do we add a purchased domain to Azure Active Directory
In the article we will see how we add to Azure Active Directory a custom domain that we can purchase from any provider. What is the use of When we create a Tenant / Azure Active Directory is automatically created… read more
How to see what operations a query performs to complete it in SQL Server (Execution Plan Operators)
To run a query on SQL Server, the Query Optimizer takes information such as the query, database schema, statistics and derives the optimal way to access them. The result is called Plano or otherwise… read more
How can we access another oracle database remotely
In this article we will analyze how we can access tables / views located in a remote Oracle database. To achieve this we need to create an object called Database Link.… read more
How can we store docx, xlsx, jpg, xml, etc. files in a database table? in SQL Server
In SQL Server we have the ability to store files such as Docx, Xlsx, XML, JSON, JPG, PNG etc. in a field of a database table. In this article we will analyze how this is done and how it is done... read more
How can we see the historical snapshot of a table in SQL Server using Temporal Tables (aka Row Versioning)
Coming from the SQL Server 2016 version, SQL Server brought the ability to view a table historically over time. That is, to have a row versioning in the table with the possibility to choose the time we want. read more
What are Columnstore Indexes and when do we use them in SQL Server
In this article we will analyze the difference between a table that is physically stored via a Clustered Rowstore Index and one that is stored via a Clustered Columnstore Index. What exactly are Columnstore Indexes, when should they be used and what are… read more
