Archives
Blog Stats
- 398,324 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
- T-SQL - Read CSV files using OpenRowSet
- The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
- SQL vs NoSQL
- MongoDB - Insert,Update,Upsert and Delete Examples - CRUD
- Simple Methods to Recover master.mdf File Password
- Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell
- SQLCMD –Quick Copy of Files - Using Robocopy
- PowerShell GUI Tool - Network Ping - Version 2
- PowerShell - Script to Monitor Disk Space of a Group of servers - HTML Formatted Email Output
- Overview of File-group(s) and Piecemeal database restore operations 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
- January 24, 2021The big day is here.
- The Big DayOctober 25, 2016The big day is here.
Author Archives: Prashanth Jayaram
Kernel Migrator for SQL Server – Expert Product Review
Ease of use, accuracy, integrity, efficiency, and security are some characteristics which a good software should have, and when we speak of software products that focus on business users, the scale of expectations increases. Therefore, there remains no room for … Continue reading
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, installation, processing and output. Automation seems to be an increasing need in IT industry. At present, PowerShell leads the game in … Continue reading
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. When I joined this family, I looked at it as a place to showcase … Continue reading
Posted in awards
Leave a comment
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the drive of that server. I tried shrinking the mdf file of … Continue reading
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 know that PowerShell is built on .Net automation framework. I would prefer PowerShell to design any such requirements than … Continue reading
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 Select-AzureRmProfile. If you try to log in using Select-AzureRmProfile you most likely encounter the following error … Continue reading
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 other great recipients who I have long admired and respected. A very special thanks to … Continue reading
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 environment. To do this, the full SQL Server estate must be discovered and inventoried. To accomplish that … Continue reading
SQL Server Essentials for beginners
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 career and make you feel more comfortable to use powerful SQL features. This article introduces … Continue reading
Posted in SQL
Tagged DBAM, DBMS, De-Normalization, Normalization, RDBMS, SQL, SQL Coalesce, SQL delete, SQL Insert, SQL Join, SQL Like, SQL Order, SQL Union, SQL Update, What is SQL?
Leave a comment
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 fully understand these extremely useful features. For professionals just getting started with SQL … Continue reading