SUBSTRING Command in SQL: A Primer
Similar to my article regarding the SQL Server STUFF command, today we will be examining the...
Primary Keys in SQL Server
Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely....
Spark SQL – the Most Important Tool for a Big Data Engineer
Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what...
Everything You Need to Know About SQL CTE in One Spot
The first time Karl heard of SQL Server CTE was when he was looking for something to make his SQL...
Add Columns to an Existing Table in SQL Server Database
Introduction A table is a two-dimensional logical structure and the fundamental means of storing data in relational database management...
Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners
This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values....
Using CASE Expressions in SQL Server
Introduction CASE Expressions in SQL Server are used for the column values substitution to present...
Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger
When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool, it is essential to test the “Live”...
Data Visualization in Microsoft Power BI
Contents Introduction. How to create a table. How to create a Power BI pie chart. Creating a line chart in Power BI. Report creation....
How to Load and Manage Data within Microsoft Power BI
Contents: Introduction Importing data from Excel, SQL Server, and the Web. Importing data from...