Questions: What does BACKUP WITH NAME Command do?
Microsoft SQL Server has given an option to connect to SQL Server when normal connections can’t be made because of any reasons. This feature is called as Dedicate Administrator Connection (DAC). You can read more about DAC over here. Diagnostic Connection for Database Administrators
Applying a patch in SQL Server is a planned process which is followed across various companies. Most of the companies take time to apply the patch to make sure the stability of the patch can be validated. Let us see an error related to patch installer.
Disasters are always bad. Recovering from disaster is a skill and needs a lot of planning and practice. One of my clients had a disaster and built a new machine to restore the backups. They tried a few attempts to install SQL Server but were having issues. Finally, they contacted me for consultation to fix rule reporting services catalog database file existence.
Sometime ago I wrote a blog on identity column value jump issue, you can read it from here SQL SERVER – Jump in Identity column after restart! In this blog post we will learn how to resolve the error when we alter column from int to bigint.
SQL SERVER – Could Not Load File or Assembly ‘SqlManagerUi, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or One of its Dependencies
Recently, one of my clients reported a weird issue to me. They explained that when they right click on the database, and try to read its properties they were getting the following error message. Let us learn about error related to could not load file or assembly.