- PVSM.RU - https://www.pvsm.ru -

Список полезных ресурсов по Microsoft SQL Server

Список из 144 бесплатных и платных интернет ресурсов для изучения и работы с Microsoft SQL Server.
Статья в формате markdown на английском языке доступна на Github [1]

Просьба в комментариях поделиться ссылками на другие веб ресурсы по SQL Server. Обязательно их добавлю.

Также, вас возможно заинтересуют другие статьи о Microsoft SQL Server:

Ресурсы SQL Server

SQL Server Ссылки для загрузки учебных баз данных

PowerShell и SQL Server

Форматирование TSQL

Генерация тестовых данных для SQL Server

Бесплатные SQL Server и R книги

SQL Server:

R:

Автор: kast218

Источник [151]


Сайт-источник PVSM.RU: https://www.pvsm.ru

Путь до страницы источника: https://www.pvsm.ru/sql/158725

Ссылки в тексте:

[1] Github: https://github.com/ktaranov/sqlserver-kit

[2] Разнообразие версий Microsoft SQL Server и какая из них последняя?: https://habrahabr.ru/post/281194/

[3] Полный список инструментов и утилит для Microsoft SQL Server — 147 инструментов: https://habrahabr.ru/post/303724/

[4] Полный список флагов трассировки Microsoft SQL Server — 303 флага: https://habrahabr.ru/post/303212/

[5] Полный список расширений для SQL Server Management Studio (SSMS) — 25 расширений: https://habrahabr.ru/post/304036/

[6] SQL Central Blog Scripts: http://www.sqlservercentral.com/Scripts/

[7] SQL Central Blog Articles: http://www.sqlservercentral.com/Articles/

[8] SQL Central Blog Stairways: http://www.sqlservercentral.com/stairway/

[9] MSSQLTips: https://www.mssqltips.com/get-free-sql-server-tips/

[10] BRENT OZAR: https://www.brentozar.com/

[11] Simple-talk Articles: https://www.simple-talk.com/

[12] SQLSentry Blog: http://blogs.sqlsentry.com

[13] Glenn Berry's SQL Server Performance: http://sqlserverperformance.wordpress.com/

[14] Kenneth Fisher SQLStudies Blog: http://sqlstudies.com/

[15] Best SQL Server Perfomance Blog: http://sqlperformance.com/

[16] Weblogs SQLTeam Blogs: http://weblogs.sqlteam.com/

[17] SQLMag: http://sqlmag.com/

[18] SQLShack: http://www.sqlshack.com/

[19] SQLPass: http://www.sqlpass.org/Home.aspx

[20] Vertabelo Blog: http://www.vertabelo.com/blog

[21] Midnightdba Blog: http://www.midnightdba.com/Jen/

[22] Madeiradata Blog: http://www.madeiradata.com/blog/

[23] SQL Server Performance Articles: http://www.sql-server-performance.com/category/articles/

[24] SQL and more with KRUTI Blog: http://sqlandmorewithkruti.blogspot.ru/search/label/SQL%20Server

[25] SQL Authority: http://blog.sqlauthority.com/

[26] TECHNET SQL Server Blog: https://blogs.technet.microsoft.com/dataplatforminsider/

[27] SQL Server Database Engine Blog: https://blogs.msdn.microsoft.com/sqlserverstorageengine/

[28] SQL Server BI Blog: https://sqlserverbiblog.wordpress.com/

[29] Andy Yun SQLBeck Blog: https://sqlbek.wordpress.com/

[30] Curated SQL: http://curatedsql.com/

[31] Blog do Ezequiel: https://blogs.msdn.microsoft.com/blogdoezequiel/

[32] SQLHA Blog: http://sqlha.com/blog/

[33] SQLSecurity Blog: http://www.sqlsecurity.com/home

[34] T-SQL.ru: http://www.t-sql.ru/

[35] Troy Hunt: https://www.troyhunt.com/troys-ultimate-list-of-security-links/

[36] sqlmap: http://sqlmap.org/

[37] Drupal 7 SQL injection flaw of 2014: https://www.drupal.org/PSA-2014-003

[38] Ethical Hacking: SQL Injection: http://www.pluralsight.com/courses/ethical-hacking-sql-injection

[39] seclists.org: http://seclists.org

[40] Exploit Database: https://www.exploit-db.com/

[41] PunkSPIDER: https://www.punkspider.org/

[42] Data Loss DB: http://datalossdb.org/

[43] Information is Beautiful: World’s Biggest Data Breaches: http://www.informationisbeautiful.net/visualizations/worlds-biggest-data-breaches-hacks/

[44] IDERA Resource Center: https://www.idera.com/resourcecentral

[45] MSSQLTips SQL Server Webcasts and Videos: https://www.mssqltips.com/sql-server-webcasts/

[46] SQL Server Videos: http://www.sqlservervideos.com/

[47] TECHNET How do I Videos: https://technet.microsoft.com/en-us/library/dd353197.aspx

[48] Veeam Learn Microsoft SQL Server: http://go.veeam.com/learn-microsoft-sql-server-free-video-tutorial-course.html

[49] MidnightDBA ITBookWorm Video: http://midnightdba.itbookworm.com/

