In a previous article we saw what an Azure SQL Database is and the differences between SQL managed instances and SQL elastic pools. In the article we will analyze how to create a Simple Azure SQL Database step by step and... read more
How do we transfer server configurations from one SQL Server Instance to another
In the article we will see an easy way to transfer the configuration of one SQL Server instance to another. Parameters such as max memory, max degree of parallelism, cost of threshold for parallelism... All that will be needed... read more
How to force a plan in an Oracle database
In a previous article we saw why a query can run with a different plan and how to force one in SQL Server. In this article we will see how to force a plan in an Oracle database with... read more
SQL Server in the Cloud Era. Time for Azure SQL Databases?
Microsoft in the era of the Cloud with Azure decided to give as many options as possible so that everyone is satisfied. Whether you are fans of on-premise or hybrid cloud. With SQL Server in Virtual Machine services… read more
How do we find what's slowing down queries in SQL Server?
Many times we will see that a query is delayed and we would like to know what is delaying it. To do this we need to know the wait types and what each of them means. Specifically… read more
What is Tabular model and how it differs from Multidimensional in SQL Server Analysis Services
Microsoft in Analysis Services for the creation of Business Intelligence (Data Warehouse) beyond the use of Multidimensional Cubes also provides the Tabular model approach. Tabular models are new, faster to build and easier to use.… read more
How to bulk data into database using Oracle Data Pump (impdp)
Many times we will need to keep the table data and their metadata (packages, procedures, functions, etc.) so that we can then import them into the same or a different system. In a previous article we saw the use of Oracle Data… read more
Useful VBA routines in Microsoft Excel (Part 2)
In continuation of the previous article we will see some more VBA (Visual Basic for Applications) routines that we can use in Microsoft Excel. These routines can be executed by calling them on a button or after some… read more
How to install SQL Server on Linux
In this article we will see how easy it is to install SQL Server 2019 on a machine with a Linux operating system and more specifically on a Red Hat distribution. We will also see how we connect and how we can… read more
