Note

This is a "User Page" (click for a list of all user pages on TechNet Wiki). User pages on TechNet Wiki exist for the following reasons:

  1.  To link to these pages from various online profiles, blog posts, etc.
  2. To allow collaboration on filling out such information.
  3. To allow easy editing for filling out such information.
  4. To act as an aggregation or collection of links that help define what a person does.

 

 

Back to top


Wiki

  1. The JSON in SQL 2016
  2. SQL Server Operations: Extending DMF to Report Disk Space of SQL Server
  3. PowerShell and SQL : Monitoring Disk Space - XML and ADO.NET Class Libraries
  4. SQL Server: Discuss Execute(SQL) At LinkedServer
  5. PoSH : Monitoring and Notification - Disk Space Alerts
  6. PoSH - Step by Step - Disk Space Monitoring Guide
  7. PoSH & SQL : Monitor and Report Disk Usage Stats - Task Scheduler
  8. Monitoring Disk Space with SQL Server and PowerShell
  9. SQL Server : Fix - Could not load file or assembly "Microsoft.SqlServer.BatchParser" - Error
  10. PoSH - DiskSpace GUI Tool
  11. PowerShell : CSV - Disk Space Report - CSV
  12. PoSH- Disk Space - HTML Report
  13. PowerShell : CSV - Disk Space Report - HTML
  14. PowerShell : CSV - Disk Space Report - Excel
  15. SQL Server: Monitoring Disk Space with FSUTIL command line utility
  16. SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects
  17. Parameter(s)-Passing-SQL-script-using-batch-filepowershell
  18. Extending-PowerShell-Module-system-parameter-measurement-modules
  19. SQL: How to refresh Multiple SQL Databases with PowerShell
  20. SQL-Server(s)-inventory-excel-csv-console-using-PowerShell-smo-and-rmo 
  21. Disk-space-GUI-tool-multi-server-s-search-grid-and-email-output-PowerSQL
  22. PowerShell-list-and-export-installed-programs-local-or-remote
  23. How to backup and replace text in all search string matching Stored Procedure(s)
  24. SSAS - Discuss various backup methods & Automating cube database(s) backup with PowerShell
  25. Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs
  26. PowerShellGUI Tools - Disk,Memory and Process - Modules
  27. INVENTORY - SQL- SSAS - SSRS - Excel Output - Email
  28. PowerShell - Export SQL Data to Excel with Powershell
  29. INVENTORY - AUTOMATIC GATHERING OF SSAS SERVER DETAILS - HTML AND EXCEL OUTPUT
  30. PowerShell: CSV - डिस्क स्थान रिपोर्ट - Excel


Interview


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 Jan 2, 2017

2017

 


Nominated WIKI Articles by Month and Year


Sep,2016



Aug, 2016


July,2016

June,2016

Dec,2014

Nov,2014


Medal Wining Article

  1. PowerShell : CSV - Disk Space Report - HTML - Sep 2016, Silver
  2. SQL Server: Monitoring Disk Space with FSUTIL command line utility - Sep 2016,Silver
  3. SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects Sep 2016, Gold
  4. Parameter(s)-Passing-SQL-script-using-batch-filepowershell - August 2016 - Silver.
  5. Extending-PowerShell-Module-system-parameter-measurement-modules - August 2016 - Silver
  6. SQL-Server(s)-Inventory-Excel-CSV-Console- Using PowerShell SMO and RMO -July 2016 - Gold Medal
  7. How-To-Refresh-Multiple-sql-database(s)-Using-PowerShell -July,2016 - Silver Medal
  8. PowerShell- DiskSpaceGUI-Tool-MultiServer(s)-Grid-Email-Search-Features - July,2016 - Gold Medal
  9. SSAS - Discuss various backup methods & Automating cube database(s) backup with PowerShell - Dec,2014 - Gold Medal
  10. Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs - Nov 2014 - Silver Medal
  11. PowerShell-list-and-export-installed-programs-local-or-remote - Jun,2016 - Silver Medal

Top Contributor Award