[50] SQL Server Hangouts: https://www.youtube.com/playlist?list=PLvcGRPk71pmRi2UZHKfyruJKu_zHZ0ROc

[51] SQL Server Radio: http://www.sqlserverradio.com/

[52] SQL Data Partners: http://sqldatapartners.com/podcast/

[53] Away from the Keyboard: http://awayfromthekeyboard.com/

[54] RunAs Radio: http://runasradio.com/

[55] People Talking Tech: http://peopletalkingtech.com/

[56] NET Rocks!: http://www.dotnetrocks.com/

[57] SQL Down Under Podcast: http://www.sqldownunder.com/Podcasts

[58] Free sql server video tutorials for beginners: http://csharp-video-tutorials.blogspot.ru/p/free-sql-server-video-tutorials-for.html

[59] Codecademy Learn SQL: https://www.codecademy.com/learn/learn-sql

[60] Codecademy SQL: Table Transformation: https://www.codecademy.com/learn/sql-table-transformation

[61] Codecademy SQL: Analyzing Business Metrics: https://www.codecademy.com/learn/sql-analyzing-business-metrics

[62] MVA SQL Server Courses: https://mva.microsoft.com/product-training/sql-server

[63] Lynda Courses: http://www.lynda.com/SQL-Server-training-tutorials/456-0.html

[64] Veeam Free Courses: https://go.veeam.com/microsoft-sql-series-webinars.html

[65] SQLSkills Trainings: https://www.sqlskills.com/sql-server-training/online-training/

[66] Brent Ozar Team Trainings: https://learnfrom.brentozar.com/

[67] Pluralsight Courses: https://www.pluralsight.com/search?q=sql+server&categories=all

[68] 2014 Backwards Compatibility: http://msdn.microsoft.com/en-us/library/cc707787.aspx

[69] 2012 Backwards Compatibility: http://msdn.microsoft.com/en-us/library/cc707787(v=sql.110).aspx

[70] 2008 R2 Backwards Compatibility: http://msdn.microsoft.com/en-us/library/cc707787(v=sql.105).aspx

[71] 2008 Backwards Compatibility: http://msdn.microsoft.com/en-us/library/cc707787(v=sql.100).aspx

[72] 2005 Backwards Compatibility: http://technet.microsoft.com/en-us/library/ms143532(v=sql.90).aspx

[73] SQL Server Management Studio: https://msdn.microsoft.com/en-us/library/mt238290.aspx

[74] Ola Maintenance Solution: https://ola.hallengren.com/

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

[76] SQL# CLR functions: http://www.sqlsharp.com/

[77] SSIS Performance Benchmarks: http://ssisperformance.com/

[78] Statistic Parser: https://github.com/Jorriss/StatisticsParser

[79] Using Excel to parse Set Statistics IO output: http://vickyharp.com/2012/03/using-excel-to-parse-set-statistics-io-output/

[80] SQL Generator: https://github.com/Jorriss/sqlgenerator

[81] Columnstore Indexes Scripts Library: https://github.com/NikoNeugebauer/CISL

[82] Stackoverflow SQL Server: http://stackoverflow.com/questions/tagged/sql-server

[83] DBA Stackexchange SQL Server: http://dba.stackexchange.com/questions/tagged/sql-server

[84] BIMLScript Learn resource: http://www.bimlscript.com/

[85] SQL Server Connection Strings: http://www.connectionstrings.com/sql-server/

[86] SQL Injection Cheat Sheet: https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/

[87] RSS Most Recent SQL Server KBs: https://support.microsoft.com/en-us/rss?rssid=1044

[88] Stackoverflow SQL Anti Patterns: http://stackoverflow.com/questions/346659/what-are-the-most-common-sql-anti-patterns

[89] SQL Server Latch Classes Library: https://www.sqlskills.com/help/latches/

[90] Azure Speed: http://www.azurespeed.com/

[91] AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3: https://www.microsoft.com/en-us/download/details.aspx?id=49502

[92] Microsoft SQL Server Community Projects & Samples: http://sqlserversamples.codeplex.com/

[93] Adventure Works 2014 Sample Databases: https://msftdbprodsamples.codeplex.com/releases/view/125550

[94] Adventure Works 2012 Sample Databases: http://msftdbprodsamples.codeplex.com/releases/view/55330

[95] Microsoft SQL Server 2008 R2 SR1 Sample Databases: https://sqlserversamples.codeplex.com/releases/view/72278

[96] Thinking Big (Adventure): http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx

[97] WideWorldImporters Sample Database: https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers

[98] Contoso Retail Data Warehose: https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/contoso-data-warehouse

[99] How to Download the Stack Overflow Database via BitTorrent 2016-03: https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/

[100] SQL Server & Windows Documentation Using Windows PowerShell: https://sqlpowerdoc.codeplex.com/

[101] TSQL Code Smells Finder: https://tsqlsmells.codeplex.com/

[102] Stairway to SQL PowerShell: http://www.sqlservercentral.com/stairway/91327/

[103] SQL Server Health Check Script with Powershell: http://www.codeproject.com/Tips/848661/SQL-Server-Health-Check-Script-with-Powershell

