Probably most of the DBAs are already aware of how to identify which is active SQL Server node in the clustered environment, however, this will
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Reason to convert datetime to bigint – What is epoch time
In my previous article, I had discussed the conversion of bigint value to date time in both PostgreSQL and SQL Server. It raises several questions
PostgreSQL BigInt Value – Conversion to UTC and Local Times
Most of the ticketing systems by default use either MySQL or PostgreSQL and often stores the date-time of the DML events in Bigint format. When
Computing Running & Cumulative Average
This article helps you understand how to calculate the running average and cumulative average on a given data set. As discussed earlier, windowing functions
Displaying the column names in Hive
In my previous post, I discussed about setting a property in the Hive prompt to print the database name which we are currently working. Similarly,
Showing the database name in Hive Prompt
Unlike in traditional RDBMS systems, it is difficult to know in which database we are currently working in Hive due to its command-line interface. It
Big Data & SQL 