Introduction to SQL Joins
SQL joins are a fundamental aspect of working with relational databases. They allow us to combine data from multiple tables based on...
top of page
Search
The Tech Platform
- May 26
Difference between PAD_Index and FillFactor in Database Optimization
In the realm of database management, optimizing storage and performance is a critical task. Two key concepts that contribute to this...
The Tech Platform
- Apr 26
Azure Cosmos DB vs Azure SQL Database
Azure Cosmos DB and Azure SQL Database are two of the most popular database services offered by Microsoft Azure. While both databases...
The Tech Platform
- Apr 24
Data Lake vs Data Warehouse
Data lakes and data warehouses are two popular approaches for storing and managing large volumes of data. While they share some...
The Tech Platform
- Apr 15
Snowflake vs Redshift: The Difference
With the growing demand for cloud-based data warehousing solutions, Snowflake and Redshift have emerged as two of the most popular...
The Tech Platform
- Apr 11
Top 10 NoSQL Database in 2023
NoSQL databases have become increasingly popular due to their ability to handle large amounts of data quickly and efficiently. As we move...
Sofia Sondh
- Jan 31
What is Data Lake?
In data management, the term "data lake" has become increasingly popular in recent years. But what exactly is a data lake, and how does...
Sofia Sondh
- Jan 23
What is SQL and How it works?
SQL (Structured Query Language) is a programming language used to manage and manipulate data in relational databases. It is used to...
Sofia Sondh
- Jan 1
Data Warehouse
Data Warehouse supports business intelligence activities such as data analysis and reporting. It is a large, structured database that...
The Tech Platform
- Nov 28, 2022
Best Free SQL Online Courses in 2022
SQL is a standard language for storing, manipulating, and retrieving data in databases. This will teach you how to use SQL in MySQL, SQL...
The Tech Platform
- Oct 17, 2022
Data Protection in ASP.NET Core
The data protection system is a set of cryptography APIs used by ASP.NET Core to encrypt data that must be handled by an untrusted third...
The Tech Platform
- Aug 18, 2022
How to Share Data Between Microservices?
Prologue Fiverr is an online marketplace for freelance services. Sellers offer their services, or Gig — e.g, graphic design,...
The Tech Platform
- Aug 8, 2022
Top 10 Web Scraping Tools
Web Scraping is an automatic method to obtain large amounts of data from websites. Most of this data is unstructured data in an HTML...
The Tech Platform
- Jul 18, 2022
SQL Server Query Tips for Database Performance. How to improve SQL Query Performance?
Efficient and speedy data retrieval is crucial for the success of applications and systems that rely on databases. SQL (Structured Query...
The Tech Platform
- Jul 18, 2022
Copying data between GSheets with AppScript
In our team, we have a lot of Google Sheets 📃 and we often need to show the same content between sheets. (e.g. 2 Sheets both need data...
The Tech Platform
- Jul 7, 2022
Configure Multiple DBs with Repository pattern in .Net Core
To configure mongoDB, we need to install mongoDB driver for C#, this we can install via NuGet package manager. After installation we need...
The Tech Platform
- Jul 5, 2022
Azure Data Studio vs SQL Server Management Studio (SSMS): Which one to choose?
Azure Data Studio Azure Data Studio is a free Microsoft desktop tool, initially called SQL Operations Studio, that can be used to manage...
The Tech Platform
- Jun 6, 2022
Important SQL Queries you should know
SQL commands are the instructions used to communicate with a database to perform tasks, functions, and queries with data. SQL commands...
The Tech Platform
- May 25, 2022
Top Question and Answer about SQL Server Indexes
Top Interview Questions and Answer about SQL Server Indexes.
The Tech Platform
- May 24, 2022
SQL Server Index Design and Architecture
SQL index is considered as one of the most important factors in the SQL Server performance tuning field. It helps in speeding up the...
bottom of page