| /* | |
| ======================================================= | |
| Find Top Exec Plans to Optimize | |
| ======================================================= | |
| Author: Eitan Blumin | eitanblumin.com , madeiradata.com | |
| Date: 2020-08-12 | |
| Description: | |
| Use this script to discover execution plans with a good | |
| potential for performance optimization. | |
| Finds execution plans with warnings and problematic operators. |
| [alias] | |
| xdiff = "!f() { \ | |
| git diff "$@" $(git ls-files --modified --exclude-standard | fzf -m); \ | |
| }; f" | |
| xadd = "!f() { \ | |
| git add "$@" $(git ls-files --modified --others --exclude-standard | fzf -m); \ | |
| }; f" |
| /*Adrian Sullivan - 2019/11/15 Fun with polygons.*/ | |
| /*Thanks to Michael J Swart for all the awesome work on color | |
| https://michaeljswart.com/ | |
| */ | |
| DECLARE @tt table(id int identity(0,1), label VARCHAR(50), gg GEOMETRY) | |
| SET NOCOUNT ON | |
| DECLARE @g geometry = 'POLYGON((-121.97087 37.372518,-121.97087 37.372518,-121.970863 37.372517,-121.970845 37.372515,-121.97087 37.372518))' |
| """ | |
| Compare two Excel sheets | |
| Inspired by https://pbpython.com/excel-diff-pandas-update.html | |
| For the documentation, download this file and type: | |
| python compare.py --help | |
| """ | |
| import argparse | |
| import pandas as pd |
| URL | Status | |
|---|---|---|
| https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/dev/Documentation/sp_Blitz%20Checks%20by%20Priority.md. | 404 | |
| https://www.BrentOzar.com/go/blitztour | 404 | |
| http://FirstResponderKit.org. | 404 | |
| https://BrentOzar.com/go/poison/# | 400 | |
| https://BrentOzar.com/go/nas | 404 | |
| https://BrentOzar.com/go/planlimits | 301 | |
| https://BrentOzar.com/go/makeparallel | 301 | |
| https://BrentOzar.com/go/dbscope | 404 | |
| https://www.BrenOzar.com/go/azurevm |
| /* | |
| Snippet is nuts and bolts for creating/moving to an isolated tempdb drive. | |
| After you run this, SQL Server must be restarted for it to take effect | |
| */ | |
| DECLARE @DriveSizeGB INT = 40 | |
| ,@FileCount INT = 9 | |
| ,@InstanceCount TINYINT = 1 | |
| ,@VolumeBuffer DECIMAL(8, 2) = .8 /* Set to amount of volume TempDB can fill. */ | |
| ,@RowID INT | |
| ,@FileSize VARCHAR(10) |
| <# | |
| .Synopsis | |
| Formatting your T-SQL code | |
| .DESCRIPTION | |
| Formatting T-SQL code through RedGate Format Api (https://www.red-gate.com/products/sql-development/sql-prompt/) | |
| Works on PowerShell Core (aka PowerShell 6+) | |
| .EXAMPLE | |
| $Script = '--(Query 16)_(AlwaysOn AG Cluster) | |
| SELECT cluster_name, quorum_type_desc, quorum_state_desc |
| import-module poshrsjob; | |
| $DownloadDir = "/users/andy/Downloads/poshrsjob"; | |
| $MaxJobs = 3; | |
| foreach ($i in 1..24) { | |
| Start-RSJob -Throttle $MaxJobs -Batch "Demo" -argumentlist $i, $DownloadDir -ScriptBlock { | |
| param($JobNum, $OutputDir) | |
| $OutputFile = Join-Path -Path $OutputDir -ChildPath "RSJob$JobNum.zip"; | |
| Start-Sleep -Seconds (get-random -Minimum 1 -Maximum 15); | |
| Invoke-WebRequest -uri "https://github.com/proxb/PoshRSJob/archive/master.zip" -OutFile $OutputFile; | |
| } |
| import glob | |
| import os | |
| import cv2 | |
| import concurrent.futures | |
| def load_and_resize(image_filename): | |
| ### Read in the image data | |
| img = cv2.imread(image_filename) | |
