netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss
  • RBAR Performance in PowerShell

    calendar May 31, 2022 · 8 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar May 24, 2022 · 6 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar Mar 24, 2022 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar Jul 24, 2020 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar Jun 10, 2020 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

    calendar May 19, 2020 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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

    calendar Sep 7, 2019 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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.

    <img
      loading="lazy"
      decoding="async"
      alt=""
      
        class="image_figure image_internal …</picture></figure></p>
    

    Read More
  • Using robocopy to move SQL Server files

    calendar Sep 6, 2019 · 3 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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

    calendar Feb 20, 2019 · 6 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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
  • My First Twitch Livestream Setup

    calendar Jan 30, 2019 · 10 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Back in December, I found Twitch and fell in love with livestreaming. It was amazing watching people code in PowerShell with blinged out profiles and cool cut screens. Whaaat, this is a thing? I love it!

    Getting started

    I jumped into streaming (I'm potatoqualitee on Twitch) as soon as I found the PowerShell Live Twitch …


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

Chrissy LeMaire

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

GenAI book

Buy now at manning.com for 45% off with code gaipbl45

AI Integration Series

  • Automation with AI Toolkit + GH Models
  • Getting Started with AI for PowerShell
  • Asking Tiny Questions: Local LLMs
  • Local Models Demystified
  • Asking Bigger Questions: Remote LLMs
  • PDF Text to SQL Data with OpenAI
  • Document Classification in SharePoint
  • Azure Functions Doc Parser

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 📊

Find me

Find me on Bluesky

recent posts

  • Document Intelligence with Azure Functions: A Practical Implementation
  • Automating Document Classification in SharePoint with Power Platform and AI
  • Asking Bigger Questions: Remote LLMs for Automation Engineers
  • AI Integration for PowerShell Developers: Getting Started with PSOpenAI and GitHub Models
  • AI Automation with AI Toolkit for VS Code and GitHub Models: A Visual Guide
  • Asking Tiny Questions: Local LLMs for PowerShell Devs
  • Local models mildly demystified
  • Let's talk about anti-AI slop: my plead for schools to teach AI literacy

categories

powershell 128 sql-server 123 general 64 security 60 windows 47 sharepoint 42 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 genai 14 github 10
All Categories
active-directory37 ai1 apache7 apple24 asp-net2 azure5 azure-functions1 bi4 db24 devcontainers1 exchange7 genai14 general64 github10 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell128 security60 sharepoint42 sql-server123 typescript1 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved