MSSQL-Shrink DB.Log

::Solution 1 (GUI)
1.ต้อง Backup Database ก่อนถึงจะทำได้
2.


::Solution 2 (Script)

1. ต้อง BK database ก่อนไม่งั้นถ้า DB_Log พัง DB ก็จะพังไปด้วย
2  Run Script



USE TMP_BIDB; 
GO 

ALTER DATABASE TMP_BIDB 
SET RECOVERY SIMPLE; 
GO 
-- Shrink the truncated log file to 1 MB. 
DBCC SHRINKFILE (TMP_BIDB_log, 1); 
GO 
-- Reset the database recovery model. 
ALTER DATABASE TMP_BIDB 
SET RECOVERY FULL; 
GO 

Switch-Vlan

http://ninehua.com/index.php/story/menu-nw/178-trunk1

batch-fix chrome

@echo off
set ChromeDir=C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data
taskkill /F /IM "chrome.exe"
Start-Sleep -Seconds 5
del /q /s /f "%ChromeDir%"
rd /s /q "%ChromeDir%"

Tomcat-version

cd tomcat/lib
java -cp catalina.jar org.apache.catalina.util.ServerInfo


Server version: Apache Tomcat/7.0.30
Server built:   May 23 2013 02:54:10
Server number:  7.0.30.0
OS Name:        Linux
OS Version:     3.13.0-36-generic
Architecture:   amd64
JVM Version:    1.7.0_65-b32
JVM Vendor:     Oracle Corporation

freeSHHd-fix service

https://gurunadhduvvuru.wordpress.com/2017/07/20/steps-to-resolve-the-specified-address-is-already-in-use-error-in-freesshd/

PowerBI

https://codeinsane.wordpress.com/2019/01/15/microsoft-power-bi-for-report-vm/


https://github.com/natthasath/powershell-script

Teams-eMail

https://tomtalks.blog/2019/11/adding-outlook-email-and-calendar-app-to-microsoft-teams-a-proof-of-concept/

Window-SMAL2

https://support.jitbit.com/helpdesk/KB/View/13284380-configuring-saml--in-adfs-



https://www.ispringsolutions.com/articles/ispring-learn-sso-with-microsoft-active-directory-federation-services

HP-P2000-storage

::Add Global Spare Disk

::Delete LeftOVR

win-layout

::PowerShell
Export-StartLayout –path c:\admscript\Layout.xml; Import-StartLayout –LayoutPath c:\admscript\Layout.xml -MountPath C:\

::CMD
Dism.exe /online /Export-DefaultAppAssociations:c:\admscript\App.xml
Dism.exe /online /Import-DefaultAppAssociations:c:\admscript\App.xml

::Remove PrivacyExperience win10_1903
reg add "HKLM\SOFTWARE\Policies\Microsoft\Windows\OOBE" /v "DisablePrivacyExperience" /t REG_DWORD /d 1 /f

::Disable_app_Suggestions
reg add "HKLM\SOFTWARE\Policies\Microsoft\Windows\CloudContent" /v "DisableWindowsConsumerFeatures" /t REG_DWORD /d 1 /f

PowerBI-download

https://www.microsoft.com/en-us/download/details.aspx?id=58494