Languages & Coding

Creating Excel in JavaScript

Basics of JavaScript, Languages & Coding

In this article, we will create an excel-like application that takes about 30 rows of JS code, with...
Read More

SQL Server 2016: New T-SQL Features

Languages & Coding, T-SQL

In this article, I would like to describe several new T-SQL features available in SQL Server 2016: DROP IF EXISTS, SESSION_CONTEXT, MAXDOP,...
Read More

Detecting Internet Explorer in JavaScript

Basics of JavaScript, Languages & Coding

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

How to Pass Parameters in Dynamic T-SQL Query

Languages & Coding, T-SQL

Developers are often faced with the need to build a dynamic query, however, there are a number of...
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

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

С# 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

Retrieving SQL Server Metadata with Help of T-SQL

Languages & Coding, T-SQL • 2 Comments

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
Read More

C# Powerful String Functions

Basics of C#, Languages & Coding

The .NET Framework provides a set of powerful string functions. These building blocks can be used to write more complex algorithms for...
Read More

C# Extension Methods: a Useful Example!

Basics of C#, Languages & Coding

What is an extension method? The extension method provides the ability to extend the functionality...
Read More
Close