Basics of Working with JSON in SQL Server
JSON – A Brief Background JSON is an acronym for JavaScript Object Notation, that became popular...
Filtering Data in T-SQL
Introduction In most scenarios when working with data, users do not require all the data in each instance of a query. T-SQL (and SQL of...
Automated testing of the desktop application: expediency and frameworks overview
Introduction You have certainly heard about regression and acceptance testing. But do you know how much is actually spent on acceptance...
T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its...
Transact-SQL: Working With Strings
Microsoft SQL Server has many built-in functions that can be used to format the output and represents it in the desired format. In this...
T-SQL Regular Expression: LIKE Operator and Its Use-Cases
A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In essence, it is a sequence of characters or...
Calculate the median by using Transact SQL
The statistical median is the value which separates a dataset into halves – one comprises...
.NET – Tools for working with multithreading and asynchrony – Part 2
This article comprises the second part of my speech at the multithreading meetup. You can have a look at the first part here. In the first...
Auto Create Statistics and Auto Update Statistics
Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine the optimal way to retrieve data from the...
T-SQL SET Operators Part 2: INTERSECT and EXCEPT
In my previous article, I explained the basics of set operators, their types, and prerequisites for...
