SQL Shack - articles about database auditing, server performance, data recovery, and more » Daniel Calbimonte

Introduction to the PostgreSQL tutorial to create a user In this article, we will show a PostgreSQL tutorial to create a user using PgAdmin and PL/PgSQL. Requirements PgAdmin installed. In this e...

https://www.sqlshack.com/postgresql-tutorial-to-create-a-user/

Introduction to the PostgreSQL tutorial In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4th most popular database in the world (the other on...

https://www.sqlshack.com/postgresql-tutorial-for-beginners/

In this article, we will learn how to create PostgreSQL stored procedures using PSQL. Introduction to Psql stored procedure PSQL is the PostgreSQL terminal. If you are familiar with SQL Server, i...

https://www.sqlshack.com/psql-stored-procedures-overview-and-examples/

In this article, we will learn how to create Power BI Reports. This article is created for newbies to start the Power BI world with a simple example. We will connect to SQL Server, show how to tr...

https://www.sqlshack.com/how-to-create-power-bi-reports/

This article is a SQL Server Tutorial. If you want to learn how to install and start with SQL Server from 0, this is the place to start. We will teach you to install SQL Server, start your first ...

https://www.sqlshack.com/sql-server-tutorial/

The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and FALSE. SQL Server uses the bit da...

https://www.sqlshack.com/sql-boolean-tutorial/

Introduction In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from ...

https://www.sqlshack.com/odbc-drivers-for-azure-sql/

In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I will add some theory to understan...

https://www.sqlshack.com/sql-subtract-dates/

Introduction In SQL Server there are several kinds of SQL partitions. However, in general, we can say that a partition is a way to divide a table (sometimes a view) into smaller pieces for perfor...

https://www.sqlshack.com/sql-partition-overview/

Introduction In previous articles, we learn how to configure PostgreSQL ODBC drivers, how to configure ODBC drivers for Azure Database for MySQL, the differences between OLE DB, ODBC, and ADO.net...

https://www.sqlshack.com/odbc-drivers-in-ssis/