SQL Link Repository

There are several ways of automating the SQL Server restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backup files that exist.

How to Fake Load Tests with SQLQueryStress

How to Turn on Snapshot Isolation in SQL Server

Localization of SSRS reports

T-SQL Puzzle Challenge: Grouping Connected Items

Port Scanner

Deadlocks: let’s do one, understand it, and fix it. - Brent Ozar

So, you want to use MERGE, eh? Please don’t.

YouTube - Kevin Stratvert

VirtualBox

Inside the VertiPaq Engine - Marco Russo

Solving Sudoku with SQL

2048 Game in SQL

SQL Server Isolation Levels : A Series - SQLPerformance.com

Paul White (@SQL_Kiwi) has put together a great series on concurrency, the ACID properties of statements & transactions, and isolation levels in SQL Server.

Parallel Execution Plans - Branches and Threads - SQLPerformance.com

Paul White (@SQL_Kiwi) dives deep into new execution plan information introduced in SQL Server 2012; specifically, thread reservation and usage information for parallel plans.

Forcing a Parallel Query Execution Plan

How to force SQL Server to generate a parallel execution plan, including many of the reasons the server sometimes chooses a serial plan.

Introduction to SQL Server sequence objects - Simple Talk

SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.

CSV to SQL Tool

tSQLt - Database Unit Testing for SQL Server

SQL unit testing with the tSQLt framework for beginners

Creating and Running a SQL Server Unit Test - Microsoft

“Black Arts” Index Maintenance #1 – GUIDs v.s. Fragmentation

Black Arts Index Maintenance 1.2 - Guids vs. Fragmentation

Kendra Little -Why Table Partitioning Doesn’t Speed Up Query Performance

Extended Events

Query Store default settings

SQLozano - Extracting information from execution plans

channeladvisor/qdstoolbox: Tools for management of SQL Server’s Query Store data

Big ol’ mess of links that need sorting

https://sqlperformance.com/2020/05/system-configuration/0-to-60-switching-to-indirect-checkpoints

https://www.youtube.com/watch?v=qfQtY17bPQ4

https://www.youtube.com/watch?v=jx-FuNp4fOA

https://www.youtube.com/watch?v=GujoKLl6LBo&list=PLvX-u4vivCUrmY4BazK4qggIDYJHjZmnR&index=2

https://www.youtube.com/watch?v=MQLCbfEFSP8

https://www.youtube.com/watch?v=3cPq9FXk-RA&list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs

https://www.youtube.com/watch?v=emTguSs-PBI

https://www.youtube.com/watch?v=h9ap0qpOlKU

https://www.youtube.com/watch?v=nP063Y8bHhQ

https://www.youtube.com/watch?v=_07ZP52HxfE

https://www.brentozar.com/archive/2019/02/video-an-introduction-to-github-for-dbas/

http://www.e-squillace.com/tech/techdiagrams/SQLServerAlertFacts.htm

http://www.e-squillace.com/Tech/Default.htm

https://docs.sqlfluff.com/en/stable/index.html

https://livebook.manning.com/book/learn-dbatools-in-a-month-of-lunches/welcome/

https://www.interviewbit.com/blog/sql-projects/

https://community.embarcadero.com/article/articles-database/1078-2-ways-to-identify-that-we-have-a-bad-plan-in-sql-server

https://straightpathsql.com/archives/2023/01/5-common-sql-server-problems-to-troubleshoot-with-sp_whoisactive/

https://www.sqlhammer.com/5-extended-events-sessions-sql-server-instance-cannot-live-without/

http://thomaslarock.com/2011/12/7-mistakes-you-cant-afford-to-make-when-upgrading-to-sql-2012/

https://bigmachine.io/products/a-curious-moon/

https://www.sqlservergeeks.com/a-tip-to-optimise-like-searches-by-erland-sommarskog/

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16

https://www.sqlskills.com/sql-server-training/accidental-and-junior-dbas/

https://www.sqlskills.com/help/accidental-dba/

http://sqlblog.com/blogs/adam_machanic/archive/tags/who+is+active/default.aspx

https://techcommunity.microsoft.com/t5/sql-server-support-blog/what-is-causing-the-always-on-ag-issue-is-it-cluster-ad-dns-or/ba-p/3781656

