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.

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

Uncategorized

Do you want data analysis to be your cup of tea? That’s great because 2021 is a good year for...
Read More

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

Uncategorized

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 and Manage MariaDB via MySQL WorkBench

MySQL, Tools & technologies

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

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized...
Read More

What is SQL Server? (Definition, Versions, Editions)

Database administation, Database development

Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You...
Read More

The Easy and Practical SQL Server Tutorial for Beginners

Database development

Introduction to Our SQL Server Tutorial for Beginners Hello, budding SQL Server enthusiast! CodingSight would like to focus on you, the...
Read More

SQL SELECT DISTINCT: Performance Best Practices

Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
Read More

SQL BETWEEN-Smart Tips to Scan for a Range of Values

Database development, Statements

SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be...
Read More

SQL ORDER BY: The 5 Do’s and Don’ts to Sort Data Like a Pro

Database development, Statements

Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And that’s what SQL ORDER BY is for. Use...
Read More

SQL GROUP BY- 3 Easy Tips to Group Results Like a Pro

Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
Read More
Close