Query session status runnable, sleeping, suspended, running and background meanings in SQL server Database
In SQL Server, when you query the session status, you can encounter various states that provide information about what a session is currently doing. Here are some…
Troubleshooting Connectivity issues & Timeout error [258]. Unable to complete login process due to delay in prelogin response/ Pre-Login Handshake Failed
If trying to connect Azure SQL Server database and getting below Error: Error Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Timeout error [258]….
How to Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS)
To Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS) Step 1 : Create user logon from master database where ‘abc’ is…
How to use Azure Key Vault for Azure Data Factory?
What is Azure Key Vault? Azure Key Vault is a cloud-based service provided by Microsoft Azure that allows you to securely manage and store sensitive information such…
What is CrowdStrike? How to install CrowdStrike with Azure VM?
CrowdStrike is a leading cybersecurity company that specializes in cloud-native endpoint protection. It provides solutions to protect against malware, ransomware, and other cybersecurity threats. CrowdStrike’s platform uses…
What is fragmentation in Azure SQL Server? How to check fragmentation for table? How to rebuilt table to reduce fragmentation?
What is fragmentation in Azure SQL server? Fragmentation in Azure SQL Server, or any SQL Server, refers to the condition where the data pages of a database…
How to install AZ Modules in Power shell. How to Connect Azure from PowerShell?
Determine if the version of PowerShell you’re running meets the minimum requirements before attempting to install the Az PowerShell module. The .NET Framework 4.7.2 or higher is…
Azure Databricks Tutorial: Getting Started with Azure Databricks – Part 2
The solution below assumes that you have access to a Microsoft Azure account and an Azure subscription with credits available for testing services. If you are on…
Azure Databricks Tutorial: End To End Analytics – Part 1
Introduction to Azure Databricks Azure Databricks is a cloud-based big data and analytics platform provided by Microsoft in collaboration with Databricks, a company founded by the creators…
What are Azure Users, Groups, service principals, and managed identities?
In Azure, users, groups, service principals, and managed identities are all components related to identity and access management (IAM). They help control access to Azure resources and…
How to implement CloudOps?
CloudOps Implementation Plan To implement CloudOps, you need to follow these steps: Implementing CloudOps involves a combination of best practices, strategies, and tools that enable efficient cloud…
What is Google BigQuery? How can integrate it with Azure?
Google BigQuery is a powerful cloud-based data warehousing and analytics platform provided by Google Cloud. It allows you to store, manage, and analyze large volumes of data…
What is Amperity?
Amperity is a customer data platform (CDP) that helps businesses collect, organize, and use customer data to improve their relationships with customers. Think of it as a…
What is SFTP server? How can integrate with Azure.
SFTP stands for “Secure File Transfer Protocol,” and an SFTP server is a computer or software system that allows you to securely send and receive files over…
What is Ataccama? Architecture, Uses and Integration with Azure
Ataccama is a software platform that helps organizations manage and improve the quality of their data. It’s like a digital janitor for your data, making sure it’s…
What is Oracle Golden Gate?
Oracle GoldenGate is a technology that helps keep data in different databases in sync in real-time. It’s like having two copies of the same book, and every…
What is Azure Logic Apps?
Azure Logic Apps is a cloud-based service provided by Microsoft Azure that enables you to create and run workflows or business processes to automate and integrate various…
What is Azure Automation Account?
An Azure Automation Account is a service offered by Microsoft Azure that allows you to automate, manage, and schedule various tasks and processes within your Azure environment…
What is CloudOps?
CloudOps is the practice of managing the delivery, tuning, optimization, and performance of workloads and IT services that run in a cloud environment. This includes cloud platforms,…
What is Azure Function App?
Azure Function App is a serverless compute service offered by Microsoft Azure that allows you to run small pieces of code, called functions, in response to various…