EugeneChiang.com

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

Logitech Keyboard and Mouse Setup with SetPoint

SetPoint lets you customize your mouse, keyboard, touchpad and number pad settings in Windows. SetPoint Download… https://support.logi.com/hc/en-us/articles/360025141274

Git GUI Clients

https://git-scm.com/download/gui/windows TortoiseGit Platforms: WindowsPrice: FreeLicense: GNU GPL

TortoiseGit

https://tortoisegit.org/ TortoiseGit is a Windows Shell Interface to Git and based on TortoiseSVN. It’s open source and can fully be build with freely available software. Since it’s not an integration for a specific IDE like Visual Studio, Eclipse or others, you can use it with whatever development tools you like, and with any type of... » read more

Azure DevOps Overview

https://docs.microsoft.com/en-us/azure/devops-project/overview Feature Description Boards JIRABoards, Backlogs, Sprints, Retrospectives Repos Source ControlTortoiseGit vs Visual Studio Git Pipelines CI Test Plans Artifacts Can I use Azure DevOps for free? Yes. You can use Azure DevOps up to the free tier limits for your organization, listed as follows: Five Azure DevOps users (Basic) Free tier of Microsoft-hosted CI/CD... » read more

SQL Server Add Windows User Account

User cant change password: Configuration information could not be read from the domain controller

Error: User cant change password: Configuration information could not be read from the domain controller, either because the machine is unavailable, or because access is denied. Resolution: Make you are you are connected to VPN before changing your password.