Author: Edwin Sanchez

Software developer and project manager with a total of 20+ years of software development. His most recent technology preferences include C#, SQL Server BI Stack, Power BI, and Sharepoint. Edwin combines his technical knowledge with his most recent content writing skills to help new breed of technology enthusiasts.

How to Get SQL Percentage Calculation as Easy as Pie 

SQL Server, Work with data

Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a...
Read More

MySQL Delete Column: The 2024 Ultimate Easy Guide 

MySQL, Tables

The MySQL delete column might sound pretty straightforward. You simply run the DROP COLUMN command, and poof! It’s gone. ...
Read More

Oracle Performance Tuning: Tips, Tricks and Hidden Secrets

Oracle

Ever wondered why Oracle Performance Tuning is so thrilling for budding Oracle developers and DBAs?  The answer lies in the art of...
Read More

SQL Multiple Joins – How to Join Tables the Easy-Breezy Way 

Database development, SQL Server

Have you ever found yourself tangled in the web of SQL multiple joins?  Don’t sweat it –...
Read More

MySQL Foreign Key – How to Relate Tables Without Freaking Out 

MySQL

Have you ever felt like a puzzle piece that won’t fit, especially about MySQL foreign keys?  Trust me, you’re not alone on this...
Read More

The MySQL ADD COLUMN Easy Guide: How to Make New Table Columns Without the Oops 

MySQL, Tables

Have you made a rookie mistake when you add or insert a new column in your MySQL table?  “But what’s the big deal? Adding or...
Read More

The SELECT INTO Temp Table Easy Guide: How to Manage Temporary Data Without Dismay       

SQL Server, Statements, Tables

Data processing may involve several steps. And it can be fun! But the fun ends when you access some...
Read More

SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets 

SQL Server, Work with data

Is SQL Server PARTITION BY clause giving you a brain freeze?  Beginners feel like entering a complex maze at first glance of code...
Read More

T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time 

SQL Server, Work with data

Is it a big deal to choose between CHAR and VARCHAR? What if your choice between CHAR vs. VARCHAR results in a nightmare of query...
Read More

SQL Server UPDATE from SELECT: How to Bulletproof Your Updates Like a Pro 

SQL Server, Statements

SQL Server UPDATE from SELECT is not your usual cup of tea on T-SQL. So, it’s time to level up...
Read More
Close