Bijay

I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc. Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.

SQL Server Add Column + Examples

by
SQL Server Add Column

In this SQL Server tutorial, we will learn How to add a column in the SQL Server table, Different examples related to adding a column, and will cover the following topics. SQL server add column with default value In SQL Server, we can specify a default value for a column in SQL server 2019, and it … Read more >>

SQL Server Convert Datetime to String + Examples

by
SQL Server Convert Datetime to String

In this SQL Server tutorial, we will learn How to convert Datetime datatype to String in SQL Server, Different SQL Server convert DateTime to string examples, and cover the below topic. Here, I have used sql server management studio and sql server 2019. SQL Server Convert Datetime to String Format There are mainly 2 functions … Read more >>

How to execute function in SQL with parameters

by
how to execute function in sql server with parameters

In this sql server tutorial, we will see, how to execute function in sql with parameters and we will see a few examples: How to execute user-defined function in SQL with parameters A user-defined function is a function created by a user and will perform an operation specified by the user. In this section, we … Read more >>

How to Restart PostgreSQL (Linux, Windows, Mac)

by
restart postgres centos

In this PostgreSQL tutorial, we will learn how to restart PostgreSQL services or servers in various platforms like Windows, Mac, and Linux. Also, we will cover these topics: How to Restart Postgres Service In this section, we will see why do we need to restart the PostgreSQL services on various platforms like Windows, Mac, and … Read more >>

How to Uninstall PostgreSQL (Linux, Mac,Windows)

by
uninstall PostgreSQL in Ubuntu

In this PostgreSQL tutorial, we will learn how to uninstall PostgreSQL from different operating systems. The possible reasons for uninstalling PostgreSQL could be the project is complete and you don’t need PostgreSQL, the software is at fault or broken, unable to update the PostgreSQL so want to reinstall with the latest version, etc. How to … Read more >>

SQL Server Convert String to Date + Examples

by
SQL Server Convert String to Date

In this SQL Server tutorial, we will discuss How to convert a String to Date in SQL Server, Different SQL Server Conversion Scenarios, and cover the below topic. All the examples, I have done here in sql server 2019 and SQL server management studio. SQL Server Convert String to Date When working with SQL Server, you may come across … Read more >>

SQL Server Convert Datetime to date + Examples

by
SQL Server Convert Datetime to date

In this SQL Server tutorial, we will discuss How to convert a DateTime to Date in SQL Server, Different SQL Server Conversion Scenarios, and cover the below topic. For all the examples, I have used sql server 2019 and sql server management studio. SQL Server Convert Datetime to date mm/dd/yyyy In SQL Server to convert a DateTime expression to … Read more >>

Top 200 SQL Server Interview Questions and Answers

Free PDF On Top 200 SQL Server Interview Questions And Answers

Download A 40 pages PDF And Learn Now.