Great minds discuss ideas!
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. So, he asked for help in a WhatsApp group for…
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 distributed and non-distributed replicated transactions. It gives information on open…
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 a new instance with a specific name in the existing…
Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming Soon !! Coming…
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 creation of a highly available and resilient database environment. However,…
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 overall database efficiency. In this blog post, we will explore…
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 diagnostic data, assisting administrators and developers in identifying and resolving…
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 objects within TempDB. Here are a few steps you can…
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 you want to grant SELECT permissions on a view while…
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 new compatibility level (130). In this article, we will explore…