访问官网
GithubSQL Server KIT
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
Table of Contents
- Repo Folders and Files
- SQL Server Web Resources
- BIML Resources and Bloggers
- PowerShell and SQL Server
- TSQL Format Code
- SQL Server Test Data Generation
- Free SQL Server and R ebooks
- Paid SQL Server ebooks
- License
Repo Folders and Files
- SQL Server Data Types
- SQL Server Drivers
- SQL Server Edition
- SQL Server Hints
- SQL Server Name Convention and T-SQL Programming Style
- SQL Server Licensing
- SQL Server People
- SQL Server Trace Flag (Complete list - 620 trace flags)
- SQL Server Version (Complete list - from SQL Server 1.0 to SQL Server 2019)
- Articles
- CLR procedures
- Extended Events
- Known Errors
- SQL Server Sample Databases and Datasets
- Scripts
- Awesome SQL Server Diagnostic Information Queries (by Glenn Alan Berry)
- SQL Managed Instance Diagnostic Information Queries
- Azure SQL Database Diagnostic Information Queries
- SQL Server 2019 Diagnostic Information Queries
- SQL Server 2017 Diagnostic Information Queries
- SQL Server 2016 Diagnostic Information Queries
- SQL Server 2014 Diagnostic Information Queries
- SQL Server 2012 Diagnostic Information Queries
- SQL Server 2008 R2 Diagnostic Information Queries
- SQL Server 2008 Diagnostic Information Queries
- SQL Server 2005 Diagnostic Information Queries
- Table count alternative (by Jes Schultz Borland)
- Foreign Key batch rename (by Wes Henriksen)
- Count character matches
- and many others...
- Awesome SQL Server Diagnostic Information Queries (by Glenn Alan Berry)
- Solution
- dbWarden a free SQL Server Monitoring Package (by Stevie Rounds and Michael Rounds)
- Base line Collector script (by Robert Virag)
- SysJobHistory (by David Wentzel)
- SSMS
- SSMS addins (37 useful free and paid SSMS Addins)
- SSMS Snippets
- SSMS Shortcuts (More than 300 Shortcuts)
- SSMS Tips (Complete guide about hidden gems of SSMS)
- Stored Procedure
- sp_RestoreGene (by Paul Brewer)
- usp_who5 (by Sean Smith)
- usp_String_Search (by Sean Smith)
- usp_BulkUpload
- usp_TableUnpivot
- and many others...
- User Defined Function
- udf_parseJSON
- udf_RenderXMLToString
- udf_RTF2Text
- udf_SplitStringByDelimiter
- udf_Tally
- and many others...
- Utilities (Complete list of 395 SQL Server paid and free Utilities and Tools)
SQL Server Web Resources
- Blogs
- Brent Ozar feedly reading list
- SQL Central Blog Scripts
- SQL Central Blog Articles
- SQL Central Blog Stairways
- DatabaseWeekly
- MSSQLTips
- BRENT OZAR scripts, videos and articles
- Simple-talk Articles
- SentryOne Blog
- Glenn Berry's SQL Server Performance
- Kenneth Fisher SQLStudies Blog
- Best SQL Server Perfomance Blog
- Weblogs SQLTeam Blogs
- SQLShack
- SQL Kiwi by Paul White
- DatabseJournal SQL Server Blog
- 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 (Russian)
- C# Corner SQL Server Articles
- TechTarget Blog
- Toad SQL Server Blog
- SQL-Articles
- DallasDBAs Blog
- UpSearch Blog
- SQL tutorial
- ProData Blog
- DallasDBAs.com Blog
- SQLBI Blog
- RDX Blog
- Codingsight
- Solomon Rutzky's SQL Quantum Leap Blog
- Niels Berglund Blog
- BornSQL Blog
- Kevin Chant Blog
- SQLBlog.org
- Idera SQL Server Blog
- SQL Server Science Blog (by Max Vernon)
- Kohera SQL Server Blog
- SQL Queries Cheat Sheet
- Security (great thanks to Troy Hunt)
- SQL injection
- sqlmap - The tool for mounting SQL injection attacks tests against a running site
- Drupal 7 SQL injection flaw of 2014 – great example of how impactful it still is (patch it within 7 hours or you are owned)
- Ethical Hacking: SQL Injection – If you really want to go deep, here is five and a half hours worth of Pluralsight content
- Exploit databases and breach coverage
- seclists.org – Heaps of exploits consolidated from various bug tracking lists
- Exploit Database – Very comprehensive list of vulnerabilities
- Data Loss DB – Good list of breaches including stats on number of records compromised
- Information is Beautiful: World’s Biggest Data Breaches
- Biggest data breaches in history (by Dave Albaugh)
- Microsoft SQL Server Permissions Posters
- Module Signing Info - Info and resources related to module signing (i.e. Certificates, Asymmetric Keys,
ADD SIGNATURE, etc) in T-SQL and SQLCLR - SQL Server security best practices (by Microsoft)
- SQL injection
- Free Videos
- Youtube Brent Ozar
- Youtube Free SQL Server Statisctics Class
- SQLPASSTV 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)
- Youtube SSMSBoost tutorials
- Youtube Redgate Videos
- User Group.tv (by Shawn Weisfeld)
- SQLPass Virtual Chapters
- Youtube SQLpassion
- SQLBits Video
- Pragmatic Works Free Training Webinars
- Youtube Pragmatic Works Video (by Devin Knight and Manuel Quintana)
- TechEd SQL Server Videos
- Build 2018 conference
- New Stars of Data SQL Server Video
- Youtube Community 1nn0va (by Community 1nn0va)
- Free Database Podcasts
- 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
