From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal. Now, we can provision Microsoft fabric easily using Microsoft PowerBI premium per capacity or using Microsoft fabric capacity using Azure portal. It is important to note that all the capacity sits under Microsoft Fabric tenants. In this blog, we delve into […]
Azure Storage Account
Read more
This blog post aims to provide an overview of Azure Storage Accounts. It will explain how to create them and use them effectively. Azure Storage Account Azure Storage Account is a container for scalable and durable cloud storage solutions. It is capable of handling large amounts of data and supports various types of data such […]
Create First Azure Data Factory Pipeline
Read more
In my previous post, we explored the basics of creating First Azure Data Factory. Today, I want to delve deeper into the process of creating and configuring pipelines within the Azure Data Factory. Azure Data Factory Pipeline A pipeline in Azure Data Factory (ADF) represents a set of logically connected activities. It enables the efficient […]
Azure Resource Group
Read more
What is Azure Resource Group? Azure Resource Group is a powerful feature that enables effective organization and management of resources in the Azure cloud. A Resource Group is a logical container that allows you to group and manage multiple resources, such as virtual machines, storage accounts, databases, and web apps, all in one place. By […]
What Is Azure Data Factory?
Read more
What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your data at scale. With ADF, you can easily create and manage data pipelines that can move and transform data between various sources and destinations, such as […]
Creating Your First Azure SQL Database
Read more
Azure SQL Database is a cloud-based database service that offers scalability and flexibility to handle large workloads. It’s based on Microsoft SQL Server Database Engine and provides a managed environment for easy provisioning, patching, upgrading, and monitoring. In this article, we’ll delve into the essential configurations of Azure SQL Database and provide a comprehensive guide […]
Best way to monitor high worker thread on SQL Server
Read more
It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially leading to degraded user experience and even downtime. Some of the common reasons for high worker thread issues in SQL Server. Blocking Sudden workload spike Resource […]
Track SQL Server Database Recovery Progress – ErrorLog
Read more
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan my database server reboot time more appropriately. The below query parse the SQL Server Error Log and gives you total time taken by a database to […]
Powershell Error – Import-Module AzureRm
Read more
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to import AzureRm module by running the below command; Import-Module AzureRm It returned this error: PS C:\windows\system32> C:\Users\User\Desktop\Azure Script.ps1 File C:\Users\User\Desktop\Azure Script.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see […]
Only one Log Reader Agent can connect to a database at a time error – Transaction Replication/CDC
Read more
An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error: Msg 18752, Level 16, State 1, Procedure sp_replcmds, Line 1 [Batch Start Line 229] Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed […]