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.

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? ...
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 joined tables again and again. So, when...
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...
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 your UPDATE skills. But with this, you...
Read More

How to Insert Multiple Rows in SQL Server Like a Hero DBA 

SQL Server

Hi there, newbie. Are you still using multiple INSERT statements to insert multiple rows in SQL Server?  Let me tell you today that...
Read More

MySQL Copy Database: Make Clones Of Your Databases With Ease

MySQL

MySQL copy database is handy when you need to make clones or duplicates of a MySQL database. These...
Read More

Power BI Star Schema: The Easy How-To Guide for Starters

Power BI

Do you want data analysis to be your cup of tea? That’s great because 2021 is a good year for that. If you’re starting out, part of...
Read More

How to Install SQL Server (The No-Nonsense, Easy Guide)

SQL Server

Last time, you learned about a primer on SQL Server. In that article, you also learned about the different versions and editions of...
Read More

How to Connect MySQL Workbench to MariaDB

MySQL, Tools & technologies

To use MySQL Workbench as a GUI for MariaDB? If you’re filled with disbelief right now, you’re...
Read More
Close