Gallery


  1. PowerShell - System Information
  2. PowerShell - OS Inventory and Disk Info - Consolidated Excel File - EMAIL
  3. PowerShell- Monitor Group Of Services on 'N' Servers & Notify Stopped Services
  4. PowerShell - Restart Service - Local or Remote Machines
  5. T-SQL – How to find Next Business day from a given date
  6. PowerShell - Export SQL Data to Excel with Powershell
  7. PowerShell - Perfmon Counters into CSV File - Multiple remote servers
  8. PowerShell - Program List - 32 and 64 Bit Applications
  9. PowerShell - SQL Inventory - Automatic - Excel File - EMAIL
  10. T-SQL Scripting Stored Procedure to Create backup copy on same database
  11. PowerShell - Disk Space Utlization GUI Tool
  12. PowerShell - Memory Details GUI Tool
  13. Capturing DB Usage stats – sp_spaceused simulation using DMV��s.
  14. SQL – Split delimited columns using XML Or UDF function
  15. T-SQL - Find Number of Rows of Database(s) tables Using Undocumented Procedure
  16. PowerShell GUI Tool - Network Pinger - Version 2
  17. PowerShell - Input Validation Scripts
  18. SQL- Querying XML attributes from XML Column
  19. SQL-How to Search String in all Stored Procedures across All User Defined DB(s)
  20. List Primary key and Concatenate composite Keys into a single row separed by ','
  21. SQL – How to Find Missing Sequence in a table
  22. T-SQL - Monitoring DiskSpace of Multiple Servers
  23. Top 10 Process Listing - Memory Consumption - GUI Tool
  24. SQL Jobs - Complete Information - SQL 2000/2005/2008/R2
  25. SQL- Backup Report
  26. PowerShell- Monitoring Group Of Service on Group of Server with Credentials
  27. USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODEL
  28. PowerShell - SSRS Inventory - Automatic - Excel File - EMAIL
  29. T-SQL to Display Weekends Between two Dates
  30. PowerShell - Script to Monitor Disk Space of a Group of servers - HTML Formatted
  31. Determine size of the file using T-SQL/Powershell/Ole Objects
  32. T-SQL – How to Find Number of Words in a Given String
  33. PowerSQL - Different Approaches to Find Free Space in all disk drives
  34. PowerShell - Service Comparison GUI Tool
  35. PowerShell - Disk Space GUI - Tool - Multiple Servers
  36. Age of a Files Report - Local or Remote - Powershell
  37. Powershell - Automatic SSAS Inventory Generation Using AMO - Excel Format
  38. SQLServer Configuration Information using Powershell
  39. PowerShell - Script to Monitor a Service on a Group of Servers - HTML Formatted
  40. T-SQL to find Data,Log,Size and Other Useful information -SQL 2000/2005/2008/R2
  41. SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases
  42. SQL - List All Tables, Space Usage Info & Other Details
  43. SQL - Identify Duplicate Indexes across all database
  44. SQL - Find encrypted objects using sql_modules or Powershell
  45. SSRS - Identify Schedule Details of SSRS Report
  46. T-SQL to find data and log file are located on a same drive or not
  47. Powershell - Automatic SSAS Inventory Generation Using AMO - HTML Format
  48. SQL Server - Certificate Details - Associated Database
  49. PowerShellGUI - Disk,Memory,Process - PSM1 Module
  50. SQL Database Backup Using PoSH
  51. Scripting Logins, Role Assignments and Server Permissions Using PoSH
  52. Disk Space GUI Tool – Multi Server(s) – Search - Grid and Email Output - PoSH
  53. DMF - sys.dm_os_volume_stats() - Drive Space Utilization
  54. SQL Server Operations: Monitoring Disk Space with WMI Class
  55. SQL Server Operations: Monitoring Disk Space with OLE Automation Objects
  56. PowerShell: CSV - Disk Space Report - Excel - Using Credentials
  57. PowerShell: CSV - Disk Space Report - Excel
  58. PowerShell : CSV - Disk Space Report - HTML