netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • A Suggested Fix for Thunderbolt Display Buzzing

    Jan 8, 2017 · 2 min read  ·
    Share on:

    About a month ago, my beloved Thunderbolt display began buzzing. After some research, it seemed that there could be all sorts of solutions. The one that seemed to almost always work was sending off the monitor to get the power supply fixed. Apparently, there's an issue with the power supply that can be confirmed if you …


    Read More
  • Loading SMO in Your SQL Server-centric PowerShell Modules

    Dec 23, 2016 · 3 min read  ·
    Share on:

    In a recent version of PowerShell, Publish-Module, which publishes modules to the Gallery began requiring fully qualified Assembly names such as "Microsoft.SqlServer.Smo, Version=$smoversion, Culture=neutral, PublicKeyToken=89845dcd8080cc91". Previously, it was sufficient just to use short names such as …


    Read More
  • Find Every Parameter for Every Command in a PowerShell Module

    Dec 20, 2016 · 1 min read  ·
    Share on:

    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

    Dec 13, 2016 · 5 min read  ·
    Share on:

    Today's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. intro dbatools has been around since 2014. At first, it started with one contributor and was solely dedicated to migrating SQL …


    Read More
  • This is How I Work

    Dec 8, 2016 · 7 min read  ·
    Share on:

    Inspired by Adam Bertram being inspired by Lifehacker's How I Work series, I'm also doing a post about how I work ;) I really liked Adam's balanced assessment so I decided to follow in his footsteps there, too. Where are you located? Belgium, land of the free, home of the beer. Also home of the Belgian PowerShell User …


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

    Dec 7, 2016 · 2 min read  ·
    Share on:

    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 ($state -eq 1) …


    Read More
  • Contributing to dbatools & dbareports using GitHub Desktop

    Dec 3, 2016 · 1 min read  ·
    Share on:

    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

    Dec 3, 2016 · 3 min read  ·
    Share on:

    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)

    Dec 3, 2016 · 5 min read  ·
    Share on:

    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
  • Share VPN with OS X Sierra Internet Sharing

    Nov 24, 2016 · 4 min read  ·
    Share on:

    After finding that it suited my requirements, I finally decided on a solid VPN - F-Secure Freedome - as recommended by a friend in security. Then I needed to share my connection with my Roku, but Freedome is an application that has to be run on a phone or computer and routers aren't supported. Once I confirmed that …


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

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

  • 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
  • You just joined Mastodon, now what?
  • Using GitHub Pages to Setup an Alias on Mastodon
  • Aliases on Mastodon: Add me! I'm also [email protected]
  • Moving to Mastodon: I actually like it better (Updated!)

categories

sql-server 119 powershell 113 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple24 asp-net2 bi4 db24 exchange7 general63 github7 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell113 security59 sharepoint41 sql-server119 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved