Query Optimization in SQL Server for beginners
April 5, 2021This article intends to give some details about the query optimization process in SQL Server.
Search Results for: INSERT
Overview and Performance Tips of Temp Tables in SQL Server
March 31, 2021In this article, we will learn the essentials of the temp tables in SQL Server and we will also discuss some performance tips about temporary tables.
Tune Model Hyperparameters for Azure Machine Learning models
March 25, 2021Introduction In this article, we will be discussing how to Tune Model Hyperparameters to choose the best parameters for Azure Machine Learning models. During this article series on Azure Machine Learning, we have discussed multiple machine learning techniques such as Regression analysis, Classification Analysis and Clustering. Further, we have discussed the basic cleaning techniques, feature […]
Learn MySQL: Control Flow functions
March 19, 2021In this article, we are going to learn about the most common control flow functions. The control flow function evaluates the condition specified in it. The output generated by them can be a true, false, static value or column expression. We can use the control flow functions in the SELECT, WHERE, ORDER BY, and GROUP […]
Ingesting data into Azure Synapse Analytics using PolyBase
March 19, 2021In this article, we will learn how to ingest data into Azure Synapse Analytics with a focus on using PolyBase to load the data.
Learn MySQL: MySQL String Functions
March 17, 2021In this article, we are going to learn about different MySQL String functions. The MySQL String functions can be categorized into the following:
Learn MySQL: Run multiple instances of MySQL Server on Windows 10
March 11, 2021This article explains how we can run multiple instances of the MySQL Server on a single machine. In How to install MySQL database server 8.0.19 on Windows 10 article, I have explained the installation process of MySQL on windows 10. For the demonstration, I have installed MySQL 8.0.19 on my workstation. We can view the […]
Customizing Differential and Transaction Log backups
March 10, 2021Introduction This article is dedicated to creating custom differential and Transaction log backups so that you will see sufficient data in the file size. In SQL Server there are mainly three backup types, Full Backup, Differential Backup, and Transactional Log backups. A Full backup will get the entire database into a backup.
Using Automatic Plan Correction for Query Tuning
March 4, 2021In this article, we will learn what is plan regression and how we can fix this issue with help of the Automatic Plan Correction feature.
Learn SQL: Dynamic SQL
March 3, 2021Dynamic SQL is a programming technique you can use to build SQL statements as textual strings and execute them later. This technique could prove to be useful in some cases and therefore it’s good to know we have it as an option. In today’s article, we’ll show how to create and execute dynamic SQL statements.
Learn MySQL: An overview of the mysqlbinlog utility
March 2, 2021The mysqlbinlog utility is used to process the binary logs of the MySQL server. Using mysqlbinlog utility, we can perform the following tasks:
Exporting data with Pandas in Python
February 24, 2021In this article, I am going to discuss the various ways in which we can use Pandas in python to export data to a database table or a file. In my previous article Getting started with Pandas in Python, I have explained in detail how to get started with analyzing data in python. Pandas is […]
Deploy Azure Data Lake Analytics database using the U-SQL scripts
February 23, 2021In this 3rd article of the Azure Data Lake Analytics series, we will explore deploying a database, tables using U-SQL scripts.
Elastic Jobs in Azure SQL Database
February 18, 2021Introduction I have dedicated this article to the topic of Elastic Jobs in Azure SQL Database which is in Public Review. This feature allows you to run scheduled tasks in your Azure SQL Databases. This is similar to SQL Server Agent you have in the On-prem SQL Server versions. However, in Elastic Jobs, you can […]
Modes of Transactions in SQL Server
February 17, 2021In this article, we are going to talk about the modes of transactions in SQL Server.
Join database tables using U-SQL scripts for Azure Data Lake Analytics
February 17, 2021In this article, we will explore joining database tables using U-SQL scripts for Azure Data Lake Analytics.
Advanced usages of Data-Tier applications
February 12, 2021In this article, I am going to explain some of the advanced usages of data-tier applications in Visual Studio. In my previous article, Working with Database Projects, I have explained how you can start building your database applications for SQL Server and Azure SQL Database using Visual Studio. This article will specifically focus on using […]
Transactions in SQL Server for beginners
February 10, 2021In this article, we will talk about fundamental details of the transactions in SQL Server.
Learn MySQL: An overview of MySQL Binary Logs
February 9, 2021In this article, we are going to learn about the concept of MySQL Binary Logs and their architecture. I am covering the following details in this article: An overview of MySQL binary logs and their architecture How to enable and disable binary logging View and change the location of the binary logs
Session timeouts in SQL Server Always On Availability Groups
February 8, 2021In this 41st article for SQL Server Always On Availability Groups, we will explore the session timeout configurations for AG replicas.
Learn MySQL: The Basics of MySQL Views
February 3, 2021In this article, we are going to learn about the fundamentals of MySQL Views. In this article, I am going to cover the following topics:
Dynamic Data Masking in SQL Server
February 2, 2021Introduction In this article, we will be looking at how to perform and access Dynamic Data Masking in SQL Server. Data Masking is the process of hiding data with different rules. One of the main reasons to apply data masking is to protect Personal Identifiable Information (PII) and sensitive data from unauthorized access. Even when […]
How to read an execution plan with all details
January 28, 2021In this article, we will discuss how to read the SQL Server execution plan (query plan) with all aspects through an example, so we will gain some practical experience that helps to solve query performance issues. Interpreting query plans correctly is the first and major principle to troubleshoot query performance issues. When we try to […]
A quick overview of database audit in SQL
January 28, 2021Database auditing is an important task that helps to guide the organization and can point out areas that can be improved, the cause of functions that aren’t quite working as intended, or simply monitoring activity for compliance with government or industry policies. At its core, an audit simply logs events that are happening on the […]
Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS
January 25, 2021There are multiple ways to deploy the databases in the AWS RDS SQL Server. Suppose you want to migrate your on-premises SQL Server database to AWS managed relational database service and you have a critical application and require minimal (almost zero) downtime. For this purpose, you can use the AWS Database Migration Service (AWS DMS) […]