Author Archives: Prashanth Jayaram

Unknown's avatar

About Prashanth Jayaram

DB Technologist, Author, Blogger, Service Delivery Manager at CTS, Automation Expert, Technet WIKI Ninja, MVB and Powershell Geek My Profile: https://social.technet.microsoft.com/profile/prashanth jayaram/ http://www.sqlshack.com/author/prashanth/ http://codingsight.com/author/prashanthjayaram/ https://www.red-gate.com/simple-talk/author/prashanthjayaram/ http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/ Connect Me: Twitter @prashantjayaram GMAIL [email protected] The articles are published in: http://www.ssas-info.com/analysis-services-articles/ http://db-pub.com/ http://www.sswug.org/sswugresearch/community/

Administering Relational Databases on Microsoft Azure: DP 300 study guide

Posted on March 9, 2021 by Prashanth Jayaram

I am excited to share an important milestone in my life. My third book, “Administering Relational Databases on Microsoft SQL“, is released. Co-authored with Ahmad Yaseen and Rajendra Gupta, who are known to be the databases’ best and bright minds … Continue reading →

Posted in Uncategorized | Leave a comment

Kernel Migrator for SQL Server – Expert Product Review

Posted on March 17, 2019 by Prashanth Jayaram

Ease of use, accuracy, integrity, efficiency, and security are some characteristics which a good software should have, and when we speak of software products that focus on business users, the scale of expectations increases. Therefore, there remains no room for … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

SQL Power Doc to Discover, Diagnose and Document SQL Server

Posted on January 22, 2019 by Prashanth Jayaram

This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose, installation, processing and output. Automation seems to be an increasing need in IT industry. At present, PowerShell leads the game in … Continue reading →

2 Comments

Today, I’m making my 100th post on SQLShack

Posted on January 14, 2019 by Prashanth Jayaram

The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join an excellent group of elite authors. When I joined this family, I looked at it as a place to showcase … Continue reading →

Posted in awards | Leave a comment

Shrinking Tempdb in SQL Server won’t work?

Posted on December 28, 2018 by Prashanth Jayaram

Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the drive of that server. I tried shrinking the mdf file of … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell

Posted on December 27, 2018 by Prashanth Jayaram

I was asked by the reader on how to get all the port information of SQL Servers instances. As you all know that PowerShell is built on .Net automation framework. I would prefer PowerShell to design any such requirements than … Continue reading →

Posted in SQL | Tagged , , | Leave a comment

Select-AzureRmProfile : The term ‘Select-AzureRmProfile’ is not recognized as the name of a cmdlet, function, script file, or operable program

Posted on December 21, 2018 by Prashanth Jayaram

I got a chance to work with PowerShell automation script to automate the login process. In the script, the profile is loaded using the Select-AzureRmProfile. If you try to log in using Select-AzureRmProfile you most likely encounter the following error … Continue reading →

Tagged , | Leave a comment

Top 50 PowerShell bloggers of 2018

Posted on December 18, 2018 by Prashanth Jayaram

My work is recognized and my blog is listed under Top 30 elite list. I am pleased, honored and humbled to accept this award and to join other great recipients who I have long admired and respected.  A very special thanks to … Continue reading →

Posted in awards | Tagged | Leave a comment

How to automatically Discover SQL Server instances

Posted on December 17, 2018 by Prashanth Jayaram

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 →

Posted in SQL | Tagged , , , , | Leave a comment