Database development, Statements

T-SQL provides two keywords that allow you to delete data from a table. They are DELETE...
Read More

SQL Server Unit Testing with tSQLt Framework

Frameworks, Languages & Coding, Testing

In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You...
Read More

SQL Server Transaction Log — Part 2

Database administation, Transaction Log

This is the second article in the series dedicated to SQL Server transaction log and its specificities. Here we are going to examine the...
Read More

Best FREE SQL Server Tools for Database Developers and Administrators!

Tools & technologies • One Comment

This article comprehensively lists the best SQL Server FREE tools for database developers and...
Read More

Lightweight Code Review

Code Management, Tools & technologies • One Comment

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...
Read More

EFFECTIVE CODE REVIEW: Formal Approach to the Process

Code Management

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...
Read More


Database development, Statements

Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all...
Read More

Iterating Over JavaScript Arrays

Basics of JavaScript, Languages & Coding

Iterating Over Arrays The article describes ES5 and ES6 approaches to iterate over javascript arrays and array-like objects!...
Read More

SQL Server Transaction Log — Part 1

Database administation, Transaction Log • One Comment

Every SQL Server database contains one or more transaction log files in addition to data files. Log files record all transactions and...
Read More

С# Nuances: foreach

Basics of C#, Languages & Coding

You may have been asked a question on a job interview: “What needs to be done to make your class...
Read More