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...
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 databases that process transactions at a...
Customer Segmentation with Data Flow in Oracle Analytics
Customer Segmentation Analysis is a popular business issue, especially in Retail domain, where...
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 that you have seen them in action without...
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...
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 vital data for backend operations or...
Execute Dynamic Query in SQL Server
Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically...
