How to resolve Microsoft SQL Server, Error 47073? | Cannot connect to DBServer.database.windows.net?

by

This article help to resolve, How to resolve Microsoft SQL Server, Error: 47073? OR Cannot connect to DBServer.database.windows.net? ADDITIONAL INFORMATION: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes (https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from … Read more

How to compress XML data in SQL 2022? | SQL Server 2022 new features | Can SQL 2022 XML compression save disk cost with XML data?

by

This article about , How to compress XML data in SQL 2022? or How SQL Server 2022 can help optimize storage with XML data compression. SQL Server 2022 new features : XML Compression SQL Server 2022 come up with a lot of new features and update which can help to improve SQL Server performance and … Read more

How SQL Server Always ON can help to achieve RPO and RTO? | Achieve three in One Solution using SQL Server Always ON

by

This article help to How SQL Server Always ON can help to achieve RPO and RTO? OR Achieve three in One Solution using SQL Server Always ON How Always On in SQL Server works? SQL Server Always On is one of the best high availability method started from SQL Server 2012. This can be used … Read more

Database recovery is slow due to log file issue in SQL Server Always ON failover | How to troubleshoot database startup slowness in SQL Server Always ON?

by

This article guides on Database recovery is slow due to log file issue in SQL Server Always ON failover? | How to troubleshoot database startup slowness in SQL Server Always ON failover ? What is DB startup in SQL Server? Whenever there is planned or unplanned SQL Server stop or restart , SQL server will … Read more

How To Resolve Microsoft SQL Server Error 15401? | Error Could not obtain information about Windows NT group/User error code 0x534

by

This article helps, How To Resolve Microsoft SQL Server Error 15401? or Error Could not obtain information about Windows NT group/User error code 0x534 How SQL Server access work with AD groups? As best security practice system admin team create different AD groups for SQL Server database access. Those groups are created based on access … Read more

How to resolve SQL query takes 30 min on one server and same will takes 3 hours on another server? | Query slowness due to Maxdop and CPU issues on SQL Server

by

This article is about, How to resolve SQL query takes 30 min on one server and same will takes 3 hours on another server? or Query slowness due to Maxdop and CPU issues on SQL Server Sometime customer raise ticket that they are facing query slowness issue on one server and same query executing quickly … Read more

How to resolve Microsoft SQL Error 1478? | The mirror database has insufficient transaction log data to preserve the log backup chain of the principal database.

by

This article about, How to resolve Microsoft SQL Error 1478? or The mirror database has insufficient transaction log data to preserve the log backup chain of the principal database. What is Microsoft SQL Availability Group? SQL Server always on availability group is one of the best high availability method in SQL server. This keep your … Read more

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