In this article, we will explore the useful backtrack feature for Amazon Aurora clusters.
Read more »Creating your first Azure SQL Database
December 23, 2020Introduction
You might be thinking why do you want to create Azure SQL Database and what are the best configurations. This article will provide you with the basic configurations of the Azure SQL Database.
Read more »Building U-SQL jobs locally for Azure Data Lake Analytics
December 23, 2020This article will help you learn to develop U-SQL jobs locally, which once ready, can be deployed on Azure Data Lake Analytics service on the Azure cloud.
Read more »Deploying U-SQL jobs on Azure Data Lake Analytics
December 23, 2020In this article, we will learn how to execute U-SQL jobs that have been developed or tested locally, to the production environment from a local machine.
Read more »Different ways to login to Azure automation using PowerShell
December 22, 2020PowerShell becomes a de facto toolset in the arsenal of Azure automation. PowerShell provides a platform and a friendly way of automating many repeated tasks, which in turn minimize the time-and-cost. PowerShell always comes to the rescue when there is a need for automation, and it is no different for Azure. If you are already familiar with PowerShell cmdlets, then it will be easy to be acquainted with Azure PowerShell modules. For Azure automation, Microsoft provided a set of Azure PowerShell Modules that can be leverage to manage the Azure Cloud platform.
Read more »How to schedule Azure Data Factory pipeline executions using Triggers
December 22, 2020In the previous articles, we discussed how to use the Azure Data Factory to move data between different data stores, how to transform data before writing it to a predefined sink, how to run an SSIS package using Azure Data Factory and how to use iterations and conditions activities in Azure Data Factory.
Read more »How to track data changes on Azure SQL Database
December 21, 2020In this article, we will guide you through tracking data changes on the Azure SQL database and introduce common use case scenarios and learn how to get the most out of system-versioned tables.
Read more »Explore Amazon Aurora global databases with MySQL compatibility
December 21, 2020In the article, Deploy your AWS RDS Aurora database clusters for MySQL, we explored the Amazon Aurora concept and deployment. In this article, we will understand about the global database feature and its implementations.
Read more »Developing U-SQL jobs on Azure Data Lake Analytics
December 21, 2020In this article, we will learn how to develop U-SQL jobs on Azure Data Lake Analytics to process data stored in Data Lake Storage.
Read more »Deploy your Amazon Aurora database clusters for MySQL
December 18, 2020Introduction
Amazon offers managed database service for various database products such as Microsoft SQL Server, MySQL, PostgreSQL, Oracle. In these relational database services (RDS), AWS manages the operating system, networking components, backups, monitoring solutions. In the previous articles, we explored many useful RDS features under the AWS RDS category on SQLShack.
Read more »How to use iterations and conditions activities in Azure Data Factory
December 17, 2020In the previous articles, we discussed how to create an Azure Data Factory pipeline to copy data between different data stores that are located in on-premises servers or in the cloud, how to transform data using Azure Data factory Mapping Dataflow activity and how to run an SSIS package using Azure Data Factory.
Read more »Getting started with Azure Data Lake Analytics
December 15, 2020This article aims to help you understand the concept of Azure Data Lake Analytics capability offered by Microsoft in the Azure cloud.
Read more »Introduction to the SQL Server Agent
December 15, 2020In this article, I am going to explain in detail about the SQL Server Agent service. This is a windows service that enables database developers and database administrators to schedule jobs on the SQL Server machine. The jobs can be simple T-SQL scripts, stored procedures, SSIS packages or SSAS databases. This service is available on all the editions of SQL Server except the Express edition.
Read more »Web Scraping for SQL Machine learning using R scripts
December 14, 2020In this article, we will explore Web Scraping using R Scripts for SQL Machine Learning.
Read more »Configure Integration Services Catalog Database SSISDB in SQL Server Always On Availability Groups
December 14, 2020In this 39th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups.
Read more »Configure SQL Server Always On Availability Groups using Windows PowerShell scripts
December 10, 2020In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it.
Read more »Explore the secrets of SQL Server execution plans
December 10, 2020The SQL Server execution plan (query plan) is a set of instructions that describes which process steps are performed while a query is executed by the database engine. The query plans are generated by the query optimizer and its essential goal is to generate the most efficient (optimum) and economical query plan. Some query plans that are created by the query optimizer contain some interesting characteristics. In this article, we will go into details of these interesting query plans.
Read more »How to install SQL Server 2019 on RedHat Linux 18
December 9, 2020In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.
Read more »Understanding Change Tracking in SQL Server using Triggers
December 9, 2020In this article, I am going to explain what change tracking is in SQL Server and why do we need it. I will also illustrate the same using some practical examples using triggers in SQL Server. Change tracking as the name suggests, is a mechanism that helps us to identify the changes in the database as the application grows. In other words, it enables us to have a history of the changes that have been made to one or more tables in the database. The changes can be considered as either INSERTs, UPDATEs, or DELETEs.
Read more »A case study of SQL Query tuning in SQL Server
December 8, 2020Gaining experience in SQL query tuning can be very difficult and complicated for database developers or administrators. For this reason, in this article, we will work on a case study and we are going to learn how we can tune its performance step by step. In this fashion, we will understand well how to approach query performance issues practically.
Read more »Import data from PDF files using R Scripts SQL Server
December 8, 2020In this article, we will read and import data from a PDF file using the R scripts SQL Server.
Read more »Identify unused SQL databases
December 8, 2020In this article, I am going to show how we can identify unused SQL databases. In our organization, after release deployment, we receive the database refresh requests. To refresh the database, we were instructed to perform the following tasks:
Read more »Extract column information using the Extract function in Power BI
December 3, 2020In this article, you will see how to use the Extract function in Power BI to extract information from columns in a Power BI dataset.
Read more »Import and Export data using R and SQL Server
December 3, 2020Data professionals get requests to import, export data into various formats. These formats can be such as Comma-separated data(.CSV), Excel, HTML, JSON, YAML, Tab-separated data(.TSV). Usually, we use SQL Server integration service ETL packages for data transformations, import or export data.
Read more »Working with images in SQL Machine Learning using R scripts
November 27, 2020In the article, An overview of SQL Machine Learning with R scripts, we learned the R services integration with SQL Server 2019. We also explored a few useful external packages.
Read more »