netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell

    Jun 20, 2022 · 12 min read  ·
    Share on:

    Code signing your scripts, modules and applications can help increase enterprise adoption, as large organizations often prohibit running unsigned tools on Windows. Signed code allows machines to verify that what they're running hasn't been altered or compromised by a third party, which ultimately increases their …


    Read More
  • RBAR Performance in PowerShell

    May 31, 2022 · 8 min read  ·
    Share on:

    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 efficient when managing data, but it's not very efficient when managing SQL Server instances. For example, say you need to perform a task against each database. The …


    Read More
  • Import-DbaCsv Design Considerations

    May 24, 2022 · 6 min read  ·
    Share on:

    This post is about Import-DbaCsv, a command within the dbatools PowerShell module for SQL Server. 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 speed. Over time, I realized that what mattered most was: …


    Read More
  • Default PowerShell Paths (PSModulePath) on GitHub Runners

    Mar 24, 2022 · 1 min read  ·
    Share on:

    If you're curious about the $Env:PSModulePath for GitHub Runners, here's what I came up with after running a workflow. Knowing the $Env:PSModulePath of each runner can be useful for making specific types of GitHub Actions. I used it within my own GitHub Action, psmodulecache which makes caching PowerShell modules from …


    Read More
  • My Windows Terminal Retro Theme

    Jul 24, 2020 · 2 min read  ·
    Share on:

    After reading a number of Windows Terminal posts by Thomas Maurer and seeing Windows Terminal Preview available in my Windows App Store, I finally decided to dive in again. I was sooo excited when Microsoft first made the announcement but was disappointed when I found out I'd have to run a specific version of Windows …


    Read More
  • SQL Server Agent with CmdExec job runs PowerShell infinitely

    Jun 10, 2020 · 1 min read  ·
    Share on:

    Just ran into this issue and solved it by using powershell -ExecutionPolicy bypass C:\path\to\script.ps1. Seems there was an issue with the signed module so I just set it to not check the sign.


    Read More
  • Windows Services Recovery for SQL Server

    May 19, 2020 · 1 min read  ·
    Share on:

    Recently, I ran into an issue after applying a few security updates and subsequent reboots: a number of the SQL services did not start successfully. After running the following script, I've had success with SQL services starting as expected after reboot. It's basically a built-in service start retry. You can read more …


    Read More
  • Remove the new ad in PowerShell 5.1 on Windows 10

    Sep 7, 2019 · 1 min read  ·
    Share on:

    I really abhor the new ad in the PowerShell 5.1 console and it seems there's no hope of Microsoft making it go away. After a long, involved Twitter conversation with the community and the PowerShell team that confirmed it's impossible for the advertisement (?!) to be easily removed, it looks like the only solution is …


    Read More
  • Using robocopy to move SQL Server files

    Sep 6, 2019 · 3 min read  ·
    Share on:

    When performing file migrations, PowerShell's Copy-Item is not ideal. I've since forgotten the original reasons I concluded this with the rest of the Internet, but this quote from reddit covers it pretty well. The Copy-Item and Move-Item cmdlets are general purpose commands. They have the ability to handle many …


    Read More
  • My Second Twitch Livestream Setup

    Feb 20, 2019 · 6 min read  ·
    Share on:

    Back in January, I wrote an introduction to livestreaming titled My First Twitch Livestream Setup. In it, I created the how-to guide for getting started that I wish I had the day I found Twitch. It's now been a couple weeks and I'm becoming more acclimated to Twitch, though I still don't get emotes and would prefer if …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

Chrissy LeMaire

SQL & PowerShell MVP. GitHub Star. Creator of dbatools. Need to oil my knees.

dbatools book

Now available in bookstores and amazon 🥳 Buy it at manning.com for 50% off with code bldbatools50

dbatools

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.

available from dbatools.io and github

dbachecks

dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI and is available on github.com 📊

recent posts

  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell
  • ExpressVPN on macOS: No internet detected
  • RBAR Performance in PowerShell
  • Import-DbaCsv Design Considerations
  • Rebuilding a Proxmox cluster node
  • Default PowerShell Paths (PSModulePath) on GitHub Runners
  • Add existing directory storage to proxmox without wiping it first
  • InspecTools on Offline Windows

categories

sql-server 117 powershell 109 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 23 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple23 asp-net2 bi4 db24 exchange7 general63 github4 iis19 linux31 livestreaming4 lync2 networking30 oracle1 powershell109 security59 sharepoint41 sql-server117 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved