-
Personal Links
Verified Services
Top 30 PowerShell bloggers of 2018
https://www.sqlshack.com/top-50-powershell-bloggers-of-2018/#Prashanth%20JayaramMy Blog is ranked amongst the Top 50 SQL blogs worldwide
http://blog.feedspot.com/sql_blogs/DZone MVB
Microsoft
Author Archives: Prashanth Jayaram
Overview of DML Operations – SQL Delete
This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations in SQL Server. To remove a row from a table is accomplished through a Data Manipulation Language, aka DML statement, using … Continue reading
Overview of the SQL Insert statement
This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The previous articles are focused on SQL query techniques, all centered around the task of data preparation and data transformation. The … Continue reading
Posted in SQL
Tagged Different ways to insert SQL statment, insert statment in SQL, SQL Insert
Leave a comment
SQL Pivot and Unpivot relational operatots
In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose SQL Server data. Also, we’ll discuss both static and dynamic ways to use PIVOT and UNPIVOT relational operators that can … Continue reading
Overview of the SQL Update statement
In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table. After reading this article, you’ll understand the following topics covering how to use a simple SQL update statement on multiple columns … Continue reading
Overview of SQL UNION
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
Overview of SQL Joins in SQL Server
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 equi join, left join, non-equi join, outer joins, right join, SQL Server inner join, SQL Server non-equi join
Leave a comment
SQL Substring function in SQL Server
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
SQL Server string functions for Data Munging (Wrangling)
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
Getting started with SQL Server Tools
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
What’s new in SQL Server 2017
SQL Server 2017 is considered a major release in the history of the SQL Server life cycle for various reasons. From my personal point of view, SQL Server 2017 is indeed an interesting release. After writing a lot about it … Continue reading