https://straightpathsql.com/archives/2022/10/alerting-on-bad-parameter-sniffing-using-automatic-tuning/

https://www.red-gate.com/blog/author/alex-yates

http://sqlblog.com/blogs/alexander_kuznetsov/archive/2013/12/19/learning-postgresql-fun-with-repeatable-read.aspx

https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/

https://www.amazon.com/Kalen-Delaney/e/B001JS5NZO%3Fref=dbs_a_mng_rwt_scns_share

https://www.sqlshack.com/an-overview-of-the-column-level-sql-server-encryption/

https://www.sqlskills.com/blogs/jonathan/an-xevent-a-day-31-days-of-extended-events/

http://sqlblog.com/blogs/andrew_kelly/archive/2016/09/08/sqlsentry-does-it-again-plan-explorer-is-completely-free.aspx

https://sqlundercover.com/2022/08/15/attach-all-sql-datafiles-in-a-directory/

http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

https://www.mssqltips.com/sqlservertip/7708/automatically-refresh-cached-web-page-data-from-sql-server-or-oracle/?utm_content=head

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-2017

https://sqlblog.org/2012/01/26/bad-habits-to-kick-thinking-a-while-loop-isnt-a-cursor

https://www.linkedin.com/learning/paths/become-a-data-analyst?trk=lilblog_06-30-20_msft-announcement-reskilling-linkedin-learning_learning

https://www.nocentino.com/posts/2021-09-27-sqlserver-vms-best-practices/

http://codebeautify.org/xmltojson

https://www.youtube.com/watch?v=rvZwMNJxqVo

https://build-your-own.org/database/

https://github.com/mikeblas/bulldog/blob/main/BulldogUnitTests/UnitTest1.cs

https://counting.substack.com/p/can-we-stop-with-the-sql-joins-venn-diagrams-insanity-16791d9250c3?utm_source=url

https://www.ted.com/talks/cathy_o_neil_the_era_of_blind_faith_in_big_data_must_end/transcript

https://www.esqlcargot.com/main/writing/christmas-tuning/

https://www.cisecurity.org/cis-benchmarks/

https://github.com/clinthuffman/PAL

https://en.wikipedia.org/wiki/Codd%27s_12_rules

https://www.mssqltips.com/sqlservertip/2602/collecting-and-storing-poor-performing-sql-server-queries-for-analysis/

https://www.erikdarlingdata.com/sql-server/setting-lock-pages-in-memory/

https://www.brentozar.com/training/fundamentals-database-administration/remote-dac-7m/

https://hevodata.com/learn/sql-server-to-s3/

https://www.erikdarlingdata.com/sql-server/considerations-for-paging-queries-in-sql-server-with-batch-mode-dont-use-offset-fetch/

https://www.mssqltips.com/sqlservertip/4664/copy-a-sql-server-database-with-just-the-objects-and-no-data/

https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

https://www.red-gate.com/hub/product-learning/flyway/creating-idempotent-ddl-scripts-for-database-migrations

http://www.red-gate.com/products/sql-development/sql-data-generator/

https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?redirectedfrom=MSDN&view=sql-server-ver15

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

https://stackoverflow.com/questions/325933/determine-whether-two-date-ranges-overlap

https://github.com/dbartolini/data-oriented-design

https://dbatools.io/

https://docs.dbatools.io/Copy-DbaDatabase

https://docs.dbatools.io/Copy-DbaDbTableData.html

https://docs.dbatools.io/Invoke-DbaDbDataMasking.html

https://dbdiagram.io/home

http://www.devart.com/dbforge/sql/sqldecryptor/

https://dbschema.com/

http://www.e-squillace.com/tech/techdiagrams/DCBB_PermissionModels.png

http://www.e-squillace.com/tech/techdiagrams/DCBB_Programming_Object_Functionality_Comparison.png

https://www.simple-talk.com/books/sql-books/defensive-database-programming/

https://www.youtube.com/watch?v=TmrWvUnl424

https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/

https://sqlperformance.com/2013/06/t-sql-queries/missing-index

https://bornsql.ca/blog/dont-optimize-for-ad-hoc-workloads-as-a-best-practice/

http://www.microsoft.com/learning/en-us/companion-moc.aspx

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?redirectedfrom=MSDN&view=sql-server-ver15

