Bookmarks

Various online tools, databases, references, cheatsheets, etc, that I’ve found over the years to be helpful in my day to day work.

If you have any suggestions to add, or a better way to organize this page, feel free to let me know in the comments.

db<>fiddle
- RDBMS Fiddler (MySQL, Oracle, Postgres, SQL Server, SQLite, etc)
PasteThePlan
- Share SQL Server Execution Plans
RAISERROR Cheatsheet
- Everything you need to know about using RAISERROR in SQL Server
SQL Fiddle
- RDBMS Fiddler (MySQL, Oracle, Postgres, SQL Server) - Nearly always broken or slow, try dbfiddle.uk instead
SQL Server Updates
- The Most Recent Updates for Microsoft SQL Server
SQLServerFast Execution Plan Operator List
- List of all known execution plan operator icons, their names, a description, and usually a link to a more in-depth breakdown of how it works
SQLShack - SQL Server wait types
- Database of SQL Server wait types and recommended actions
SQLSkills - SQL Server latch types
- Database of SQL Server latch types
SQLSkills - SQL Server wait types
- Database of SQL Server wait types
Statistics Parser
- SQL Statistics Parser

Add a “reset_time” column to index stats DMVs
- Ever queried sys.dm_index_usage_stats and wondered how old that stats data is? Too bad…There’s really no way to know
Add new metadata function: INDEX_NAME()
- SQL Server has OBJECT_NAME(), COL_NAME(), DB_NAME()…why no INDEX_NAME()?
Output warning message when altering an indexed view that all indexes (clustered and non-clustered) will be dropped
- ALTER VIEW … Oops! All the indexes are now gone, clustered and non-clustered and SQL Server didn’t say a thing…Not even a warning.
Statement execution duration global variable - Similar to @@ROWCOUNT, but instead how long the previous statement took to run
- Wouldn’t it be nice if you could stop messing with datetime variables and datediff to figure out how long the previous statement took to run?

Asciinema
- Record Shell Session - Appears project is dead, but repo and site upload still works
Board
- Online Whiteboard, alternative link: https://board.new
PasteBin
- Share text

asciiflow
- Draw ascii art style diagrams and flowcharts
dbdiagram.io
- A free, simple tool to draw Entity-Relationship diagrams by just writing code
Diagram.codes
- Generate diagrams from simple text conventions
GraphViz Online
- Dot/GraphViz visualizer
markmap.js
- Visualize your Markdown with mindmaps (and interactive)
swimlanes.io
- Build swimlane charts using code
WebSequenceDiagrams
- Create sequence diagrams using a diagramming language

dotnet-install scripts reference
- Script to install various versions of the .NET SDK
HTTP Status Codes
- Database of HTTP Status Codes with their definitions and helpful code references
Javascript Equality Table
- Reference chart showing result of equality operations