-
Personal Links
Verified Services
Top 30 PowerShell bloggers of 2018
https://www.sqlshack.com/top-50-powershell-bloggers-of-2018/#Prashanth%20JayaramMy Blog is ranked amongst the Top 50 SQL blogs worldwide
http://blog.feedspot.com/sql_blogs/DZone MVB
Microsoft
Monthly Archives: April 2014
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell 2.0 The Inputs are validated for the below mentioned functionality PostalCode PhoneNumber EmailID IP FileName Download the scripts from the … Continue reading
Posted in Uncategorized
Tagged Email ID, Filename Validation, Input validation, IP, Phonenumber, PostalCode
Leave a comment
SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF, and R have an associated SQL module. SQL SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition, CAST(CASE WHEN sm.definition IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted] FROM sys.sql_modules AS sm JOIN sys.objects AS o ON sm.object_id = o.object_id ORDER BY o.type; sql_modules to list … Continue reading
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over the internet and reading blogs of many wonderful brains made me think about creating a blog. When I wrote my … Continue reading
PowerShell GUI Tool – Network Ping – Version 2
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks for sharing. http://www.amandhally.net/2012/08/08/powershell-based-network-range-pinging-application-network-pinger-ajit-2/ In my version of the tool, I’ve re-used his template and modified in such a way that … Continue reading
Prashanth Jayaram 