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

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various columns that show the internals of a database, backup size, and gives the latest completion statuses and the corresponding backup sizes. Though the output is derived from the… Read more

0 comments, 94 reads

Posted in PowerSQL By Prashanth Jayaram on 15 August 2017

A Quick Start Guide to Managing SQL Server 2017 on CentOS/RHEL Using the SSH Protocol

This article details the following

  1. How to get PuTTY and SQL Server
  2. How to install/uninstall SQL 2017 CTP2.1
  3. How to Upgrade to SQL 2017 RC1
  4. How to Install/remove SQL Tools

In one of my previous articles Installation of SQL Server vNext CTP on Linux Distribution CentOS 7, I spoke… Read more

0 comments, 164 reads

Posted in PowerSQL By Prashanth Jayaram on 8 August 2017

How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to configure Transparent Data encryption (TDE) using asymmetric key protection with Azure Key Vault with AlwaysOn. That, to me, opened a whole different dimension on data security.

Configure-tde-database-alwayson-using-azure-key-vault-sql-server-2016

Happy Learning!! Read more

0 comments, 235 reads

Posted in PowerSQL By Prashanth Jayaram on 28 July 2017

How to analyze SQL Server database performance using T-SQL

The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces is to identify the most resource-intensive databases. This article talks about the natively available features that can accomplish the task of getting the required details of the entire database… Read more

0 comments, 215 reads

Posted in PowerSQL By Prashanth Jayaram on 10 July 2017

Overview of Resumable Indexes in SQL Server 2017

Managing indexes is a critical component of database maintenance but we often don’t think about the indicators behind the index maintenance operations. SQL Server 2017 (CTP 2.0) introduces a very useful index feature, to mitigate the administration overhead of index maintenance which we’ll review and discuss in this article. Read more

0 comments, 324 reads

Posted in PowerSQL By Prashanth Jayaram on 26 June 2017

How to use Python in SQL Server 2017 to obtain advanced data analytics

On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest innovations put data, analytics and artificial intelligence at the heart of business transformation. Microsoft has, over the last few years, made great strides in accelerating the pace of innovation… Read more

0 comments, 438 reads

Posted in PowerSQL By Prashanth Jayaram on 20 June 2017

Top string functions in SQL Server 2017

SQL Server 2017 has been in the talk for its many features that simplify a developer’s life. With the previous versions, developers had to write T-SQL, or user-defined functions using temporary tables, and build complex logic, just for string manipulation. In almost every database I work with, I see many… Read more

0 comments, 233 reads

Posted in PowerSQL By Prashanth Jayaram on 8 June 2017

Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol

In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one server to another—sometimes, even move them from Windows to Linux.

In the case of moving a database to Linux, SQL Server’s Backup and Restore feature is the recommended mode of… Read more

0 comments, 195 reads

Posted in PowerSQL By Prashanth Jayaram on 16 May 2017

Installation of SQL Server vNext CTP on Linux Distribution CentOS 7

It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was the first time in history that Microsoft ever designed SQL Server to run on a non-Windows operating system. SQL Server vNext was released for public preview so the user community…

Read more

0 comments, 431 reads

Posted in PowerSQL By Prashanth Jayaram on 10 May 2017

Understanding Database Backup Encryption in SQL Server

Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as it sounds. Apart from keeping the data secure, a database administrator also has to keep the system up and running, and restore the data as needed, in case of… Read more

0 comments, 373 reads

Posted in PowerSQL By Prashanth Jayaram on 3 May 2017

SQL Server 2016 enhancements – Truncate Table and Table Partitioning

The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate command partitioning enhancements in SQL 2016

One of the biggest challenges for a DBA is to identify the right candidate for table partitioning, as it requires expertise in design and… Read more

0 comments, 1,912 reads

Posted in PowerSQL By Prashanth Jayaram on 19 April 2017

SQL Server Database Recovery Process Internals – database STARTUP Command

A database recovery process is an essential requirement for database systems, It can be a tedious job and the process of recovery varies on a lot of scenarios. The desire to improve recovery results has resulted in various procedures but understood by few and prone to errors. In this article,… Read more

0 comments, 223 reads

Posted in PowerSQL By Prashanth Jayaram on 28 March 2017

Custom keyboard shortcuts in SQL Server Management Studio (SSMS)

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of time; you’ll definitely notice a boost the productivity because you’re… Read more

0 comments, 235 reads

Posted in PowerSQL By Prashanth Jayaram on 27 March 2017

Illustration of an example availability monitoring service Using PowerShell and SQL

This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML

Article highlights

  • Defines the objective of JSON
  • Explains the PoSH…

Read more

0 comments, 191 reads

Posted in PowerSQL By Prashanth Jayaram on 23 March 2017

PowerShell: Managing Service(s) Using WMI, CIM and Get-Service Cmdlet

Abstract

A common task of any administrator is to manage and maintain the application availability by checking the various services status, accomplish configuring the services and restarting the service on a local/remote system. There are several components are available to accomplish this day to day tasks.This can be done using…

Read more

0 comments, 470 reads

Posted in PowerSQL By Prashanth Jayaram on 10 March 2017

SQL: Different ways to generate sequence

There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3.

Select A =identity(int,1,1),B,C from table_abs

1,A,41

2,B,13

3,C,90

4,D,91

5,E,98

6,F,12

7,G,54

8,H,16

For this output, the 4th column generates the Sequence of numbers… Read more

2 comments, 2,248 reads

Posted in PowerSQL By Prashanth Jayaram on 6 February 2017

SQL Server 2016: JSON integration

Abstract

This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable an integration of JSON data into a relational schema.

The idea behind this article is to list as many examples of JSON nested elements, an inclusion of sample data,…

Read more

0 comments, 3,142 reads

Posted in PowerSQL By Prashanth Jayaram on 23 January 2017

My Interview published on Microsoft Technet Blog

Wish you a Happy New Year to all the readers and technical enthusiasts!!!

https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/

My interview is published on the Microsoft Technet blog yesterday

 

 


Read more

0 comments, 263 reads

Posted in PowerSQL By Prashanth Jayaram on 3 January 2017

Older posts