-->
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 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, 230 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, 216 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, 196 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, 208 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, 708 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, 329 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, 204 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, 707 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, 266 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, 618 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,211 reads

Posted in PowerSQL By Prashanth Jayaram on 20 June 2018

SQL Server -Database Backup Report using PowerShell and T-SQL

In the previous articles, we discussed several ways of taking backup and testing the restore process to ensure the integrity of the backup file. In this article, we’re going to discuss the importance of the database backup reporting. This kind of … Continue reading

Read more

0 comments, 773 reads

Posted in PowerSQL By Prashanth Jayaram on 14 June 2018

Getting Started with Mssql-cli tool

A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business are almost always a trade-off, and striking the right balance in a product in terms of the toolset is a … Continue reading

Read more

0 comments, 163 reads

Posted in PowerSQL By Prashanth Jayaram on 12 June 2018

SQL Database Corruption: Causes, Prevention, Fixing Techniques

“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I try to attach the file, I am receiving following error message : The header for file ….\MSSQL\DATA\xxxx_data.mdf’ is not a … Continue reading

Read more

0 comments, 157 reads

Posted in PowerSQL By Prashanth Jayaram on 5 June 2018

Backup and Restore Automation using SQLCMD and SQL Server agent

Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to the test or development environment. This is done so that the development or the test environment closely resembles the production … Continue reading

Read more

0 comments, 215 reads

Posted in PowerSQL By Prashanth Jayaram on 30 May 2018

SQL Server: Backup and Restore operations using Cloud

This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob storage service as a target for the backup. As we all know, disk and tapes were the default destinations of … Continue reading

Read more

0 comments, 207 reads

Posted in PowerSQL By Prashanth Jayaram on 29 May 2018

Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler

  This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux and Windows machines. Here’s an outline of what this article is all about: Introduction Technical specifications How to load … Continue reading

Read more

0 comments, 1,936 reads

Posted in PowerSQL By Prashanth Jayaram on 22 May 2018

Data Recovery : Page level restore in SQL Server

In this article, we shall discuss the importance of understanding the internals of the page restoration for a database administrator. Most of the time, performing a page-level restore suffices for database availability. A good backup strategy is a key to recovery … Continue reading

Read more

0 comments, 247 reads

Posted in PowerSQL By Prashanth Jayaram on 18 May 2018

Discuss smart database backup in SQL Server 2017

So far, we’ve discussed several phases of backup that starts with planning, creating, strategizing and implementing. In this article, we are going to see how database administrators can define the strategy to improve backup performance and efficiently manage backups in SQL Server 2017. The following are the topics of discussion: Read more

0 comments, 274 reads

Posted in PowerSQL By Prashanth Jayaram on 15 May 2018

Mssql-cli Command-Line Query Tool

A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business are almost always a trade-off, and striking the right balance in a product in terms of the toolset is a sign of a successful product. After testing the SQL… Read more

0 comments, 732 reads

Posted in PowerSQL By Prashanth Jayaram on 11 May 2018

Older posts