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

Do You Make These Mistakes When Using SQL CURSOR?

Total: 3 Average: 5

For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in the details! You can read all sorts of blasphemy in the entire SQL blogosphere in the name of SQL CURSOR.

If you feel the same way, what made you come to this conclusion?

If it’s from a trusted friend and colleague, I can’t blame you. It happens. Sometimes a lot. But if someone convinced you with proof, that’s a different story.

We haven’t met before. You don’t know me as a friend. But I hope that I can explain it with examples and convince you that SQL CURSOR has its place. It’s not much, but that small place in our code has rules.

Read More

Virtual Columns and Functional Indexes

Total: 1 Average: 5

Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very long time to execute, but they consume a huge amount of CPU and other resources. Nevertheless, in many cases, complex queries provide valuable information to the application/person. Therefore, it brings useful assets in all varieties of applications.

Read More

How AI Will Change Software Development and Testing

Total: 2 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

Install Azure CLI 2.0 on Microsoft Windows

Total: 2 Average: 5

Azure CLI is a Microsoft cross-platform tool that allows users to remotely access Azure services via their command line. The current article will describe installing Azure CLI 2.0 on Windows. However, before we go to perform this task, we’ll briefly review what Microsoft Azure is, what services it provides, and how to sign up with Microsoft Azure.

Let’s begin without ado.

Read More

Understanding SQL Server ALTER TABLE ADD COLUMN Statement

Total: 1 Average: 5

This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this statement is to add a new column to an existing table. Also, the article will clarify the following use cases:

  1. Add multiple columns.
  2. Add a new primary key column.
  3. Add a new foreign key column.
  4. Add new columns that have computed columns.
  5. Add a new column that has CHECK and UNIQUE constraints.
Read More

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

Total: 2 Average: 4

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

SQL DROP TABLE Statement and Various Use Cases

Total: 1 Average: 5

The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it. The statement is irreversible. Thus, you can restore the table only by restoring the backup.

This article covers the following cases:

  1. Delete one or multiple tables.
  2. Delete the table used in a View.
  3. Delete the table having a foreign key.
  4. Delete the table having clustered and non-clustered indexes.
  5. Delete the table from the replication setup.
Read More