This article will show how to catalog data assets and then tag business glossaries at the attribute level of data assets in Azure Purview.
Read more »
Copy Data tool to export data from Azure SQL Database into Azure Storage
October 29, 2021DBA may import, export regularly within a different environment. You might receive data in a specified format for importing it into database tables.
Read more »
Install and configure SSDT 2017 on Windows 10
October 28, 2021In this article, we are going to learn how we can install and configure the SSDT 2017 on Windows 10. The SQL Server data tools 2017 (SSDT 2017) is a development tool used for database development, SQL Server analysis service data models, SQL Server report service reports, and Integration service packages.
Read more »
Defining Business Glossary with Azure Purview
October 27, 2021In this article, we will explore Azure Purview capability and understand it with a practical walkthrough.
Read more »
SQL Syntax Checker Tools
October 27, 2021In this article, we will look at the 2 different SQL syntax checker tools that help to find the syntax errors of the queries without executing them.
Read more »
Automatic Index advisor in Azure SQL database
October 26, 2021This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »
SQL Server Interview questions and answers
October 25, 2021This article will help you to learn and prepare SQL Server interview questions and answers. If you are looking for a job change or want to improve your interview skills, then you must go through with this article along with questions & answers given in this article. I have tried to answer each question in a very precise manner which most interviewers want to listen to these days.
Read more »
Creating metadata-driven data pipelines using Azure Data Factory
October 25, 2021In this article, we will learn how to build metadata-driven pipelines using Azure Data Factory.
Read more »
Configure ODBC drivers for PostgreSQL
October 22, 2021In this article, we are going to understand the process to configure the ODBC driver for PostgreSQL. For the demonstration, I have installed PostgreSQL on my workstation. The details of the server and database are following:
Read more »
SQL LEFT function in queries
October 22, 2021In this article, we will learn how to use SQL LEFT function with straightforward examples.
Read more »
High Availability in Azure Database for PostgreSQL
October 21, 2021In this article, we will learn about the high availability features recently introduced in Azure Database for PostgreSQL.
Read more »
Upgrade SQL Server Management Studio (SSMS) along with Azure Data Studio
October 20, 2021This article explains upgrading SQL Server Management Studio (SSMS) and Azure Data Studio (ADS) to their latest version with a single installation.
Read more »
SQL Interview questions and answers
October 20, 2021This article will walk you through some SQL interview questions and answers to help you with a job change or if you want to improve your interview skills. I have also tried to attach supporting articles for each question to help you learn more in-depth about the specified topics. I tried to answer each question in a very precise manner which most the interviewers want to listen to these days. If you want to learn more about the topic asked, you can visit the attached link given for that question.
Read more »
Creating databases in Oracle 19c using the Database Configuration Assistant
October 19, 2021In this article, we understand how to create a new database in Oracle 19c using a database configuration assistant. The database configuration assistant allows us to create a new database using a pre-defined template or create a database with various configuration options. In this article, we are going to learn both methods.
Read more »
An overview of SQL Comments
October 19, 2021In a typical database, we have multi lines or page SQL statements in a view, SQL statement or the stored procedure. Also, multiple developers change the T-SQL, and it becomes difficult to track who altered the code and for what reason.
Read more »
Visualizing data with dashboards in Azure Databricks
October 18, 2021In this article, we will learn how to create dashboards using the data that is typically processed using notebooks in Azure Databricks.
Read more »
How to use SQL Check Constraints
October 15, 2021This article intends to give comprehensive information about the usage and other details of SQL check constraints.
Read more »
SQL Server Extended Events Causality Tracking
October 14, 2021This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues.
Read more »
Performance impact analysis of enabling Transparent Data Encryption (TDE) on SQL Server
October 14, 2021Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to secure your data in a temporary space. The process of encryption and decryption adds additional overhead to the database system. Even non-encrypted databases hosted on the same SQL Server instance would have some performance degradation because of tempdb encryption. Today I will show you performance impact analysis using few simple T-SQL statements by comparing their stats gathered before and after enabling TDE.
Read more »
Populating Delta Lake Tables in Azure Databricks with Azure Data Factory
October 13, 2021In this article, we will learn how to populate delta lake tables into Azure Databricks from Azure SQL Database using Azure Data Factory.
Read more »
Installing Oracle 19c on Windows Server 2019
October 13, 2021In this article, we understand the step-by-step installation process of Oracle 19c on Windows Server 2019. The minimum hardware requirement to install an Oracle database server is following:
Read more »
Monitoring SQL Server blocking problems
October 12, 2021In this article, we will learn how to monitor SQL Server blocking issues with different methods.
Read more »
Creating Delta Lake Tables in Azure Databricks
October 11, 2021In this article, we will learn how to create a delta table format in Azure Databricks.
Read more »
Overview of Power BI Time calculations
October 11, 2021In this article, we are going to understand the various types of Power BI time calculations and how to implement these calculations. We will also understand the reason behind implementing such time-based calculations and the importance of these in the real world. The Power BI time calculations are also known as Time Intelligence functions that can be applied in DAX. There are a lot of functions available under Time Intelligence and you can read about it in detail from the official documentation from Microsoft.
Read more »
How to manage SQL Server logs effectively
October 8, 2021This article covers an overview of SQL Server logs for monitoring and troubleshooting issues in SQL Server.
Read more »