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

Tag: SQL Server

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

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

Post navigation

Page 1 of 3
1 2 3 Next →

Categories

Connect with

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

Loading Comments...