What is AWS Athena?
AWS Athena is a fully managed, popular cloud service provided by Amazon to query structured data in...
Oracle Predictive Analytics: How to Predict of Employee Attrition
From the Customer Segmentation tutorial, you already know that Oracle Analytics provides several Machine Learning (ML) algorithms to solve...
Upload Files to AWS S3 with the AWS CLI
Introduction Amazon Web Service, aka AWS, is a leading cloud infrastructure provider for storing your servers, applications, databases,...
An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle...
Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can be integer, float, Varchar, NVARCHAR,...
SQL Server COUNT Function
COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers for their day-to-day needs. In this...
SQL Server Configuration Manager
Introduced in SQL Server 2005, SQL Server Configuration Manager is a tool that is installed by...
How to limit rows in SQL Server
While executing SELECT queries on tables containing huge records, developers often need to limit the number of records being fetched out to...
Stored Procedure to Get Logins and Server Roles Inventory
Security is for sure one of the most important areas that we, as professional DBAs, must cover. Within SQL Server, there are many...
User-Defined Data Types In SQL Server
SQL Server platform comes with many data types, but there are cases when they are not sufficient....
