Tech Blog – Notebook

Quick Links
CIDR Conversions
SQL Server Notes
Other Links


Quick Links

Cloud Portals
# Microsoft Azure.
# Amazon Web Services (AWS).

RDMS Software Downloads
# SQL Server 2019 Download.
# SQL Server Management Studio (SSMS) Download.
# MySQL Community Downloads.
# PostgreSQL Downloads.

Test Databases
# MSSQL – AdventureWorks.
# MySQL – Employees.
# Various – Sakila.

Cheat Sheets
# MSSQL Operational Cheat Sheet.
# MSSQL Diagnostic Cheat Sheet.
# MSSQL ETL Cheat Sheet.
# PowerShell Cheat Sheet.


CIDR Conversions

CIDR Prefix LengthNetmaskHosts (Class C’s/B’s/A’s)
/32255.255.255.2551
/31255.255.255.2542
/30255.255.255.2524
/29255.255.255.2488
/28255.255.255.24016
/27255.255.255.22432
/26255.255.255.19264
/25255.255.255.128128
/24 (Class C)255.255.255.0256 / 1
/23255.255.254.0512 / 2
/22255.255.252.01,024 / 4
/21255.255.248.02,048 / 8
/20255.255.240.04,096 / 16
/19255.255.224.08,192 / 32
/18255.255.192.016,384 / 64
/17255.255.128.032,768 / 128
/16 (Class B)255.255.0.065,536 / 256 / 1
/15255.254.0.0131,072 / 512 / 2
/14255.252.0.0262,144 / 1024 / 4
/13255.248.0.0524,288 / 2048 / 8
/12255.240.0.01,048,576 / 4096 / 16
/11255.224.0.02,097,152 / 8129 / 32
/10255.192.0.04,194,304 / 16,384 / 64
/9255.128.0.08,388,608 / 32,768 / 128
/8 (Class A)255.0.0.016,777,216 / 65,536 / 256 / 1
/7254.0.0.033,554,432 / 131,072 / 512 / 2
/6252.0.0.067,108,864 / 262,144 / 1,024 / 4
/5248.0.0.0134,217,728 / 524,288 / 2,048 / 8
/4240.0.0.0268,435,456 / 1,048,576 / 4,096 / 16
/3224.0.0.0536,870,912 / 2,097,152 / 8,192 / 32
/2192.0.0.01,073,741,824 / 4,194,304 / 16,384 / 64
/1128.0.0.02,147,483,648 / 8,388,608 / 32,768 / 128
/00.0.0.04,294,967,296 / 16,777,216 / 65,536 / 256

SQL Server Notes

Build Versions
# Show all build versions.
# Subscribe to new updates.

Supported Version & Edition Upgrades
# 2017.
# 2019.
# 2014.
# 2012.

Supported Edition Features
# 2019.
# 2017.
# 2016.
# 2014.
# 2012.
# 2008-R2.
# 2008.

Anti-Virus Exclusions
# MS Documentation.

Cheat Sheets
# MSSQL Operational Cheat Sheet.
# MSSQL Diagnostic Cheat Sheet.
# MSSQL ETL Cheat Sheet.

Test Databases
# MSSQL – AdventureWorks.
# MSSQL – Wide World Importers.
# MSSQL – Stack Overflow.

Tools
# Ola Hallengren’s Maintenance Solution.
# sp_whoisactive.
# sp_Blitz & First Responder Kit.
# Glen Berry’s Diagnostic Scripts.
# Statistics Parser.
# Max the CPU!

Blogs, Forums & Other Resources
# SQL Server Central (Weekly Links, Stairways, Forum).
# Brent Ozar (Blog, Training, Tools).
# DBA Stack Exchange (Q&A Site).
# .
# .
# .


Other Links

# SQL Server Links.
# Link Dump.