DBAdmin/inbox/SQL-Server

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 Kit

PowerShell Kit

SQL Stress Test

SQL Scipts

SQL Server Scripts Kendra

SQL Server PowerDoc

sp_whoisactive

dbatools

dbacheck

JupyterNotebooks

SQL Server Maintenace Solution Ola Hallengren

PowerShell tools

Oficjalne repozytoria Microsoft

TigerBox

Dokumentacja do SQL Server

SQL Server Sample Database

Reporting Services Tools

Fora internetowe i inne

!!! **Tiger Tollbox ** !!! - oficjalne repozytorium Microsoft SQL Server na GitHub

Stack Exchange

SQL Server Central

MS SQL Tips

PASS

Data Community

Microsoft SQL Server Versions List

Zasoby GitHub dla SQL Server

SQL Nexus

SqlCeToolbox

SQL Server PowerShell Extensions

Ci ważniejsi od SQL Servera

SQL WorkBooks

Brent Ozar

Kendra Little

Ola Hallegren

Steve Mogran

Pinal Dave SQL Authority

Ben Miller

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

PowerShell for the SQL DBA

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

Indexing on Brent Ozar

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

===========

1. 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/