Hadi Fadlallah
SSIS OLE DB Destination SQL command Query builder

Data Access Modes in SSIS OLE DB Destination: SQL Command vs. Table or View

October 5, 2021 by

This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode. In a previously published article, SSIS OLE DB Destination vs SQL Server Destination, in this series, we explained the OLE DB Destination component in SSIS and illustrated how it differs from the SQL Server Destination component. So, in this article, we will focus on the OLE DB Destination data access modes, not the component itself.

Read more »
Dinesh Asanka
Distribution of documents for positive and negative labels.

Text Classification in Azure Machine Learning using Word Vectors

October 1, 2021 by

This article discusses how to perform Text classification in Azure Machine using a popular word vector technique in Text Mining. This article is part of the Azure Machine learning series during which we have discussed many aspects such as data cleaning and feature selection techniques of Machine Learning. We further discussed how to perform classification in Azure Machine Learning and we will be utilizing some of those experiences here. Further, we have discussed several machine learning tasks in Azure Machine Learning such as Clustering, Regression, Recommender System and Time Series Anomaly Detection. With respect to text mining, we have discussed techniques such as Language Detection, Named Entity Recognition, LDA, Text Recommendations, etc.

Read more »
Aveek Das
Using RANK and DENSE_RANK Functions in MySQL

Overview of MySQL Window Functions

October 1, 2021 by

In this article, we are going to learn about the different types of MySQL Window Functions and how to use them as per different use cases. MySQL is one of the most commonly used databases in the software world today. Almost every other web application running uses MySQL as a database, either on-premise or on the cloud. It becomes extremely necessary for developers and database users to master their querying abilities such that they can query the databases as per the requirements and produce suitable results. In this article, we are going to focus on the MySQL Window Functions and how to use them with practical examples. An important point to note is that most of the MySQL Window Functions are applicable only to versions 8 or higher.

Read more »
Manvendra Singh
Check encryption state after TDE SCAN

Understanding the TDE SCAN process in Transparent Data Encryption

September 30, 2021 by

Transparent Data Encryption is a SQL Server feature that is used to protect data stored in SQL Server databases. The process to enable TDE on any user database is a straightforward method. Once we enable TDE on any user database, SQL Server performs a scan for each data page into the buffer pool and then writes the encrypted pages back to disk. The process of scanning each data page is known as TDE scan. Any database is fully encrypted once the TDE scan will be completed for all data pages of the database.

Read more »
Nisarg Upadhyay
SELECT Query with space in columns name without errors

How to write SQL queries with spaces in column names

September 29, 2021 by

In this article, we are going to learn how we can write a SQL query with space in the column name. Blanks spaces are restricted in the naming convention of the database object’s name and column name of the table. If you want to include the blanks space in the object name or column name, the query and application code must be written differently. You must be careful and precise while writing dynamic SQL queries. This article explains how we can handle object names and columns with blank space in SQL Server and MySQL.

Read more »
Manvendra Singh
Check Transparent Data Encryption state after removing TDE

Remove Transparent Data Encryption (TDE) from SQL Server user databases

September 24, 2021 by

Transparent Data Encryption is getting popular these days because every business owner is serious about protecting their data. Everybody wants to use the latest encryption technologies to make sure their systems are more secure and stable. SQL Server also offers some encryption features to protect client’s data like TDE (Transparent Data Encryption), Always Encrypt, etc. Sometimes, business wants to transform their existing encryption solution by implementing its advance versions or encryptions. You must remove the existing encryption solution before implementing any newer solution.

Read more »
Aveek Das
Queue Function triggered - Queue Storage in Azure

Triggering Function Apps from Azure Queue Storage

September 23, 2021 by

In this article, we are going to learn how to trigger Function Apps from Queue Storage in Azure. Function Apps has been one of the most popular cloud services of Microsoft Azure. Function Apps allow users to write code in any language and then execute the code in the cloud. There is no infrastructure to be managed and hence is very flexible for writing and building applications on the go. Every Function App can be triggered in multiple ways, for example, by calling the function URL using an HTTP endpoint or from some other functions in Azure. In this article, we are going to trigger the Function App from Queue Storage in Azure and see how to pass a message from the queue to the Function App.

Read more »
Dinesh Asanka

Building Ensemble Classifiers in Azure Machine Learning

September 21, 2021 by

Introduction

This article is the newest addition to the article series of Azure Machine Learning which is Ensemble classifiers in Azure Machine Learning. During this article discussion, we have focused on data cleaning and feature selection techniques of Machine Learning. Further, we have discussed several machine learning tasks in Azure Machine Learning such as Classification, Clustering, Regression, Recommender System and Time Series Anomaly Detection. Further, we discussed AutoML features that are available with Azure Machine Learning Services. In the AutoML techniques, we have identified how to utilize Classification in AutoML. This article is an extension of the classification techniques that we discussed before.

Read more »
Manvendra Singh
Check transparent data encryption state of tempdb and user database after enabling it

Impact of TDE (Transparent Data Encryption) on Tempdb databases

September 15, 2021 by

This article will explain the impact of TDE (Transparent Data Encryption) on one of the crucial system databases, tempdb. Everybody wants to secure their data to prevent unauthorized access and use. SQL Server is a very popular enterprise RDBMS system that is used to store client’s data inside their databases. It also offers multiple features to secure the data stored in the databases. TDE (Transparent Data Encryption) is one of those features which is used to secure SQL Server databases by encrypting their database files. TDE protects data by applying encryption using a certificate which is also protected by the master key.

Read more »
Aveek Das

Getting started with the Azure Queue Storage using Python

September 14, 2021 by

In this article, we are going to talk about the Azure Queue Storage service using python as a programming language. As it goes by the name, Azure Queue Storage is a simple queue and messaging service in Azure that can be used to build queues and process messages in an asynchronous fashion. Queues help to decouple multiple systems and provide the middle layer in a distributed architecture. The Queue Storage service in Azure allows users to connect to and store messages up to 64 KB in size from anywhere in the world. It is exposed by using HTTP or HTTPS endpoints and can contain millions of messages that need to be processed.

Read more »