EFFECTIVE CODE REVIEW: Formal Approach to the Process
Formal Approach to Code Review This is the second article in a series of articles that describe the...
ROLLBACK TRUNCATE in SQL Server
Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all data loss. The worst thing is that you...
Iterating Over JavaScript Arrays
Iterating Over Arrays The article describes ES5 and ES6 approaches to iterate over javascript arrays and array-like objects!...
SQL Server Transaction Log — Part 1
Every SQL Server database contains one or more transaction log files in addition to data files. Log...
С# Nuances: foreach
You may have been asked a question on a job interview: “What needs to be done to make your class work with the foreach loop?” Well, the...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
Active Directory vs Azure Active Directory
Active Directory traditionally used to manage elements of a domain-based network. But companies...
C# Powerful String Functions
The .NET Framework provides a set of powerful string functions. These building blocks can be used to write more complex algorithms for...
C# Extension Methods: a Useful Example!
What is an extension method? The extension method provides the ability to extend the functionality of an existing class by adding a static...