https://orderbyselectnull.com/2017/08/25/dynamic-data-unmasking/

https://www.sommarskog.se/dyn-search.html

https://sommarskog.se/dyn-search.html

http://www.sommarskog.se/dyn-search.html

https://www.docker.com/

https://entdna.com/

https://bengribaudo.com/blog/2017/02/21/3565/equating-nulls-with-exists-intersect

https://www.brentozar.com/archive/2022/10/erik-darlings-month-of-free-tools-training/

https://www.sommarskog.se/index.html

https://www.sommarskog.se/error_handling/Part3.html

https://www.sommarskog.se/error_handling/Part1.html

https://www.sommarskog.se/error_handling/Part2.html

https://www.microsoft.com/learning/en-us/exam-70-461.aspx

https://matthewmcgiffen.com/2023/06/13/executing-queries-using-always-encrypted/

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15

https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/

https://gist.github.com/timvisee/fcda9bbdff88d45cc9061606b4b923ca

https://pgdash.io/blog/finding-unused-indexes-in-postgresql.html

https://ssbipolar.com/2019/10/19/fiores-virtues-of-business-intelligence/

https://forrestmcdaniel.com/

https://sqlsolutionsgroup.com/

https://sqlserverperformance.wordpress.com/2009/12/28/fun-with-dbcc-freeproccache/

https://sqlserverfast.com/epr/generic_information/

https://forrestmcdaniel.com/2021/01/15/giant-in-lists-of-doom/

https://github.com/amachanic/sp_whoisactive

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/tree/main

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/

https://github.com/channeladvisor/qdstoolbox

https://www.hammerdb.com/document.html

https://www.hammerdb.com/about.html

https://learn.microsoft.com/en-us/sql/t-sql/data-types/hierarchyid-data-type-method-reference?view=sql-server-ver16

https://sqlserverfast.com/

https://www.erikdarlingdata.com/of-temporary-tables-and-plan-cache-pollution/

https://www.brentozar.com/archive/2011/09/how-do-you-mask-data/

https://www.richinsql.com/2018/12/how-i-configure-sql-management-studio/

https://learn.microsoft.com/en-us/archive/blogs/psssql/how-it-works-what-is-a-sleeping-awaiting-command-session

http://www.brentozar.com/sql/becoming-a-dba/

https://www.brentozar.com/archive/2023/05/how-to-configure-ola-hallengrens-database-maintenance-scripts-for-backups/

http://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20131202

https://www.mssqltips.com/sqlservertip/4092/how-to-interpret-sql-server-dbcc-showstatistics-output/

http://www.sharepointdiary.com/2016/01/move-sharepoint-databases-to-new-sql-server.html

http://support.microsoft.com/kb/913089

https://www.brentozar.com/archive/2021/06/how-to-patch-sql-server/

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

https://www.brentozar.com/archive/2018/02/how-to-suck-at-database-administration/amp/

http://support.microsoft.com/?id=894435

http://support.microsoft.com/kb/918992/

https://www.reddit.com/r/SQLServer/comments/cpz86m/i_am_an_accidental_dba_and_clueless_i_want_to/

https://www.brentozar.com/archive/2022/06/i-wish-sql-server-warned-about-hard-coded-estimates/

https://www.sqlservercentral.com/blogs/identifying-blocking-via-extended-events

https://www.mssqltips.com/sqlservertip/6456/improve-sql-server-extended-events-systemhealth-session/

https://glennsqlperformance.com/2022/09/22/improving-sql-server-database-backup-performance/

https://www.youtube.com/watch?v=p3SXxclj_vg

https://www.sql.kiwi/2010/08/inside-the-optimiser-row-goals-in-depth.html

https://www.youtube.com/watch?v=85rJ-9vQBbU

https://gist.github.com/kcranston/b309664dc8864e680813f0f2b87c3b5b

https://matthewmcgiffen.com/2023/05/31/introduction-to-sql-server-query-store/

http://sqlblog.com/blogs/jamie_thomson/archive/2013/12/19/schema-compare-or-publish-ssdt.aspx

http://weblogs.sqlteam.com/jeffs/archive/2007/10.aspx

https://github.com/MadeiraData/DynamicFilters

http://www.mssqltips.com/tip.asp?tip=1312

