SQL

 

System Center Operations Manager, “Out of memory” and the failing MSSQL workflows

Today’s post will be pretty short, however hopefully very informative and helpful. Actually, the content of it is not mine, but I am sharing it, because I would like this information to reach as many people as possible. If you have been working with the SQL management pack for System Center Operations Manager, then you […]

Error deleting a SCOM Management Pack

A couples of days ago I had to remove a Management Pack. I went to the SCOM Console, removed all the dependencies and then tried to delete the Management Pack. A “Please wait” message popped up on my screen and remained there for about 30 minutes. Then I got the following error message: Error Message: […]

Automating SQL operations with Invoke-Sqlcmd – challenges and solutions

I’ve been working on some automation tasks with SMA 2016 lately, which involved quite heavy data transactions to a SQL database in the backend. Doing this, I have faced some really interesting challenges that I would like to share now with you and of course their respective solutions/workarounds. Reading and writing data to a SQL […]