Tag: tips and tricks

SQL BETWEEN-Smart Tips to Scan for a Range of Values

Database development, Statements

SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be...
Read More

GROUP BY in SQL Server: 3 Easy Examples to Group Results

Database development, SQL Server, Statements

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

Make Awesome Lists Yourself, or GitHub as Notebook

Database administration, Work with data

This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps,...
Read More

Seven Secrets in SSMS for Developers

SSMS, Tools & technologies

SQL Server Management Studio is Microsoft’s primary client tool for interacting with SQL Server....
Read More

Automated testing of the desktop application: expediency and frameworks overview

Automation, Languages & Coding, Testing

Introduction You have certainly heard about regression and acceptance testing. But do you know how much is actually spent on acceptance...
Read More

.NET – Tools for working with multithreading and asynchrony – Part 2

ASP .NET CORE, Languages & Coding, Tools & technologies

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

.NET: Tools for working with multi-threading and asynchrony – Part 1

ASP .NET CORE, Languages & Coding, Tools & technologies

The need to do things in an asynchronous way – that is, dividing big tasks between multiple...
Read More

New Features in Visual Studio 2019

Tools & technologies, Visual Studio

Microsoft has recently released the preview version of Visual Studio 2019. Like all previous editions, the latest Visual Studio comes with...
Read More

SQL Server 2019 New Features

Database development

Microsoft’s leading database is an essential tool, with in-cloud and on-premises versions providing incredible storage and analytic...
Read More

SQL Database Administrator Interview Tips

Database administration

Interview is the most significant step of SQL database administrator recruitment. During the...
Read More