https://www.mssqltips.com/sqlservertip/3003/manual-cleanup-change-data-capture-for-a-sql-server-database/

http://sqlblog.com/blogs/maria_zakourdaev/archive/2013/11/18/grouping-events-into-intervals-using-hedgehog-rolling-style.aspx

https://michaeljswart.com/2022/01/measure-the-effect-of-cost-threshold-for-parallelism/

https://richardswinbank.net/blog/metadata-driven-sql-code-generation

http://microsoft-ssis.blogspot.com/2015/04/reading-sensitive-parameters-in-script.html

http://microsoft-ssis.blogspot.com/2016/12/ssis-naming-conventions.html

https://www.minionware.net/

https://erikdarlingdata.com/monitoring-sql-server-for-query-timeouts-with-extended-events/

http://msdn.microsoft.com/en-US/

https://web.archive.org/web/20220104181634/https://blog.sesse.net/blog/tech/2021-12-05-16-41_leaving_mysql.html

http://nhgreatlakes.com/Blog/TabId/145/ArtMID/601/ArticleID/50/Free-Resources-for-SQL-Server.aspx

https://www.brentozar.com/archive/2018/09/one-hundred-percent-cpu/

https://sqlperformance.com/2017/02/t-sql-queries/seek-leading-wildcard-sql-server

https://sqlserverfast.com/epr/operator-list/

https://www.sqlservercentral.com/articles/optimising-server-side-paging-part-i

https://sqlperformance.com/2018/04/sql-plan/grouping-and-aggregating-part-1

https://www.brentozar.com/archive/2013/06/optimize-for-unknown-sql-server-parameter-sniffing/

http://www.mssqltips.com/sqlservertip/3212/options-to-move-a-big-sql-server-database-to-a-new-drive-with-minimal-downtime/?utm_source=dailynewsletter&utm_medium=email&utm_content=text&utm_campaign=20141024

https://matthewmcgiffen.com/2022/12/12/overview-of-sql-server-encryption-features/

https://www.sommarskog.se/grantperm.html#serverleveluserdbcert

https://www.sommarskog.se/grantperm.html#ownshipchaindb

https://www.sql.kiwi/2011/06/undocumented-query-plans-equality-comparisons.html?m=1

https://github.com/Pansynchro-Technologies/Pansynchro

https://www.madeiradata.com/post/paul-white-and-the-code-that-made-me-wow-trigram-search

https://sqlperformance.com/2020/09/locking/upsert-anti-pattern

https://pollgab.com/room/brento

https://poorsql.com/

https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/pop-rivetts-sql-server-faq-no-4-pop-does-log-shipping/

https://www.crunchydata.com/blog/challenging-postgres-terminology

https://www.simple-talk.com/sql/learn-sql-server/primary-key-primer-for-sql-server/

https://www.mssqltips.com/sqlservertip/1257/processing-data-queues-in-sql-server-with-readpast-and-updlock/

https://straightforwardsql.com/posts/production-code/

https://www.brentozar.com/sql/picking-a-dba-career-path/

https://www.red-gate.com/hub/product-learning/sql-provision/how-to-automatically-provision-sanitized-data-using-sql-clone-data-masker-and-powershell

https://www.sqlskills.com/blogs/erin/query-store-best-practices/

https://www.youtube.com/watch?v=RKnoeIVwSRk

https://www.sqlskills.com/blogs/erin/query-store-settings/

http://msdn.microsoft.com/en-us/library/ms178592.aspx

https://www.mssqltips.com/sqlservertip/7324/python-pandas-read-sql-server-data-dataframe/?utm_content=head

https://medium.com/swlh/recursion-in-sql-explained-graphically-679f6a0f143b

https://sqlperformance.com/2021/09/sql-performance/refreshing-tables-partition-switching

https://www.regexbuddy.com/

https://www.simplethread.com/relational-databases-arent-dinosaurs-theyre-sharks/

https://dbis-uibk.github.io/relax/calc/local/uibk/local/0

https://sqlperformance.com/2020/03/extended-events/removing-default-trace-1

http://msdn.microsoft.com/en-us/library/ms186858.aspx

https://chad-franklin.com/2021/09/19/restoring-a-database-with-cdc-enabled/

https://www.youtube.com/watch?v=O3ItyjN2iPA

