Do You Make These Mistakes When Using SQL CURSOR?
For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in...
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3
CROSS JOIN is in the spotlight. This article finishes our small series of SQL JOIN-related publications. If you missed the previous two...
Top 3 Tips You Need to Know to Write Faster SQL Views
Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
Your Ultimate Guide to SQL Join: INNER JOIN – Part 1
Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic code with T-SQL codes embedded in it....
Top Answers to 5 Burning Questions on COALESCE Function in SQL Server
How cool is COALESCE function in SQL? It’s cool enough to be so important to me. And I’ll be...
3 Easy and Secure Ways to Make Users Run SSIS Packages
Have you ever come across a situation where you needed to make users run SSIS packages? This happens when the user is not comfortable with...
3 Nasty I/O Statistics That Lag SQL Query Performance
“But it ran fine on our development server!” How many times did I hear it when SQL query performance issues occurred here and there? I...
How to Make Sense of SQL Server Geography Data Type
SQL Server Geography data type is unlike other types simply because you don’t use it often....
