Skip to content

Instantly share code, notes, and snippets.

View tboggiano's full-sized avatar

Tracy Boggiano tboggiano

View GitHub Profile
@SQLDBAWithABeard
SQLDBAWithABeard / prompt.ps1
Last active March 21, 2024 07:16
new improved colourful prompt
######## POSH-GIT
# with props to https://bradwilson.io/blog/prompt/powershell
#
#
# Now for this to work most beautifully - you will need to have the latest posh-git module
#
# You will also need the MesloLGM Nerd Font Mono font
# from here https://github.com/ryanoasis/nerd-fonts/blob/master/patched-fonts/Meslo/M/Regular/complete/Meslo%20LG%20M%20Regular%20Nerd%20Font%20Complete.ttf
# if you are super nerdy
# or
@potatoqualitee
potatoqualitee / mentalhealth.txt
Last active November 7, 2024 15:33
⛔ BlueSky mental health mute list
# mute here: https://bsky.app/moderation
election
president-elect
hurricane
storm surge
climate crisis
Iran
Israel
ballistic missiles
North Korea
@wsmelton
wsmelton / SystemHealth_Parsed_DeadlockInfo.sql
Created October 6, 2016 20:00
Script to parse Deadlock information from System_Health XEvent session in SQL Server
;WITH xDeadlock (Contents)
AS
(
select CAST(XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') as xml) as DeadlockGraph
FROM
(select CAST(target_data as xml) as TargetData
from sys.dm_xe_session_targets st
join sys.dm_xe_sessions s on s.address = st.event_session_address
where name = 'system_health') AS Data
CROSS APPLY TargetData.nodes ('RingBufferTarget/event[@name="xml_deadlock_report"]') AS XEventData (XEvent)