12 min read 3 Interview Questions MSSQL SQL Server DBA Interview Questions OTI 2 June 2023 Introduction SQL Server is a popular relational database management system (RDBMS) developed by Microsoft. It is used by a wide…
4 min read 1 MSSQL Is it possible to restore the database except specific tables in MSSQL OTI 31 May 2023 Once upon a time, there was a innocent Database Administrator (DBA) who had to restore a database but leave out…
4 min read 0 MSSQL Find Open Transactions on a SQL Server OTI 30 May 2023 Understanding DBCC OPENTRAN DBCC OPENTRAN is a SQL Server database console command (DBCC) that lets administrators to access information about…
3 min read 0 MSSQL Story of Error : The request failed or the service did not respond in a timely fashion OTI 29 May 2023 Scenario Once upon a time, there was a poor person who worked as a database administrator (DBA) for a rich…
2 min read 0 MSSQL SQL Server Database Backup With Ola Hallengren Maintenance Solution Scripts OTI 29 May 2023 Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon…
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 protection is paramount for businesses. Microsoft SQL Server offers a…
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 responsibilities is to ensure optimal performance and efficient management of…
3 min read 0 MSSQL Understanding SQL Server Error Logs OTI 26 May 2023 Scenario SQL Server error logs are logs that store important information about events, warnings, and errors encountered by the SQL…
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, particularly with certain MDF files growing while others remain unaffected,…
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 encapsulate complex queries and present a simplified and abstracted representation…