8 min read 1 MSSQL Differences between configuring Always On Availability Groups on a physical and Azure virtual machine OTI 28 May 2023 Introduction In today’s data-driven world, ensuring high availability and data…
4 min read 0 MSSQL Efficiently Monitor and Manage Index Fragmentation with T-SQL OTI 28 May 2023 Introduction As a database administrator (DBA), one of the key…
3 min read 0 MSSQL Understanding SQL Server Error Logs OTI 26 May 2023 Scenario SQL Server error logs are logs that store important…
3 min read 0 MSSQL Certain MDF files growing issues in TempDB OTI 25 May 2023 Scenario If you’re facing issues with TempDB in SQL Server,…
1 min read 0 MSSQL Granting SELECT Permissions on a View OTI 25 May 2023 Introduction In SQL Server, views provide a convenient way to…
3 min read 0 MSSQL Compatibility Level of the Master DB Remains Same After Upgrades OTI 23 May 2023 Scenario During an upgrade from SQL Server 2008 R2 to…
6 min read 0 MSSQL Monitoring SQL Server Jobs & its Schedules OTI 22 May 2023 Introduction SQL Server jobs are essential for automating tasks and…
2 min read 0 MSSQL TSQL to find list of all index not used for last 30 days OTI 16 May 2023 This code is designed to provide information about the indexes…
3 min read 1 MSSQL Use ProcDump to capture sql server unexpected crash dump OTI 11 May 2023 To use ProcDump to capture a SQL Server unexpected crash…
2 min read 0 MSSQL SQL Server (MSSQLSERVER) service terminated unexpectedly OTI 11 May 2023 One day, we suddenly discovered that the SQL Server was…