Monthly Archives: September 2018

Overview of SQL UNION

Posted on September 27, 2018 by Prashanth Jayaram

This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL. To address real-world data requirements, we may need … Continue reading →

Posted in T-SQL | Tagged , , , | Leave a comment

Overview of SQL Joins in SQL Server

Posted on September 19, 2018 by Prashanth Jayaram

The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause.  It’s the nature of traditional relational database systems where some table … Continue reading →

Posted in SQL Joins | Tagged , , , , , , | Leave a comment

SQL Substring function in SQL Server

Posted on September 17, 2018 by Prashanth Jayaram

The requirement of data refactoring is very common and vital in data mining operations. In the previous article, you’ll learn the tips for getting started with SQL string functions, including the SQL substring function for data munging with SQL Server. … Continue reading →

Posted in SQL String | Tagged , | Leave a comment

SQL Server string functions for Data Munging (Wrangling)

Posted on September 13, 2018 by Prashanth Jayaram

In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server. In many cases, Machine learning outcomes are only as good as the data they’re built on – but the work … Continue reading →

Posted in String handling | Tagged , | Leave a comment

Getting started with SQL Server Tools

Posted on September 4, 2018 by Prashanth Jayaram

This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques to build applications using SQL Server tools. The first article of the series covers the rudimentary DevOps concepts and discusses … Continue reading →

Posted in SQL Server Tools | Tagged , , , , | Leave a comment