9 Best Practices for Writing SQL Queries

Total: 1 Average: 5

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many ways to execute a SQL query to get desired results on your database.

However, not all SQL queries are created equal. Most can be optimized to follow the best practice. This article focuses on the ways of queries optimizing. After reading, you will know all the dos and don’ts of writing SQL queries.

Read More

Git Tips & Best Practices for Beginners

Total: 1 Average: 5

Without a version control system, it’s next to impossible to manage the source code.  You can be a software developer of C, C#, Java, or any other language, but you need version control. The best and one of the most popular version control systems is Git.

Git is a free open-source distributed version control system (VCS) used by many small and large companies. Its functionality is impressive, and many thousands of Git supporters gladly add more practices and tips to make the source control management more productive.

Currently, you can use more than 35 Git best practices and many tips. However, this article will focus on the best 11 Git tips and practices that are optimal for beginners.

Read More

ASP.NET vs. PHP: the Best Framework for Web Development

Total: 1 Average: 5

The primary goal of web development teams is to deliver web applications with the best user experience, scalability, and sustainability. Hence, developers always look for the right technology stack to build with these goals.

There are various web technologies stacks like PHP, .Net, Ruby on Rails, Java, or Python. PHP and .NET are the most commonly used technologies in web development. As statistics claims, PHP and ASP.NET hold the lion’s share of the web technologies market. In most cases, development teams choose between these two variants.

Both options have their pros and cons. In this article, we’ll discuss the differences and applicability of PHP and ASP.NET.

Read More

How AI Will Change Software Development and Testing

Total: 1 Average: 5

Artificial intelligence is the fuel for what we know as the fifth industrial revolution. Its capacities to impact and disrupt numerous industries are virtually unparalleled. It is no less true regarding software development and testing.

While self-writing code is not yet a broadly commercialized technology, automation is more prevalent in writing and testing software. This approach becomes even stronger with the increasing adoption of AI.

Read More

Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms

Total: 1 Average: 5

This article describes the ways of using an INNER JOIN to combine results from two tables in the SQL Server database and display them in an HTML5 table inside an ASP.NET webform. Additionally, it touches on the question of using CSS3 (cascading style sheets) to apply a style to the HTML5 table in an ASP.NET webform.

Let’s begin.

Read More

Manage MDF Files in SQL Server 2019

Total: 1 Average: 5

An SQL Server database contains primary data files, secondary data files (optional), and transaction log files.

The primary and secondary datafiles contain tables, database objects, schema, and data.

The file extension of the primary database file is *.mdf, and the file extension of the secondary data file is *.ndf.

The transaction log files store all the changes made by the transactions (insert, update, and delete). If the SQL Server restarts unexpectedly or crashes, the database engine rolls the incomplete transaction back before the point of failure using the Transaction log file.

The extension of the transaction log file is *.ldf. You might want to refer to this article to understand the Transaction Log Files architecture.

In this article, I am going to explain how we can manage the database files (MDF files) in SQL Server 2019.

Read More

Make Awesome Lists Yourself, or GitHub as Notebook

Total: 1 Average: 5

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 you. Over time, it all grows excessively, links become broken, and materials get obsolete.

But what if we could share these insightful gems with the community? Upload a file to GitHub? Then, your findings would be useful for someone else. Besides, it would be easier to keep the file up-to-date together, getting the list updated via the good old pull requests.

This is what we have the Awesome Lists project for.

Read More

Everything You Need to Know About SQL CTE in One Spot

Total: 1 Average: 5

The first time Karl heard of SQL Server CTE was when he was looking for something to make his SQL code easier for the eye. It’s kind of a headache when you look at it. Anton, his concerned colleague, asked him about CTE. Karl thought Anton was referring to his headache. Maybe he heard it all wrong, so he answered, “Of course not.” The funny thing is, he was referring to Chronic Traumatic Encephalopathy, also a CTE – a neurodegenerative disease caused by repeated head injuries. But based on Karl’s response, Anton knew for sure that his colleague was clueless about what he was saying.

What a crazy way to introduce CTEs! So, before you get into the same boat, let’s clarify, what is SQL CTE or Common Table Expressions in the SQL world?

You can read the basics here. Meanwhile, we’ll learn a bit more about what happened in this unusual story.

Read More