How to Write Complex Queries in SQL
Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a...
How to Install SQL Server Tools on Ubuntu 18.04 Linux System – Step by Step
In the previous articles, we covered sequential steps necessary to build a virtual machine, install Ubuntu 18.04 operating system, and...
SQL Stuff Function
The main idea around the SQL Server function called STUFF is concatenating multiple columns into a single column with more flexibility than...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server...
Customer Segmentation with Data Flow in Oracle Analytics
Customer Segmentation Analysis is a popular business issue, especially in Retail domain, where companies need to discover the data and...
An Overview of Analytic Functions in PostgreSQL
Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default. They allow you to execute a variety of...
Hash What? Understanding Hash Indexes
Hash indexes are an integral part of databases. If you’ve ever used a database, chances are...
T-SQL Scripts to Monitor your Resource Pool Stats
Imagine you have a business-critical MS SQL Server serving requests for both OLTP and some batch processing tasks, as data gets pulled by...
Import JSON Data with SQL Developer Web into Autonomous Database
Twitter Activity provides loads of information for analysis. You can learn your target audience better, determine the most popular content,...
How to Find SQL Server Instance Name and More with Stored Procedures
SQL Server instances serve as the backbone of a business model, housing databases that contain...
