Skip to content

Instantly share code, notes, and snippets.

View Carm01's full-sized avatar
🎨
Focusing

Carm01

🎨
Focusing
View GitHub Profile
@Carm01
Carm01 / Snipets.sql
Last active April 25, 2023 12:11
T SQL code snipets
-- How to show differences between white space characters and empty string characters as sql sees string.empty as the same as a space
declare @string as varchar(10)=''
if @string= char(32) or @string= char(9) or @string= char(10)
begin
    IF DATALENGTH(@string)=0
        Print 'string.empty' --action if empty string
        else
        begin
        Print 'ALL White Space Detected' --action if only white spaces
@Carm01
Carm01 / S22_ADB_DeBloat.cmd
Last active November 13, 2022 05:36
Samsung Galaxy S22 remove carrier(VZW)/Samsung 3rd party bloat
REM cd /D "%~dp0"
REM cmd.exe
REM Place this file in your ADB minimal folder, right click run as normal user NOT admin
REM Enable Developer Menu in ANdroid
REM Settings - Developer - Enable USB Debugging
REM You phone will promt you to allow this computer to connect to this phone
REM https://forum.xda-developers.com/galaxy-note-10/how-to/galaxy-note-10-note-10-plus-debloat-t3964225
REM Prints all packages
'Right click copy to clipboard
Private Sub ContextAdditionalDays_Opening(sender As Object, e As System.ComponentModel.CancelEventArgs) Handles ContextAdditionalDays.Opening
Try
Clipboard.SetText(lblAdditionalDays.Text)' Copy to clipboard
Catch ex As Exception
'
End Try
End Sub
'=================================================================================================
'Onload event to prevent application from running Twice
@Carm01
Carm01 / W10_prevent_reset_detaultAPPS.au3
Last active March 25, 2019 21:11
AutoIT - Untested as of this post vased off of a few ways to prevent window10 from resetting default apps
#RequireAdmin
#Region ;**** Directives created by AutoIt3Wrapper_GUI ****
#AutoIt3Wrapper_Icon=
#AutoIt3Wrapper_Outfile_x64=AntiDefAppHijacker.exe
#AutoIt3Wrapper_Compression=4
#AutoIt3Wrapper_UseX64=y
#AutoIt3Wrapper_Res_Comment=attempts to prevent Windows 10 from resetting default apps for a few applications
#AutoIt3Wrapper_Res_Description=prevent default app reset
#AutoIt3Wrapper_Res_Fileversion=1.0.0.1
#AutoIt3Wrapper_Res_ProductVersion=1.0.0.1
@Carm01
Carm01 / Annoyances_Tweaks.cmd
Last active November 13, 2022 05:22
bat file commands to apply to a machine designed to replace the sysprep Aufit Mode / Copy Profile methodology. This provides a consistant and efficient way to apply user settings without manually doing it for all users. You can pick and choose which settings you want and do not want
:: https://stealthpuppy.com/customize-the-windows-default-profile/#.XEfajs17mUm
:: https://helgeklein.com/blog/2011/12/customizing-the-default-profile/
:: https://www.reddit.com/r/PowerShell/comments/8rupxv/unloading_registry_hive_with_a_script/
:: https://blogs.technet.microsoft.com/deploymentguys/2009/10/29/configuring-default-user-settings-full-update-for-windows-7-and-windows-server-2008-r2/
:: remove the double colon to activate the code if it is commented out
:: disable Cortana
:: https://www.addictivetips.com/windows-tips/disable-web-search-windows-10-april-update/
REG ADD "HKLM\SOFTWARE\Policies\Microsoft\Windows\Windows Search" /v "AllowCortana" /d 0 /t REG_DWORD /f
:: 5/9/2019
REG ADD "HKLM\SOFTWARE\Policies\Microsoft\Windows\Windows Search" /v "DisableWebSearch" /d 1 /t REG_DWORD /f
@Carm01
Carm01 / OfficeSettings.cmd
Last active July 1, 2022 09:36
These settings are designed to allow a user a better exxperience by removing annoyances. This works for Office 2016 and 2019
:: remove settings for individual and common apps
REG delete HKCU\Software\Microsoft\Office\16.0\Common\General /v "DisableBootToOfficeStart" /f
REG delete HKCU\Software\Microsoft\Office\16.0\Common\General /v "FirstRun" /f
REG delete HKCU\Software\Microsoft\Office\16.0\Common\General /v "AlertIfNotDefault" /f
REG delete HKCU\Software\Microsoft\Office\16.0\Excel\Options /v "AlertIfNotDefault" /f
REG delete HKCU\Software\Microsoft\Office\16.0\Excel\Options /v "DisableBootToOfficeStart" /f
REG delete HKCU\Software\Microsoft\Office\16.0\PowerPoint\Options /v "AlertIfNotDefault" /f
REG delete HKCU\Software\Microsoft\Office\16.0\PowerPoint\Options /v "DisableBootToOfficeStart" /f
REG delete HKCU\Software\Microsoft\Office\16.0\Word\Options /v "AlertIfNotDefault" /f
REG delete HKCU\Software\Microsoft\Office\16.0\Word\Options /v "DisableBootToOfficeStart" /f
@Carm01
Carm01 / 1reboot.txt
Last active March 20, 2019 11:56
Reboot multiple machines based off a list or reboot a single machine AutoIT script.
pc1
pc2
pc3
pc4
5
pc3