Creating Excel in JavaScript
In this article, we will create an excel-like application that takes about 30 rows of JS code, with...
SQL Server 2016: New T-SQL Features
In this article, I would like to describe several new T-SQL features available in SQL Server 2016: DROP IF EXISTS, SESSION_CONTEXT, MAXDOP,...
Detecting Internet Explorer in JavaScript
There are several simple ways to detect whether the web browser is IE or not. In the following code example, the variable returns true in...
How to Pass Parameters in Dynamic T-SQL Query
Developers are often faced with the need to build a dynamic query, however, there are a number of...
Database Checkpoints in SQL Server
In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
In-Memory OLTP: What’s new in SQL Server 2016
SQL Server development team has added new features to In-Memory OLTP. All these features allow you to build new applications as well as to...
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...
Lightweight Code Review
This is the third article in a series of articles that describe code review process. In this part,...
