This article explains the SSIS Script task and Script component, the scripting tools available in the SQL Server Integration Services (SSIS).
Read more »Understanding Backups for Azure SQL Database
November 18, 2021Azure SQL database is Database as a Service offering under the PaaS model in the Azure cloud. It is a fully managed SQL Server database engine that uses the latest stable version of SQL Server enterprise edition. This database service offers rich functionalities to increase the availability with the help of in-built high availability capability and reduce the manageability efforts by using easy and smooth deployments, automatic backup, and patching, etc. We generally use this deployment for modern cloud-compatible applications or if we want to leverage hyperscale or serverless options. This article will explain Azure SQL database backups to help you understand how backups work for these databases in the background and how can we use them for our data protection and recovery requirements.
Read more »SQL Server Extended Events tips
November 17, 2021This article aims to provide some beneficial tips about SQL Server extended events that make it easier to create and use event sessions.
Read more »Transfer SQL Logins between SQL Server instances using SSDT 2017
November 16, 2021This is the third article in the series of Migrating SQL Server Objects using SSDT 2017. In the second article, we learned how we can transfer the stored procedure of the master database. In this article, we will learn how to copy SQL Logins to another instance using SSDT 2017.
Read more »Importing Azure Cosmos DB data in Azure Search
November 16, 2021In this article, we will learn how to configure the Azure Search instance to import data from Azure Cosmos DB.
Read more »Parameterized SQL Notebooks in Azure Data Studio
November 10, 2021This article will explore Parameterized SQL notebooks in Azure Data Studio.
Read more »Transfer Stored Procedures between master databases on SQL Server instances using SSDT 2017
November 9, 2021This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database.
Read more »SQL TOP statement performance tips
November 9, 2021In this article, we will discuss the performance details of the SQL TOP statement, and we will also work on a performance case study.
Read more »Getting started with Azure SQL
November 8, 2021This article will help you understand Azure SQL and its deployment options available in the Azure cloud. This article would be helpful to you if you are planning to migrate your SQL Server workloads to Azure cloud or want to provision a SQL database for your new application development. You will learn which deployment option would be beneficial for your database workload in this article.
Read more »Searching multi-lingual data in Azure SQL Databases
November 8, 2021In this article, we will learn how to enable multi-lingual search on data hosted in Azure SQL Databases.
Read more »Copy Data tool to import data into Azure SQL Database from web sources
November 8, 2021This article will explore the Copy Data tool for importing data into Azure SQL Database from a web source.
Read more »Transfer SQL Jobs between SQL Server instances using SSDT 2017
November 5, 2021In this series of articles, we will learn how we can clone the SQL Server instance using SSDT 2017. In my previous article, we learned how to Install and configure SSDT 2017 on Windows 10. In this series of articles, we will migrate the following SQL Server components to another server using SSIS tools provided in SSDT 2017:
Read more »Using SQL Server to query data from Amazon Athena
November 5, 2021In this article, we are going to use SQL Server to query data that resides in Amazon S3 buckets with the help of Amazon Athena. SQL Server is one of the most popular relational database management systems developed by Microsoft. SQL Server can be installed on-premises or on popular cloud services like Azure or AWS. For the purpose of this demonstration, we are going to use SQL Server that has been installed on-premises. Also, as a pre-requisite for this tutorial, we would need to have an AWS account valid and some knowledge about Amazon Athena.
Read more »Creating an Azure Search service instance for Azure Cosmos DB
November 4, 2021In this article, we will learn how to create an instance of Azure Search service and attach it to an instance of Azure Cosmos DB.
Read more »Use Replication to improve the ETL process in SQL Server
November 4, 2021Introduction
This article describes how to improve the ETL Process in SQL Server by using the native replication technique in SQL Server.
Read more »SQL Server 2022 Private Preview announcement
November 3, 2021This article talks about the next version of SQL Server which is SQL Server 2022. This will cover the latest announcement, release, and all the exciting features SQL Server 2022 offers.
Read more »SSIS XML Source vs. XML task
November 3, 2021This article explains the SSIS XML Source and the SSIS XML task, which are the XML-related components in the SQL Server Integration Services.
Read more »SQL Server DBA Interview questions and answers
November 1, 2021This article will help you with some popular SQL Server DBA Interview questions and answers. I would recommend you to read this article as well as SQL Server Interview questions and answers to learn more about SQL interview questions. In this article also, I tried to answer each question in a very precise manner.
Read more »Using SQL Server Extended Events to monitor query performance
November 1, 2021In this article, we will explore how we can use SQL Server extended events to monitor query performance in SQL Server.
Read more »Discovering data assets with glossary terms in Azure Purview
October 29, 2021This article will show how to catalog data assets and then tag business glossaries at the attribute level of data assets in Azure Purview.
Read more »Copy Data tool to export data from Azure SQL Database into Azure Storage
October 29, 2021DBA may import, export regularly within a different environment. You might receive data in a specified format for importing it into database tables.
Read more »Install and configure SSDT 2017 on Windows 10
October 28, 2021In this article, we are going to learn how we can install and configure the SSDT 2017 on Windows 10. The SQL Server data tools 2017 (SSDT 2017) is a development tool used for database development, SQL Server analysis service data models, SQL Server report service reports, and Integration service packages.
Read more »Defining Business Glossary with Azure Purview
October 27, 2021In this article, we will explore Azure Purview capability and understand it with a practical walkthrough.
Read more »SQL Syntax Checker Tools
October 27, 2021In this article, we will look at the 2 different SQL syntax checker tools that help to find the syntax errors of the queries without executing them.
Read more »Automatic Index advisor in Azure SQL database
October 26, 2021This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »