This article will walk you through all the steps to uninstall MariaDB in Windows, Linux, Ubuntu, etc. You can install MariaDB on your computer if you have not yet done so. How to uninstall MariaDB Let us discuss all the cases individually. Case-1 In Windows There are several methods to uninstall MariaDB from Windows. Some of them … Read more >>
If you’ve tried ORDER BY ship_date DESC to find your latest shipment, you’ve probably seen blank dates land on top. PostgreSQL ORDER BY sorts rows by any column or expression; add NULLS LAST and those blanks drop to the bottom. Without ORDER BY, PostgreSQL returns rows in no guaranteed order, so every “top N” or … Read more >>
As a database consultant working with PostgreSQL, I’ve recently had a requirement to convert timestamp values to dates for one of the applications. In this comprehensive guide, I’ll share the multiple methods to convert PostgreSQL timestamps to dates, including the pros and cons of each approach. PostgreSQL Cast Timestamp To Date Before diving into conversion … Read more >>
In this Azure SQL article, you will learn how to create a table in the Azure SQL database. We will discuss multiple ways that you can use to create a table in an Azure SQL database. Also, we have created some examples so that you can understand the concept better. Create table syntax in Azure … Read more >>
When you create an Azure SQL database, a default administrator user is created. This user has all the administrative rights and can manage the SQL server and the databases as an administrator. However, you also need to create more users to manage access to the database. We use multiple users with different authorization levels and … Read more >>
In this SQL Server tutorial, we are going to talk about SQL Server scheduled stored procedure. Here we will learn about different methods of scheduling a stored procedure in SQL Server. And we will also understand the following topics. SQL Server scheduled stored procedure In this section, we will try to understand how to schedule a stored … Read more >>
In this SQL Server tutorial, we will understand the difference between table and view in SQL Server. Moreover, we will also discuss the following topics in this tutorial. Is a view a table in SQL Server? A view in SQL Server is just like a virtual table created from a result set of a SQL query. A view … Read more >>
You may have faced scenarios when you need to change the password of your Azure SQL database. In this article, we will explain various ways to achieve this. How To Reset Azure SQL Database Password Let us discuss all the approaches individually. Approach-1: Using Azure Portal To reset Azure SQL database password, follow the below … Read more >>
If you’ve tried to query a table as a new login, you’ve probably seen “The SELECT permission was denied on the object.” SQL Server user permissions are working; nobody granted that user SELECT. The fix starts with knowing what a user can do: impersonate them with EXECUTE AS USER, run fn_my_permissions, then REVERT. You change … Read more >>
In this PostgreSQL tutorial, I will show you how to format numbers in PostgreSQL, where you will understand different functions provided by PostgreSQL such as to_char, round() and etc. Additionally, you will understand how to use lpad() function with the numeric value, and use the to_char() function to format the numeric value with the currency … Read more >>