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.

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

16:37 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...
Read More

The Easy and Practical SQL Server Tutorial for Beginners

13:47 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

Is SQL DISTINCT Good for Removing Duplicates in Results?

05:57 Database development, Statements

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

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

10:50 Database development, Statements

SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be...
Read More

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

10:24 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

08:56 Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
Read More

The Best SQL VARCHAR Do’s and Don’ts for Faster Databases

10:05 Database administation, Work with data

This post has “strings attached: for a good reason. We are going to explore deep into SQL...
Read More

What are SQL Aggregate Functions? (Easy Tips for Newbies)

09:59 Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these...
Read More

10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL

12:37 SQL Server • One Comment

Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow someone to take over your database. Plus,...
Read More

SQL FLOAT: 3 Points that Will Help you to Avoid Weird Math Errors

12:31 Database administation, Work with data

Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL...
Read More