netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • Display WPF Popups in Lower Right Corner of Screen using PowerShell

    Sep 20, 2015 · 3 min read  ·
    Share on:

    I've recently changed my mind on this, but will leave the previous post up in case you want to reposition a WPF popup. If you want a big window to popup in the lower-right corner of the screen, use a WPF Window. WPF Popups are chromeless, it's true, but they are also limiting in how you can move them around, and how …


    Read More
  • Icon Color Replacement Fun with PowerShell

    Sep 20, 2015 · 2 min read  ·
    Share on:

    I like to keep interfaces simple and tend to use icons in my GUI designs. Recently, when making a PowerShell GUI to alert myself to alarm status changes in vCenter, I decided to reuse the same icon over and over for different statuses, but I made them meaningful by dynamically changing the color. The Goal My ultimate …


    Read More
  • Use base64 for Images in WPF-based PowerShell Forms

    Sep 19, 2015 · 2 min read  ·
    Share on:

    I'm currently building a notification module to let me know when VMware vCenter alerts go off in my home lab. I plan to share it, and wanted to use a non-standard icon, but didn't want to require a separate download. I knew base64 would be the answer, and ultimately, some C# code from StackExchange helped me figure out …


    Read More
  • Import-CsvToSql: Super Fast CSV to SQL Server Import PowerShell Module

    Sep 6, 2015 · 3 min read  ·
    Share on:

    A while back, I wrote about High-Performance Techniques for Importing CSV to SQL Server using PowerShell. Earlier today, I released a PowerShell module, CsvSqlImport.psm1, which puts that post into practice. Using this module, it's possible to import over 90,000 records a second in optimized environments. In addition …


    Read More
  • How to drop a SQL database stuck in Restoring...

    Jun 21, 2015 · 1 min read  ·
    Share on:

    No idea where I got this (it's been in Drafts forever), and now I kinda want to do it in PowerShell, but here's some T-SQL to drop a hella stuck database (if plain old restore database @dbname doesn't work). 1DECLARE @dbname sysname 2DECLARE @spid int 3DECLARE @dbid int 4SET @dbname = 'big' 5 6SELECT @spid = …


    Read More
  • Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers

    Jun 7, 2015 · 2 min read  ·
    Share on:

    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

    May 18, 2015 · 2 min read  ·
    Share on:

    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. The Code Here's an …


    Read More
  • Simplifying SQL Server Migrations using PowerShell

    May 15, 2015 · 1 min read  ·
    Share on:

    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

    Apr 20, 2015  · Brandon Abshire   · 7 min read  ·
    Share on:

    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
  • Making Bootable USB sticks on Windows

    Apr 2, 2015 · 1 min read  ·
    Share on:

    Just because I always forget.. All of my workstations are Macs, which I then use to connect to my vSphere and Hyper-V labs. This can make it a challenge to create bootable Windows-based USB sticks for my servers. I used to use unetbootin for Mac, but I found it worked well for my ESX servers (sometimes), but not …


    Read More
    • ««
    • «
    • 7
    • 8
    • 9
    • 10
    • 11
    • »
    • »»

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

  • 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!)
  • Docker on GitHub Actions macOS Runners (2022)
  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell
  • ExpressVPN on macOS: No internet detected
  • RBAR Performance in PowerShell

categories

sql-server 117 powershell 109 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 powershell109 security59 sharepoint41 sql-server117 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved