Welcome to my site. I use this site as a repository to dump knowledge I come across, generally in the areas of software engineering and information technologies, but may include other miscellaneous tidbits. Most of the posts are written as notes for my personal reference.
if i.hear then
i.forget
if i.see then
i.remember
if i.do then
i.understand
Ternary Conditionals var x = true ? true : false; Nested Ternaries isArthur && isKing ? (weapon = ‘a, helment = ‘a) : isArcher ? (weapon = ‘b’, helmet = ‘b’) : (weapon = ‘c’, helmet = ‘c’); Logical Assignments Var result = 42 || undefined; // 42 Var result2 = [‘sweet’] || […]
Unit Tests tests a single class focuses on single behavior or function it drives implementation runs in memory (using mocks) Integration Tests tests a system (more whole than unit test) focuses on interaction between functions catches regressions (in future changes) runs in database (uses data access layer) Due to integration tests being focused on the […]
Unit Test One of the most commonly skipped or minimally managed areas of application development is unit testing. It is often seen as overhead, even unnecessary, and given very little or no attention. On some projects where requirements are often changing rapidly, the developer can get frustrated trying to keep up with the changes and […]
These are my notes while reviewing the latest release of Entity Framework EF6 Migrations = creates or updates database automatically as models in the application change. This lets developers focus on the application models and not worry about the database. EF SaveChanges() This does the actual SQL command execution. It is […]
A quick reference to SQL Server Account Types and System Security Ports Clients connect to SQL Server through UDP 1434 SQL server responds with a TCP Port number to continue their connection Default TCP port is 1433 Server and System Security SQL Service runs under a service account, can be: Windows account […]
Other notes here regarding types of databases and cloud providers for these types of databases. http://solidfish.com/types-of-databases/ History Relational theory Tuples = unordered set of attribute values (row and attribute of column in a table) Relation = collection of tuples and corresponding relations Constraints = enforce consistency; used to identify tuples and relationships between them […]
These are some notes on different types of databases used in the current industry. Refer to my other post on Relational vs Non-Relational Database for more information specific to NoSQL Document Databases. http://solidfish.com/relational-vs-non-relational-databases/ Below is a list of some different types of databases as well as some platforms/tools for these database types. Document Databases […]
These are my notes in regards to using the Repository and Factory design patterns in an ASP.NET MVC / Web-API application. Definitions Repository = A repository is used to separate the concerns between the domain logic and data layer of an application. It helps the domain layer to be decoupled from the data layer. […]
Managing Hot Fixes and Code Quality Branches and Code Reviews TFVC vs Git Branching by feature is nice, and Git supports branching very easily. But note that each branch requires integration (merge). So having more branches mean there are potentially more merges. Some issues when doing too much branches. One good scenario for branching is […]
Some general notes on MVC5 and WebAPI… The MVC pattern is been in computer science since 1979, known then as the Thing-Model-View-Editor. The Model: A set of classes that describes the data you’re working with as well as the business rules for how the data can be changed and manipulated The View: Defines how […]