Two of my SQL Servers stopped working after an unexpected power outage. When I attempted to start them, they gave me an Access Denied error. These are two totally different machines (diff Win & diff SQL version) that both, after years of working, just stopped in their tracks with an Access Denied. This isn't an …
Read MoreYou know what's scary as hell? When one node of an important cluster loses its trust relationship with the domain and you see the error "the trust relationship between this workstation and the primary domain failed". That happened to me late last year with one of my SQL Server 2008 R2 nodes. The scary part …
Read MoreI'll be presenting some sessions about SQL Server and PowerShell at the PowerShell Conference EU in Hanover, Germany on April 20-22! You should join me, because the speaker and session lineup is amaaazing! Register at psconf.eu. Want to know more? Check out PowerShellMagazine.com and psconf.eu!
Read MoreRecently, I wanted to access the System.Windows.Forms.Integration.ElementHost type, which uses the System.Windows.Forms.Integration namespace. When I tried to load that namespace, PowerShell complained that The assembly 'System.Windows.Forms.Integration' could not be found. I read up and found that the …
Read MoreThis post builds on some previous post titled Use base64 for Images in WPF-based PowerShell Forms. Show-WpfIconExample.ps1, which can be found below and on github, demonstrates how to overlay the default PowerShell toolbar icon with an image that's been transformed to a base64 string to …
Read MoreUpdate Jan 7: Added KeyboardInterop so that TextBoxes will work. One of the lessons learned when making Popups and NotifyIcons in PowerShell and WPF is that the WPF window must be run the the proper context. I was tipped off to this by Denniver Reining's PowerShell / NotifyIcon article and Johnny J's "Doing a (C#) …
Read MoreIf you're looking to create your own CloudFlare API v4-based PowerShell module, and would like some syntax examples, here's a simplified breakdown of my CloudFlareDynDns module on github, which I discuss in "Use PowerShell and CloudFlare API v4 to Dynamically Update CloudFlare DNS to your External IP". 1# Set …
Read MoreGot a homelab and miss how DynDNS used to be free? Using PowerShell and a CloudFlare hosted domain, you can emulate similar functionality for free using PowerShell and a Scheduled Task. If you're looking for a DDNS client that you can run on a router, check out CloudFlare's ddclient or Scott Helme's post Replacing …
Read MoreSo this happened about a month ago, but I've been out with the flu. Ed Wilson with Microsoft Scripting Guys invited me to write a few articles on WPF, and I excitedly said yes! In the first article of the series, I detail how to Create Pop-ups by Using PowerShell. The example used displayed local hard drive space. The …
Read MoreIn addition to be able to use base64 for Images in WPF-based PowerShell Forms, you can also use base64 for icons as well. Essentially, you take the base64, convert it to a memory stream, draw an image from that stream, then convert the image to an icon. Finally, you assign the $notify.Icon this new variable. Just the …
Read More