Javascrtipt Deep Copy
In this article, we will discuss how to copy and deep copy javascript objects....
Creating Excel in JavaScript
In this article, we will create an excel-like application that takes about 30 rows of JS code, with automatic saving to localStorage....
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...
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 pitfalls, which we will discuss further...
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...
SQL Server: DELETE vs TRUNCATE
T-SQL provides two keywords that allow you to delete data from a table. They are DELETE and TRUNCATE. These are alike in what they are...
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...
