Skip to content

Instantly share code, notes, and snippets.

@macfergusson
macfergusson / SQL_Resources.md
Last active January 11, 2026 18:34
SQL Community Discord Resources
@macfergusson
macfergusson / WoW_specs.txt
Last active June 13, 2024 04:37
WoW specs - a bit tongue in cheek descriptions
My impressions, these should be taken with a grain of salt, and some of it may be outdated since I haven't played everything in the current patch.
For high end mythic raid comps, there is more space for ranged DPS than melee DPS due to the need for very specific roles to be filled, leaving a lot less flexibility in who they bring.
If you're not in the Race to World First happening right now, this doesn't really apply to you.
If you're focusing on normal or heroic, or maybe lightly approaching mythic raiding, being good at any DPS spec is the real requirement.
ST: Single Target
AOE: Area of Effect/multi target/cleave.
HoT: Heal over Time
DoT: Damage over Time AKA bleed/disease/damage dealing debuff.
@macfergusson
macfergusson / index_scripting.sql
Last active June 13, 2024 04:36
script out indexing
/* script out indexing */
SELECT ' CREATE ' +
CASE
WHEN I.is_unique = 1 THEN ' UNIQUE '
ELSE ''
END +
I.type_desc COLLATE DATABASE_DEFAULT + ' INDEX ' +
I.name + ' ON ' +
SCHEMA_NAME(T.schema_id) + '.' + T.name + ' ( ' +
@macfergusson
macfergusson / SSRS_subreports.sql
Last active June 19, 2024 23:00
SSRS_subreports.sql
USE ReportServerDB
IF OBJECT_ID('tempdb..#ResultsTable') IS NOT NULL
DROP TABLE #ResultsTable;
CREATE TABLE #ResultsTable (
ReportID UNIQUEIDENTIFIER NOT NULL
,ReportName NVARCHAR(425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL
,ReportPath NVARCHAR(425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL
,SubreportName NVARCHAR(256) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL

Rules clarifications from the starwarsunlimited.com card database:

Update dates: 10/31/2025 07/14/2025 03/06/2025 03/05/2025 10/31/2024 07/22/2024 07/16/2024 03/01/2024

These dates are the dates that a batch of updates have been made. Use Ctrl + F to search for updates made on that date.

Set 6 - Secrets of Power

Academy Disciplinarian

  • 10/31/2025 - Abilities that refer to a card’s power include temporary modifiers.

Accelerate Our Plans

@macfergusson
macfergusson / SWU_Policy.md
Last active January 9, 2026 17:50
SWU Policy Clarifications

Star Wars Unlimited Policy Clarifications

Revised Policy Clarifications Page to be used with new CEG policy document as of 2025-12-09.

Revisions and Clarifications

These clarifications have been updated to have changed wording, and the meaning of the language will change or language was missing and has been added back in. In some cases, the intention has not changed, but typing errors or formatting errors lead to this policy being published. Some of these revisions also come from experience with Star Wars™: Unlimited limited events, which did not exist when the policy was initially written.

TR Section 4