tips and tricks Archives - {coding}Sight

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

Edwin Sanchez — Fri, 13 Aug 2021 08:50:36 +0000

SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be outside of the range if you add the NOT operator before it. It works for dates, dates with time, numbers, and strings. You can use it on …

The post SQL BETWEEN-Smart Tips to Scan for a Range of Values appeared first on {coding}Sight.

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

Edwin Sanchez — Tue, 10 Aug 2021 06:56:55 +0000

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 methods is the SQL GROUP BY clause. You can use SQL GROUP BY to divide rows in results into groups with an aggregate function. It sounds easy to sum, …

The post GROUP BY in SQL Server: 3 Easy Examples to Group Results appeared first on {coding}Sight.

Make Awesome Lists Yourself, or GitHub as Notebook

Maksim Gramin — Tue, 22 Dec 2020 18:14:48 +0000

This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps, everyone has somewhere a file to keep certain exciting and useful things, like, links to articles, books, repositories, manuals, etc. You might use bookmarks in a browser or tabs, still open and waiting for …

The post Make Awesome Lists Yourself, or GitHub as Notebook appeared first on {coding}Sight.

Seven Secrets in SSMS for Developers

Kenneth Igiri — Thu, 12 Nov 2020 14:47:37 +0000

SQL Server Management Studio is Microsoft’s primary client tool for interacting with SQL Server. It is simple, and it has been around for quite a while (launched with SQL Server 2005). Still, it is easy to miss plenty of great features that can make the T-SQL scripts execution and overall interaction with SQL Server more …

The post Seven Secrets in SSMS for Developers appeared first on {coding}Sight.

Automated testing of the desktop application: expediency and frameworks overview

Oleh Levytskyi — Tue, 29 Oct 2019 00:55:54 +0000

Introduction You have certainly heard about regression and acceptance testing. But do you know how much is actually spent on acceptance testing in a project? We can quickly get an answer to this with the help of a time tracking system like TMetric. On our project, acceptance-testing a desktop application of around 100 assemblies took …

The post Automated testing of the desktop application: expediency and frameworks overview appeared first on {coding}Sight.

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

Andrey Podkolzin — Sun, 14 Jul 2019 22:27:12 +0000

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 part, I focused on the basic set of tools used to start a thread or a Task, the ways to track their state, and some additional neat things such …

The post .NET – Tools for working with multithreading and asynchrony – Part 2 appeared first on {coding}Sight.

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

Andrey Podkolzin — Wed, 22 May 2019 22:28:24 +0000

The need to do things in an asynchronous way – that is, dividing big tasks between multiple working units – was present long before the appearance of computers. However, when they did appear, this need became even more obvious. It is now 2019, and I’m writing this article on a laptop powered by an 8-core …

The post .NET: Tools for working with multi-threading and asynchrony – Part 1 appeared first on {coding}Sight.

New Features in Visual Studio 2019

Amarendra Babu — Tue, 30 Apr 2019 21:50:34 +0000

Microsoft has recently released the preview version of Visual Studio 2019. Like all previous editions, the latest Visual Studio comes with lots of improvements and new features that are focused on faster execution, more productivity for developers and team collaboration. If you haven’t downloaded it yet, you can do it here for free: Visual Studio …

The post New Features in Visual Studio 2019 appeared first on {coding}Sight.

SQL Server 2019 New Features

Amarendra Babu — Thu, 14 Feb 2019 08:44:45 +0000

Microsoft’s leading database is an essential tool, with in-cloud and on-premises versions providing incredible storage and analytic tools. It’s additionally turned into an essential application for data scientists, giving a structure to building and testing machine learning models. There is more in SQL Server, and the new release version can indicate where Microsoft thinks your …

The post SQL Server 2019 New Features appeared first on {coding}Sight.

SQL Database Administrator Interview Tips

Esat Erkeç — Fri, 28 Sep 2018 14:11:02 +0000

Interview is the most significant step of SQL database administrator recruitment. During the interview, a technical person or interviewer asks questions about the technical experience of a candidate. The purpose of these questions is to understand candidate’s experience about SQL Server. The answers to the questions will measure your knowledge and experience. If you cannot …

The post SQL Database Administrator Interview Tips appeared first on {coding}Sight.