-->
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.

How to automatically Discover SQL Server instances

DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the entire SQL Server environment. To do this, the full SQL Server estate must be discovered and inventoried. To accomplish that … Continue reading

Read more

0 comments, 117 reads

Posted in PowerSQL By Prashanth Jayaram on 17 December 2018

SQL Server Essentials for beginners

SQL is the essential part of SQL Administration and SQL Development. A quick overview of basics can take you a long way in the database career and make you feel more comfortable to use powerful SQL features. This article introduces … Continue reading

Read more

0 comments, 144 reads

Posted in PowerSQL By Prashanth Jayaram on 10 December 2018

SQL Date functions in SQL Server

SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many of us never took the time to fully understand these extremely useful features. For professionals just getting started with SQL … Continue reading

Read more

0 comments, 478 reads

Posted in PowerSQL By Prashanth Jayaram on 4 December 2018

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

Read more

0 comments, 299 reads

Posted in PowerSQL By Prashanth Jayaram on 3 December 2018

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

Read more

0 comments, 290 reads

Posted in PowerSQL By Prashanth Jayaram on 26 October 2018

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, 170 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, 236 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, 651 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, 532 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, 191 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, 233 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, 571 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, 254 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,295 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, 323 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, 291 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, 276 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, 278 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, 830 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, 429 reads

Posted in PowerSQL By Prashanth Jayaram on 16 July 2018

Older posts