Global Git configuration: (Windows) c:/users/{user}/.gitconfig
git config --global user.email "email@example.com"
git config --global user.name "John Doe"
Single Repository Level: /.git/config
git config user.email "email@example.com"
git config user.name "John Doe"
References:
Use Case: In cases where there are multiple HTTP requests and the code needs to wait until the responses from all the HTTP requests are available.
forkJoin
waits for each HTTP request to complete and group’s all the observables returned by each HTTP call into a single observable array and finally return that observable array.
The result of a forkJoin
is an Observable. The data returned when all of the HTTP request are fullfilled, is an array with elements in the same order as they were presented in the array passed to the forkJoin
rxjs
library function.
References:
https://medium.com/@swarnakishore/performing-multiple-http-requests-in-angular-4-5-with-forkjoin-74f3ac166d61
Actions are operations exposed by an OData service that MAY have side effects when invoked. Actions MAY return data but MUST NOT be further composed with additional path segments.
Functions are operations exposed by an OData service that MUST return data and MUST have no observable side effects.
These are similar to SQL functions versus stored procedures.
In SQL, functions are generally used to query, whereas stored procedures could be used for both query and modifications (update/insert/delete).
References:
https://stackoverflow.com/questions/38089753/odata-v4-what-are-functions-and-actions-in-simple-terms
Changes are only detected when the databound input property is changed via a template's binding. If the changes are done manually to a property on a component class, the change is not detected.
References:
sp_rename '{table_name}.{column_old_name}', '{column_new_name}', 'COLUMN';
Microsoft recommends that you drop and recreate the table so that scripts and stored procedures are not broken.
https://www.techonthenet.com/sql_server/tables/alter_table.php
EXEC sp_rename 'schemaName.oldTableName', 'newTableName';
References:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/rename-tables-database-engine
A test fixture sets up the system under test (SUT) for the software testing process by initializing it (configuration and/or data) satisfying any preconditions the system may have.
Example: initialize a database with known parameters before running a test.
This allows for tests to be repeatable, which is one of the key features of an effective test framework.
In a non-software context, such as circuit boards, a test fixture is a setup or another device designed to hold the device under test (DUT) in place and allow it to be tested.
References:
SELECT {col_name},
COUNT({col_name}) AS dupe_cnt
FROM {table_name}
GROUP BY {col_name}
HAVING COUNT({col_name}) > 1
ORDER BY COUNT({col_name}) DESC
Replace:
Returns the table's column length in bytes:
COL_LENGTH ( 'table' , 'column' )
References:
https://docs.microsoft.com/en-us/sql/t-sql/functions/col-length-transact-sql
To debug against Azure (e.g. getting access to Key Vault etc.) configure Visual Studio to use the account with which it uses to send credentials to Azure.
This configuration is under: Options => Azure Service Authentication => Account Selection
References:
https://docs.microsoft.com/en-us/azure/azure-app-configuration/howto-integrate-azure-managed-service-identity?tabs=core2x
https://docs.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/overview
The trigger files are stored in a location similar to:
/common/workflows/datafactory/trigger/*.json
Each trigger has the following information:
References:
Roslyn
RyuJIT
The TRACERT diagnostic utility determines the route to a destination by sending Internet Control Message Protocol (ICMP) echo packets to the destination.
References:
The .NET Portability Analyzer is an open source tool that is utitlized to analyze assemblies, files or directory of files for compatibility across .NET implementations.
This tool reports on the compatibility of the current app across .NET implementations.
It comes as:
References:
In VS Code, there are two core debugging modes, Launch and Attach.
References:
A configuration file allows you to configure and save debugging setup details.
VS Code keeps debugging configuration information in a launch.json
file located in a .vscode
folder in your workspace (project root folder)
References:
Dry-run: The command git remote prune origin --dry-run
lists branches that can be deleted/pruned on your local.
To remove the local remove '--dry-run'.
References:
$filter: The expression specified with $filter is evaluated for each resource in the collection, and only items where the expression evaluates to true are included in the response.
serviceRoot/People?$filter=FirstName eq 'Scott'
$orderby: The $orderby system query option allows clients to request resources in either ascending order using asc or descending order using desc.
serviceRoot/People('scottketchum')/Trips?$orderby=EndsAt desc
$count: The $count system query option allows clients to request a count of the matching resources included with the resources in the response.
serviceRoot/People/$count
$select: The $select system query option allows the clients to requests a limited set of properties for each entity
serviceRoot/Airports?$select=Name, IcaoCode
$top & $skip: The $top system query option requests the number of items in the queried collection to be included in the result. The $skip query option requests the number of items in the queried collection that are to be skipped and not included in the result.
serviceRoot/People?$top=2
$expand: The $expand system query option specifies the related resources to be included in line with retrieved resources.
serviceRoot/People('keithpinckney')?$expand=Friends
Supporting multiple filters:
Use the and/or operators to apply multiple filters.
References:
http://www.odata.org/getting-started/basic-tutorial
Marks a test method as being a data theory.
Data theories are tests which are fed various bits of data from a data source, mapping to parameters on the test method.
If the data source contains multiple rows, then the test method is executed multiple times (once with each data row). Data is provided by attributes which derive from Xunit.Sdk.DataAttribute:
References: