PostgreSQL Tutorial for beginners

April 6, 2023 by

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 ones are Oracle, SQL Server, and MySQL). That is why we think it is an important DBMS to learn.

Power BI Desktop - Get data

How to create Power BI reports

January 11, 2023 by

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 transform data from SQL Server in Power BI, and then we will create some reports, and play with […]

We need to use IS NULL or IS NOT NULL syntax when we compare the NULL values in a table

5 Best Practices for writing SQL queries

December 30, 2022 by

In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions […]

Restore database

Use of the RESTORE FILELISTONLY command in SQL Server

December 21, 2022 by

This article explores the RESTORE FILELISTONLY command in SQL Server with examples. Introduction Performing a database backup is an integral part of a DBA’s job. Backups are taken to ensure that data can be recovered in an emergency. There are different restore mechanisms, and the SQL Server DBA needs to understand them to make the […]

Get age in SQL Server based on bithdate

SQL Subtract dates

November 7, 2022 by

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 understand the syntax of the DATEDIFF function which is the base of this article.

ODBC connection to test database

ODBC Drivers in SSIS

September 23, 2022 by

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, how to configure Linked Servers using ODBC DRIVER. This time we will use the ODBC Drivers to connect in SSIS.