Skip to content

Instantly share code, notes, and snippets.

Rules clarifications from the starwarsunlimited.com card database:

Update dates: 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 5 - Legends of the Force

A Precarious Predicament

  • 07/14/2025 - "Play for free" ignores all resource costs, including the aspect penalty, but not other additional costs.
  • 07/14/2025 - Abilities that return a card to hand must choose a card in play unless otherwise specified.
@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
@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 / 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 / SQL_Resources.md
Last active July 22, 2025 15:38
SQL Community Discord Resources