https://www.mssqltips.com/sqlservertip/1260/script-to-recompile-all-sql-server-database-objects/

https://learn.microsoft.com/en-us/sql/relational-databases/security/securing-sql-server?view=sql-server-ver16

http://www.sqlnewsgroups.net/sqlserver/t1395-select-servername.aspx

https://www.jeeja.biz/2022/09/07/september-free-community-tools-awareness-month/

https://www.sql.kiwi/2010/10/sequence-tables.html

http://www.sommarskog.se/query-plan-mysteries.html

http://www.softchoice.com/

http://www.brentozar.com/blitz/

https://erikdarlingdata.com/sp_humanevents/

https://www.erikdarlingdata.com/sp_humanevents/

https://erikdarlingdata.com/sp_pressuredetector/

https://erikdarlingdata.com/sp_quickiestore/

https://github.com/spaghettidba/WorkloadTools

http://stackoverflow.com/questions/1139160/when-should-i-use-cross-apply-over-inner-join

https://dba.stackexchange.com/questions/306555/sql-ag-flip-sql-2019-cu14-sql-server-error-interop-cpp-line-125-failed-ass

http://www.devart.com/dbforge/sql/sqlcomplete/

https://www.freecodecamp.org/news/sql-contains-string-sql-regex-example-query/

https://www.youtube.com/watch?v=nc4CMo7VSPo

https://use-the-index-luke.com/

https://owasp.org/www-community/attacks/SQL_Injection

http://www.sqlsentry.com/plan-explorer/sql-server-query-view.asp

http://www.sqlsentry.net/download-trial/landing/complete.asp?ad=20131210-Email-MSSQLTips

https://dba.stackexchange.com/questions/81791/strategies-for-checking-out-records-for-processing

https://dba.stackexchange.com/questions/310937/using-an-extended-event-to-track-a-single-stored-procedure

https://stackoverflow.com/questions/37677204/using-sqlserver-contains-for-partial-words/63535196#63535196

http://blogs.technet.com/b/melville/archive/2006/08/25/sql-server-2005-encryption.aspx

https://www.brentozar.com/archive/2015/05/sql-server-2016-security-roadmap-session-notes-msignite/

https://www.erikdarlingdata.com/sql-server/sql-server-2022-is-going-to-mess-up-your-query-monitoring-scripts/

https://www.simple-talk.com/sql/t-sql-programming/sql-server-apply-basics/?utm_source=simpletalk&utm_medium=email-main&utm_content=APPLYbasics-20100601&utm_campaign=SQL

https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-ver16

https://ola.hallengren.com/

https://www.simple-talk.com/books/sql-books/sql-server-concurrency-locking,-blocking-and-row-versioning/

https://nielsberglund.com/2016/12/31/sql-server-error-handling-gotchas/

https://sqlserverfast.com/epr/

http://stackoverflow.com/questions/7899408/sql-server-find-datediff-between-different-rows-sum

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91919

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

https://blog.sqlauthority.com/2019/09/12/sql-server-management-studio-18-enable-dark-theme/

https://www.brentozar.com/sql/table-partitioning-resources/

https://www.brentozar.com/training/

https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/sql-server-triggers-good-scary/

https://www.mssqltips.com/sqlservertip/6290/sql-server-update-lock-and-updlock-table-hints/

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

https://gist.github.com/mikeblas/098b1e0661de34802afc3181c1abdff7

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/replication/sql-transaction-log-grows

http://www.w3schools.com/sql/sql_where.asp

https://sqlsharp.com/

http://www.e-squillace.com/tech/techdiagrams/SQL2012_CertificationPaths.png

https://www.sqlfacts.com/

http://www.sqlsaturday.com/

https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md

https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md#recommended-trace-flags

http://www.sqlservercentral.com/articles/Stairway+Series/125187/

https://www.sqlservercentral.com/stairways/stairway-to-alwayson

https://statisticsparser.com/about.html

https://statisticsparser.com/

https://sqlchitchat.com/sqldev/tsql/statistics-in-execution-plans/

https://www.brentozar.com/training/statistics-sql-servers-guessing-game/

https://tracyboggiano.com/archive/2022/07/storing-sp_blitzindex-to-a-table-between-reboot/

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql

