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

Author: Jamie

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 2 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

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

SQL Server ConfigurationFile.ini

2020-07-21 Jamie 1 Comment

The ability to use a parameter file (configurationfile.ini), for automating the installation of SQL Server, has been around for many…

Continue Reading →

Posted in: SQL Server Filed under: configurationfile.ini, configure, install, parameters, setup.exe, SQL Server

Post navigation

Page 1 of 4
1 2 … 4 Next →

Categories

Connect with

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

Loading Comments...