List of useful resources on Microsoft SQL Server

A list of 147 free and paid online resources for studying and working with Microsoft SQL Server.
An article in markdown format in English is available on Github.

Please share in the comments links to other web resources on SQL Server. Be sure to add them.

Also, you might be interested in other articles on Microsoft SQL Server:

SQL Server Resources

Blogs
Security (thank you so much Troy Hunt )
- SQL injection
  - sqlmap - A tool for monitoring SQL injection test attacks for a working site
  - Drupal 7 SQL injection flaw of 2014
  - Ethical Hacking: SQL Injection - Detailed Course on SQL Injection (Paid)
- Exploit databases and breach coverage
  - seclists.org - Selection of vulnerabilities from different resources
  - Exploit Database - A solid collection of database vulnerabilities
  - PunkSPIDER - A large list of vulnerabilities of all types for web resources
  - Data Loss DB - A Good List of Database Vulnerabilities
  - Information is Beautiful: World's Biggest Data Breaches - Interesting geographical visualization of past vulnerabilities.
Free videos
- IDERA Resource Center
- MSSQLTips SQL Server Webcasts and Videos
- SQL Server Videos
- TECHNET How do I Videos
- Veeam Learn Microsoft SQL Server
- MidnightDBA ITBookWorm Video
- SQL Server Hangouts (by Boris Hristov, Cathrine Wilhelmsen)
- Youtube russianVC (Russian)
Free podcasts (in English)
- SQL Server Radio (by Guy Glantser and Matan Yungman)
- SQL Data Partners (by Carlos L Chacon, César Oviedo and Adrian Miranda)
- Away from the Keyboard (by Cecil Phillip and Richie Rump)
- RunAs Radio (by Richard Campbell and Greg Hughes)
- People Talking Tech (by Denny Cherry)
- NET Rocks! (by Richard Campbell and Carl Franklin)
- SQL Down Under Podcast (by Greg Low)
- Free sql server video tutorials for beginners (by PRAGIM Technologies)
Courses
- Free
  - Codecademy Learn SQL (Free)
  - Codecademy SQL: Table Transformation (Free)
  - Codecademy SQL: Analyzing Business Metrics (Free)
  - MVA SQL Server Courses (Free)
- Paid
  - Lynda Courses (Feeded)
  - Veeam Free Courses (Paid)
  - SQLSkills Trainings (Feeded)
  - Brent Ozar Team Trainings (Paid)
  - Pluralsight Courses (Feeded)
Backward compatibility
Other
- SQL Server Management Studio
- The best solution for backups and index management Ola Maintenance Solution
- SQL Server First Responder Kit
- SQL # CLR functions (by Sql Quantum Leap)
- SSIS Performance Benchmarks
- Statistic Parser (by Richie Rump)
- Using Excel to Parse Set Statistics IO output (by Vicky Harp)
- SQL Generator (by Richie Rump)
- Columnstore Indexes Scripts Library (by Niko Neugebauer)
- Stackoverflow SQL Server
- DBA Stackexchange SQL Server
- BIMLScript Learn resource
- SQL Server Connection Strings
- SQL Injection Cheat Sheet (by Ferruh Mavituna)
- RSS Most Recent SQL Server KBs
- Stackoverflow SQL Anti Patterns
- SQL Server Latch Classes Library (by Paul S. Randal)
- Azure Speed (by Blair Chen)
- SQLFiddle
- Practical skills of SQL language (Russian)

SQL Server Download links for training databases

PowerShell and SQL Server

SQL Server & Windows Documentation Using Windows PowerShell (by Kendal Vandyke)
TSQL Code Smells Finder (by Dave Ballantyne)
Stairway to SQL PowerShell (by Ben Miller)
SQL Server Health Check Script with Powershell (by Atul Kapoor)
Universal SQL Server Installation Scripts (by Prakash Heda)
Powershell SQL Server Performance Health Check (by Omid Afzalalghom)
Performance Analysis of Logs (PAL) Tool (by svenhau and mikelag)
PSCI - Powershell Continuous Integration (by Objectivity Bespoke Software Specialists)
SQLTranscriptase - SQL Server Documentation in Powershell (by Vijay Bandi)
SQL Server PowerShell Extensions (SQLPSX) (by Mike Shepard)
PowerShell dbatools for SQL Server (by Chrissy LeMaire)
Create a Monitoring Server for SQL Server with PowerShell (by Laerte Junior)
PowerShell SQLPass articles and video
PowerShell Blog NetNerds
QS Config (by Derik Hammer)
Idera 89 Free SQL Server PowerShell Scripts
Performance Analysis of Logs (PAL) Tool (by Clint Huffman)
Powershell SQL Server Library (PSSQLLib) (by Sander Stad)

TSQL formatting

Generating Test Data for SQL Server

Free SQL Server and R Books

SQL Server:

FreeComputerBooks R EBooks
Effective Graphs with Microsoft R Open
Little Book of R for Time Series (by Avril Coghlan)
Book of R for Biomedical Statistics (by Avril Coghlan)
Book of R for Multivariate Analysis (by Avril Coghlan)

Update 2016-07-21 : Added SQLFiddle and sql-ex.ru
Update 2016-07-19 : Added russianVC , thanks @AlanDenton
Update 2016-07-19 : Fixed Backwards Compatibility links (and added for SQL Server 2016), thanks @Tsyoma

Source: https://habr.com/ru/post/305866/

All Articles