This is the third article in a series of articles that describe code review process. In this part, we will have a look at the lightweight code review process. Read More
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 whys and hows of the code review process. In this part, we will have a look at the Formal code review process. You can also read the introductory article: EFFECTIVE CODE REVIEW: Uprooting Source Code Defects Read More
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 will not have a chance to get your data back. In this article, we will have a look how to avoid such situations and have a chance to ROLLBACK TRUNCATE. Read More
Dive Into SQL Server Transaction Log — Part 2
This is the second article in a series of articles about SQL Server transaction log file architecture. In this article, we will have a look at two SQL Server statements that allow examining transaction log details. If you would like to get an introductory information about how SQL Server transaction log works, read Dive Into SQL Server Transaction Log — Part 1 Read More
Iterating Over JavaScript Arrays
Iterating Over Arrays
The article describes ES5 and ES6 approaches to iterate over javascript arrays and array-like objects! Read More
Dive Into SQL Server Transaction Log — Part 1
Chances are you already know that every SQL Server database contains one or more transaction log files, in addition to data files, that records all the transactions and database modifications made by each transaction. The transaction log is an essential part of any database, and the database administrator must keep it under observation. One of the most important tasks for the database administrator is to truncate the transaction log file to keep it from overflow. Why? Because the transaction log plays the most important role when it comes to the database recovery. Read More
С# 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 answer is “To implement IEnumerable”. The answer is correct but not complete. Read More
Retrieving SQL Server Metadata with Help of T-SQL
Active Directory vs Azure Active Directory
Active Directory traditionally used to manage elements of a domain-based network. But companies increasingly implement various cloud services that require its own user accounts. A tool for creating and managing user accounts, that are used by different Microsoft cloud services, which a company acquires, is Azure Active Directory. Read More
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 handling string data. To write good string handling functions, it is important to understand the characteristics of string objects in C#. Read More