SQL Server: DELETE vs TRUNCATE
T-SQL provides two keywords that allow you to delete data from a table. They are DELETE...
SQL Server Unit Testing with tSQLt Framework
In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You...
SQL Server Transaction Log — Part 2
This is the second article in the series dedicated to SQL Server transaction log and its specificities. Here we are going to examine the...
Best FREE SQL Server Tools for Database Developers and Administrators!
This article comprehensively lists the best SQL Server FREE tools for database developers and...
Lightweight Code Review
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...
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...
ROLLBACK TRUNCATE in SQL Server
Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all...
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 files record all transactions and...
С# Nuances: foreach
You may have been asked a question on a job interview: “What needs to be done to make your class...
