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:...
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 pitfalls, which we will discuss further...
SQL Server Unit Testing with tSQLt Framework
In this article, we will talk about the tSQLt framework — a free database unit testing...
Iterating Over JavaScript Arrays
Iterating Over Arrays The article describes ES5 and ES6 approaches to iterate over javascript arrays and array-like objects!...
С# Nuances: foreach
You may have been asked a question on a job interview: “What needs to be done to make your class work with the foreach loop?” Well, the...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system...
C# Powerful String Functions
The .NET Framework provides a set of powerful string functions. These building blocks can be used to write more complex algorithms for...
C# Extension Methods: a Useful Example!
What is an extension method? The extension method provides the ability to extend the functionality of an existing class by adding a static...
