There are times when we need to know which jobs are going to run in the upcoming half an hour or so. It is quite possible
Category: RDBMS
Creating Linked Server for PostgreSQL in MSSQL
Creating a linked server in Microsoft SQL Server to connect PostgreSQL 1) Download the PostgreSQL Unicode (x64) driver to support ODBC. 2) Go to ODBC
Automation – PostgreSQL Restore Data
There are three methods to backing up PostgreSQL databases SQL dump File System Level backup Continuous archiving SQL Dump command used to take a full
Aggregate Functions in Analytic Context
The functions SUM, AVG, COUNT, MIN, and MAX are well-known aggregate functions that we use every day. They are to compute/summarize the multiple rows by
SQL Server 2016, 2017 and 2019 New Functions
There are several string and analytical functions introduced with the newer versions of SQL Server and are listed below. STRING_SPLIT is a table-valued function introduced
Approximate Count of Unique Values in SQL Server
In my previous blog, I discussed the approximate count of unique values for which a predefined function is available in Impala (NDV), Oracle 12c (APPROX_COUNT_DISTINCT)
Big Data & SQL 