netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss
  • Find Every Parameter for Every Command in a PowerShell Module

    calendar Dec 20, 2016 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    We're currently working on standardizing our documentation for dbatools and I needed a list of all of the parameters we use. Here's how I did it (well, I did it an uglier way then Aaron made it prettier ;))

    1Get-Command -Module dbatools -CommandType Function | 
    2ForEach-Object { $_.Parameters.Values.Name } |
    3Sort - …

    Read More
  • dbatools to the backup/restore rescue

    calendar Dec 13, 2016 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    <img
      loading="lazy"
      decoding="async"
      alt="TSQL2SDAY-150x150"
      
        class="image_figure image_internal image_unprocessed"
        src="https://blog.netnerds.net/images/TSQL2SDAY-150x150.png"
      
      
    /> …</picture></figure></a></p>
    

    Read More
  • PowerShell: Too Many If Elses? Use Switch.

    calendar Dec 7, 2016 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    One of my favorite things in PowerShell (and other languages) is the switch statement. It's clean and a much better alternative to a ton of if elses. Ever had this happen?

     1if ($state -eq -1)
     2{
     3    $diskstate = "Unknown"
     4}
     5elseif ($state -eq 0)
     6{
     7    $diskstate = "Inherited"
     8}
     9elseif …

    Read More
  • Contributing to dbatools & dbareports using GitHub Desktop

    calendar Dec 3, 2016 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Repost from dbatools.io: Recently, I presented to the Philadelphia PowerShell User Group about Contributing to Open Source PowerShell projects using GitHub Desktop. I chose this topic because a number of people have asked for step-by-step instructions on how to work with GitHub.

    I love the command line, but with Git? I …


    Read More
  • Immediately Output Runspace Results to the Pipeline

    calendar Dec 3, 2016 · 3 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    In my previous post, I presented the template I use anytime I need to add multithreading to my scripts.

    Recently, I had a request to add multi-threading to Read-DbaBackupHeader. This was the first runspace in which I had to output the results from the runspace to the host -- usually I just needed commands to run in the …


    Read More
  • Runspaces Simplified (as much as possible)

    calendar Dec 3, 2016 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Last year, I was looking into multi-threading in PowerShell and, with the help of Dr. Tobias Weltner, Boe Prox and Martin Pugh ultimately decided on runspaces.

    Then, I presented at psconf.eu about using runspaces to speed up SQL Server/CSV imports. Runspaces took me from about 90,000 rows per second to 230,000 rows per …


    Read More
  • Guest blogger Cláudio Silva: Why Expand-SqlTLogResponsibly?

    calendar Jul 20, 2016 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Hey yall! I invited one of the most active dbatools developers, Cláudio Silva, to do a guest post about his motivation for joining the team and why he built this particular command. So without further ado... here's Cláudio :D


    Hi everyone my name is Cláudio Silva, I'm a MS SQL Server DBA, and have worked with SQL …


    Read More
  • New PowerShell Commands from the SQL Server Team!

    calendar Jul 5, 2016 · 4 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    Have you seen the SQL Server Tools team's post about the PowerShell module for SQL Server? There are TWENTY FIVE new cmdlets! TWENTY FIVE! That's a 53% increase over the previous 46 cmdlets. It looks like the SQL Server community is well on its way to becoming proper citizens in the PowerShell world, and we'll reach …
    Read More
  • The PowerShell Module Formerly Known as SQLPS

    calendar Jun 30, 2016 · 3 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    I am still so floored by the additions and enhancements made to the module formerly known as SQLPS, now known as SqlServer. Not only do the new additions bring the total number of cmdlets from 46 to 71, but they align what we voted for on the Trello board. That's a 54% increase in the number of cmdlets! We'll be up to …
    Read More
  • It’s 2016, so why are you still using sp_help_revlogin?

    calendar Jun 14, 2016 · 4 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    <img
      loading="lazy"
      decoding="async"
      alt="TSQL2SDAY-150x150"
      
        class="image_figure image_internal image_unprocessed"
        src="https://blog.netnerds.net/images/TSQL2SDAY-150x150.png"
      
      
    /> …</picture></figure></a></p>
    

    Read More
    • ««
    • «
    • 3
    • 4
    • 5
    • 6
    • 7
    • »
    • »»

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