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:
|
Table of Contents
Wiki
- The JSON in SQL 2016
- SQL Server Operations: Extending DMF to Report Disk Space of SQL Server
- PowerShell and SQL : Monitoring Disk Space - XML and ADO.NET Class Libraries
- SQL Server: Discuss Execute(SQL) At LinkedServer
- PoSH : Monitoring and Notification - Disk Space Alerts
- PoSH - Step by Step - Disk Space Monitoring Guide
- PoSH & SQL : Monitor and Report Disk Usage Stats - Task Scheduler
- Monitoring Disk Space with SQL Server and PowerShell
- SQL Server : Fix - Could not load file or assembly "Microsoft.SqlServer.BatchParser" - Error
- PoSH - DiskSpace GUI Tool
- PowerShell : CSV - Disk Space Report - CSV
- PoSH- Disk Space - HTML Report
- PowerShell : CSV - Disk Space Report - HTML
- PowerShell : CSV - Disk Space Report - Excel
- SQL Server: Monitoring Disk Space with FSUTIL command line utility
- SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects
- Parameter(s)-Passing-SQL-script-using-batch-filepowershell
- Extending-PowerShell-Module-system-parameter-measurement-modules
- SQL: How to refresh Multiple SQL Databases with PowerShell
- SQL-Server(s)-inventory-excel-csv-console-using-PowerShell-smo-and-rmo
- Disk-space-GUI-tool-multi-server-s-search-grid-and-email-output-PowerSQL
- PowerShell-list-and-export-installed-programs-local-or-remote
- How to backup and replace text in all search string matching Stored Procedure(s)
- SSAS - Discuss various backup methods & Automating cube database(s) backup with PowerShell
- Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs
- PowerShellGUI Tools - Disk,Memory and Process - Modules
- INVENTORY - SQL- SSAS - SSRS - Excel Output - Email
- PowerShell - Export SQL Data to Excel with Powershell
- INVENTORY - AUTOMATIC GATHERING OF SSAS SERVER DETAILS - HTML AND EXCEL OUTPUT
- 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
Nominated WIKI Articles by Month and Year
Sep,2016
Aug, 2016
- Parameter(s)-Passing-SQL-script-using-batch-filepowershell
- Extending-PowerShell-Module-system-parameter-measurement-modules
July,2016
- How-To-Refresh-Multiple-sql-database(s)-Using-PowerShell by Prashanth Jayaram
- SQL-Server(s)-Inventory-Excel-CSV-Console- Using PowerShell SMO and RMO by Prashanth Jayaram
- Disk-space-GUI-tool-multi-server-s-search-grid-and-email-output-PowerSQL
June,2016
Dec,2014
Medal Wining Article
- PowerShell : CSV - Disk Space Report - HTML - Sep 2016, Silver
- SQL Server: Monitoring Disk Space with FSUTIL command line utility - Sep 2016,Silver
- SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects Sep 2016, Gold
- Parameter(s)-Passing-SQL-script-using-batch-filepowershell - August 2016 - Silver.
- Extending-PowerShell-Module-system-parameter-measurement-modules - August 2016 - Silver
- SQL-Server(s)-Inventory-Excel-CSV-Console- Using PowerShell SMO and RMO -July 2016 - Gold Medal
- How-To-Refresh-Multiple-sql-database(s)-Using-PowerShell -July,2016 - Silver Medal
- PowerShell- DiskSpaceGUI-Tool-MultiServer(s)-Grid-Email-Search-Features - July,2016 - Gold Medal
- SSAS - Discuss various backup methods & Automating cube database(s) backup with PowerShell - Dec,2014 - Gold Medal
- Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs - Nov 2014 - Silver Medal
- PowerShell-list-and-export-installed-programs-local-or-remote - Jun,2016 - Silver Medal
Top Contributor Award
- Top Contributor Award - October,2016
- Top Contributor Award - Sep,27,2016
- Top Contributor Award - Sep,2016
- Top Contribution Award - July,2016
- top-contributors-awards-July-2016
- Top Contributor award - Sep, 2016
Gallery
- PowerShell - System Information
- PowerShell - OS Inventory and Disk Info - Consolidated Excel File - EMAIL
- PowerShell- Monitor Group Of Services on 'N' Servers & Notify Stopped Services
- PowerShell - Restart Service - Local or Remote Machines
- T-SQL – How to find Next Business day from a given date
- PowerShell - Export SQL Data to Excel with Powershell
- PowerShell - Perfmon Counters into CSV File - Multiple remote servers
- PowerShell - Program List - 32 and 64 Bit Applications
- PowerShell - SQL Inventory - Automatic - Excel File - EMAIL
- T-SQL Scripting Stored Procedure to Create backup copy on same database
- PowerShell - Disk Space Utlization GUI Tool
- PowerShell - Memory Details GUI Tool
- Capturing DB Usage stats – sp_spaceused simulation using DMV��s.
- SQL – Split delimited columns using XML Or UDF function
- T-SQL - Find Number of Rows of Database(s) tables Using Undocumented Procedure
- PowerShell GUI Tool - Network Pinger - Version 2
- PowerShell - Input Validation Scripts
- SQL- Querying XML attributes from XML Column
- SQL-How to Search String in all Stored Procedures across All User Defined DB(s)
- List Primary key and Concatenate composite Keys into a single row separed by ','
- SQL – How to Find Missing Sequence in a table
- T-SQL - Monitoring DiskSpace of Multiple Servers
- Top 10 Process Listing - Memory Consumption - GUI Tool
- SQL Jobs - Complete Information - SQL 2000/2005/2008/R2
- SQL- Backup Report
- PowerShell- Monitoring Group Of Service on Group of Server with Credentials
- USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODEL
- PowerShell - SSRS Inventory - Automatic - Excel File - EMAIL
- T-SQL to Display Weekends Between two Dates
- PowerShell - Script to Monitor Disk Space of a Group of servers - HTML Formatted
- Determine size of the file using T-SQL/Powershell/Ole Objects
- T-SQL – How to Find Number of Words in a Given String
- PowerSQL - Different Approaches to Find Free Space in all disk drives
- PowerShell - Service Comparison GUI Tool
- PowerShell - Disk Space GUI - Tool - Multiple Servers
- Age of a Files Report - Local or Remote - Powershell
- Powershell - Automatic SSAS Inventory Generation Using AMO - Excel Format
- SQLServer Configuration Information using Powershell
- PowerShell - Script to Monitor a Service on a Group of Servers - HTML Formatted
- T-SQL to find Data,Log,Size and Other Useful information -SQL 2000/2005/2008/R2
- SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases
- SQL - List All Tables, Space Usage Info & Other Details
- SQL - Identify Duplicate Indexes across all database
- SQL - Find encrypted objects using sql_modules or Powershell
- SSRS - Identify Schedule Details of SSRS Report
- T-SQL to find data and log file are located on a same drive or not
- Powershell - Automatic SSAS Inventory Generation Using AMO - HTML Format
- SQL Server - Certificate Details - Associated Database
- PowerShellGUI - Disk,Memory,Process - PSM1 Module
- SQL Database Backup Using PoSH
- Scripting Logins, Role Assignments and Server Permissions Using PoSH
- Disk Space GUI Tool – Multi Server(s) – Search - Grid and Email Output - PoSH
- DMF - sys.dm_os_volume_stats() - Drive Space Utilization
- SQL Server Operations: Monitoring Disk Space with WMI Class
- SQL Server Operations: Monitoring Disk Space with OLE Automation Objects
- PowerShell: CSV - Disk Space Report - Excel - Using Credentials
- PowerShell: CSV - Disk Space Report - Excel
- PowerShell : CSV - Disk Space Report - HTML