-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

PowerSQL By Prashanth Jayaram

Technology enthusiast with 7+ years of experience in Database Technology. I am Microsoft Certified Professional with certificates of OCA, MCP, MCTS, MCITP developer, MCITP administration and backed with a degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication, PowerShell and Performance Tuning. Hobbies are Drawing, playing soccer and listening to Melodies songs.

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

Read more

0 comments, 49 reads

Posted in PowerSQL By Prashanth Jayaram on 15 October 2018

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

Read more

0 comments, 158 reads

Posted in PowerSQL By Prashanth Jayaram on 8 October 2018

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

Read more

0 comments, 485 reads

Posted in PowerSQL By Prashanth Jayaram on 27 September 2018

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

Read more

0 comments, 460 reads

Posted in PowerSQL By Prashanth Jayaram on 19 September 2018

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

Read more

0 comments, 153 reads

Posted in PowerSQL By Prashanth Jayaram on 17 September 2018

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

Read more

0 comments, 189 reads

Posted in PowerSQL By Prashanth Jayaram on 13 September 2018

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

Read more

0 comments, 527 reads

Posted in PowerSQL By Prashanth Jayaram on 4 September 2018

Experimenting SysTools SQL Database Repair Tool by SQL MVP Shashank

Author Bio: Shashank is a TechNet Wiki Ninja who loves to work on SQL Server. He lives in Mumbai and has won TechNet Guru award multiple times. Areas of his expertise are SQL Server, Database internals, SQL Server HA, SQL … Continue reading

Read more

0 comments, 222 reads

Posted in PowerSQL By Prashanth Jayaram on 24 August 2018

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

Read more

0 comments, 1,241 reads

Posted in PowerSQL By Prashanth Jayaram on 15 August 2018

SQL Server – Stairway to Database Backup-and -Restore, (and Recovery)- Complete Guide

It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of database backup-and-restore features and skills you’ll need to build good backup-and-restore strategies using the available tools and techniques. Along the way, … Continue reading

Read more

0 comments, 272 reads

Posted in PowerSQL By Prashanth Jayaram on 26 July 2018

Know more about SQL Server MSDB log store for database backups, restores, and recovery: Q& A – Part 3

In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do you delete six months old data to reduce the size of the backup and restore history tables? How do you … Continue reading

Read more

0 comments, 257 reads

Posted in PowerSQL By Prashanth Jayaram on 25 July 2018

Know more about SQL Server database backups, restores, and recovery: Q& A – Part 2

In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL Server database backup-and-restore (recovery) internals, you can refer to the following full list of topics. Define database restore Define the … Continue reading

Read more

0 comments, 233 reads

Posted in PowerSQL By Prashanth Jayaram on 25 July 2018

Know more about SQL Server database backups, restores, and recovery: Q& A – Part 1

Let’s deep dive and review each of the database backup command topics to get a better understanding of what it is all about. In this article, we will find an answer for FAQs about the SQL Server database backup. We … Continue reading

Read more

0 comments, 246 reads

Posted in PowerSQL By Prashanth Jayaram on 25 July 2018

Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio

In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio configured on … Continue reading

Read more

0 comments, 774 reads

Posted in PowerSQL By Prashanth Jayaram on 19 July 2018

Understanding Data Sharing in SQL Server Docker Containers

This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers the following topics: Introduction of the Docker volumes. Managing volume using Docker CLI commands or Docker API. Sharing data between … Continue reading

Read more

0 comments, 381 reads

Posted in PowerSQL By Prashanth Jayaram on 16 July 2018

SQL Server : Understanding Backup and Restore operations using Docker Containers

In this article, we will discuss the concepts of database backup-and-restore operations on SQL Server Docker containers. This is certainly the era of containers and it made the buzz in the business, so let us understand the importance of backup-and-restore … Continue reading

Read more

0 comments, 271 reads

Posted in PowerSQL By Prashanth Jayaram on 12 July 2018

SQL Server In-Memory Optimized database backup and restore in action

A SQL Server backup and restore strategy is an essential process to safeguard and protect critical data. The vital role of any DBA is to minimize the risk of data loss and preserve data modifications at regular intervals of time. … Continue reading

Read more

0 comments, 808 reads

Posted in PowerSQL By Prashanth Jayaram on 6 July 2018

Introduction to Docker and Docker Toolbox

The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding  Docker and its basics. Once you start grasping the basics and learn to use them, you will easily understand how to use … Continue reading

Read more

0 comments, 310 reads

Posted in PowerSQL By Prashanth Jayaram on 2 July 2018

Overview of File-group(s) and Piecemeal database restore operations in SQL Server

So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series, we are going to discuss, the file-group and piecemeal database backup and restore process. Database “Backup and Restore” strategies are … Continue reading

Read more

0 comments, 666 reads

Posted in PowerSQL By Prashanth Jayaram on 22 June 2018

Overview of SQL Server 2017 Docker containers on Linux machine

SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the freedom that it gives to install the product anywhere. The advent of the Docker containers and growing emphasis on open … Continue reading

Read more

2 comments, 1,285 reads

Posted in PowerSQL By Prashanth Jayaram on 20 June 2018

Older posts