This article explains the process to configure the ODBC driver for oracle 19c. I am covering the following topics:
Read more »Advanced options in Azure Blob Storage accounts
December 8, 2021In this article, we will learn how to create an Azure Blob Storage account and understand all the different configuration options and their impact on the blobs stored in the account.
Read more »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.
Read more »SQL Update statement Performance Tips
December 7, 2021The SQL update statement is used to modify an existing record or records in a table and it is commonly widely used in databases applications. In this article, we will examine the update statement in terms of the performance perspective.
Read more »An overview of Power BI Incremental Refresh
December 6, 2021In this article, we are going to talk about Power BI Incremental Refresh. Power BI is the cloud-based business intelligence tool developed by Microsoft. Using Power BI, users can create various kinds of modern reports and dashboards that provide insights and information of their data in a meaningful way. Power BI is a strong and independent BI tool that is available for both Windows desktop and also the cloud. In order to demonstrate the capabilities of Power BI Incremental Refresh, we will leverage Power BI Desktop to develop and author the data model and then publish it to the Power BI cloud where it will be refreshed incrementally.
Read more »Configure a Linked Server between SQL Server and PostgreSQL using ODBC drivers
December 6, 2021This article explains configuring a linked server between SQL Server 2019 and PostgreSQL. In my previous article named Configure ODBC drivers for PostgreSQL, we got introduced to the ODBC driver of PostgreSQL. We also learned how we could download, install, and configure it. In this article, we will explore how we can utilize the ODBC driver to access the data of the PostgreSQL from SQL Server 2019.
Read more »Understanding the SQL MIN statement and its use cases
December 3, 2021Today, I will explain an overview of the SQL MIN () function along with its several use cases in this article. This function is categorized under aggregate functions in SQL Server. Aggregate functions perform a calculation on a set of values from a specified expression and return a single value in their output. Aggregate functions return the same value every time you execute them unless your source data is changed.
Read more »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.
Read more »SQL Server Trace Flags and how they impact the SQL Server Query Optimizer behavior
December 2, 2021In this article, we will learn some query hints and trace flags that impact the query performance and also influence the SQL Server query optimizer’s default execution plan generation algorithm.
Read more »Centralizing data validation with domains in Azure Database for PostgreSQL
December 2, 2021In this article, we will learn how to work with domains in Azure Database for PostgreSQL and learn how to use it with tables to centralize the constraints logic that would be applied across tables.
Read more »How to download and install SQL Server 2016 express edition
December 2, 2021In this article, you are going to learn about SQL Server 2016 express download and installation process. The SQL Server 2016 express edition is a free version of SQL Server that offers limited features. The express edition of SQL Server can be used in any of the following scenarios:
Read more »BCP for import and export data in Azure SQL Database
December 1, 2021The Bulk Copy Program (BCP) utility can move bulk data between SQL Server instances. You can export SQL Server data into BCP files. You can also use them for moving data from on-premises SQL Server instances to Azure SQL Database. The BCP files do not contain schema or the format information of your data. Therefore, you cannot use it as a database migration tool. However, it is adequate to import or export many rows. However, you need to create the table or use a format file to import data into a table.
Read more »Table Inheritance in Azure Database for PostgreSQL
November 30, 2021In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL.
Read more »How to restore an Azure SQL Database
November 30, 2021I will explain how to restore an Azure SQL database in case you need to recover some data, or somebody has deleted your database in this article. Databases restore is the common activity a DBA performs in his day-to-day activities to meet various business requirements. We should also perform regular restores to ensure our backups are healthy and restorable in case of any emergency. Here, I will create an Azure SQL database named TestDB along with a table Employee inside this database and then recover them by restoring its automatic backups.
Read more »Migrate encrypted columns data from on-premises to Azure SQL Database
November 29, 2021Azure SQL Database is a cloud database hosted on Microsoft’s Azure platform. It is an enterprise-grade database service that supports a wide range of advanced features, and it can be used to store and process data. Customers can migrate data from an on-premises SQL Server without downtime and minimal disruption.
Read more »Transfer error messages between SQL Server instances using SSDT 2017
November 29, 2021This is the fourth article in the series of Migrating SQL Server Objects using SSDT 2017. In the third article, we learned how we could transfer SQL logins between the servers. In this article, we will learn how to copy error messages to another instance using the Transfer Error Messages Task of SSDT 2017.
Read more »Working with Date and Time Functions in PostgreSQL
November 26, 2021Working with Date and Time calculations is an integral part of any Data Analytics solution. Be it financial data or any data related to sales, dates always play a pivotal role in analyzing the trends and hence draw a pattern out from them. Some of the most commonly used KPIs that involve date and time calculations are monthly sales, quarterly web traffic, year-over-year growth etc. These KPIs help businesses understand and gauge their performance and also aids in making decisions necessary for their development. In this article, we are going to explore some of the important Date and Time functions that can be used in PostgreSQL and how they can be implemented henceforth.
Read more »Using tables as templates in Azure Database for PostgreSQL
November 26, 2021In this article, we will learn how to create a new instance of Azure Database for PostgreSQL as well as understand how to use existing tables as templates while creating new tables.
Read more »SSIS term extraction vs. term lookup
November 25, 2021This article explains both the SSIS term extraction and term lookup components. Besides, it illustrates the use cases of each one of them.
Read more »Go LSN in SQL Server
November 25, 2021Introduction
If you are reading this article is because you read about the SQL Server transaction log and you want to go to the LSN to restore information. This article will explain what is the LSN and show some tables, views, and system functions used to retrieve LSN information. We will also learn how to restore information using the Transaction Log information. We will also find out if there is a Go LSN command. So, if you want to learn more about the transaction log and want to recover some information using the logs, you are in the right place.
Read more »Managing Retention period of Azure SQL Database Backup
November 24, 2021Azure SQL Database is a fully managed SQL Server database engine based on the latest stable version of SQL Server enterprise edition. This is Database as a Service offering under the PaaS model in the Azure cloud. It offers in-built high availability capability and reduces the manageability efforts by automating administration activities like backups, patching, etc. Backups are managed automatically by Azure for all PaaS database deployments. This article will explain one of the configuration item retention periods of Azure SQL database backups.
Read more »Hybrid Buffer Pool in SQL Server 2019
November 23, 2021This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019.
Read more »Understanding Summarization and Aggregation in DAX Functions
November 23, 2021In this article, we are going to learn about the various DAX functions that are available for the summarization and aggregation of data. DAX, abbreviated as Data Analysis Expressions, is developed by Microsoft as a scripting language to interact with the Microsoft Business Intelligence stack, such as Power BI, SSAS Tabular, Power Pivot, etc. If you have prior experience working with Microsoft Excel, learning DAX Functions will not be too much of a hassle for you. One of the most popular tools in the BI market that uses DAX Functions is Power BI. Power BI can be used without using DAX, however, using DAX Functions in Power BI helps us to build powerful data models which also helps in performance optimization.
Read more »SQL commands in SQL Server
November 22, 2021Introduction
If you are here, it means that you want to learn the SQL commands. This article applies to SQL Server especially, but most of the theory is similar to Oracle, MySQL, MariaDB, PostgreSQL, and other databases. The SQL commands are instructions that we send to the database to get information, manipulate the information or create objects, modify them, and handle the access to the information.
Read more »INDEXPROPERTY() function in SQL Database
November 22, 2021This article will give an insight into the INDEXPROPERTY() function in SQL Databases.
Read more »