MS SQL DB useful pages

SQL pages:

https://sqlperformance.com/
https://www.mssqltips.com/
https://www.sqlskills.com
http://www.sqlservercentral.com/
https://www.erikdarlingdata.com/
https://sqlworldwide.com/
https://www.brentozar.com/
https://blogs.msdn.microsoft.com/sql_server_team/
https://sqlserverfast.com
https://sqlworkbooks.com/
http://littlekendra.com/
http://www.scarydba.com/
https://voiceofthedba.com/
https://blog.sqlauthority.com
https://dbatools.io/
https://learnsqlserverhadr.com
https://tracyboggiano.com/
https://sqlserverfast.com
https://jesspomfret.com/
https://sqldbawithabeard.com/
https://www.kevinrchant.com/
https://sqlquantumleap.com/
https://claudioessilva.eu/
https://inside-sqlserver.com/
https://dallasdbas.com/
https://jesspomfret.com/
https://blog.sqlxdetails.com/collect-performance-data/
https://milossql.wordpress.com
https://shanewelgama.com
https://sqlserverperformace.blogspot.com
https://tsql.tech
https://joeydantoni.com/
https://stevestedman.com/
https://www.nocentino.com/
https://www.sentryone.com/blog
https://www.red-gate.com/simple-talk/

Data Community

https://sqlsaturday.com/
https://passdatacommunitysummit.com/sessions/video-library/
https://datasaturdays.com/
http://aka.ms/sqlworkshops
https://github.com/microsoft/sqlworkshops/
https://microsoft.github.io/sqlworkshops/

Learning:

https://groupby.org/ (free!)
https://www.pass.org/Learn/Recordings/Listing.aspx
https://fundamentals.pass.org/
https://www.pluralsight.com/
https://www.udemy.com/
https://www.edx.org/ (free, but you can pay for certificate)
https://www.packtpub.com/
https://www.coursera.org/
https://mva.microsoft.com/product-training/sql-server
https://openclassrooms.com
https://learning.oreilly.com
https://www.red-gate.com/hub/university/courses/industry-training
https://www.katacoda.com/

https://docs.microsoft.com/en-us/sql/sql-server/
https://docs.microsoft.com/en-us/learn/
https://github.com/microsoft/sqlworkshops-sql2019workshop

 

Hungarian:
https://www.iamberke.com/

Tools:

dbatools
dbachecks
https://www.sentryone.com/plan-explorer  Plan explorer

https://microsoft.github.io/sqlworkshops/  Tiger Team Materials
https://techcommunity.microsoft.com/t5/sql-server/bg-p/SQLServer/label-name/SQLServerTiger Tiger Team BLOGS

sp_helpindex

https://glennsqlperformance.com/resources/  Glenn Berrys diagnostic scripts

https://ola.hallengren.com  Ola Halengrens Maintenance solutions

https://www.scalesql.com/cleartrace/download/

https://www.databasestar.com/software-developer-database-advice/

Docker

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker

Azure Data Factory

https://www.cathrinewilhelmsen.net/series/beginners-guide-azure-data-factory/

Powershell

https://adamtheautomator.com/
http://www.powershellkonyv.hu/

https://github.com/stridergdm
https://www.youtube.com/@dbaduck/videos

VLT

https://www.cathrinewilhelmsen.net/series/table-partitioning-in-sql-server/
https://www.mssqltips.com/sqlservertip/5296/implementation-of-sliding-window-partitioning-in-sql-server-to-purge-data/

 

Youtube channels:

https://www.youtube.com/c/MicrosoftDeveloper/videos
https://www.youtube.com/c/ErikDarlingData/videos
https://www.youtube.com/c/GroupbyOrg/videos
https://www.youtube.com/c/BrentOzarUnlimited/videos
https://www.youtube.com/user/SQLPASSTV/videos
https://www.youtube.com/c/LittleKendra/videos
https://www.youtube.com/channel/UCyXMbRR9nPJD7cW6pndVk9Q/videos
https://www.youtube.com/c/redgate/videos
https://www.youtube.com/c/GrantFritchey/videos
https://www.youtube.com/groupby
https://www.youtube.com/passtv
https://www.youtube.com/channel/UCEHf_UKwG3GMkb9wIVBTeQA
https://youtu.be/VCnh-r_tD3U

 

PassTV
https://www.red-gate.com/hub/university/courses/t-sql/tsql-for-beginners

SQLBITS:

https://sqlbits.com/watch

PassData:
https://passdatacommunitysummit.com/video-library/

Events:

https://www.meetup.com/HUG-MSSQL/
https://www.microsoft.com/en-rs/trainingdays
https://www.meetup.com/pro/azuredatatechgroups/

 

Pluralsight Powershell:

Github:

https://github.com/retracement
ARM templates:
https://github.com/Azure/azure-quickstart-templates/tree/master/quickstarts/microsoft.sql
https://github.com/microsoft/bobsql
http://aka.ms/bobwardms
https://github.com/sqlworldwide/Presentations
https://github.com/dbafromthecold/
https://github.com/MadeiraData/MadeiraToolbox
https://github.com/sqlsunday/presentation-partitioning
https://github.com/dhmacher/sqlserver-kit#paid-ebooks
https://github.com/dbaduck/Presentations/

 

 

Articles to read:

https://techcommunity.microsoft.com/t5/sql-server-support/common-causes-and-troubleshooting-solutions-for-sql-ag-data/ba-p/2963083
https://www.sommarskog.se/query-plan-mysteries.html

Other:
https://www.redhat.com/en/services/training/rh024-red-hat-linux-technical-overview

https://www.red-gate.com/hub/university/courses/industry-training
https://stuart-moore.com/31-days-of-sql-server-backup-and-restores-with-powershell-index/
https://sqlmaestros.com/sql-server-resources/

 

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

https://statisticsparser.com/

Docker playground:
https://labs.play-with-docker.com/