Repair/Restore Option for Database in Suspect Mode
If a database is in Suspect Mode… Try to bring the database back online. If that does not work, try to repair the database with data loss. If that does not work, you have to restore the database from a backup file.
Custom Login Message for WASM Identity Authorization
To change the message “Authorizing…” Need to add to file App.razor Sources: https://docs.microsoft.com/en-us/aspnet/core/blazor/security/?view=aspnetcore-5.0#customize-unauthorized-content-with-the-router-component
Managing NTFS Permissions and Share Permissions
Access to a shared folder required both share permission and NTFS permission. Managing NTFS Permissions and Share Permissions If you find working with two separate sets of permissions to be too complicated or time consuming to manage, you can switch to using only NTFS permissions. Shared folder permissions provide limited security for your folders. Therefore, you gain the greatest flexibility... » read more
Manage User Secret
File Location (For Local Development Environment) C:\Users\user01\AppData\Roaming\Microsoft\UserSecrets\e13a4f3c-0111-4fcc-bba1-11d7e67a1b6d\secrets.json Example Note: Need to create the same entry in configuration when deploying application to Azure. Each project will have a user secret file. Change the name of the project will create a new user secret file.
Rebuild or Reorganize: SQL Server Index Maintenance
To Rebuild or Reorganize: That is the Question First off: ‘Reorganize’ and ‘Rebuild’ are two different operations that each reduce fragmentation in an index. They work differently toward the same end. You don’t need to run both against the same index. (I sometimes find that people are doing both against every index in a maintenance... » read more
Custom Index Defrag Script for SQL Server 2008
uspDbaIndexDefrag xx_dba_parseString_udf xx_dba_indexDefragStatus xx_dba_indexDefragExclusion xx_dba_indexDefragLog Result Executing: ALTER INDEX [PK_tbTable01] ON [MyDB01].[dbo].[tbTable01] REORGANIZE Executing: ALTER INDEX [XPK_tbTable02] ON [MyDB01].[dbo].[tbTable02] REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON) Executing: ALTER INDEX [PK_tbTable03] ON [MyDB01].[dbo].[tbTable03] REORGANIZE Executing: ALTER INDEX [XPKtbTable04] ON [MyDB01].[dbo].[tbTable04] REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON) Executing: ALTER INDEX [PK_tbTable05] ON [MyDB01].[dbo].[tbTable05] REORGANIZE
SQL Server Error: BobMgr::GetBuf: Sort Big Output Buffer write not complete after 60 seconds.
Error: BobMgr::GetBuf: Sort Big Output Buffer write not complete after 60 seconds. SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file . The OS file handle is 0x000006A4. The offset of the latest long I/O is: 0x00000 (or) BobMgr::GetBuf: Sort Big Output Buffer write not complete... » read more
Pair Beats Pill+
Pair Beats Pill+ Pair Beats Pill+ with an iPhone, iPad, iPod touch, or Apple Watch: Make sure that your Beats Pill+ is charged and turned on. The “b” button pulses to indicate that the Beats Pill+ is in discovery mode, ready to be paired. If it doesn’t pulse, hold down the “b” button for 3 seconds to enter discovery mode. On... » read more
Search for Text in File using Notepad++
Use Notepad++ Search -> Find in Files Search in specific folders. About Notepad++ https://notepad-plus-plus.org Notepad++ is a free (as in “free speech” and also as in “free beer”) source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GNU General Public License. Based on the... » read more