fitomkarofficial@gmail.com 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
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
This article guide on, How to resolve SQL Server Error 15343? or Troubleshoot, Could not drop login Why Error 15434: Could not drop login as the user is currently logged in coming? When there is task to delete or drop user from SQL Server we have to make sure that no one is connected with … Read more
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
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
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
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
This article guide to identify high CPU queries on SQL Server. Sometime as DBA we get alert for high CPU utilization on SQL Server. To start troubleshooting, we need to find out which queries currently taking high CPU time to execute. Below query help to find out high CPU running queries. This query will returns … Read more
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
This article help to resolve, Cannot open database “test” requested by the login. The login failed. Login failed for user ‘ABC\Test’. or Database status is in recovery pending Why we get error Cannot open database “test” requested by the login. The login failed. Login failed for user ‘ABC\Test’ Sometime due to heavy SQL queries or … Read more