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
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
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
The Great Database Battle – SQL Server vs Oracle Database
The two best-known RDBMS (Relational Database Management Systems) with the largest market shares are Microsoft SQL Server and Oracle Database. They have a lot in common but also a lot of differences between them. Let's see in detail: Filegroups: They are… read more
How we collect blocking queries via Extended Event and how we read its data
In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will create an Extended Event that records blockings. All we need to do is create it… read more
How do we find how much more it takes to complete the query and which is delayed (SQL Server Query Profiling)
Many times we will encounter queries that take too long to complete or never complete at all. To find what exactly is at fault the most useful information is the actual execution plan. As the actual execution plan requires the completion of the query, with… read more
