MarioBinder

Use Master
GO
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE WITH OVERRIDE
GO

MarioBinder

USE Exercises
GO
/* ***********************************************************************************************
 *
 * CRONTAB EXPANDER
 *
 * ***********************************************************************************************/


/**************************************************************************************************

MarioBinder

export function levenshtein(a: string, b: string): number {
   if (!a.length) {
    return b.length;
  }

  /* c8 ignore next 3 */
  if (!b.length) {
    return a.length;
  }

MarioBinder

$Folder1 = Get-ChildItem -Name "D:\Gitserver\Repositories" | foreach {$_.ToLower() + ".git"}
$Folder2 = Get-childitem -Name "D:\Gitea\Repositories\wdmm" | foreach {$_.ToLower() }
Compare-Object $Folder1 $Folder2

MarioBinder

sublime-protocol-win

Setting up Custom URI scheme handler for Windows to open files in Sublime editor
Created to parse URI's generated by filp/whoops
Parsing is done with VBScript, as that was the only way I found to open Sublime editor, while avoiding annoying command prompt window to pop up and close.

NOTE

After downloading / cloning the repository, you have to edit files to update path to open_file.vbs and to add path to Sublime editor
Currently I don't have time to create install/uninstall scripts, so any help is welcome
Also, README.md is all upside-down, so that will be updated soon

MarioBinder

--This query enables ole automation procedures.  set 0 to disable
exec master.dbo.sp_configure 'Ole Automation Procedures', 1
RECONFIGURE

--OLE automation disabled the following error is thrown.
--SQL Server blocked access to procedure 'sys.sp_OACreate' of component
--'Ole Automation Procedures' because this component is turned off as part 
--of the security configuration for this server. 
--A system administrator can enable the use of 'Ole Automation Procedures'

MarioBinder

rmdir /s/q foldername

MarioBinder

create a temp virtual drive: pushd "\\172.29.0.30\"
delete the virtual drive: popd "\\172.29.0.30\"

MarioBinder

var jq = document.createElement('script');
jq.src = "https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js";
document.getElementsByTagName('head')[0].appendChild(jq);
// ... give time for script to load, then type (or see below for non wait option)
jQuery.noConflict();

//https://stackoverflow.com/a/7474386/119109

MarioBinder

SET STATISTICS IO, TIME ON