netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss
  • Importing Windows Forwarded Events into SQL Server using PowerShell

    calendar Mar 20, 2013  · Updated: November 1, 2025 · 5 min read  ·
    Share on: facebook linkedin bluesky copy

    Over the past couple weeks, I've looked into a number of ways of parsing and importing Windows Forwarded Events into SQL Server: from using SSIS to LogParser to PowerShell to setting up a linked server to the "Forwarding Events.evtx" file. Ultimately, the only thing that worked was PowerShell's Get-WinEvent …


    Read More
  • SQL Server Discovery Tools and Scripts

    calendar May 24, 2012 · 2 min read  ·
    Share on: facebook linkedin bluesky copy

    Each time I start a new contract, the first thing I do is search for all SQL Servers across any network/subnet to which I have access. While the documentation I get is usually paltry or non-existent. When it does exist, it's usually only for the production SQL Servers. Sometimes, most production SQL Servers aren't even …


    Read More
  • Using Bookpedia, SQLite, Book+ and PowerShell to Organize Your e-Book Collection

    calendar May 6, 2012 · 5 min read  ·
    Share on: facebook linkedin bluesky copy

    This setup is so unlikely, I doubt anyone on the 'net will be looking for this solution but: if you're an eBook loving Windows developer who uses a Macbook Pro for your primary workstation, this may appeal to you. My Macbook Pro runs Windows 7 within Parallels. It's fast and slick and I <3 it. My eBook reader of …


    Read More
  • [Client-side Workaround] SharePoint 2010 Excel Services cannot Automatically Refresh Data when using SharePoint Lists as a Data Source

    calendar Apr 6, 2012 · 4 min read  ·
    Share on: facebook linkedin bluesky copy

    So far as I can tell, Excel Services is not capable of automatic data refreshes when using SharePoint Lists as a data source. If you're looking for this functionality, you have two choices: PowerPivot (best) or scheduled client-side data refreshing (ghetto). In order for Excel Services to communicate with other data …


    Read More
  • PowerShell: Copy-Item -recurse -force Does Not Create Directories when Using Get-ChildItem -include

    calendar Oct 24, 2011  · Updated: November 2, 2025 · 2 min read  ·
    Share on: facebook linkedin bluesky copy

    I recently wrote a PowerShell script which copied documents from a filter to my local hard drive. I chose PowerShell for this task because it was one of the few programs actually allowed on my ultra locked-down workstation (and 'cuz I love it.) Because I only wanted specific types of files, I gathered the list of …


    Read More
  • PowerShell: Find/Replace Template

    calendar Oct 20, 2011  · Updated: November 2, 2025 · 1 min read  ·
    Share on: facebook linkedin bluesky copy

    Brandon had this in some of his maintenance plan code and I found myself using it a bit so I thought I'd blog about it. Here is a simple script that reads a file (C:\scripts\maintenanceplans\$sqlversion\template.dtsx), replaces certain placeholders (in this case, [SERVERNAME] and [BACKUPPATH]), then writes a new file …


    Read More
  • SharePoint + PowerShell: Batch Import Models, Create ECT's, Set Permissions

    calendar Sep 20, 2011  · Updated: November 3, 2025 · 3 min read  ·
    Share on: facebook linkedin bluesky copy

    Here is a script that will batch import Models, create associated ECT's, and set permissions for users and admins. Please modify the variables as needed. The script does the following: Scans current directory for BDC Export (.bdcm) files Creates the External System/Lob and the External Content Types Creates External …


    Read More
  • SharePoint + PowerShell: Import All BDCM Files in a Directory and Set Permissions

    calendar Sep 20, 2011  · Updated: November 3, 2025 · 1 min read  ·
    Share on: facebook linkedin bluesky copy

    In order to invest as little effort as possible creating and recreating and recreating my External Content Types on my development server, I exported the ECT's then deleted External Content Types, External Systems, and BDC Models. I saved them all in a directory on the SharePoint server, then I placed …


    Read More
  • SharePoint 2010 + PowerShell: Export/Import Calendar Items

    calendar Sep 20, 2011  · Updated: November 1, 2025 · 2 min read  ·
    Share on: facebook linkedin bluesky copy

    Today has been miserable. All I wanted to do was import a SharePoint 2007 calendar into SharePoint 2010 to use as sample data for a prototype site. I was caaarraaazzy enough to believe it would be a simple import/export, but no. There's no such thing. Maybe I could use Outlook calendaring or idq files as a medium? No. …


    Read More
  • SharePoint + Powershell: Remove Hold, Record Declaration on All Documents in a Library

    calendar Sep 8, 2011  · Updated: November 1, 2025 · 1 min read  ·
    Share on: facebook linkedin bluesky copy

    In order to delete a Records Library or Records Center, all holds and records in a library must be removed and the Holds and Processing timer job must be run. If this criteria is not met, the "Delete this Document Library" will not be an option in the library settings. Here is how you can do this …


    Read More
    • ««
    • «
    • 10
    • 11
    • 12
    • 13
    • 14
    • »
    • »»

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

  • Got a ChatGPT Subscription? Use It to Keep Your Blog Up-to-date
  • Update your blog with an AI CLI (No, really)
  • Update Your Blog with GitHub Copilot CLI
  • Rebuilding dbatools.io: From Notepad++ to Cursor
  • Have You Considered Not Using SQL Server High Availability?
  • PowerShell Output Redirection with AI CLIs
  • dbatools is moving to Azure Trusted Signing
  • Document Intelligence with Azure Functions: A Practical Implementation

categories

powershell 134 sql-server 124 general 62 security 61 windows 47 sharepoint 42 active-directory 37 linux 31 vbscript 31 networking 30 apple 24 virtualization 22 iis 19 genai 18 github 10
All Categories
active-directory37 ai6 apache7 apple24 asp-net2 azure5 azure-functions1 bi4 db24 dbatools1 devcontainers1 exchange7 genai18 general62 github10 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell134 security61 sharepoint42 sql-server124 typescript1 vbscript31 virtualization22 windows47 wpf7
[A~Z][0~9]

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved

Go work on your website

Start typing to search

Search across posts, pages, and commands

    ↑↓ to navigate ↵ to select esc to close
    Powered by Fuse.js