Blog Stats
- 402,355 hits
-
Prashanth Jayaram
DB Technologist, Author, Blogger, Service Delivery Manager at CTS, Automation Expert, Technet WIKI Ninja, MVB and Powershell Geek My Profile: https://social.technet.microsoft.com/profile/prashanth jayaram/ http://www.sqlshack.com/author/prashanth/ http://codingsight.com/author/prashanthjayaram/ https://www.red-gate.com/simple-talk/author/prashanthjayaram/ http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/ Connect Me: Twitter @prashantjayaram GMAIL powershellsql@gmail.com The articles are published in: http://www.ssas-info.com/analysis-services-articles/ http://db-pub.com/ http://www.sswug.org/sswugresearch/community/
Personal Links
Verified Services
Top 30 PowerShell bloggers of 2018
My Blog is ranked amongst the Top 50 SQL blogs worldwide
DZone MVB
Microsoft
Archives
- January 2021 (1)
- October 2020 (1)
- June 2019 (1)
- May 2019 (2)
- April 2019 (1)
- March 2019 (1)
- January 2019 (3)
- December 2018 (8)
- October 2018 (3)
- September 2018 (5)
- August 2018 (1)
- July 2018 (9)
- June 2018 (5)
- May 2018 (8)
- April 2018 (5)
- March 2018 (6)
- February 2018 (1)
- January 2018 (4)
- December 2017 (3)
- November 2017 (3)
- October 2017 (5)
- September 2017 (3)
- August 2017 (3)
- July 2017 (3)
- June 2017 (3)
- May 2017 (3)
- April 2017 (1)
- March 2017 (4)
- February 2017 (1)
- January 2017 (3)
- December 2016 (1)
- November 2016 (2)
- October 2016 (2)
- September 2016 (2)
- August 2016 (3)
- July 2016 (6)
- June 2016 (2)
- May 2016 (9)
- April 2016 (12)
- March 2016 (4)
- February 2016 (2)
- January 2016 (6)
- December 2015 (2)
- August 2015 (1)
- March 2015 (3)
- February 2015 (3)
- January 2015 (5)
- December 2014 (4)
- November 2014 (3)
- October 2014 (1)
- September 2014 (1)
- August 2014 (1)
- July 2014 (1)
- June 2014 (1)
- May 2014 (2)
- April 2014 (4)
- March 2014 (4)
- February 2014 (5)
- January 2014 (8)
- December 2013 (2)
- November 2013 (1)
- October 2013 (2)
- September 2013 (6)
- August 2013 (5)
- July 2013 (6)
- June 2013 (6)
- May 2013 (9)
- April 2013 (16)
Top Posts & Pages
- PowerShell- Monitoring Multiple Services On Multiple Servers Using Win
- The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
- PowerShell GUI Tool - Network Ping - Version 2
- How to Change Suspect Mode to Normal Mode in SQL Server Database
- PowerShell - Identify Service Account & Other Details of SQL Services - Multi Server Script
- PowerShell : Monitoring and Notification - Disk Space Alerts
- Minimizing SQL Server DBCC CHECKDB Performance Impacts
- SSAS Cube Backup strategies and Step by Step approach to setup and configure backup
- PowerShell - CHECK, START and STOP SQL Services of a remote servers
- Know How to Repair SQL Database Marked as Suspect Mode in SQL Server
Categories
- AlwaysOn (1)
- awards (2)
- Backup and Restore (14)
- Citrix (1)
- databases_files (2)
- docker (5)
- Exchange (2)
- FileProperty (1)
- GDPR (1)
- GENERAL (3)
- Graph database (1)
- JSON (4)
- Logshipping on Linux (1)
- MongoDB (16)
- NoSQL (1)
- Philosophy (1)
- PowerShell (64)
- Python (4)
- Robocopy (2)
- SCCM (1)
- Security (3)
- Vulnerability (1)
- SETVAR (2)
- sp_msforeachDB (1)
- sp_MSforeachtable (1)
- SQL (99)
- SQL 2012 (4)
- SQL 2016 (11)
- SQL 2017 (7)
- SQL 2017 on Linux (5)
- SQL and Python (1)
- SQL AZURE (2)
- SQL Indexes (1)
- SQL Joins (1)
- SQL On Linux (1)
- SQL Ops Studio (1)
- SQL Server 2017 (11)
- SQL Server Backup (10)
- SQL Server DevOps (1)
- SQL Server Tools (1)
- SQL Server vNext (2)
- SQL String (1)
- SQL tools (2)
- SQL XML (1)
- SQLCMD (3)
- SSAS (4)
- SSRS (3)
- String handling (2)
- sysfiles (3)
- T-SQL (37)
- Uncategorized (42)
- Variable Passing (1)
- XenApp VDA (1)
- XenDesktop VDA (1)
- XML (2)
- Follow Prashanth Jayaram on WordPress.com
- March 7, 2021The big day is here.
- The Big DayOctober 25, 2016The big day is here.
-
Recent Posts
- SQL PowerShell to check and repair Ad-hoc distributed queries Vulnerability January 4, 2021
- Hadoop Workflow Automation using Apache spark and Oozie October 30, 2020
- Import Local SQL Server Database to Azure – Pick the Best Method June 11, 2019
- Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue May 21, 2019
- Restore SQL Server 2014 Database from Backup – Step By Step Guide May 6, 2019
- Know How to Repair SQL Database Marked as Suspect Mode in SQL Server April 30, 2019
- Kernel Migrator for SQL Server – Expert Product Review March 17, 2019
- SQL Power Doc to Discover, Diagnose and Document SQL Server January 22, 2019
- Today, I’m making my 100th post on SQLShack January 14, 2019
- How to Change Suspect Mode to Normal Mode in SQL Server Database January 7, 2019
- Shrinking Tempdb in SQL Server won’t work? December 28, 2018
- Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell December 27, 2018
- Select-AzureRmProfile : The term ‘Select-AzureRmProfile’ is not recognized as the name of a cmdlet, function, script file, or operable program December 21, 2018
- Top 50 PowerShell bloggers of 2018 December 18, 2018
- How to automatically Discover SQL Server instances December 17, 2018
- SQL Server Essentials for beginners December 10, 2018
- SQL Date functions in SQL Server December 4, 2018
- Overview of DML Operations – SQL Delete December 3, 2018
- Overview of the SQL Insert statement October 26, 2018
- SQL Pivot and Unpivot relational operatots October 15, 2018
PowershellSQL
T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases
There are many different ways to accomplish this tasks. Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6 The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string CREATE TABLE #ProcSearch (databaseName VARCHAR(100),ROUTINE_CATALOG varchar(50),ProcName VARCHAR(128),RoutineType varchar(100),CreateDate … Continue reading →