Skip to content

Instantly share code, notes, and snippets.

Avatar

Matthew Whited mwwhited

View GitHub Profile
View SQL Table as Queue.md

Simple TSQL Table as Queue

Show unlocked events

SELECT
	*
FROM dbo.queue WITH (READPAST)
;
View Xilinx Native FIFO.md

XILINX FIO Generator - Native Interface

Summary

The intent of this documnent is to describe the state flow of a XILINX Native FIFO with Independent Clocks

Configuration

  • Native Interface
  • Independent Clocks
@mwwhited
mwwhited / DbPublish.xml
Created Jan 12, 2021
Example DACPAC Publish Profile
View DbPublish.xml
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<TargetDatabaseName>YourDatabase</TargetDatabaseName>
<DeployScriptFileName>YourFileName.sql</DeployScriptFileName>
<CreateNewDatabase>False</CreateNewDatabase>
<IncludeCompositeObjects>True</IncludeCompositeObjects>
<GenerateSmartDefaults>True</GenerateSmartDefaults>
<BlockOnPossibleDataLoss>True</BlockOnPossibleDataLoss>
<DropObjectsNotInSource>False</DropObjectsNotInSource>
@mwwhited
mwwhited / .gitignore
Created Jan 12, 2021 — forked from eupenik/.gitignore
Vivado .gitignore
View .gitignore
#########################################################################################################
## This is an example .gitignore file for Vivado, please treat it as an example as
## it might not be complete. In addition, XAPP 1165 should be followed.
#########################################################################################################
#########
#Exclude all
#########
*
!*/
!.gitignore
View RevertSqlSystemVersioned.md

Revert System Versioned tables

ALTER TABLE dbo.your_table
	DROP CONSTRAINT DF_SysStart , DF_SysEnd 
ALTER TABLE dbo.your_table
	DROP PERIOD FOR SYSTEM_TIME
ALTER TABLE dbo.your_table
	DROP COLUMN [SysStartTime], [SysEndTime]
View ASPNetCoreMiddlewareCheck.md

ASP.Net Core Middleware Check

Summary

This uses reflection to evaluate the registered middleware pipeline fpr ASP.Net Core.

    //Stage
    var config = new ConfigurationBuilder()
        .AddJsonStream(this.GetResourceStream("appsettings.json"))
View AzureDevopsPrivateNuget.md

Create Private NuGet feed for use with Azure Devops

Summary

It is possible to host and publish to a private NuGet feed within Azure DevOps

Process

  • Under Artifacts click Create Feed
    • Name the feed as desired
View TsqlImpersonateWithMasking.md

TSQL Impersonation with Dynamic Datamasking

Summary

It is possible to use impersonation to change between a masked and unmasked data within the same connection.

/*
CREATE USER [unmasked] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
@mwwhited
mwwhited / UsbHidDecode.md
Last active Dec 7, 2020
USB HID Decoding Tips
View UsbHidDecode.md

HID USB Decoding

Summary

This is a guide on how you can decode existing USB devices and protocols.

Wireshark with USBPcap

Wireshark makes it possible to trace and capture raw data from USB Devices

View GitTips.md

Git Notes

Summary

I can't remember all this voodoo so maybe this will help.

Commands

force accept remote changes