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
| [Reflection.Assembly]$ass = [Reflection.Assembly]::LoadFile("C:\Temp\File.dll") | |
| $specificType = $ass.GetType("Namespace.Type") | |
| $specificType.GetMethods([System.Reflection.BindingFlags]::NonPublic -bor [System.Reflection.BindingFlags]::Instance) | |
| $instanceTypeObj = [System.Activator]::CreateInstance("Namespace.Type") | |
| $nameOfMethod = $specificType.GetMethod("NameOfMethod", [System.Reflection.BindingFlags]::NonPublic -bor [System.Reflection.BindingFlags]::Instance) |
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
| --select schema_name(t.schema_id) as schema_name, | |
| -- t.name as table_name, | |
| -- '['+ schema_name(t.schema_id) +'].['+ t.name +']' AS FullName | |
| --from sys.tables t | |
| --order by schema_name, | |
| -- table_name; | |
| DECLARE @CurrentRowId AS INT, @CMD AS NVARCHAR(MAX), @Value AS NVARCHAR(MAX),@COMBINEDCMD AS NVARCHAR(MAX) |
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
| $pathInput = "C:\Temp(Not-Synced)\OpenShot\Convert2Gif" | |
| $pathOutput = "C:\Temp(Not-Synced)\OpenShot\Convert2Gif" | |
| $ffmpegPath = "C:\Tools\Screen2Gif\ffmpeg.exe" | |
| $files = Get-ChildItem -Path $pathInput | |
| $parameterString = '-y -i "{0}" -lavfi "palettegen=stats_mode=full[palette],[0:v][palette]paletteuse=dither=sierra2_4a" "{1}"' | |
| foreach($file in $files) { |
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
| ffmpeg -i "PathToFile" -c copy -map 0 -segment_time 00:01:00 -f segment -reset_timestamps 1 "PathToFolder\FileName_%03d.mp4" |
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
| ffmpeg.exe -i "PATH.MP4" -lavfi "palettegen=stats_mode=full[palette],[0:v][palette]paletteuse=dither=sierra2_4a" "OUTPATH.gif" | |
| ScreenToGif: | |
| -lavfi palettegen=stats_mode=full[palette],[0:v][palette]paletteuse=new=1:diff_mode=rectangle |
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
| Navigate to "C:\Program Files\Oracle\VirtualBox\drivers\vboxdrv" | |
| Right click on "VBoxDrv.inf" file and select Install option | |
| Open the Console as a administrator and run the following command | |
| sc start vboxdrv |
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
| SELECT ' DROP FUNCTION '+ QUOTENAME(SCHEMA_NAME(schema_id)) | |
| + N'.' + QUOTENAME(name) | |
| from sys.objects | |
| WHERE [type] IN (N'FN', N'IF', N'TF', N'FS', N'FT') |
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
| SELECT ' DROP PROCEDURE ' + s.NAME + '.' + p.NAME | |
| FROM sys.procedures p | |
| JOIN sys.schemas s | |
| ON p.[schema_id] = s.[schema_id] | |
| WHERE p.type = 'P' |
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
| SELECT ' Drop table ' + s.NAME + '.' + t.NAME | |
| FROM sys.tables t | |
| JOIN sys.schemas s | |
| ON t.[schema_id] = s.[schema_id] | |
| WHERE t.type = 'U' |
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
| SELECT ' Drop view ' + s.NAME + '.' + v.NAME | |
| FROM sys.views v | |
| JOIN sys.schemas s | |
| ON v.[schema_id] = s.[schema_id] | |
| WHERE v.type = 'V' |