Monitor and failover a Distributed SQL Server Always On Availability Group
August 26, 2020In this 14th article of SQL Server Always On Availability Group series, we monitor and failover a distributed AG.
Search Results for: performance
Test-driven database hotfix development (TDHD) with SQL unit test based framework (tSQLt)
August 24, 2020This article talks about test-driven database hotfix development using a very productive database testing framework called tSQLt applying the same SQL unit test based approach.
Getting started with AWS RDS Aurora DB Clusters
August 24, 2020This article provides a step by step explanation of how to create an Aurora DB cluster that is compliant with MySQL or PostgreSQL.
SQL Server troubleshooting: Disk I/O problems
August 17, 2020In this article, we will discuss how to resolve I/O problems that is a very important point for the SQL Server troubleshooting. The storage subsystem is one of the significant performance factors for the databases. Detecting and identifying I/O problems in SQL Server can be a tough task for the database administrators (DBAs). Generally, the […]
Configure a SQL Server Always On Availability Group on the domain-independent Failover Cluster
August 13, 2020This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.
Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups
August 12, 2020This is the 10th article in the series for SQL Server Always On Availability Groups.
SQL database hotfix testing with tSQLt
August 10, 2020This article talks about getting your database hotfixes tested with tSQLt provided they do not have any inherited complexities or dependencies on things other than SQL database.
SQL Certifications
August 7, 2020Introduction Many people ask me how to get the Microsoft SQL Certification. SQL Server has a lot of certifications and specializations. In this article, we will provide an introduction to each of them and provide some tips related. At the time of this publication, we are under the Coronavirus era. Many people are at home […]
Migrating SQL workloads to Microsoft Azure: Databases trip to Azure SQL Database Managed Instance
August 5, 2020In the previous two trips of this articles series, databases trip to SQL Server on Azure VM and to Azure SQL Database, we discussed the benefits of migrating your on-premises SQL Server databases to the Microsoft Azure database platforms and the methods that can be followed to migrate the on-premises databases to the Azure database […]
Implementing an SSAS Tabular Model for Data Analytics
August 4, 2020Introduction Having discussed different aspects of MDM SSAS cubes, we will look at the Microsoft recommended OLAP tool, SSAS Tabular Models for data analytics. There are a few advantages of using Tabular Models over MDM that are listed below.
Migrating SQL workloads to Microsoft Azure: Databases Trip to Azure SQL Database
August 3, 2020In the previous article of this series, Migrate SQL workloads to Microsoft Azure: Databases trip to SQL Server on Azure VM, we went through the methods that can be used for assessing your on-premises SQL Server databases before the migration process then migrating it to a SQL Server instance hosted in a Microsoft Azure VM.
Migrating SQL workloads to Microsoft Azure: Assessment and Migration Tools
July 31, 2020In the previous articles of this series we discussed how to draw the initial strategy when planning to migrate the SQL workload to Microsoft Azure, the different database target platforms provided by Microsoft Azure that can be used as a migration target, based on the workload type, and finally, we went through some tools that […]
Migrating SQL workloads to Microsoft Azure: Guidance and Assessment Tools
July 30, 2020In the previous articles, Migrating SQL workloads to Microsoft Azure: Planning the jump and Migrating SQL workloads to Microsoft Azure: Services Selection, we discussed the steps that you should follow when you start thinking loudly that you need to migrate your SQL workload to Azure, by checking your on-prem site and the available services and […]
Getting started with Azure SQL Analytics
July 29, 2020Using Azure SQL Analytics, you will rediscover the new ways to manage the Azure SQL Database. Microsoft is driving an intelligent platform to provide seamless collaboration for all their end users to business analysts, by building an effective Log Analytics stack and intelligent insight through dashboards.
Using Diskspd to test SQL Server Storage Subsystems
July 28, 2020In this article, we will learn how to test our storage subsystems performance using Diskspd. The storage subsystem is one of the key performance factors for SQL Server because SQL Server storage engine stores database objects, tables, and indexes on the physical files. Therefore, the storage engine always interacts with the disk subsystem because of […]
Migrating SQL workloads to Microsoft Azure: Services Selection
July 28, 2020In the previous article, Migrating SQL workloads to Microsoft Azure: Planning the jump, we discussed the main points that should be checked and considered while drawing your plan to migrate the SQL workload from the on-premises datacenters to Microsoft Azure. In this article, we will go through the different database services that are provided by […]
Learn MySQL: What is pagination
July 27, 2020In this article, I am going to explain that in MySQL, what is pagination and how we can implement it. When we are populating a large dataset from the MySQL database, it is not easy to read all the records on the same page. Using pagination, we can divide the result-set into multiple pages, and […]
Understanding the SQL MERGE statement
July 27, 2020In this article, I am going to give a detailed explanation of how to use the SQL MERGE statement in SQL Server. The MERGE statement in SQL is a very popular clause that can handle inserts, updates, and deletes all in a single transaction without having to write separate logic for each of these. You […]
Migrating SQL workloads to Microsoft Azure: Planning the jump
July 27, 2020In this article, we will discuss several points that should be considered when planning to migrate the on-premises SQL workload to Microsoft Azure cloud services. This article is the first step in a series of articles that discuss how to perform the SQL and No-SQL workload migration smoothly to the cloud.
Page Life Expectancy (PLE) in SQL Server
July 17, 2020Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory. Page Life Expectancy value indicates the memory pressure in allocated memory to the SQL Server instance. In most of the cases, a […]
SQL Server 2019 Memory-Optimized TempDB Metadata
July 16, 2020In this article, I will walk you through the new feature in SQL Server 2019, memory-optimized TempDB metadata. The most commonly faced performance problems in SQL Server world is known to be TempDB resource contention. Don’t you agree? Let us find the answer in this article.
Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups
July 15, 2020In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations.
Configure failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups
July 14, 2020This article explores the configuration of Windows failover clusters, storage controllers, and quorum configurations for SQL Server Always On Availability Groups.
A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016
July 13, 2020In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration.
Improve readability with SSAS Perspectives
July 9, 2020Introduction In this article, we will be looking at a feature of SQL Server Analysis Service (SSAS) OLAP Cube that is SSAS Perspectives. We discussed creating SSAS OLAP Cubes in a previous article: OLAP Cubes in SQL Server. In an SSAS OLAP cube, there can be a large number of measures, dimensions and dimension attributes. […]