SQL BETWEEN-Smart Tips to Scan for a Range of Values
SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be...
GROUP BY in SQL Server: 3 Easy Examples to Group Results
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
Make Awesome Lists Yourself, or GitHub as Notebook
This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps,...
Seven Secrets in SSMS for Developers
SQL Server Management Studio is Microsoft’s primary client tool for interacting with SQL Server....
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...
.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...
.NET: Tools for working with multi-threading and asynchrony – Part 1
The need to do things in an asynchronous way – that is, dividing big tasks between multiple...
New Features in Visual Studio 2019
Microsoft has recently released the preview version of Visual Studio 2019. Like all previous editions, the latest Visual Studio comes with...
SQL Server 2019 New Features
Microsoft’s leading database is an essential tool, with in-cloud and on-premises versions providing incredible storage and analytic...
SQL Database Administrator Interview Tips
Interview is the most significant step of SQL database administrator recruitment. During the...
