Add versioning to SQL Server Projects
Summary
This is a basic set of instructions on how to add version number support for SQL Server projects and databases. This will will add the version number as an extended property on the deployed database.
This is a basic set of instructions on how to add version number support for SQL Server projects and databases. This will will add the version number as an extended property on the deployed database.
Gitversion is a tool to generate version numbers based on your git repository commit history.
To customize GitVersion create a GitVersion.yml
file at the root of your repository. Use this file to configure your repository. For framework libraries it is suggested to use Continuous Deliver
for
This will create a dataset listing all all schemas, objects and columns within the current database
SELECT
This script may be used to generate the properties expected for an EF Entity to back a DBSet<> for a view.
DECLARE @procName NVARCHAR(2000) = '[dbo].[YourTable]';
WITH [SystemTypes] AS (
Notes from reverse engineering serial protocol used by Radex One from Quarta
○ Examples
Some times you need to move or merge git repositories... here is the general list of commands
git remote rename origin upstream
git pull upstream master
git remote add origin NEW_URL_HERE
git pull origin master --allow-unrelated-histories
…do merge voodoo…
I can't remember all this voodoo so maybe this will help.
This is a guide on how you can decode existing USB devices and protocols.
Wireshark makes it possible to trace and capture raw data from USB Devices
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]
It is possible to host and publish to a private NuGet feed within Azure DevOps
Artifacts
click Create Feed