Skip to content
WickTech Blog
Thoughts on SQL Server & Technology
  • About
  • Posts
  • Blog Roll
  • Presentations
  • Photo Gallery
  • Contact

Author: Jamie

Automatically Updating SSL Certificates on SQL Server

2023-09-05 Jamie 2 Comments

In a previous post (How Secure Are Your Client Connections?) I covered using SSL certificates to encrypt client connections to…

Continue Reading →

Posted in: PowerShell, SQL Server, Windows Server Filed under: Encryption, PowerShell, SQL Server, SSL Certificate

Contact Information in a Digital World

2023-05-11 Jamie Leave a comment

Printed business cards have been a necessity for most of my professional life. I’ve always needed to have a few…

Continue Reading →

Posted in: Uncategorized Filed under: contact info, digital business card, qr code

Migrating Legacy SQL Databases To Aurora PostgreSQL

2023-02-08 Jamie Leave a comment

This post is rather lengthy, so here is an executive summary of what is covered. Why migrate from SQL Server…

Continue Reading →

Posted in: AWS, SQL Server Filed under: Aurora, Babelfish, Postgres, SQL Server

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

SQL Server on Linux with AD authentication

2021-01-29 Jamie 4 Comments

SQL Server has been supported on several Linux distributions for a couple of years now. For some people, the primary…

Continue Reading →

Posted in: Linux, SQL Server Filed under: Active Directory, kerberos, Linux, Login, pass-through authentication, SQL Server

SQL Server Database Snapshots

2020-12-16 Jamie 2 Comments

A SQL Server database snapshot is a read-only view of what the data pages in the source database looked like,…

Continue Reading →

Posted in: SQL Server Filed under: recovery, snapshot, SQL Server, t-sql

Accelerated Database Recovery with SQL Server 2019

2020-11-09 Jamie 1 Comment

Beginning with SQL Server 2019, Microsoft has redesigned the database recovery process (ie. crash recovery and rollback) to improve availability…

Continue Reading →

Posted in: SQL Server Filed under: 2019, database, Logical Revert, new feature, Persisted Version Store, PVS, recovery, rollback transaction, sLog, SQL Server

SQL Server Availability Group Automatic Seeding

2020-10-27 Jamie 1 Comment

In SQL Server 2016 Microsoft introduced Automatic Seeding for Availability Groups (AG). The Automatic Seeding process streams the database files…

Continue Reading →

Posted in: SQL Server Filed under: Availability Groups, Seeding, SQL Server

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

Post navigation

Page 1 of 4
1 2 … 4 Next →

Categories

Connect with

  • Twitter
  • LinkedIn
  • Instagram
Tweets by Jamie_Wick
Copyright © 2025 WickTech Blog
 

Loading Comments...