This article will explore backup options available in the Azure Cosmos DB service. Backups are very important to safeguard our data in case of data corruption, data deletion, system failure, or any unforeseen circumstances like DR. We have planned, configured, and managed it for our on-prem databases whether it is SQL Server, Oracle, DB2, or […]
In this article, we will learn how to set up and configure Azure Data Explorer based data processing capability on Azure Synapse.
This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.
This article gives an overview and deployment steps for SQL Elastic Pool for Azure SQL database.
This article will get you started with Azure Synapse Lake Database and Lake tables.
Introduction In this article, we will answer the most common questions related to SSMS 2016 like these ones: What is SSMS 2016? How to install SSMS 2016? What SSMS versions exist? Is SSMS 2016 compatible with any SQL Server version? What changes were made in SSMS 2016? How to uninstall SSMS 2016?
The SQL Server Data Tools for Visual Studio 2015 are tools used for different purposes like: Working in relational database projects. Creating multidimensional or tabular databases in Analysis Services. Using Integration Service projects to import and export data. Building Reports in reporting services.
Azure storage is a core cloud storage service that is used by almost all application or database deployments. We use it in SQL Server for various requirements like for backing up our databases directly to blob storage or some clients prefer to host their databases in Azure blob storage to leverage snapshot backups functionality. Today, […]
In this article, we will learn how to perform Process Mining with Power BI.
This article will explore the importance of disk caching in Azure storage for SQL Server workloads.
Interested in becoming an Azure SQL DBA but don’t know how to start? This article prepares you for the Azure SQL DBA interview by providing reference material links.
In this article, we will learn how to build a customized widget in Azure Data Studio that helps to monitor the performance metrics.
This article will explore various Azure disk storage available for SQL Server workload running on Azure virtual machines. Suppose you have been tasked to migrate your on-premises SQL Server workload to the Azure cloud. Your client does not want significant change in architecture so you have decided to migrate with IaaS (Infrastructure as a service) […]
In this article, we will learn various methods of how to get an SQL execution plan of a query.
In this article, we will learn how to use smart narratives in Power BI to generate textual narratives that summarize the key highlights of the data presented in the report.
The purpose of this article is to provide insights into how parameter sniffing occurs for an ad-hoc query and how it affects their performance.
In this article, we will explore some internal working principles of SQL Server statistics.
The goal of this article is to throw light on the less-known points about SQL Server statistics.
This article will talk about the SQL WHERE statement.
This article will show Partitions in SQL Server and how they work.
SQL (Structured Query Language) is an ANSI/ISO standard programming language that is designed to program relational databases and T-SQL (Transact-SQL) is an extended implementation of the SQL for Microsoft SQL Server databases. T-SQL is highly used by database persons when they want to program or manage the SQL Server databases. However, the beginners may do […]
This article will cover testing or verification aspects of Type 2 Slowly Changing Dimensions in a Data Warehouse.
This article will explore an overview of Azure Cosmos DB, we will also discuss how to create Cosmos DB along with its uses on why we need to choose Cosmos DB.
In 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.
This article will show some important questions and answers to practice SQL.
© Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy