Список из 147 бесплатных и платных интернет ресурсов для изучения и работы с Microsoft SQL Server.
Статья в формате markdown на английском языке доступна на Github
Ресурсы SQL Server
- Блоги
- SQL Central Blog Scripts
- SQL Central Blog Articles
- SQL Central Blog Stairways
- MSSQLTips
- BRENT OZAR scripts, videos and articles
- Simple-talk Articles
- SQLSentry Blog
- Glenn Berry’s SQL Server Performance
- Kenneth Fisher SQLStudies Blog
- Best SQL Server Perfomance Blog
- Weblogs SQLTeam Blogs
- SQLMag
- SQLShack
- SQLPass
- Vertabelo Blog
- Midnightdba Blog
- Madeiradata Blog
- SQL Server Performance Articles
- SQL and more with KRUTI Blog
- SQL Authority
- TECHNET SQL Server Blog
- SQL Server Database Engine Blog
- SQL Server BI Blog
- Andy Yun SQLBeck Blog
- Curated SQL
- Blog do Ezequiel
- SQLHA Blog
- SQLSecurity Blog
- SQL.ru SQL Server (Русский)
- Безопасность (огромное спасибо Troy Hunt)
- SQL injection
- sqlmap – Инструмент для мониторинга SQL injection тестовых атак для работающего сайта
- cheat sheet for sqlmap — Шпаргалка для sqlmap
- Drupal 7 SQL injection flaw of 2014
- Ethical Hacking: SQL Injection – Подробный курс по SQL Injection (Платно)
- Exploit databases and breach coverage
- seclists.org – Подборка уязвимостей с разных ресурсов
- Exploit Database – Солидная подборка уязвимостей баз данных
- PunkSPIDER – Большой список уязвимостей всех типов для веб ресурсов
- Data Loss DB – Хороший список уязвимостей для баз данных
- Information is Beautiful: World’s Biggest Data Breaches – Интересная географическая визуализация произошедших уязвимостей
- SQL injection
- Бесплатные видео
- 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 (Русский)
- Бесплатные подкасты (на английском)
- 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)
- Курсы
- Бесплатные
- Codecademy Learn SQL (Бесплатно)
- Codecademy SQL: Table Transformation (Бесплатно)
- Codecademy SQL: Analyzing Business Metrics (Бесплатно)
- MVA SQL Server Courses (Бесплатно)
- Платные
- Lynda Courses (Платно)
- Veeam Free Courses (Платно)
- SQLSkills Trainings (Платно)
- Brent Ozar Team Trainings (Платно)
- Pluralsight Courses (Платно)
- Бесплатные
- Обратная Совместимость
- Другое
- SQL Server Management Studio
- Лучшее решение для бэкапов и управления индексами 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 (Русский)
SQL Server Ссылки для загрузки учебных баз данных
- AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3
- Microsoft SQL Server Community Projects & Samples
- Adventure Works 2014 Sample Databases
- Adventure Works 2012 Sample Databases
- Microsoft SQL Server 2008 R2 SR1 Sample Databases
- Thinking Big (Adventure) (by Adam Machanic)
- WideWorldImporters Sample Database
- Contoso Retail Data Warehose
- How to Download the Stack Overflow Database via BitTorrent 2016-03 (by Bren Ozar)
PowerShell и 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
- http://sqlinform.com/
- http://www.dpriver.com/pp/sqlformat.htm
- http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio
- http://www.apexsql.com/sql_tools_refactor.aspx
- http://poorsql.com/
- http://www.architectshack.com/PoorMansTSqlFormatter.ashx
- http://www.ssmstoolspack.com/
- http://www.devart.com/dbforge/sql/sqlcomplete/
- http://www.sql-format.com/
Генерация тестовых данных для SQL Server
- https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/
- http://www.yandataellan.com/
- https://github.com/benkeen/generatedata
- https://sourceforge.net/projects/dbmonster/
- https://sourceforge.net/projects/spawner/
- http://databene.org/databene-benerator
- http://stackoverflow.com/questions/591892/tools-for-generating-mock-data
Бесплатные SQL Server и R книги
SQL Server:
- Avesome Red Gate ebooks
- Microsoft huge collection
- Microsoft large collection
- Microsoft MVA Free ebooks
- OnlineVideoLectures ebooks
- Brent Ozar ebooks
- E-books SQL Server Directory
- TOAD SQL Server ebooks
- Syncfusion Techportal
- Modern Storage Strategies for SQL Server
- Migrating SQL Server Databases to Azure
- SQL Sentry Free eBooks
R:
- FreeComputerBooks R EBooks
- Effective Graphs with Microsoft R Open
- Little Book of R for Time Series (by Avril Coghlan)
- Little Book of R for Biomedical Statistics (by Avril Coghlan)
- Little Book of R for Multivariate Analysis (by Avril Coghlan)
