Learn SQL Server Administration in a Month of Lunches

[Fi8sVrs]

Contents:

1
Before you begin1
1.1Is this book for you?11.2How to use this book21.3Setting up your lab environment3
Choosing a SQL Server edition for your lab3
?
Selecting a version of Windows for your lab4
?
My recommendation for your lab environment5
?
A word about SQL Server versions5
1.4SQL Server documentation51.5Online resources61.6A word on my recommendations61.7Being immediately effective with SQL Server7
2
Server assessment and configuration8
2.1Identifying instances and versions82.2Identifying databases112.3Identifying other server objects13

CONTENTS
x
2.4Inventorying the server configuration142.5Hands-on lab15
3
T-SQL crash course16
3.1SELECT queries16
A basic SELECT query17
?
Returning specific rows from the table19
?
Delimiting string and date values20 Sorting results20
?
Finding T-SQL documentation21
3.2DELETE, UPDATE, and INSERT queries23
DELETE queries23
?
UPDATE queries24 INSERT queries24
3.3Assessing a database’s structure253.4Multitable SELECT queries313.5Hands-on lab33
4
Managing databases34
4.1Configuring database options344.2Detaching and attaching databases364.3Assessing database storage384.4Identifying potential performance concerns in storage38
Problems with file layout38
?
Problems with file size40 Filegroups41
4.5System databases414.6An overview of storage hardware424.7Hands-on lab43
5
Backup and recovery44
5.1The transaction log445.2How backups work47
Making a full database backup48
?
Making a differential database backup48
?
Making a transaction log backup48
5.3How restoration works49
Preparing for recovery50
?
Starting the recovery50
5.4Model backup and recovery scenarios525.5Special procedures for system databases54

CONTENTS
xi
5.6Backup and recovery using T-SQL or PowerShell545.7Hands-on lab55
6
Authentication: who are you?56
6.1Understanding logins56
Windows Authentication57
?
Mixed Mode Authentication58
6.2Understanding database users596.3How the real world often does authentication626.4Understanding application roles636.5Hands-on lab64
7
Authorization: what are you allowed to do?65
7.1Understanding SQL Server permissions65
Securing database objects66
?
Revoking permissions67 Column-level permissions68
?
The many sources of permissions68
7.2Using server roles687.3Using database roles697.4Schemas and owners70
Owners70
?
Schemas70
7.5Permission chains717.6How the real world often does authorization737.7Hands-on lab74
8
Accounting: what did you do?75
8.1Triggers758.2SQL Server Profiler768.3Event logs and C2 auditing768.4SQL Audit76
SQL Audit architecture76
?
Creating an audit77 Using SQL Audit for security auditing79 Using SQL Audit for troubleshooting80
8.5Hands-on lab81
9
Analyzing indexes82
9.1Index basics829.2Heaps83

Download:

http://www.scribd.com/doc/228142928/Learn-SQL-Server-Administration-in-a-Month-of-Lunches

Edited June 5, 2014 by Fi8sVrs