This article will take you through the process to apply Dynamic Data Masking on the dedicated SQL pool of Azure Synapse Analytics.
Read more »Setting up a PostgreSQL Database on Mac
April 23, 2021In this article, I am going to discuss different ways in which you can install and setup Postgres Database on a Mac. Postgres is an open-source relational database system that can be used to develop a wide variety of data-based applications. Postgres has been popular for analytical workloads as well since it has support for column-store index and in-memory storage as well. Postgres is also available on all the major public cloud services like AWS, Azure, and GCP. In order to use those services, it is recommended that you should also have them installed on your local machine before deploying your databases to the cloud directly.
Read more »Lift and Shift SSIS packages using Azure Data Factory V2
April 23, 2021This article will explore the process for Lift and Shift SSIS packages to Azure using Azure Data Factory V2.
Read more »Hidden secrets of SQL Server Foreign Keys
April 21, 2021This article will describe the effect of SQL Server foreign keys on query plans which are created by the query optimizer.
Read more »SQL Definition
April 21, 2021Introduction
In this article, we will provide a SQL definition and we will explain what it is, and we will also talk about the SQL extensions. We will also provide some examples of SQL Syntax.
Read more »Automate consistency checks of SQL database using Windows Task Scheduler
April 20, 2021The SQL database integrity check is one of the most crucial and important tasks of the database administrator. The database integrity task checks the structural integrity and allocation of all database objects and indexes. The integrity checks can be performed by using the DBCC CheckDB command. The CheckDB command is used to identify the corruption in the database. The command performs the following operations on the database.
Read more »Spinning up MySQL instances on RDS using CloudFormation Templates
April 20, 2021In this article, we are going to discuss how to set up a MySQL instance on AWS RDS using Cloud Formation templates. In my previous article, How to configure an Amazon RDS environment for MySQL, I have provided a detailed walkthrough of how to set up a MySQL instance on Amazon. You can use the AWS console to provide all the information required for setting up the instance and then use it. However, in this article, we will discuss an automated way of achieving the same functionalities using Cloud Formation templates.
Read more »Azure Automation: Automate Pause and Resume of Azure Analysis Services
April 20, 2021This article explores Azure Automation for the change state of Azure Analysis Services.
Read more »Sourcing data from Azure SQL Database in Azure Machine Learning
April 19, 2021In this article, we will show how to source data from Azure SQL Database to use in a Machine Learning workflow.
Read more »Direct Query Mode in Power BI for Azure Analysis Services
April 19, 2021In this article, we will explore Direct Query Mode in Power BI for Azure Analysis Services.
Read more »SQL Server Performance Tuning made simple
April 19, 2021In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it.
Read more »Understanding Execution Plans of the SQL Server Insert statement
April 16, 2021In this article, we will learn how to interpret an execution plan of a SQL Server insert statement.
Read more »Working with parameters in the sp_executesql stored procedure
April 16, 2021This article explains how to use the sp_executesql system stored procedure to run static and dynamic SQL queries and how to pass input and output parameters while using it.
Read more »Automate SQL database backups using Windows Task Scheduler
April 15, 2021In this article, we will learn how we can automate the backup of SQL database created in SQL Server Express edition. SQL Server Express edition is a lightweight database that has limited functionalities and resource allocation. The SQL Server Express edition does not support SQL Server Agent jobs, so it is tricky to automate various database administration tasks.
Read more »Azure Analysis Services and Power BI Live connections
April 14, 2021In this article, we will deploy Azure Analysis Services and create a live connection in the Power BI.
Read more »Designing Recommender Systems in Azure Machine Learning
April 13, 2021In this article, we will be discussing how to design a Recommender System in Azure Machine learning which is the next article in the Azure Machine Learning series. During this lengthy article series on Azure Machine Learning, we have discussed multiple machine learning techniques such as Regression analysis, Classification Analysis, Clustering and Anomaly detection of Time Series. Further, we have discussed the basic cleaning techniques, feature selection techniques and Principal component analysis, Comparing Models and Cross-Validation and Hyper Tune parameters in this article series to date.
Read more »Export compressed data from Azure SQL Database
April 12, 2021This article will walk you through the way to export data out of Azure SQL Databases in a compressed format using Azure Data Factory.
Read more »Introduction to Apache Spark
April 12, 2021In this article, I am going to discuss Apache Spark and how to create robust ETL pipelines for transforming big data. I will start from the very basics of Spark and then provide details on how to install Spark and start building the pipelines. In the later part of the article, I will also discuss how to leverage the Spark APIs to do transformations and obtain data into Spark data frames and SQL to continue with the data analysis.
Read more »An overview of Power BI data models
April 12, 2021Power BI is a business analytics solution provided by Microsoft. It helps you to create data visualizations from various data sources. We can import data from these data sources, create a data model, and prepares reports, visuals. These data sources are as below:
Read more »How to handle 100 million rows with SQL Server BCP
April 9, 2021In this article, we will explore the Bulk Copy Program tool that is also known as the SQL Server BCP tool. BCP allows us to export data into particular flat-file formats from SQL Server, and it also enables us to transfer data between different SQL Server instances or into the SQL Azure.
Read more »Automate rebuilding SQL Database indexes using Maintenance Plans
April 9, 2021Index maintenance is a vital part of a database administrator’s job. I have worked for few clients who often face performance issues in SQL Database and don’t have a dedicated DBA. I remember that one of our clients was facing performance issues. I logged in to their server and found that they did not set up any index maintenance jobs; therefore, many indexes were fragmented, causing the problem.
Read more »Visualizing data with Azure Data Explorer dashboards
April 8, 2021This article will help you understand the process of author dashboards using Azure Data Explorer to visualize data hosted in the clusters.
Read more »SQL Database unit testing in Azure Data Studio with tSQLt
April 8, 2021This article talks about unit testing SQL database in Azure Data Studio using the tSQLt testing framework.
Read more »Multi-language support for SSAS
April 8, 2021Introduction
After discussing many features in SQL Server Analysis Services (SSAS) in order to carry out much richer analytics activities, we are going to discuss another feature in SSAS named Multi-language support for SSAS. In a previous article, we discussed how to create SSAS OLAP Cubes and how to access the OLAP cube using Excel. Further, we discussed how to include hierarchies in SSAS in order to improve the data analysis capabilities. In addition to those features, we discussed how to create perspectives in OLAP Cubes and how to perform management activities in SSAS.
Read more »Stairway to SQL essentials
April 7, 2021SQL Essentials stairway series helps readers understand the most common database language SQL uses for data munging and data wrangling. SQL Essentials articles is a collection of SQL standards and best practices and help you take you in step closer to learn database query.
Read more »