[104] Universal SQL Server Installation Scripts: https://github.com/ktaranov/Universal-SQL-Installation-Scripts

[105] Powershell SQL Server Performance Health Check : https://github.com/SpeedySQL/HealthCheck

[106] Performance Analysis of Logs (PAL) Tool: http://pal.codeplex.com/

[107] PSCI — Powershell Continuous Integration: https://github.com/ObjectivityBSS/PSCI

[108] SQLTranscriptase — SQL Server Documentation in Powershell: https://github.com/vijaybandi/SQLTranscriptase

[109] SQL Server PowerShell Extensions (SQLPSX): https://github.com/MikeShepard/SQLPSX

[110] PowerShell dbatools for SQL Server: https://github.com/ctrlbold/dbatools

[111] Create a Monitoring Server for SQL Server with PowerShell: https://www.simple-talk.com/sql/database-administration/create-a-monitoring-server-for-sql-server-with-powershell/

[112] PowerShell SQLPass articles and video: http://powershell.sqlpass.org/default.aspx

[113] PowerShell Blog NetNerds: https://blog.netnerds.net/

[114] QS Config: http://www.sqlhammer.com/qs-config/

[115] Idera 89 Free SQL Server PowerShell Scripts: https://www.idera.com/productssolutions/freetools/sqlpowershellscripts

[116] Performance Analysis of Logs (PAL) Tool: https://pal.codeplex.com/

[117] Powershell SQL Server Library (PSSQLLib): https://github.com/sanderstad/PSSQLLib

[118] http://sqlinform.com/: http://sqlinform.com/

[119] http://www.dpriver.com/pp/sqlformat.htm: http://www.dpriver.com/pp/sqlformat.htm

[120] http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio: http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio

[121] http://www.apexsql.com/sql_tools_refactor.aspx: http://www.apexsql.com/sql_tools_refactor.aspx

[122] http://poorsql.com/: http://poorsql.com/

[123] http://www.architectshack.com/PoorMansTSqlFormatter.ashx: http://www.architectshack.com/PoorMansTSqlFormatter.ashx

[124] http://www.ssmstoolspack.com/: http://www.ssmstoolspack.com/

[125] http://www.devart.com/dbforge/sql/sqlcomplete/: http://www.devart.com/dbforge/sql/sqlcomplete/

[126] http://www.sql-format.com/: http://www.sql-format.com/

[127] https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/: https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/

[128] http://www.yandataellan.com/: http://www.yandataellan.com/

[129] https://github.com/benkeen/generatedata: https://github.com/benkeen/generatedata

[130] https://sourceforge.net/projects/dbmonster/: https://sourceforge.net/projects/dbmonster/

[131] https://sourceforge.net/projects/spawner/: https://sourceforge.net/projects/spawner/

[132] http://databene.org/databene-benerator: http://databene.org/databene-benerator

[133] http://stackoverflow.com/questions/591892/tools-for-generating-mock-data: http://stackoverflow.com/questions/591892/tools-for-generating-mock-data

[134] Avesome Red Gate ebooks: http://www.red-gate.com/community/books/

[135] Microsoft huge collection: https://blogs.msdn.microsoft.com/mssmallbiz/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server/

[136] Microsoft large collection: https://blogs.msdn.microsoft.com/mssmallbiz/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more/

[137] Microsoft MVA Free ebooks: https://mva.microsoft.com/ebooks

[138] OnlineVideoLectures ebooks: http://onlinevideolecture.com/ebooks/?subject=SQL-Server

[139] Brent Ozar ebooks: http://www.brentozar.com/first-aid/free-database-books-pdfs-download/

[140] E-books SQL Server Directory: http://www.e-booksdirectory.com/listing.php?category=569

[141] TOAD SQL Server ebooks: https://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/06/21/huge-collection-of-free-microsoft-sql-server-ebooks

[142] Syncfusion Techportal: http://syncfusion.com/resources/techportal

[143] Modern Storage Strategies for SQL Server: http://www.actualtech.io/gg-modern-storage/

[144] Migrating SQL Server Databases to Azure: https://blogs.msdn.microsoft.com/microsoft_press/2016/05/11/free-ebook-microsoft-azure-essentials-migrating-sql-server-databases-to-azure/

[145] SQL Sentry Free eBooks: http://www.sqlsentry.com/sql-server-books

[146] FreeComputerBooks R EBooks: http://freecomputerbooks.com/langRBooks.html

[147] Effective Graphs with Microsoft R Open: http://blog.revolutionanalytics.com/2016/05/e-book-effective-graphs.html

[148] Little Book of R for Time Series: http://a-little-book-of-r-for-time-series.readthedocs.io/en/latest/index.html

[149] Little Book of R for Biomedical Statistics: http://a-little-book-of-r-for-biomedical-statistics.readthedocs.io/en/latest/index.html

[150] Little Book of R for Multivariate Analysis: http://little-book-of-r-for-multivariate-analysis.readthedocs.io/en/latest/index.html

[151] Источник: https://habrahabr.ru/post/305866/?utm_source=habrahabr&utm_medium=rss&utm_campaign=best