Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to...
Understanding Text Mining with SQL Example
The current article focuses on the conceptual understanding of Text Mining. It gives clear examples and teaches us to use the T-SQL script...
Basics of Working with JSON in SQL Server
JSON – A Brief Background JSON is an acronym for JavaScript Object Notation, that became popular a little over seventeen years ago. JSON...
Filtering Data in T-SQL
Introduction In most scenarios when working with data, users do not require all the data in each...
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 usage and provided several examples with...
Transact-SQL: Working With Strings
Microsoft SQL Server has many built-in functions that can be used to format the output and...
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 greater values, and the other 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...
