Blog: Prashanth Jayaram

224 blogs updated: 25 min. ago
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, install...
22-01-2019 18:30:31 Prashanth Jayaram SQL Server
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...
14-01-2019 18:30:36 Prashanth Jayaram SQL Server
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 h...
07-01-2019 09:05:36 Prashanth Jayaram SQL Server
Shrinking Tempdb in SQL Server won't work?
Problem statement When I was working DML operation on the database, Tempdb has grown 80 GB. After the completion, It is noted that the tempd...
28-12-2018 18:48:47 Prashanth Jayaram SQL Server
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 knew that PowerShell is an automation ...
27-12-2018 23:52:44 Prashanth Jayaram SQL Server
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 Selec...
21-12-2018 22:26:48 Prashanth Jayaram SQL Server
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 othe...
18-12-2018 21:09:37 Prashanth Jayaram SQL Server
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 environ...
17-12-2018 23:13:24 Prashanth Jayaram SQL Server
SQL Server Essentials Series
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 care...
10-12-2018 20:55:18 Prashanth Jayaram SQL Server
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...
04-12-2018 14:53:49 Prashanth Jayaram SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.