Archive for May 2023

Once upon a time, there was a innocent Database Administrator (DBA) who had to restore a database but leave out certain tables. However, he didn’t know how to do it….

Understanding DBCC OPENTRAN DBCC OPENTRAN is a SQL Server database console command (DBCC) that lets administrators to access information about the database’s oldest current transaction, as well as the oldest…

Scenario Once upon a time, there was a poor person who worked as a database administrator (DBA) for a rich company. One day, the DBA was asked to set up…

Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !!…

Introduction In today’s data-driven world, ensuring high availability and data protection is paramount for businesses. Microsoft SQL Server offers a robust solution called Always On Availability Groups that enables the…

Introduction As a database administrator (DBA), one of the key responsibilities is to ensure optimal performance and efficient management of database indexes. Index fragmentation can significantly impact query performance and…

Scenario SQL Server error logs are logs that store important information about events, warnings, and errors encountered by the SQL Server instance. These logs act as a valuable source of…

Scenario If you’re facing issues with TempDB in SQL Server, particularly with certain MDF files growing while others remain unaffected, it could indicate a problem with the allocation of database…

Introduction In SQL Server, views provide a convenient way to encapsulate complex queries and present a simplified and abstracted representation of data to users. However, there may be situations where…

Scenario During an upgrade from SQL Server 2008 R2 to SQL Server 2016 SP2, we have noticed that all system databases, except for the master database, are automatically assigned the…