Upgrading to the latest version of 3.X was no problem, but then moving from 3.X to 4 everything blew up because of database schema changes with messages like this A GhostError occurred. Message: Ghost was able to start, but errored during boot with: alter table `members_status_events`

Open Source, it forms the basis of most personal and commercial software with no sign of a decrease in adoption or change in it's practical use.  At <Company> there is no project or solution that I have heard of or examined that does not use or build from

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 schema and second it sits in

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 appear busy or unavailable is to

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 open program to be created and

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 format according to pattern in this

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 DECLARE @name1 NVARCHAR(200) = 'ABCDE FGHIJ'

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 MERGE statement, which promised to be

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 X-Windows forwardingAdd the following to your

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 debugging issues a little off. First

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 changes ( --hard ) commit in question is

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 stick entire table into memoryBacked by

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; >> } >> } >> "@ PS

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 created with LEFT JOIN of a

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 automated standup bot in yout slack

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) as randomBytes) T FOR JSON AUTO

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 in terms of computer software is

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) = ' PROC [dbo].[usp_some_proc] AS

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+1 FROM t WHERE 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.exe /k doskey /macrofile=c:\utilities\

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_status 64 DATABASE S GRANT 65

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 or appsettings.json file it is

​ 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 Compose Database Server }Coverage is on

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 be counted and remove all the

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 FullName { public string FirstName { get; set;