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.
Read more »

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.
Read more »This article will show some important questions and answers to practice SQL.
Read more »This article will describe Azure blob storage, its features along with its uses in SQL Server. I have explored the basics of Azure storage in my last article, “Getting started with Azure Storage”, I would recommend you read this article to learn various storage options available in Microsoft Azure. The blob storage is one of the storage options offered under Azure storage discussed in this article.
Read more »This article will explain the Access Tier property of Azure storage. I will also explain how to change access tiers of an Azure storage account and for a specific blob object in this article. We have explored the basics of Azure storage in my last articles below which I would suggest you read to understand Azure blob storage.
Read more »This article will explain the steps of upgrading the Azure blob storage account type from legacy storage account type BlobStorage or GPv1 to GPv2. Microsoft Azure keeps on adding and upgrading their services. They also persuade customers to upgrade their services which were initially provisioned on older or legacy versions. This article will discuss steps about upgrading the Azure blob storage account that is running on standard performance tier GPv1 or BlobStorage to its latest version standard performance tier GPv2.
Read more »In this article, we will explore Microsoft SQL Server trace flags with all aspects, and we will learn also how to use them.
Read more »This article explores the database-level roles in the Azure SQL Database.
Read more »This article will explain Azure storage explorer, its installations, and details of how to start working with this application to access Azure storage services. Azure storage provides a flexible solution to store various types of data at a massive scale in the cloud environment. If you have many storage accounts in Azure storage, then it will be difficult to manage them. Microsoft has recognized this problem and developed a desktop application Azure storage explorer to manage Azure storage accounts easily. It can be installed on Windows, Linux, and macOS operating systems.
Read more »This article gives fundamental insights into which 5 reasons can cause to drop off the query performances in SQL Server.
Read more »This article is for discussing fixed server roles in Azure SQL Database Server.
Read more »This article will help you understand the Azure storage options available in the Microsoft Azure cloud. Microsoft Azure provides various services to store data depending on their type, nature, shape, and size. Data could be anything like an image, a video, a text file, a database file to store customer’s data, or data that comes from a digital medium like online retail websites or YouTube, etc. There are various types of data available, and one storage solution cannot fit all distinct types of data storage requirements.
Read more »This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.
Read more »The article Configure IP firewall rules for Azure SQL Databases, discuss the configuring server and database IP firewall rules for Azure databases. In this article, we will explore setting applicable to Azure databases that control connectivity to the database.
Read more »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 to populate data from the base table and store it in a temporary table. You can process and format the data stored in a temporary table. The syntax to create a temporary table and regular table are the same. You can add indexes, constraints, statistics to the temporary tables. In this article, we are going to learn the following topics:
Read more »The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the database infrastructure.
Read more »In this article, we will learn how to add natural language-based data exploration capability to Power BI reports.
Read more »As 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.
Read more »In this article, we will learn the use of decomposition trees in Power BI and learn how to use it to analyze data using the visual as well as the AI built into this visual.
Read more »In this article, we are going to learn how we can create an SSRS report to populate the data from PostgreSQL 13 using SSDT 2017.
Read more »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.
Read more »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 right set of rules and policies in place to secure our database environment. Database security measures also help any organization to protect its data to maintain its privacy and integrity.
Read more »In this article, we are going to learn how we can copy database objects between two databases of different instances of SQL Server. Sometimes, we receive the request to provide the specific database object to another database. To fulfill this requirement, instead of using Generating the T-SQL script for each object and export data using import-export task, we can use the Transfer SQL Server Object task of SSDT 2017. In this article, we will understand how we can transfer the database objects of a specific schema to another database.
Read more »In this article, we will learn how to analyze the performance of Power BI Desktop reports using the Performance Analyzer.
Read more »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; therefore, you do not get full access to SQL Server features, databases.
Read more »In this article, we will learn how to user slicers to filter data in a Power BI report.
Read more »© 2022 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy