netnerds.net
Home
AI Integration Series
AI Usage
About
Subscribe
github bluesky youtube github-star rss
  • Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers

    calendar Jun 7, 2015 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    It's obvious that I love PowerShell and SQL Server. Together, they allow SQL Server DBA's to solve just about any problem. Most of my projects have come from questions posted in Reddit's SQL Server subreddit, including my most recent project, Reset-SqlSaPassword, which allows you to regain syadmin access to your SQL …
    Read More
  • Getting Total Number of Rows Copied in SqlBulkCopy Using PowerShell

    calendar May 18, 2015 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    Getting the total number of inserted rows for SqlBulkCopy should be easier, but I believe the easiest (and fastest) is by using reflection and some C# code within your PowerShell script. Thanks to user601543 at stackoverflow, I was able translate his code for use within one of my own scripts. …
    Read More
  • Simplifying SQL Server Migrations using PowerShell

    calendar May 15, 2015 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Recently, I did a webcast for the PowerShell Virtual Chapter of PASS on Simplifying SQL Server Migrations using PowerShell. If you're planning for a SQL Server migration, I wrote a bunch of scripts that can help, and put them all on github.

    Check out the sqlmigration repository, and the accompanying PowerPoint Slides. …


    Read More
  • Sudden High CPU Utilization and Query Performance Decrease | When Query Plans Go Bad

    calendar Apr 20, 2015  · Brandon Abshire   · 7 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    Each morning when I get into the office, I check performance graphs in SolarWinds Database Performance Analyzer (DPA - formerly Confio Ignite).  Monday mornings are usually the most important, because I run full system maintenance on a specific monitored database on Sunday.  Monday is the first day of heavy utilization …
    Read More
  • Get SQL Server Product Keys for Local and Remote Servers using PowerShell

    calendar Mar 22, 2015 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    I just released a new PowerShell script, Get-SQLServerKeys.ps1. The script works works with several versions of SQL Server (2005-2014), and can use Central Management Server, a text file, or just a string of servers as input.

    <img …</picture></figure></a></p>
    

    Read More
  • Using .NET DataTable Computes and Column Expressions in PowerShell

    calendar Feb 3, 2015 · 5 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    As a SQL Server DBA, I'm used to SQL being able to perform aliasing, super fast subselects, and easy aggregation. My most recent project, Invoke-Locate.ps1, however, uses SQLite because of its portability and speed when performing simple selects and inserts. The downside is that SQLite doesn't handle some subselects …
    Read More
  • Working with Basic .NET DataSets and DataTables in PowerShell

    calendar Feb 1, 2015 · 3 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    This is mostly for my reference, but you can use it, too :)

    Create Basic Datatable

     1$dt = New-Object System.Data.Datatable
     2[void]$dt.Columns.Add("First")
     3[void]$dt.Columns.Add("Second")
     4[void]$dt.Columns.Add("Third")
     5
     6# Add a row manually
     7 …

    Read More
  • High-Performance Techniques for Importing CSV to SQL Server using PowerShell

    calendar Jan 18, 2015 · 10 min read  ·
    Share on: mastodon facebook linkedin bluesky copy
    If you've ever tried to use PowerShell's Import-CSV with large files, you know that it can exhaust all of your RAM. Previously, I created a script on ScriptCenter that used an alternative technique to import large CSV files, and even imported them into SQL Server at a rate of 1.7 million rows a minute. I've now gotten …
    Read More
  • Professional PowerShell-based SQL Server SMO Recipes

    calendar Jan 8, 2015 · 2 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    Last year, I finally started working with SMO (SQL Management Objects) within PowerShell and I absolutely love it. Below are a few recipes that I created and use extensively throughout my SQL Management scripts, which you can find on ScriptCenter. Some recipes show more than one way to perform a task.

    These SMO recipes …


    Read More
  • Enumerate file structure within detached MDF database file using SMO

    calendar Jan 7, 2015 · 1 min read  ·
    Share on: mastodon facebook linkedin bluesky copy

    While researching how connect to a detached MDF and read the internal file structure of the internal files, including LDF files, I kept seeing suggestions for using the undocumented DBCC command DBCC checkprimaryfile. Initially, my code looked like this:

     1# SQL Server is required to read the file contents
     2 …

    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

  • dbatools is moving to Azure Trusted Signing
  • 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

categories

powershell 129 sql-server 124 general 64 security 61 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 powershell129 security61 sharepoint42 sql-server124 typescript1 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved