potatoqualitee/blog-comments

Github Issue-Based Commenting with utterances

Hi there 👋

I automate everything possible using PowerShell 💙

blog-comments's Issues

Use PowerShell and CloudFlare API v4 to Dynamically Update CloudFlare DNS to your External IP

Use PowerShell and CloudFlare API v4 to Dynamically Update CloudFlare DNS to your External IP | netnerds.net

Got 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 …

https://blog.netnerds.net/2015/12/use-powershell-and-cloudflare-api-v4-to-dynamically-update-cloudflare-dns-to-your-external-ip/

RBAR Performance in PowerShell

RBAR Performance in PowerShell | netnerds.net

Years ago before I learned PowerShell, I was using T-SQL to do things it just wasn't meant to do, namely SQL Server estate management. T-SQL is incredibly …

https://blog.netnerds.net/2022/05/rbar-performance-in-powershell/

Install-DbaMaintenanceSolution now supports auto-scheduling

Install-DbaMaintenanceSolution now supports auto-scheduling | netnerds.net

If you're wondering about the uptick in SQL Server-related posts, I recently changed jobs and went back to being a SQL Server DBA. For a few years there, I …

https://blog.netnerds.net/2023/05/install-dbamaintenancesolution-now-supports-auto-scheduling/

Migrating my WordPress sites to GitHub Pages

Migrating my WordPress sites to GitHub Pages | netnerds.net

After getting hacked one too many times, I've decided to move all of my blogs and URL-shortening sites from a Virtual Private Server to GitHub Pages.
GitHub …

https://blog.netnerds.net/2020/08/migrating-my-wordpress-sites-to-github-pages/

Use base64 for Images in WPF-based PowerShell Forms

Use base64 for Images in WPF-based PowerShell Forms | netnerds.net

I'm currently building a notification module to let me know when VMware vCenter alerts go off in my home lab. I plan to share it, and wanted to use a …

https://blog.netnerds.net/2015/09/use-base64-for-images-in-powershellwpf-forms/

Hello World! I Created My First iPhone App (And Used Snow Leopard on a Netbook to do it.)

Hello World! I Created My First iPhone App (And Used Snow Leopard on a Netbook to do it.) | netnerds.net

With the guidance of Apress's Beginning iPhone 3 Development, I was able to create my first iPhone App in less than two hours. While the book's first chapter …

https://blog.netnerds.net/2009/12/hello-world-i-created-my-first-iphone-app-and-used-snow-leopard-on-a-netbook-to-do-it/

Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1

Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1 | netnerds.net

I cannot believe my eyes.
I imagine some PowerShellers will disagree with me but when developing modules that support older versions of PowerShell, I refuse to …

https://blog.netnerds.net/2023/03/dont-waste-your-time-with-core-versions/

New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider

New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider | netnerds.net

Note: This blog post is going to borrow a bit from Microsoft's official documentation in "Connect with Azure Data Studio" and from our book, Learn …

https://blog.netnerds.net/2023/03/new-defaults-for-sql-server-connections-encryption-trust-certificate/

Offline Installation of dbatools 2.0 with the dbatools.library Dependency

Offline Installation of dbatools 2.0 with the dbatools.library Dependency | netnerds.net

If you work in an offline environment, you're probably familiar with how painful it can be to install anything, including PowerShell modules like dbatools.
In …

https://blog.netnerds.net/2023/04/offline-install-of-dbatools-and-dbatools-library/

Working with Basic .NET DataSets and DataTables in PowerShell

Working with Basic .NET DataSets and DataTables in PowerShell | netnerds.net

This is mostly for my reference, but you can use it, too :)
Create Basic Datatable 1$dt = New-Object System.Data.Datatable …

https://blog.netnerds.net/2015/02/working-with-basic-net-datasets-in-powershell/

Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers

Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers | netnerds.net

It's obvious that I love PowerShell and SQL Server. Together, they allow SQL Server DBA's to solve just about any problem. Most of my projects have come from …

https://blog.netnerds.net/2015/06/reset-sqlsapassword-easily-regain-sasysadmin-access-to-your-sql-servers/

URL Shortening/Redirects using GitHub Pages and Jekyll

URL Shortening/Redirects using GitHub Pages and Jekyll | netnerds.net

Recently, I moved many of my blogs/shortlink domains to GitHub Pages. With that, the security of my sites increased dramatically, but I lost some functionality …

https://blog.netnerds.net/2020/08/url-shortening-redirects-using-github-pages-and-jekyll/

Import-DbaCsv Design Considerations

Import-DbaCsv Design Considerations | netnerds.net

I've been writing about CSV imports using PowerShell for a pretty long time and in VBScript for even longer.
Initially, my primary concerns were ease-of-use and …

https://blog.netnerds.net/2022/05/import-csv-dbatools-design-considerations/

OS X: How to Setup NAT on Lion and Mountain Lion

OS X: How to Setup NAT on Lion and Mountain Lion | netnerds.net

