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.

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

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

SQL Data Types: 5 Worst Choices You Need to Stop Today

Database administation, Work with data

Do your choices of SQL server data types and their sizes matter? The answer lies in the result you got. Did your database balloon in a...
Read More

Easy Answers to 5 Vital Questions about Composite Index in SQL

Database development, Indexes

Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter the results with columns a and b only....
Read More

Clustered and Non Clustered Index: 7 Top Points Explained

Database development, Indexes • One Comment

Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what...
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

Database development, Languages & Coding, Statements, T-SQL

Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
Read More

SQL Date Format: How to Handle It the Smart Way

Database administation, Work with data

Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric dates, we have month-day-year,...
Read More

SQL CASE: Know and Avoid 3 Lesser-Known Hassles

Database development, Statements

SQL CASE? Piece of cake! Really? Not until you bump into 3 troublesome issues that can cause...
Read More

Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance

Database administation, Database development, Perfomance Tuning, Statements

What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
Read More

SQL FOREIGN KEY CONSTRAINT: The Ultimate, Easy Guide for Newbies

Constraints, Database development

Newbie? Then an SQL foreign key may be foreign to you. You may have heard different opinions about SQL foreign keys. If you haven’t, soon...
Read More

TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers

Database development, Languages & Coding, Statements, T-SQL

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are...
Read More
Close