netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss
  • PDF Text to SQL Data: Using OpenAI's Structured Output with PSOpenAI

    calendar Aug 20, 2024 · 9 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Incredible! I just used PowerShell and OpenAI to import text from a PDF right into SQL Server 🚀 AI's usefulness is often debated but this is such a great use-case. I also see it being useful for automatically adding SharePoint document metadata and cleaning dirty data.

    Using a new feature from OpenAI called …


    Read More
  • Update-Module dbatools Authenticode Issuer Error

    calendar Sep 21, 2023 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    TLDR: This error is expected and the change is legitimate. To update, switch to Install-Module, then slap on the -SkipPublisherCheck and -Force parameters and continue your update.

    1Install-Module dbatools -Force -SkipPublisherCheck
    

    I've always been very proud that dbatools is Code Signed like a "real" …


    Read More
  • Install-DbaMaintenanceSolution now supports auto-scheduling

    calendar May 23, 2023 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    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 switched to security engineering; I figured I'd try something new and welcomed no longer being an admin. It was nice enough and I got to do a ton of PowerShell, but …
    Read More
  • Offline Installation of dbatools 2.0 with the dbatools.library Dependency

    calendar Apr 5, 2023 · 3 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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 the past, dbatools had no dependencies, so the installation process was somewhat straightforward — you could even download a zip from our GitHub repo. However, …


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

    calendar Mar 5, 2023 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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 dbatools in a Month of Lunches. It also addresses dbatools 2.0, which is currently in pre-release.

    Microsoft recently made some changes to the default encryption …


    Read More
  • What's new and different in dbatools 2.0

    calendar Mar 5, 2023 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    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:

    1Install-Module dbatools
    

    Requirements

    dbatools still works on PowerShell v3 an v4! Thanks to Microsoft for making that possible with SMO.

    PowerShell v5.1 is …


    Read More
  • 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
  • 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
  • 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
    • ««
    • «
    • 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