Author Archives: rohitmssqlfun

RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format with rows and columns relations. Types of DBMS:- Hierarchical DBMS Network DBMS Relational DBMS Object-Oriented DBMS We have multiple RDBMS available products in the market Oracle … Continue reading →

Dear Friends We are launching the YouTube Channel “Decode ITES”. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public Cloud, VM Ware, Backup, Network, Storage, etc.. Decode ITES is a continual part of successful Web blog “https://mssqlfun.com/” from the last 5+ years with thousands of … Continue reading →

Dear Friends Apologies for less knowledge sharing articles for a long time and Big thanks for stay connected with me. I will be coming up with the “SQL Server Learning Series” to cover a list of topics from beginner to Expert level based on my core 13+ years of experience. Stay Connected and keep sharing … Continue reading →

DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period was exceeded” Error: Today, My DBCC checkdb job failed with below error. Executed as user: USERNAME. Object ID 451805713 (object ‘dbo.AEETBL’): DBCC could not obtain a lock on this object because the lock request timeout … Continue reading →

Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive approach and keep your system’s performance on top rather than reactive when it comes to addressing user complaints. SQL Server is a complex system and due to the continuous increasing size of data and multiple … Continue reading →