Skip to content
WickTech Blog
Thoughts on SQL Server, PowerShell, and excursions with a Canon camera
  • About
  • Posts
  • Blog Roll
  • Presentations
  • Photo Gallery
  • Contact

Category: PowerShell

Installing The Prometheus Exporter For Windows Clients

2022-04-19 Jamie 1 Comment

Prometheus is an open-source monitoring solution that our Linux team has been using for several years. More recently, we began…

Continue Reading →

Posted in: PowerShell, Windows Server Filed under: monitoring, PowerShell, Prometheus, windows server, windows_exporter

Using SSH keys to connect to GitLab from a Windows client

2022-03-29 Jamie 1 Comment

For those who have not used GitLab before, it is an open-source code repository and collaboration tool (similar to GitHub).…

Continue Reading →

Posted in: PowerShell, Source Control Filed under: authentication, code repository, Git, GitLab, PowerShell, Source Control, SSH, ssh-keygen

Windows Containers and IIS

2020-09-15 Jamie 3 Comments

Recently I was asked to work on containerizing a legacy web app that was written by a developer who is…

Continue Reading →

Posted in: Containers, PowerShell, Windows Server Filed under: .NET, Active Directory, Credential Spec, Docker, dockerfile, gMSA, Group Managed Service Account, IIS, pass-through authentication, web app, Windows container, windows server

Windows containers & SQL Server – Part 3 – Error Logs

2020-08-31 Jamie Leave a comment

So far this series has covered: installing Docker for Windows, the basic commands for managing images and containers, and creating…

Continue Reading →

Posted in: Containers, PowerShell, SQL Server Filed under: Docker, docker cp, docker logs, error log, PowerShell, SQL Server, troubleshooting, Windows container

Jupyter books in Azure Data Studio

2020-04-14 Jamie 1 Comment

Jupyter Book: A collection of SQL, PowerShell, and Python-based notebooks and markdown files. In a recent Channel9 segment, Vicky Harp…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: azure data studio, Jupyter book, notebook, PowerShell, SQL Server

Getting started with Windows containers & SQL Server

2020-03-17 Jamie 2 Comments

SQL Server containers are gaining popularity as a way of enhancing and standardizing development environments for Windows & Linux based…

Continue Reading →

Posted in: Containers, PowerShell, SQL Server Filed under: Docker, PowerShell, SQL Server, Windows container

PowerShell and Failover Clustering (WSFC)

2019-03-19 Jamie Leave a comment

This is one article in a series that cover how to use PowerShell scripts to automatically install SQL Server. The full script set can be found here. High availability in production SQL Servers is often a desirable feature.…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: Availability Groups, failover cluster, PowerShell, SQL Server, wsfc

PowerShell and Group Managed Service Accounts (gMSA)

2019-02-19 Jamie 4 Comments

This is one article in a series that cover how to use PowerShell scripts to automatically install SQL Server. The full script set can be found here. Service Accounts are a requirement for installing and running a SQL…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: Active Directory, gMSA, install, Managed Service Account, PowerShell, SQL Server

How Secure Are Your Client Connections?

2018-09-04 Jamie 1 Comment

First, thanks to Sean McCown (t|w) and Mladen Prajdic (t|w) for their assistance with finding & confirming some of the…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: Encryption, encryption cipher, encryption protocol, Schannel, Security, SQL client, SQL Server, SSL Certificate, TLS

Server Maintenance – Snapshots & Maintenance Mode

2018-06-21 Jamie 1 Comment

Patching servers is an annoying, but critically necessary task. Every month, on every (virtual) server, we have to: Create a…

Continue Reading →

Posted in: PowerShell Filed under: maintenance mode, PowerShell, PSRemoting, SCOM 2016, script, server maintenance, snapshot, Using scope modifier, VMware

Post navigation

Page 1 of 2
1 2 Next →

Categories

Connect with

  • LinkedIn
  • Twitter
Tweets by Jamie_Wick
Copyright © 2023 WickTech Blog
 

Loading Comments...