SQL

Suppose you've had SQL Server installed for a while and forgotten your SA password. Even long-time users can encounter this situation. This article from TipsMake will guide you on

You may not know this, but Microsoft is quite supportive of the open-source community. Proof of this is that some Microsoft software is available on Linux, including .NET and SQL.

Previous articles by TipsMake have introduced you to common commands and clauses in SQL. Today's article will continue by introducing you to the LIKE and IN comparison operators in

SQL stands for Structured Query Language, a programming language used to communicate with and manipulate databases. In this article, TipsMake will introduce the CREATE command in

DCL commands in SQL are used to enforce database security in user database environments. The GRANT and REVOKE commands in SQL are two types of DCL commands. To learn more about DCL

Typically, the JOINS statement in SQL is used to connect information in different tables; the JOINS condition is part of an SQL query to retrieve rows from two or more tables.

Today, TipsMake will guide you on how to deploy SQL Server through PowerShell DSC, enabling you to use the new PowerShell feature to manage your infrastructure on-premises and in

Microsoft SQL Server has a built-in Identity column, used to generate important values. It can reference an AutoNumber field in Microsoft Access or a range in Oracle. This article

In case your SA account is disabled and you cannot log in to SQL Server, this article from TipsMake will guide you on how to log in to SQL Server if your SA account is disabled.

For those learning programming, Laravel is a must-know. So, how do you install Laravel on your computer, run web applications smoothly, and help you learn and practice effectively?

The latest version of Microsoft SQL Server 2019 offers many attractive new features to meet the needs of today's users, especially in helping organizations evaluate and verify data

The AND and OR operators are used to combine multiple conditions to narrow down the data in an SQL statement. These two operators are called conjugate operators in SQL. AND and OR

How is a database drop used in SQL? This article will guide you in detail on how to delete a database in SQL.

There are many types of RDBMS such as MySQL, Oracle, SQL Server, Mongo DB, Sybase,... To better understand RDBMS, in this article we will learn about some of the most popular

What is Window Function in SQL? Let's explore how to use window functions to conduct statistical analysis with just one SQL query.

Deleting tables in SQL is used quite a lot. This term is also known as drop table in SQL. Here's everything you need to know about deleting tables in SQL.

What does the CREATE TABLE command in SQL do? In this article, let's learn everything you need to know about the CREATE TABLE statement in SQL!

An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. These SQL expressions are like formulas and they are written in query

SQL has a set of rules and instructions called Syntax (syntax). This article will quickly list for you the basic SQL syntax.

What is RDBMS? RDBMS stands for Relational Database Management System. RDBMS is the foundation for SQL as well as for all other database systems such as MS SQL Server, IBM DB2,