Robert Libotti libotti
libotti
/ oracle session nls_session_parameters with trigger
Created
March 22, 2021 12:37
How to set Oracle NLS_SESSION_SETTINGS WITH A TRIGGER
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE TRIGGER sys.schema_nls_session_settings AFTER LOGON ON BOB.SCHEMA | |
| BEGIN | |
| execute immediate 'alter session SET NLS_TERRITORY="BRAZIL"'; | |
| execute immediate 'alter session SET NLS_LANGUAGE="BRAZILIAN PORTUGUESE"'; | |
| execute immediate 'alter session SET NLS_ISO_CURRENCY="BRAZIL"'; | |
| execute immediate 'alter session SET NLS_CURRENCY="R$"'; | |
| execute immediate 'alter session SET NLS_DATE_FORMAT="DD/MM/RR"'; | |
| execute immediate 'alter session SET NLS_DATE_LANGUAGE="BRAZILIAN PORTUGUESE"'; | |
| execute immediate 'alter session SET NLS_SORT="BINARY"'; | |
| execute immediate 'alter session SET NLS_TIME_FORMAT="HH24:MI:SSXFF"'; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using ServiceReference1; | |
| using System; | |
| using System.Collections.Generic; | |
| using System.IO; | |
| using System.ServiceModel; | |
| using System.Threading.Tasks; | |
| namespace SSRSSimple | |
| { | |
| class Program |
libotti
/ move-user-profiles.ps1
Created
July 16, 2022 07:56
Move all windows userprofiles from C:\USERS to D:\Users
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ProfilePaths = Get-ChildItem "REGISTRY::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList" | | |
| Where-Object {$_.Name -match "^S-1-5-21*"} | | |
| Select-Object -ExpandProperty Name -Skip 1 | Foreach { | |
| (Get-ItemProperty "REGISTRY::$($_)" -Name "ProfileImagePath").ProfileImagePath | |
| } | |
| $ProfilePaths = $ProfilePaths | Where-Object {$_ -ne "C:\Users\$($env:Username)"} | |
| $ProfilePaths | Foreach { | |
| $Current = "$_" | |
| $Move = $_ -replace "^C:","D:" | |
| Move-Item -Path "$Current" -Destination "$Move" |
OlderNewer