-->
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 Power Doc to Discover, Diagnose and Document SQL Server

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

Read more

2 comments, 179 reads

Posted in PowerSQL By Prashanth Jayaram on 22 January 2019

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

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

Read more

0 comments, 144 reads

Posted in PowerSQL By Prashanth Jayaram on 14 January 2019

How to Change Suspect Mode to Normal Mode in SQL Server Database

If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also means that your database has gone into the suspect mode. In that case, you have already experienced one of the … Continue reading

Read more

0 comments, 154 reads

Posted in PowerSQL By Prashanth Jayaram on 7 January 2019

Shrinking Tempdb in SQL Server won’t work?

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

Read more

0 comments, 934 reads

Posted in PowerSQL By Prashanth Jayaram on 28 December 2018

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

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

Read more

0 comments, 387 reads

Posted in PowerSQL By Prashanth Jayaram on 27 December 2018

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

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

Read more

0 comments, 194 reads

Posted in PowerSQL By Prashanth Jayaram on 21 December 2018

Top 50 PowerShell bloggers of 2018

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

Read more

0 comments, 204 reads

Posted in PowerSQL By Prashanth Jayaram on 18 December 2018

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, 195 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, 185 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, 568 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, 343 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, 347 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, 205 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, 273 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, 720 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, 570 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, 225 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, 275 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, 605 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, 288 reads

Posted in PowerSQL By Prashanth Jayaram on 24 August 2018

Older posts