netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • Install-DbaMaintenanceSolution now supports auto-scheduling

    May 23, 2023 · 5 min read  ·
    Share on:

    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
  • [Solved] OmniSharp.Extensions.JsonRpc.RpcErrorException in VS Code Dev Containers for PowerShell-based Azure Functions

    Apr 16, 2023 · 2 min read  ·
    Share on:

    I recently got into VS Code Dev Containers and Azure Functions, and I love them. Unfortunately, the PowerShell Azure Functions pretty much come out of the box with a high likelihood of throwing Ominsharp exceptions when debugging. Two of the files the setup process generates, launch.json and tasks.json, use the func …


    Read More
  • Exploring GitHub Copilot Chat

    Apr 7, 2023 · 6 min read  ·
    Share on:

    I've been super busy with a couple projects (including dbatools 2.0, which will be GA soon) and hadn't kept up with much, but I got a notification on my phone for an article on infoworld.com that talked about a new GitHub Copilot feature in VS code called Copilot chat. While reading the article, I got the feeling that …


    Read More
  • Offline Installation of dbatools 2.0 with the dbatools.library Dependency

    Apr 5, 2023 · 3 min read  ·
    Share on:

    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

    Mar 5, 2023 · 5 min read  ·
    Share on:

    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

    Mar 5, 2023 · 5 min read  ·
    Share on:

    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
  • Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1

    Mar 4, 2023 · 4 min read  ·
    Share on:

    I cannot believe my eyes. I imagine some PowerShellers will disagree with me but when developing modules that support older versions of PowerShell, I refuse to even try to support Core vs Desktop in my module manifest. I imagine this will be the case for the next decade or two. I've been working on dbatools 2.0 for a …


    Read More
  • Exploring faster PowerShell import times.. again

    Mar 4, 2023 · 5 min read  ·
    Share on:

    I've been trying for years to get dbatools to import faster. There's a lot of plain-text code to import and even more help. Binary modules like Microsoft's SqlServer module benefit from prior compilation and can be imported in like 500-900ms whereas dbatools generally takes 2-5 seconds. I've written about module …


    Read More
  • You just joined Mastodon, now what?

    Nov 28, 2022 · 3 min read  ·
    Share on:

    When I first joined Mastodon, I was excited to learn that fedifinder and debirdify can help find my Twitter friends on Mastodon. Both are web-based tools that search your follows and/or followers on Twitter for possible Mastodon accounts, then export the results to a CSV file. First thing I'd recommend doing? Find your …


    Read More
  • Using GitHub Pages to Setup an Alias on Mastodon

    Nov 21, 2022 · 3 min read  ·
    Share on:

    After moving from Twitter to Mastodon, I wrote a blog post about how aliases can help us keep a consistent social media presence even if we change servers. This means that even though dbatools is currently using the fosstodon.org server as [email protected], I'll be linking [email protected] on all of our …


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

Chrissy LeMaire

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

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 Mastodon

recent posts

  • Install-DbaMaintenanceSolution now supports auto-scheduling
  • [Solved] OmniSharp.Extensions.JsonRpc.RpcErrorException in VS Code Dev Containers for PowerShell-based Azure Functions
  • Exploring GitHub Copilot Chat
  • Offline Installation of dbatools 2.0 with the dbatools.library Dependency
  • New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
  • What's new and different in dbatools 2.0
  • Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1
  • Exploring faster PowerShell import times.. again

categories

sql-server 121 powershell 116 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 github 8 apache 7
All Categories
active-directory37 apache7 apple24 asp-net2 azure-functions1 bi4 db24 devcontainers1 exchange7 general63 github8 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell116 security59 sharepoint41 sql-server121 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved