Identify and remove unused indexes in SQL                         Server   Introduction: Indexes means order information about data, with indexes we can retrieve data from the database more [...]

Controlling visibility of databases and server level setting by Contained Database Introduction: Contained Database is a new feature of SQL Server 2012. A contained database is a database that is [...]

        Adding data file to Mirroring database What is Mirroring? Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the [...]

What is log shipping? SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on [...]

Resource Database Corruption: What is resource database: Resource database is a binary and a system database, and its corruption would not allow instance to start. If resource database is corrupt [...]

                        Slipstream in SQL Server What is the slipstream how to use slipstream to install SQL server? Slipstream is a technique used by System Admins to easily update the setup [...]

How to uninstall patch file when need to downgrade and remove it What is the patch file. RTM is the original build version of the product when you download the ISO file from MSDN. SQL Server [...]

Issue ; while closing the AR period we could see one receipt in in valid status in subledger period close exception report.   Fix ; we have data fix for this issue..The receipts are in [...]

Issue : I have created new major category and minor category ..so after that i have created asset category with newly created Major category and minor category…So when i try to create an [...]

How to fix the “Excel is waiting for OLE” issue Open the Excel sheet. Go to the File menu. Click on Options. Go to the Advanced tab. Scroll down to the General area and check “Ignore other [...]