Skip to content

Instantly share code, notes, and snippets.

View Sebazzz's full-sized avatar
🏃‍♂️
Busy busy busy...

Sebastiaan Dammann Sebazzz

🏃‍♂️
Busy busy busy...
View GitHub Profile
@timothyham
timothyham / ipv6guide.md
Last active July 5, 2024 13:41
A Short IPv6 Guide for Home IPv4 Admins

A Short IPv6 Guide for Home IPv4 Admins

This guide is for homelab admins who understand IPv4s well but find setting up IPv6 hard or annoying because things work differently. In some ways, managing an IPv6 network can be simpler than IPv4, one just needs to learn some new concepts and discard some old ones.

Let’s begin.

First of all, there are some concepts that one must unlearn from ipv4:

Concept 1

@Sebazzz
Sebazzz / defragment-identity-fk.sql
Created January 21, 2017 11:26
Scripts to defragment (remove holes) between primary FK keys
-----------------------------------------
-- Script to "defragment" identity values in tables of the current database
--
-- Author: Sebastiaan Dammann
--
-- Global overview:
-- This script generates SQL statements you can use to remove gaps in identity
-- values in your SQL database. This script only operates on the dbo schema.
-- You can exclude tables for defragmenting via @tablesToSkip (LIKE query pattern).
--