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

Category: SQL Server

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

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

Don’t forget the SIDs

2020-05-13 Jamie Leave a comment

When talking with people about databases and disaster recovery our conversation often sounds like this: Q: What does your backup…

Continue Reading →

Posted in: SQL Server Filed under: create login, database user, Login, relink user login, SID, SQL Server, System Identifier

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

Post navigation

Page 1 of 3
1 2 3 Next →

Categories

Connect with

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

Loading Comments...