Skip to content

WickTech Blog

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

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

Windows containers & SQL Server – Part 2 – Creating new images

2020-06-24 Jamie Leave a comment

Part 1 of this series covered installing Docker for Windows and the basic comands for managing SQL Server images and…

Continue Reading →

Posted in: Containers, SQL Server Filed under: Docker, new image, save image, SQL Server, Windows container

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