Microsoft azure

How to Resolve, Cannot open server ‘testdbserver’ requested by the login for Azure SQL Database | Resolve Client with IP address ” is not allowed to access the Azure SQL server.

by

This article guides , How to Resolve, Cannot open server ‘testdbserver’ requested by the login for Azure SQL Database or Resolve Client with IP address ” is not allowed to access the Azure SQL server. What is Azure SQL Database? Azure SQL database is pass(platform as Service) offering from Microsoft. You can use Azure SQL … Read more

How to get filenames from Azure blob storage using PowerShell? | List filenames from Azure Storage

by

This article guides How to get filenames from Azure blob storage using PowerShell? What is Blob storage? Blob storage or Azure storage is file storage service on Microsoft Azure cloud. We can use this to store various types of file. It supports Blob, file and table. Most common use of azure storage to store file … Read more

How to perform Index maintenance of large tables in availability groups? | Index maintenance in availability groups for 10 TB Database

by

This article some best practices about How to perform Index maintenance of large tables in availability groups? OR Index maintenance in availability groups for 10 TB Database What is index in SQL Server? Index is an object in SQL Server database which can be used to retrieve data faster and improve query performance. Mainly there … Read more

How to resolve Report server URL was not working? | Fix rsCannotValidateEncryptedData error

by

This Article help , How to resolve Report server URL was not working? or Fix rsCannotValidateEncryptedData error What is SSRS? SQL Server Reporting Services are getting used to create various type of reports from database or data warehouse. This reports are useful to identify various trends, business metrics etc. This reports can be accessed from … Read more

Availability Group database stuck in Not Synchronizing | Log file full due to Availability Replica

by

This article guide, How to resolve, Availability Group database stuck in Not Synchronizing or Database is not coming in restoring mode post removing it from AG group Why this issue occurred? Database size was 5+ TB of one of the database on SQL Server. Index jobs runs weekly. Due to index maintenance job , log … Read more

Why Data file is not shrinking in SQL Server? | DBCC ShrinkFile doesn’t shrink file

by

This article help to resolve, Data file is not shrinking in SQL Server | DBCC ShrinkFile doesn’t shrink file You can follow the steps and check which best solution work for your case. What is issue? or Why Data file is not shrinking in SQL Server or DBCC ShrinkFile doesn’t shrink file Database size was … Read more

How to resolve, the server principal owns one or more availability group(s) and cannot be dropped?

by

This article about, How to resolve, the server principal owns one or more availability group(s) and cannot be dropped? What is availability group? Availability Groups are a feature in Microsoft SQL Server that provide high-availability and disaster recovery for user databases. They were introduced in SQL Server 2012 as a database-level solution, allowing multiple databases … Read more

How to write simple SQL queries? | Learn simple SQL queries

by

This is video tutorial on How to write simple SQL queries? or Learn simple SQL queries SQL queries are versatile, and they can be utilized for numerous operations, including creating and modifying tables, inserting, updating, or deleting data from tables, selecting data from one or multiple tables based on specified conditions, joining tables to combine … Read more

How to get deadlocks history in SQL Server using system_health extended events?

by

This article helps to find Deadlock history or How to get deadlocks history in SQL Server using system_health extended events? Deadlock : refers to a situation where two or more transactions are waiting for each other to release resources, resulting in a state of permanent blocking. This impasse prevents any of the transactions involved from … Read more

How to troubleshoot service principal name issue? | The SQL Server Network Interface library could not register the Service Principal Name (SPN) in SQL Server

by

This article help to resolve, How to troubleshoot service principal name issue? | The SQL Server Network Interface library could not register the Service Principal Name (SPN) in SQL Server What is SPN? In SQL Server, the Service Principal Name (SPN) is a unique identifier used to associate a service instance with a specific domain … Read more