This article explores the impact of dropping a login in the active directory if that owns a HADR endpoint and SQL Server Always On Availability Groups. It is the 23rd article in the SQL Server Always On Availability Group.
Read more »Backup SQL databases on the AWS S3 bucket using Windows PowerShell
September 16, 2020In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket.
Read more »How to prepare for the Exam DP-200: Implementing an Azure Data Solution
September 16, 2020In this article, we will show how to prepare yourself for one of the important Microsoft Azure exams, DP-200: Implementing an Azure Data Solution certificate exam.
Read more »Backup compression in TDE enabled databases in SQL Server Always On Availability Groups
September 16, 2020In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database.
Read more »Configuring ODBC drivers for Azure Database for MySQL
September 15, 2020In this article, I am going to show how we can configure the ODBC driver to connect the Azure Database for MySQL Server. Also, I am going to demonstrate the configuration using the SQL Server Integration Services (SSIS) package.
Read more »How to parse JSON in SQL Server
September 15, 2020In this article, we will learn how to parse and query JSON in SQL Server with the help of the OPENJSON function. Firstly, we will briefly look at the data structure of the JSON and then we will learn details of the parsing and querying JSON data using the OPENJSON function.
Read more »Manticore search: a continuation of the Sphinx search engine
September 14, 2020In this article, we will be talking about Manticore Search, which is an open-source search engine first released in 2017 as a fork of the Sphinx search engine. We will try to describe this search engine briefly, mention some of its differences from the Sphinx search engine, and we will provide a step-by-step guide on how to build full-text indexes from SQL Server databases. Finally, we will show how to connect to the Manticore engine from the SQL Server management studio using a linked server object. In our previously published articles in this series, we talked briefly about the Sphinx search engine and how to create full-text indexes from SQL Server databases.
Read more »How to prepare for the Exam DP-300: Administering Relational Databases on Microsoft Azure
September 14, 2020In this article, we will show how to prepare yourself for the DP-300 exam: Administering Relational Databases on the Microsoft Azure certificate exam.
Read more »Exporting SSRS reports to multiple worksheets in Excel
September 11, 2020Introduction
SQL Server Reporting Services (SSRS) has multiple options of exporting data into a variety of formats and we will be discussing the options of exporting SSRS Reports to multiple sheets of excel. In SSRS, there are multiple formats available to export reports depending on the user’s needs. Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Tiff file, MHTML (Web Archive), CSV (comma delimited) and XML file with report data are the popular formats that can be exported from SSRS as shown in the below screenshot.
Read more »Exploring AG dashboards for monitoring SQL Server Always On Availability Groups
September 11, 2020In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes.
Read more »How to prepare for the Exam AZ-900: Microsoft Azure Fundamentals
September 9, 2020In this article, we will show how to prepare yourself for the Microsoft Azure Fundamentals exam (AZ-900).
Read more »Getting started with Azure SQL Database using Azure CLI
September 9, 2020There are plenty of tools out in the market to manage Azure Cloud platform— Azure Management Web portal, Visual Studio, Visual Studio Code with Azure Studio SDK, Azure PowerShell, Azure CLI, and Azure Cloud Shell.
Read more »Restore an existing availability group database participating in SQL Server Always On Availability Groups
September 8, 2020In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database.
Read more »How to create an AWS SageMaker Instance
September 7, 2020This article provides a step by step explanation of how to get started with AWS Sagemaker by creating an AWS SageMaker instance for using machine learning related features on AWS Cloud.
Read more »Deploy MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 7, 2020In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group.
Read more »Explore Cross-database MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 4, 2020In the 18th part of the SQL Server Always On Availability Group series, we will discuss the cross-database MSDTC support in an availability group.
Read more »SQL interview questions
September 3, 2020Introduction
If you are applying for a SQL Server Administration or Development job, you may need to study and practice for the interview. It is a common mistake to go for an interview without studying.
Read more »An introduction to SSIS Data Lineage concepts
September 3, 2020In this article, I am going to discuss SSIS data lineage concepts, which are often used while designing ETL workloads on a data warehouse. Although this article is focused on implementing data lineage using SSIS, it does not only confine to SSIS but to any ETL tools in the market using which data is moved from one source to a destination. In my previous article, Understanding Data Lineage in ETL, I have already discussed the generic importance of data lineage concepts for any ETL tool. I would definitely suggest you have a look at it if you want to understand in general how data lineage helps to track the source of a single record in the warehouse.
Read more »Understanding Data Lineage in ETL
September 3, 2020In this article, I am going to explain what Data Lineage in ETL is and how to implement the same. In this modern world, where companies are dealing with a humongous amount of data every day, there also lies a challenge to efficiently manage and monitor this data. There are systems that generate data every second and are being processed to a final reporting or monitoring tool for analysis. In order to process this data, we use a variety of ETL tools, which in turn makes the data transformation possible in a managed way.
Read more »Saving AWS Redshift costs with elastic resize
September 3, 2020In this article, you will learn to elastically resize the AWS Redshift cluster to save costs.
Read more »Getting started with Azure Automation
September 1, 2020Microsoft Azure Automation service provides a framework to create and schedule workflows to simplify the repetitive and mundane tasks that Cloud administrators perform with Azure. The workflows are commonly known as run-books.
Read more »Learn SQL: SQL-Related Jobs
September 1, 2020In today’s article, we’ll take a look at 4 common SQL-related jobs and roles and explain what kind of tasks you could expect at each of these roles and what types of queries you’ll possibly use to solve these tasks. If you’re already in any of these roles, you’re probably familiar with this, but if you’re new to the world of SQL, you could find this very useful to decide in which way you want your career to develop.
Read more »Configuring SQL Server replication for distribution databases in SQL Server Always On Availability Groups
September 1, 2020In this 17h article of the SQL Server Always On Availability Group series, we are going to explore the SQL Server replication for the distribution database in the availability group.
Read more »Data Reduction Technique: Principal Component Analysis in Azure Machine Learning
August 31, 2020Introduction
We will be discussing one of the most common Data Reduction Technique named Principal Component Analysis in Azure Machine Learning in this article. After discussing the basic cleaning techniques, feature selection techniques in previous articles, now we will be looking at a data reduction technique in this article.
Read more »Configure SQL Server replication for a database in SQL Server Always On Availability Groups
August 31, 2020This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs.
Read more »