JP Voogt A Data Enthusiasts Ramblings

URL Repository

SQL Server



  • SQL - The Landing Page of SQL Server for the Internet
  • SQL Server - SQL Server Technical Docs
  • Azure SQL - Azure SQL Documentation

SQL First-Aid


URL Notes
Glenn Berry - DMV Notebook A very awesome notebook for use in Azure Data Studio to gather information when on new environments.
Paul Randal - Where Does it Hurt Identify the Top Wait Stats for an SQL Server Instance
Brent Ozar - First Responder Very comprehensive tool set for helping with investigations

Community


Information


** TSQL Beginners Course** - Well outlined Starting point for people interested in learning TSQL

Blogs (alphabetically)


Author URL
Alex Yates http://workingwithdevs.com/
Allen White http://blog.allenmwhite.com/
Andrew B. Collier https://datawookie.netlify.app/blog/
Andy Leonard https://andyleonard.blog/
Andy Yun https://sqlbek.wordpress.com/
Angela Henry https://sqlswimmer.com/
Bob Pusateri https://www.bobpusateri.com/
Brent Ozar https://www.brentozar.com/blog/
Carlos Robles http://dbamastery.com/
Cathrine Wilhelmsen https://www.cathrinewilhelmsen.net/
Chris Yates https://chrisyatessql.com/
Ed Watson https://sqlgator.com/
Erin Stellato https://www.sqlskills.com/blogs/erin/
Gail Shaw https://sqlinthewild.co.za/
Ginger Grant https://www.desertislesql.com/
Glenn Berry https://glennsqlperformance.com/glenns-blog/
Grant Fritchey http://www.scarydba.com/
Hamish Watson https://moosh.co.nz/
Hugo Kornelis https://sqlserverfast.com/blog/
Itzik Ben-Gan https://tsql.lucient.com/
James McGillivray http://jimbabwe.co.za/
Jonathan Kehayias https://www.sqlskills.com/blogs/jonathan/
Kendra Little https://littlekendra.com/
Kimberly L. Tripp https://www.sqlskills.com/blogs/kimberly/
Martin Catherall http://martincatherall.com/
Michael J Swart https://michaeljswart.com/
Michael Johnson https://michaeladrianjohnson.com/
Paul Randal https://www.sqlskills.com/blogs/paul/
Pinal Dave https://blog.sqlauthority.com/all-articles/
Rob Farley http://blogs.lobsterpot.com.au/
Shabnam Watson https://shabnamwatson.wpcomstaging.com/
Thomas LaRock https://thomaslarock.com/blog/
Uwe Ricken https://www.db-berater.de/sql-server-blog/

Azure Synapse



Blogs


Data Science



URL Notes
Data Science Path a Twitter Thread on a recommend path for a new Data Scientist
Top 30 Data Science Courses Articel listing some good Data Science courses
10 Data Science and ML Courses 10 More Courses for new and aspiring Data Scientists
DevOps in Data Science Buck Woody Articles on DevOps for Data Science
How Decision Trees Work Explaining in detail how decision trees work
Model Performance Measures How to measure performance of a ML Model
WoE Weight of Evidence in python
Regression Solvers Explaining the different Regrerssion Resolvers

Python


Other