View MSSQL_RepetitiveReplace_fn.sql
This file contains 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 FUNCTION dbo.RepetitiveReplace_fn | |
( | |
@P_String VARCHAR(MAX), | |
@P_Pattern VARCHAR(MAX), | |
@P_ReplaceString VARCHAR(MAX), | |
@P_ReplaceLength INT = 1 | |
) | |
RETURNS VARCHAR(MAX) | |
BEGIN | |
DECLARE @Index INT; |
View Microsoft.PowerShell_profile.ps1
This file contains 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
## Use PowerShell Engine Event (OnIdle) to Update the PowerShell | |
## Console Window's Title to have the current path and last command executed. | |
## For this to work Nicely add it to your PowerShell Profile. | |
## Subscribe to PowerShell.OnIdle Event | |
## Out to null to hide Register-EngineEvent output | |
$null = Register-EngineEvent PowerShell.OnIdle -Action { | |
## Get Last Command ran from history | |
$LastCommand = Get-History | Sort-Object -Property Id -Descending | Select-Object -First 1 -exp CommandLine | |
## Updated the console window's title to have the path and command. |
View Invoke-URLInDefaultBrowser.ps1
This file contains 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
function Invoke-URLInDefaultBrowser | |
{ | |
<# | |
.SYNOPSIS | |
Cmdlet to open a URL in the User's default browser. | |
.DESCRIPTION | |
Cmdlet to open a URL in the User's default browser. | |
.PARAMETER URL | |
Specify the URL to be Opened. | |
.EXAMPLE |
View AutomaticJobCleanup.ps1
This file contains 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
#Build Job Name to be unique | |
$JobName = "ExampleJob" | |
$JobNameCount = (get-job | Where-Object Name -like $JobName*).Count | |
$JobName = "$($JobName)_$($JobNameCount)" | |
#Define and Start job | |
$Job = Start-Job -Name $JobName -ScriptBlock { Start-Sleep 60 } | |
#Create Event to clean up job after complete | |
Register-ObjectEvent -InputObject $Job -EventName "StateChanged" -Action { |
View ToastNotification_Windows10.ps1
This file contains 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
$ErrorActionPreference = "Stop" | |
$notificationTitle = "Notification: " + [DateTime]::Now.ToShortTimeString() | |
[Windows.UI.Notifications.ToastNotificationManager, Windows.UI.Notifications, ContentType = WindowsRuntime] > $null | |
$template = [Windows.UI.Notifications.ToastNotificationManager]::GetTemplateContent([Windows.UI.Notifications.ToastTemplateType]::ToastText01) | |
#Convert to .NET type for XML manipuration | |
$toastXml = [xml] $template.GetXml() | |
$toastXml.GetElementsByTagName("text").AppendChild($toastXml.CreateTextNode($notificationTitle)) > $null |