It appears Apple changed the way NAT works, starting in Lion and this upset a lot of people. Apparently, nat would just stop working for some folks after they …

https://blog.netnerds.net/2012/07/os-x-how-to-setup-nat-on-lion-and-mountain-lion/

[Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services

[Solved] Annoying Scrollbars in Excel Web Access Web Parts and PerformancePoint w/ Excel Services | netnerds.net

Recently, while using Excel Services to access PivotCharts and PivotTables within Excel Web Viewer Web Parts and PerformancePart Dashboards, I encountered …

https://blog.netnerds.net/2012/03/solved-annoying-scrollbars-in-performancepoint-w-excel-services-pivotcharts-and-excel-web-access-web-parts/

Docker on GitHub Actions macOS Runners (2022)

Docker on GitHub Actions macOS Runners (2022) | netnerds.net

One of my GitHub Actions, mssqlsuite makes it ultra easy to install SQL Server on Linux, Windows and macOS runners. When working on the macOS portion, I was …

https://blog.netnerds.net/2022/11/docker-macos-github-actions/

ExpressVPN on macOS: No internet detected

ExpressVPN on macOS: No internet detected | netnerds.net

I've used ExpressVPN for years and it's worked great on all my devices until one day, when it stopped even trying to make a connection from my Mac Mini.
As soon …

https://blog.netnerds.net/2022/06/expressvpn-no-internet-detected-macos/

Using GitHub Pages to Setup an Alias on Mastodon

Using GitHub Pages to Setup an Alias on Mastodon | netnerds.net

After moving from Twitter to Mastodon, I wrote a blog post about how aliases can help us keep a consistent social media presence even if we change servers.
This …

https://blog.netnerds.net/2022/11/alias-mastodon-github-pages/

Workaround for SMO Bug: urn could not be resolved at level OleDbProviderSetting

Workaround for SMO Bug: urn could not be resolved at level OleDbProviderSetting | netnerds.net

Microsoft ConnectM isn't letting me sign in to post this workaround, but I just ran into a bug with the OleDbProviderSettings within SMO.
To get around it, I …

https://blog.netnerds.net/2015/01/workaround-for-smo-bug-urn-could-not-be-resolved-at-level-oledbprovidersetting/

It’s 2016, so why are you still using sp_help_revlogin?

It’s 2016, so why are you still using sp_help_revlogin? | netnerds.net

Today's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. …

https://blog.netnerds.net/2016/06/its-2016-why-is-sp_help_revlogin-a-thing/

What's new and different in dbatools 2.0

What's new and different in dbatools 2.0 | netnerds.net

So much is new and different! If you'd like to try it while you read this blog post, you can currently install dbatools 2.0 by executing the following command: …

https://blog.netnerds.net/2023/03/whats-new-dbatools-2.0/

Add existing directory storage to proxmox without wiping it first

Add existing directory storage to proxmox without wiping it first | netnerds.net

I wanted to blog about this because I couldn't find any info about it on the internet.
Against the advice of everyone, I installed Proxmox on a USB thumbdrive. …

https://blog.netnerds.net/2022/03/add-existing-storage-proxmox-without-wiping-it-first/

High-Performance Techniques for Importing CSV to SQL Server using PowerShell

High-Performance Techniques for Importing CSV to SQL Server using PowerShell | netnerds.net

If you've ever tried to use PowerShell's Import-CSV with large files, you know that it can exhaust all of your RAM. Previously, I created a script on …

https://blog.netnerds.net/2015/01/powershell-high-performance-techniques-for-importing-csv-to-sql-server/

Setup an SSTP SSL VPN in Windows Server 2012 R2

Setup an SSTP SSL VPN in Windows Server 2012 R2 | netnerds.net

So here's what's awesome about Secure Socket Tunneling Protocol SSL VPNs: they give your connecting client an IP and make it a full-on part of the network. And …

https://blog.netnerds.net/2015/02/setup-an-sstp-ssl-vpn-in-windows-server-2012-r2/

Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell

Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell | netnerds.net

Code signing your scripts, modules and applications can help increase enterprise adoption, as large organizations often prohibit running unsigned tools on …

https://blog.netnerds.net/2022/06/signing-powershell-modules-github-actions/

Mounting NAS Volumes in Mac OS X the Right Way

Mounting NAS Volumes in Mac OS X the Right Way | netnerds.net

I've been using Mac OS X for a while now, but upgraded to a 13-inch Macbook Pro Retina about a year ago. I love having access to the command line and I just RDP …

https://blog.netnerds.net/2013/10/mounting-nas-volumes-in-mac-os-x-the-right-way/

Now in MEAP: Generative AI for the IT Pro!

Now in MEAP: Generative AI for the IT Pro! | netnerds.net

Me and my BFF, Brandon, have been writing a new book it's available today in the Manning Early Access Program! This means you can get a copy of the book as …

https://blog.netnerds.net/2024/02/ai-for-it-meap/