Primary Menu

Skip to content
Menu
  • Brain Dump
  • My Test Labs
    • Docker
    • DockerCompose
    • VMWare Workstation Lab
    • VirtualBox Lab
    • Azure
    • AWS
    • LocalDB
    • VMWare Player Lab
  • SQL Scripts
    • Top Published Scripts
    • DBA sp_ collection
    • Environment Snippet Collection
  • PowerShell
  • LM Studio / ChatGPT
  • Python
  • Other Database Systems
    • Aurora /My SQL /MariaDB
    • Snowflake Data Cloud
    • PostGreSQL
    • MongoDB
  • About Me
    • Consulting
    • SiteMap
  • WebMail
Header Toggle

Stormrage

Senior SQL DBA and Code Monkey Script Dump

Category: Uncategorized

Windows PowerShell to create Docker Containers for SQL2017,SQL2019

Posted on2024-05-282024-05-28Leave a comment

Code example that create ten instances: each version of ‘Express’,’Developer’,’Web’,’StandardEdition’,’EnterpriseEdition’

CategoriesUncategorized

SQL Shark

Posted on2024-02-062024-02-06Leave a comment

CategoriesUncategorized

Posted on2024-02-062024-02-06Leave a comment

CategoriesUncategorized

Scanning Every Server with Dynamic Reports

Posted on2024-01-242024-01-24Leave a comment

I am really big on using a couple of methods to scan every server in my environment with a huge array of queries. Why? because There’s the classic purposes to doing this. How do I do it? I have two Read More …

CategoriesUncategorized

Standard SQL Server Machine

Posted on2022-12-262022-12-26Leave a comment

When you build a plain old Vanilla Windows Machine supporting a SQL Server instance, what does your run book look like? My run book is an excel spreadsheet with lots of formulas that update or make visible items based on Read More …

CategoriesUncategorized

Lonely Secondary Log Shipping

Posted on2022-04-272024-01-24Leave a comment

Have you ever had that rare situation where you need log shipping to another server, but have zero access to the primary server? I encountered that issue recently and my solution was two parts. A Secondary Log Shipping Target without Read More …

CategoriesUncategorized

Performance Tuning

Posted on2022-03-312022-03-31Leave a comment

Code Performance improvements are a layered approach. I think of it as multiple passes and focii to Statistics. slightly out of date stats on huge tables can greatly affect performance. Index Optimization: Review missing indexes, remove unused indexes. Data Management Read More …

CategoriesUncategorized

Who is this Lowell guy anyway?

Posted on2022-03-312022-04-13Leave a comment

Hi I am Lowell Izaguirre, and I’ve am a cutting edge Senior Database Administrator for SQL Server. I’ve got the paper pedigree for those who care, two MCSA’s and an MCSE as well, but the key is my experience, deep Read More …

CategoriesUncategorized

Massive tempdb usage implies a missing index opportunity

Posted on2022-03-152022-03-16Leave a comment

Tripped over a great example yesterday, where an application was recently upgraded, and ran out of temp db space for the tables, and not the log. The TLDR was that an inefficient query was sticking 500MB of data into a Read More …

CategoriesUncategorized

Hello world!

Posted on2022-03-10Leave a comment

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

CategoriesUncategorized

Archives

  • May 2024
  • February 2024
  • January 2024
  • December 2022
  • May 2022
  • April 2022
  • March 2022
  • September 2021
  • August 2021
  • July 2021
Copyright © 2025 Stormrage. All Rights Reserved.
Full Frame by Catch Themes
Scroll Up
  • Brain Dump
  • My Test Labs
    • Docker
    • DockerCompose
    • VMWare Workstation Lab
    • VirtualBox Lab
    • Azure
    • AWS
    • LocalDB
    • VMWare Player Lab
  • SQL Scripts
    • Top Published Scripts
    • DBA sp_ collection
    • Environment Snippet Collection
  • PowerShell
  • LM Studio / ChatGPT
  • Python
  • Other Database Systems
    • Aurora /My SQL /MariaDB
    • Snowflake Data Cloud
    • PostGreSQL
    • MongoDB
  • About Me
    • Consulting
    • SiteMap
  • WebMail