Different methods for monitoring MongoDB databases
June 14, 2023This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases.
Search Results for: in memory
Understanding the Scalability in Oracle Database
March 9, 2023When an application grows the associated database grows automatically. It needs to be scaled to a larger machine or server and overall configuration needs to be increased to handle the application and database performance requirement.
Top Power BI Interview Questions and Answers
January 31, 2023Microsoft Power BI is a very popular data visualization tool. In this article, we will discuss the most frequently asked Power BI Interview Questions and Answers.
Use of the RESTORE FILELISTONLY command in SQL Server
December 21, 2022This article explores the RESTORE FILELISTONLY command in SQL Server with examples. Introduction Performing a database backup is an integral part of a DBA’s job. Backups are taken to ensure that data can be recovered in an emergency. There are different restore mechanisms, and the SQL Server DBA needs to understand them to make the […]
INT vs BIGINT in SQL Server with Examples
November 22, 2022SQL Server provides int, bigint, smallint and tinyint data for storing exact-number data. In this article, we will focus on int and bigint data types.
Getting started with MySQL on AWS: Costs, Setup, and Deployment options
November 11, 2022This article will show the basics of hosting MySQL databases in Amazon Web Services (AWS).
How to identify suitable SKUs for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM
October 28, 2022The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM. Every database might have different resource requirements, and we need to choose the correct DB sizing based on the current workloads.
Manage SQL Databases in CentOS: Backup and Restore SQL Database
September 12, 2022In this article, we will learn how we can backup and restore the SQL Database in CentOS. This article is the second article on the topic Manage SQL Server on CentOS. In my previous article, Install SQL Server on CentOS, we learned how we could install and create a SQL Database in CentOS.
Deploy a SQL Server container using Azure Kubernetes Services (AKS)
August 31, 2022This article deploys a SQL Server container using Azure Kubernetes Services (AKS).
Managing file groups of SQL Databases
August 8, 2022IN this article, we are going to learn how we can manage the filegroup of SQL Database in SQL Server. The SQL Server has four filegroups.
SQLPackage utility to export Azure SQL Databases
August 1, 2022Azure SQL Database does not support native database backups. Therefore, you cannot use it to move from the Azure cloud to on-premises SQL Server. You can use the data-tier application BACPAC file format for exporting database schema and data from the Azure database. This BACPAC file is helpful to deploy on an Azure SQL Database, […]
How to overcome parameter sniffing problems in ad-hoc queries
June 17, 2022The purpose of this article is to provide insights into how parameter sniffing occurs for an ad-hoc query and how it affects their performance.
How to become a SQL Server Developer
May 20, 2022In this article, we will talk about what SQL Server developers do and which main skills are required to get a job as a SQL developer.
5 reasons to consider on your Query Performance degradation
April 7, 2022This article gives fundamental insights into which 5 reasons can cause to drop off the query performances in SQL Server.
SQL Server Dedicated Administrator Connections for Azure SQL Database
March 29, 2022This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.
Azure Functions for Azure SQL Database
March 10, 2022As a Platform as a Service (PaaS) service, Azure SQL Database enables developers to deploy SQL Database in Azure Cloud without managing the infrastructure. We use SQL Server Agent to schedule jobs to run at a specific schedule in an on-prem SQL instance. However, Azure DB does not have agent functionality.
Scalar UDF Inlining for Azure SQL Database
February 2, 2022This article explores the scalar UDF performance issues and improvements in Azure SQL Database using UDF Inlining.
Deploying Azure Container Instances using YAML
January 21, 2022The Azure Container Instances provides a flexible solution for implementing container-based images in Azure infrastructure quickly. It does not require building the virtual machine, installing applications like Microsoft SQL Server, or configuring the software. You can choose the container images from the libraries and build solutions. You can use non-persisted(default) and persisted storage to avoid […]
Azure SQL – a FAQ article
January 12, 2022Introduction In this article, we will talk about Azure SQL. The article will compile the FAQ about this topic. The article will cover FAQ related to concepts for newbies, prices, some common features, migration and several links for references to get higher details on specific topics.
Getting started with SQL Server CLR functions
January 11, 2022This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then, we will use the C# […]
Monitoring SQL Server TempDB with Dynamic Management Views
December 29, 2021In this article, we will learn how we can detect which operations cause to fill up SQL Server tempdb through the dynamic management views.
Use ARM templates to deploy Azure container instances with SQL Server Linux images
December 21, 2021The Azure Resource Manager (ARM) template is a JavaScript Object Notation (JSON) file for deploying Azure resources automatically. You can use a declarative syntax to specify the resources, their configurations. Usually, if you need to deploy Azure resources, it might be a tiring experience of navigating through different services, their configurations. With the ARM templates, […]
Store SQL Server files in Persistent Storage for Azure Container Instances
December 10, 2021In the articles, Deploying Azure Container Instances for SQL Server 2019 and Create Azure Container Instances for SQL Server 2019 using Azure CLI, we explored Azure Container Instances for SQL Server on Linux. These containers are stateless. Therefore, if you stop or restart container instances, you lost your data. Suppose, being a developer, you created […]
Create Azure Container Instances for SQL Server 2019 using Azure CLI
December 8, 2021This article explores Azure CLI scripts for deploying Azure Container Instances with SQL Server 2019 image.
Deploying Azure Container Instances for SQL Server 2019
December 3, 2021This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal.