code

Previously a design choice was made to store raw JSON responses in a table as  VARCHAR(MAX) field.  As the person coming in afterwards to understand and debug the problem this was a pain to read and work with.  First I don't know the

Sometimes you want to test a query being unable to access a table that is part of a query (suppose you are using an ORM like Entity Framework <- which sucks ) and a reasonably quick way I have found to make the table

Preface: Covid19 is a unique situation that gives opportunity to embrace successful distributed work.  With over eight plus months of resounding success to distributed work for the company with expectations meant and exceeding even the optimistic forecasts, I would like to propose a further

Use git log with the arguments ofafter Takes iso date parameter for example: 2020-01-01author Takes string pattern most likely the email connected to the committer author like me@memememe.comThen pretty print the commits to format date, name, and commit message textpretty Specify a

A bug was reported where matching condition in the table join was produce erroneous matches and in this case this cause an invalid match which then caused the system to report records were not completed or available. Here is an example setup and results

Collected merge statement alternatives as their use can consolidate the insert/update sql code necessary but come with known risks The Case of the Blocking Merge Statement (LCK_M_RS_U locks) Use Caution with SQL Server’s MERGE StatementSQL Server 2008 introduced the

As Windows Subsystem for Linux 2 is a separated Virtual Machine on the host Windows Operating System instead of a process it is no longer able to use the same X Windows forwarding over 127.0.0.1 that I was previously available. Setup

Windows Subsystem for Linux 2 which is now a fully backed kernel linked through underlying virtual machine tied into the hypervisor of the machine is a full linux kernel and environment, but it still sits inside of the Windows host which can make some

Writing these down because I keep forgetting them. Situation 1 - Local commit wrong branchMade a commit to a branch I shouldn't have locally i.e. main should be in fixify-brokebrain git reset --hard HEAD^Resets the branch to the commit specified and remove

DocumentationStarting with SQL Server 2016 (13.x), there is no limit on the size of memory-optimized tables, though the tables do need to fit in memory. Memory tables in SQL Server are pretty close analogs to RedisWill use as much memory as possible to

Trying out some things and writing and compiling a type in Powershell PS C:\Users\siliconrob\Desktop> $MyCode = @" $MyCode = @" >> public class Calc >> { >> public int Mul(int a,int b) >> { >> return a*b; >

This is a helper post to understand that denormalized data created with joins and in particular left joins or cross apply can be rolled up with the proper use of GROUP BY.  In the following example I will use the example of redundant data

I completely agree with the sentiment here.  The stand-up meeting is a good way to lose focus for a team especially if you are distributed and remote.  If you can use Basecamp then I would suggest that, but if you are not use an

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