https://github.com/feaselkl/Analyzing-Business-Data-with-TSQL/blob/master/Scripts/06%20-%20Interlude%20-%20Calendar.sql

https://www.brentozar.com/training/t-sql-level/

https://sqlblog.org/2022/10/11/t-sql-tuesday-155-do-x-to-all-the-dbs

https://eitanblumin.com/2021/05/11/t-sql-tuesday-138-sp_help_revlogin-is-dead-long-live-sp_help_revlogin2/

https://sqlreitse.com/2022/10/11/t-sql-tuesday-155-dynamic-sql/

https://www.youtube.com/watch?v=KRlRkZj0o58

https://www.sql.kiwi/2012/08/temporary-object-caching-explained.html

https://www.sql.kiwi/2012/08/temporary-tables-in-stored-procedures.html

https://www.sommarskog.se/dynamic_sql.html

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd425070(v=sql.100)

https://tracyboggiano.com/archive/2022/06/the-first-30-days-at-a-new-database-job/

https://sqlperformance.com/2022/09/sql-performance/lock-escalation-threshold-part-1

https://sqlperformance.com/2022/10/sql-performance/lock-escalation-threshold-part-2

https://sqlperformance.com/2022/10/sql-performance/lock-escalation-threshold-part-3

https://sqlserverupdates.com/

https://sqlperformance.com/2014/04/t-sql-queries/the-serializable-isolation-level

https://www.red-gate.com/simple-talk/sql/performance/the-seven-sins-against-tsql-performance/

https://sqlserverfast.com/the-sqlserverfast-execution-plan-video-training/the-sqlserverfast-execution-plan-video-training-quick-links/

https://medium.com/@gouncloud/the-tragedy-of-database-schema-df1bcf3a8334

https://michaeljswart.com/2022/09/this-function-generates-unpivot-syntax/

https://learn.microsoft.com/en-us/sql/relational-databases/thread-and-task-architecture-guide?view=sql-server-ver16

https://sqlserverfast.com/epr/top/

https://www.simple-talk.com/sql/t-sql-programming/transact-sql-formatting-standards-(coding-styles)/

https://sqlperformance.com/2017/09/sql-performance/sql-server-trigram-wildcard-search

https://flxsql.com/2021/06/18/troubleshooting-backup-compression-for-encrypted-databases/

https://www.sqlpassion.at/archive/2011/10/25/troubleshooting-threadpool-waits/

https://techcommunity.microsoft.com/t5/sql-server-blog/understanding-sql-server-fast-forward-server-cursors/ba-p/383556

http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server

https://www.mssqltips.com/sqlservertip/5855/update-statistics-for-all-tables-and-databases-in-a-sql-server-instance/

http://msdn.microsoft.com/en-us/library/ms175156.aspx

https://www.sqlservercentral.com/articles/using-apply-to-make-your-queries-dryer

https://tracyboggiano.com/archive/2023/06/using-azure-automation-and-runbooks-to-run-azure-sql-database-maintenance-tasks/

http://www.sqlteam.com/article/using-cross-apply-in-sql-server-2005

https://sqlundercover.com/2023/03/29/using-sql-alerts-to-spot-suspicious-activity-in-sql/

http://www.developer.com/db/article.php/3798361/Using-T-SQL-CROSS-APPLY-and-OUTER-APPLY.htm

https://www.sommarskog.se/arrays-in-sql-2008.html

https://stackoverflow.com/questions/386294/what-is-the-maximum-length-of-a-valid-email-address/574698#574698

http://blogs.msdn.com/b/craigfr/archive/2011/12/21/629615.aspx

https://www.brentozar.com/sql/watch-brent-tune-queries/

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-2017

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver16

https://www.mssqltips.com/sqlservertip/2650/what-maxdop-setting-should-be-used-for-sql-server/

https://sqlsoldier.net/wp/sqlserver/whylogshippingisbetterthandatabasemirroringformigrations

http://blogs.technet.com/b/askpfeplat/archive/2013/03/10/windows-server-2012-hyper-v-best-practices-in-easy-checklist-form.aspx

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/work-with-change-tracking-sql-server?view=sql-server-ver16

Database Design, Normalization, and Diagramming

Code Snippets

Eric Sommarskog

SSRS Slow Startup References:

Playlist stolen from a friend:

Big ol’ mess of links that need sorting