Paweł Domański
7.7 KiB
SQL-Server
Przydatne linki
Sporo materiału nie umieszczam celowo ponieważ nie chcę całości utrzymywać ale poniższe linki są bardzo przydatne i korzystam z nich dość często
SQL Server - First Responder Kit
SQL Server Maintenace Solution Ola Hallengren
Oficjalne repozytoria Microsoft
Fora internetowe i inne
!!! **Tiger Tollbox ** !!! - oficjalne repozytorium Microsoft SQL Server na GitHub
Microsoft SQL Server Versions List
Zasoby GitHub dla SQL Server
SQL Server PowerShell Extensions
Ci ważniejsi od SQL Servera
Przydatne rozwiązania
Narzędzia do migracji i monitorowania PowerShell
Opis pól dla Dashbordu Always On
First Responder Kit from Brent Ozar
SQL Server Maintenance Solution
MongoDB Podstawowe polecenia administracyjne
Zaawanowane szkolenie Olnine by Brent Ozar
DBA Training Plan 1: Build a Server Inventory
DBA Training Plan 2: Backups (And More Importantly, Restores)
DBA Training Plan 3: Treat Your Servers Like Cattle, Not Like Pets
DBA Training Plan 4: Checking for Corruption
DBA Training Plan 5: Knowing Who Has Access
DBA Training Plan 6: How to Monitor Drive Space
DBA Training Plan 7: How SQL Server Stores Stuff in MDF Files
DBA Training Plan 8: What’s Inside Your Own Databases
DBA Training Plan 9: My 3 Index Guidelines
DBA Training Plan 10: Managing Index Fragmentation
DBA Training Plan 11: The Basics of Executing a Query
DBA Training Plan 12: What Query Plans Are In Cache?
DBA Training Plan 13: Why Do Cached Plans Go Bad?
DBA Training Plan 14: POP QUIZ!
DBA Training Plan 15: What’s Your SQL Server Waiting On?
DBA Training Plan 16: Is It Time to Scale Out?
DBA Training Plan 17: Should You Partition Your Tables?
DBA Training Plan 18: Managing Concurrency
DBA Training Plan 19: The L-Word, Licensing
DBA Training Plan 20: Planning Your Next Server
First Responder Kit i więcej
Welcome to SQL Server medical school!
How to Do a Free SQL Server Health Check
How to Do a Free SQL Server Performance Check
How to Do a SQL Server Architecture Review
Indeksy
Stairway to SQL Server Indexes
Stairway to Columnstore Indexes
Are My SQL Server Indexes Being Used?
Tabele
How to Update SQL Server Statistics for Big Tables
Performance
SQL Server Database Activity Based on Transaction Log Backup Size
Bezpieczeństwo
Stairway to SQL Server Security Level 1: Overview of SQL Server Security
===========
- index - skrypty dotyczące indeksów, statystyk i sprawdzania wydajności
Skrypt który pokazuje brakjące indeksów w bazach https://www.mssqltips.com/sqlservertip/1237/finding-primary-keys-and-missing-primary-keys-in-sql-server/