code

I wanted to generate an 8 character web compatible (base64 encoded) id that is fairly easy to type or memorize from SQL, so came up with this inspired from this Postgres approach SELECT randomId from openjson( ( SELECT randomBytes FROM (SELECT CRYPT_GEN_RANDOM(6)

This project although popular on nuget for downloads appeared to have been for the most unmaintained as the last update to the nuget package had not occurred in approximately in almost 2 years  and before the last update was over 6 years ago which

Copied from StackOverflow -- put the entire stored procedure code in a variable -- have it start with "PROC" so we can easily either create or alter the -- procedure based on whether it already exists or not DECLARE @sp_code NVARCHAR(MAX) = '

MS SQL ServerI want to generate a table with 1,000,000 sequential ids because I am wasteful and scourge upon humanity Step 1 - Create temp tableStep 2 - Use recursive Common Table Expression with UNION ALLGenerate the range with the SELECT n+

Create a doskey macro file: ls=dir /q $1 ip=ipconfig $* np=notepad++.exe vs=devenvCopy this file to a specified location e.g. c:\utilitiesOpen the a command promptEdit the Shortcut tab, under TargetCopy the following into the Target path%windir%\system32\cmd.

Open three query windows like so select request_session_id, resource_type, request_mode, request_status from sys.dm_tran_locks where request_session_id in (64, 65)Use this query to determine the locks showing request_session_id resource_type request_mode request_

Used this code to trick a security scanner into trusting an input. The security scanner builds a trace of an input into a function and does not trust modification of the input without revalidation. If you have a connection string located in web.config

​ Objective: Test provide meaning and are actionable ​ This means that all components that encompass at the level of the test { Unit, Integration, Application/Acceptance } provide detailed information within the system they are testing. Primary GoalsShould be repeatable in isolationDockerization of common components possibility { Docker

Have denomralized data with duplicate data within a table.  Use a Common Table Expression or With clause to construct to constructive a recursive temporary referenced resultset from the original larger query source to return an in place grouped and distinct set that can then

Hashing algorithms work with byte values and as such to develop a consistent hashing algorithm across disparate code bases you need to be consistent with your byte encodings that are supplied to the hashing algorithm, Given I have a class like this public class

Normally I would do this with cURL and jq Download random image or a pet from an API providing a url path to an image file First part is get the current time specifically the second.Divide the second by 2 and determine if

Selecting random row and or random sample from SQL and previous format use like so using the ORDER BY with the random Unique Identifier for each row randomly arranges the rows and then SELECT TOP 10 PERCENT * FROM MyTable ORDER BY NEWID()Now use

Saw this online and then thought about it more and it cuts to the representation of numbers in bytes in binary quite clearly. Given that you have two numeric variables how do you swap the values?let firstNumber = 1; let secondNumber = 2;Output >

Wanted to get the size of files in a folder, in this particular case all the csv files, and came up with this after reviewing what others had done. First find all the csv files in a particular location: find  *.csvThen use xargs and

Messing with tags and needing to find the latest Windows + PowerShellgit tag --sort=-authordate:iso8601 | Select -First 1 First part reference the git tagPass a sort parameter in this case the authordate in ISO8601 (the one format to rule all others)Put a -

Need to find a column across several databases on a particular server and there were a lot of databases so used this query to build a temp table that holds the found metadata for the particular SQL Server. Need to construct dynamic sql statement

Needed to replace a nullable column in a database with a non nullable column that.  In this case a boolean field needed to transition so came up with this to alter the structure it.  The following statement does not transition the contents of the

Code complexity has categories Technical:The domain of knowledge or in this case business or scientific rules and baselines that are needed to satisfy the conditions of the problem. Example 1: Tax laws being codified into softwareExample 2: Gravity calculation and or light calculations

Tagging a release and I am documenting the steps and commands I use to do this git pull git describe --tags $(git rev-list --tags --max-count=1) git tag "next_tag" git push --tagsgit pull Pull down the latest and synchronize git rev-list --tags --max-count=

The Dapper project is a database tool that makes working with SQL in .NET projects in a clean and understandable manner when you know SQL. As an open source project it lends itself to understanding and extension, but there are areas it has deliberately

While working through a complicated SQL series of steps I had the need to make a copy of an existing table, specifically in this case a temporary table to use for bulk loading. The into statement is how I would normally do this, but

Tracking the changes from a DELETE or UPDATE statement at the table level by creating a compatible [audit].[TableToTrack] and then attaching an after DELETE, UPDATE trigger on the watched table to keep a record of all changes Example Table [dbo].[TableToTrack]CREATE TABLE

This batch script is designed to run a series of sql script files in default order of a directory.  In this case this batch file called for example: run_scripts.bat Is in the same folder as the *.sql files and they are most

Fighting with the css for override the main menu header bar.  I want to display my custom google site search bar and this was working previously with my Ghost 2.X theme, but then 3.X changed the styling and overrides. It appears Ghost

Thinking through the case that if you know the key beforehand through a deterministic process.  Then MS SQL Server has a very handy builtin constraint that you can turn off so that you no longer have to perform complicated merge logic i.e. you