| DECLARE @message VARCHAR(MAX) = 'Some {item} with {count} {collection}.'; | |
| -- Via https://stackoverflow.com/a/77054331/370611 | |
| -- Recursive expression, frowned upon by https://learn.microsoft.com/en-us/sql/t-sql/language-elements/select-local-variable-transact-sql?view=sql-server-ver16#c-antipattern-use-of-recursive-variable-assignment | |
| -- But... it does seem to work. | |
| SELECT @message = REPLACE(@message, SearchText, ReplaceText) | |
| FROM ( VALUES -- Table constructor (literal), anonymous table, essentially. | |
| ('{item}', 'text string'), | |
| ('{count}', '3'), | |
| ('{collection}', 'variables') |
| git update-index --chmod=+x myscript.sh | |
| # May be required to get your bash script to run in a Linux Azure pipeline agent; watch for "not executable" errors. | |
| # (This is Powershell, but who cares, it's a command line.) | |
| # From https://www.aligrant.com/web/blog/2022-04-20_execute_permission_on_chained_shell_scripts_through_azure_devops |
This is some code I wrote in a doomed attempt to deal with some long hex strings in some of our database objects.
The effort was doomed, but this code seems to work fine.
The strings I was working with were fixed 24-hex-digit strings, but you could probably make this variable length (so long as the values fit in numeric(38) values).
This was for Sql Server 2016, so I didn't have string_split() or string_agg(). (String_split doesn't take empty string or null for separator.)
| var reader = cmd.ExecuteReader(); | |
| var ds = new DataSet(); | |
| while (! reader.IsClosed) | |
| { | |
| var dt = ds.Tables.Add(); | |
| dt.Load( reader ); | |
| } |
| $ServicePID = (get-wmiobject win32_service | where { $_.name -eq 'service name'}).processID | |
| # https://social.technet.microsoft.com/Forums/en-US/43fa0ba5-f5b6-43b7-a10b-4957bc4a5f19/how-to-search-a-pid-with-service-name-and-then-task-kill-it?forum=winserverpowershell |
| // Edit your settings.json, probably located at C:\Users\j6l\AppData\Roaming\Code\User\settings.json | |
| // The following is a snippet. Note the background is completely transparent (trailing "0"). | |
| // (Note the actual VS Code settings can't have comments.) | |
| "workbench.colorTheme": "Default Light+", | |
| "breadcrumbs.enabled": true, | |
| "workbench.colorCustomizations": { | |
| "[Default Light+]": { | |
| "editorBracketMatch.border": "#00ffff", | |
| "editorBracketMatch.background": "#00ffff80", |
| get-process node ` | |
| | select id,starttime,name, | |
| @{ Name="CommandLine"; | |
| Expr={ $filter = "ProcessId = {0}" -f $_.Id; (Get-CimInstance Win32_Process -filter $filter).CommandLine }} ` | |
| | ? {$_.CommandLine -match ' gulp\.js Build_'} ` | |
| | sort starttime ` | |
| | ft -au -wr | |
| # Omit the filter on gulp.js for a fuller result. |
| # Old log file cleanup | |
| cd C:\ProgramData\Sisense\PrismWeb\Logs | |
| ls *.log.* ` | |
| | ? {$_.Extension -match '^\.[0-9]+$' } ` | |
| | ? {$_.LastWriteTime -lt (Get-Date).AddMonths(-1)} ` | |
| | rm -vb | |
| # Skip short files (assumed error outputs), files that contain "already begin built". | |
| # Parse timestamp out of filename (YYYY-MM-DD-HHMMSS). | |
| # Drop first component of "cube name" (the "Build_" part of "Build_Cube_Name") | |
| ls *-2022-09-*.txt ` | |
| | ? {$_.Length -gt 1000} ` | |
| | ? {-not (sls -list 'already being built' $_)} ` | |
| | sls "Finished '(.*)' after (([0-9\.]+) [a-zA-Z]+)" ` | |
| | sel -fir 1000 ` | |
| | sel @{Name="Timestamp";Expr={if ($_.Filename -match "(?<timestamp>20\d+-\d+-\d+-\d+)") {$Matches.timestamp} else {""}}} ` |
| cd N:\SisenseBuilds\Elasticubes | |
| ls */*.xml ` | |
| | % {[xml] $xml = cat $_; | |
| # $xml | gm | |
| $xml.Cloud["Cloud.Tables"].Tables.CloudTable ` | |
| | % { | |
| # $_ | gm | |
| [PSCustomObject] @{ | |
| Server = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Server; | |
| Database = $_["CloudTable.ConnectionProperties"].SqlServerConnectionProperties.Database |