Introduction In SQL Server there are several kinds of SQL partitions. However, in general, we can say that a partition is a way to divide a table (sometimes a view) into smaller pieces for performance purposes. In this article, we will explain what partition does mean for a table partition and SSAS. We will also […]
This article deploys a SQL Server container using Azure Kubernetes Services (AKS).
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 use Power BI Desktop to analyze key influencers in a dataset and learn how to use the corresponding visualization as well.
In this article, we are going to learn about the OPENQUERY function. It is used to run an ad-hoc distributed query on the remote data source using the linked server. There are various ways to query the remote data source. You can read this article, Querying remote data sources in SQL Server, to learn more […]
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.
We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics: What are Notebook Views? Where can you find Notebook Views? How do you create a new view? How do you modify an existing view? Where can you […]
The goal of this article is to throw light on the less-known points about SQL Server statistics.
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 intends to give some beneficial suggestions that help to write a more readable T-SQL query.
Introduction For a recent Tsql development project involving text document records, the customer wanted a product that would show the latest and most recent earlier version of specific document text stored in a SQL Server 2014 database. One result set row had to hold all relevant information for each document: both document versions as described […]
The SQL MIN function is an aggregate function that is used to find the minimum values in columns or rows in a table.
In this article, we are going to learn about the CREATE TABLE statement. This article consolidates the various scenarios. I have covered the following scenarios.
This article explores the database-level roles in the Azure SQL Database.
This article gives fundamental insights into which 5 reasons can cause to drop off the query performances in SQL Server.
In this article, we are going to learn how we can drop the temp table in PostgreSQL. The temp table is used to store data temporarily. Suppose you want to format or manipulate the data using aggregate and string functions. So instead of processing and formatting the data in the base table, it is preferred […]
In this article, we will learn how to add natural language-based data exploration capability to Power BI reports.
Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure Data Studio, or applications for query data.
This article will explain various aspects of security testing for the SQL Server environment. Security is a very critical area for any database environment. We must properly plan, deploy, and audit database security measures to protect and prevent any unauthorized access of the data. We should also perform regular security testing to ensure we have […]
The database contains business, customer sensitive and confidential data. Therefore, securing the database environment is the prime responsibility of a database administrator. If you plan to host your databases in Microsoft Azure, you can choose the platform as a service solution – Azure SQL Database. The Azure SQL DB is a fully managed database service; […]
The goal of this article is to give details about the database query parameterization feature and explain its effects on query performance.
In this article, we will take a walk-through of the Power BI Desktop user interface and features provided to author reports.
In this article, we will learn how to create a table in PostgreSQL. I am going to explain the following topics:
This article explores the process of table partitioning in Azure SQL Database and explains how it differs from on-premises SQL Server.
In this article, we will learn the basics of working with views in the Azure Database for PostgreSQL.
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy
