Guy Hermann

Visine Project - 1989
	Gets the Red Out...
	Novell
	


SQL Server 2016 Bootcamp

Sarcasm - 
TLAs - Three Letter Acronym 
Questions???


Class Password for all VMs: Pa$$w0rd


Break - 10:10am

AGDLP
 
A - Accounts
G - Groups
DL - Domain Local Groups (Resource Specific)
P - Permissions

  ----XX---|-->
A ---> G --|--> DL <--- P
           |
 Domain    |  Local Resource
           |  SQL Admininstrator


You may need to know:
  SELECT * FROM sys.firewall_rules ORDER by Name;

Lab 1 - 12:15pm

Lunch - 1:00pm

Visit http://extras.gsatrain.com/sql
	to download a .PDF of the 2 courses.

Break - 1:45pm
Lab 2- 2:45pm
Lab 3 - 4:15pm
Break - 4:30pm



https://techsherpas.learnondemand
        .net/User/Login


TechSherpas Wifi Connections:
	abcd123456


SQL Process....

    1) Write to the LOG
    2) Update Memory to reflect the changes (pages)
    3) Sweep memory to persist to the data file
    4) continues

SQL Server Crashes...
    (1) Backup the log file (tail of the log)
    (2) Restore all the backups (data files)
    (3) Restore the most recent logs
    (4) Restore the tail of the log
    (5) Bring it back online


SQL Performance - How many disks does SQL Need?

	What needs to be stored?

	Data Files - .mdf, .ndf
	Log Files - .ldf
	TempDB - 	
	System Databases (OS/App)



	FileType	RAID	Disks?
	------------------------------------
	Apps + System	1	2
	Data Files	5	3
	Log Files	10	4
	TempDB(RAM/SSD)	0	2
				-----
				11 Spindles

How much RAM in SQL Box?

Break - 10:25am

Lab 5 - 11:30am


Lunch + Lab 6 - 1:45pm




(1) Backup the Tail of the Log
(2) Restore the last Full Backup
(3) Differential from Tuesday
(4) Logs from all of Wednesday + 9 and 10 on Thursday
(5) Tail of the Log (WITH RECOVERY)

Lab + Break - 3:30pm



The Great Security Epiphany Event
	August 2002 - PDC

	SD^3 + C

	Secure by Design
	Secure by Default
	Secure in Deployment (Patch Tuesday)
	Communications 

Windows 95
	Windows 98
Windows 98 SE
	Windows ME
Windows XP
	Windows Vista
Windows 7
	Windows 8
	windows 8.1
Windows 10


Windows XP SP2

History of Windows

Windows NT Server - Windows NT Workstation
	Mark Russinovich
Windows Server 2000 - Windows 2000 Professional
	Mark Russinovich
----------------------------

Security Epiphany

----------------------------
Windows Server 2003 - ?????????????????????????
Windows Server 2003 R2 - ??????????????????????
Windows Server 2008 - ?????????????????????????
---------------------------------------
Windows Server 2008 R2 - Windows 7
	Mark Russinovich

	IPv6 Native - IPv4
	Kerberos instead NTLM
	Direct Access - always on VPN (IPv6)

Break - 4:50pm

3 Labs - 8, 9 and 10 - 9:00am

Break - 10:35am

Lab 11 - 11:00am

Lunch + Lab 12 - 1:30pm

Break - 2:45pm

Story - 

Febuary 1997 - 
Ellison NetPC
	<$1,000
	AOL
	NetScape
	Sun
	Wyse - bankrupt

Apple - $6 --> $11 --> $18

Jobs - Next - Pixar

Apple Plan
	Jobs to join Apple Board
	Ellison + 3 Oracle Execs - to join the Board
	Apple is going to fund Ellison's Boat Project
		($171 Million)
	Microsoft Partnership
		Office 98
		IE as the browser
		Connect to MSN
		ActiveX
		$172 Million Cash 
		Drop the Look and Feel Lawsuits
		GUI Crosslicensed (NextStep)
		Microsoft Agreed to buy a few macs
			460,000 macs/quarter 5 years
	Apple saves Microsoft

	Microsoft - Justice Dept (Monopoly)
	
	SEC - Gag order...
	
	SQL Server - 

Break - 3:40pm

Break - 5:10pm	

Resume - 9:00am

Break - 10:30am


Nano Server

Break - 11:35am

Lunch - 12:45pm

Lab 2 - 1:45pm (You need to attach the DVD in the Lab)
	Located on right side of LOD Interface
	In pulldown for DVD Drive on 20765B-MIA-SQL
	Select: SQLServer2016-x64-enu.ISO


Break - 2:00pm

Break - 3:15pm

Lab 3 - 4:00pm

Break - 5:00pm

Lab 4 - 5:45pm

Break - 6:00pm

Questions????


Azure Pass Info...

	http://microsoftazurepass.com

	Here are the Azure passes...
 
		Chris M - W19S4DBF1MCH454UY6
		Chris S - W49AD1CLPV385ADZ9Q
		Danial -  W3UEOM06HELQU0UU85
		David -   WICEOFFW1KGU5B9MTU
		Dominic - WM0A39WAA7EUK78CT6
		Frisco -  WJUGBM6O07LH9UOTRF


Tips for the Exams:
  https://www.microsoft.com/en-us/learning/exam-70-764.aspx
  https://www.mssqltips.com/sqlservertip/4696/exam-material-for-the-microsoft-70764-administering-a-sql-database-infrastructure/

  https://www.microsoft.com/en-us/learning/exam-70-765.aspx
  https://www.mssqltips.com/sqlservertip/4734/microsoft-70765-exam-materials--provisioning-sql-databases/

Lab 5 - 10:30am

Break - 10:45am

Break - 11:45am

Lab 6 - 12:30pm

Lunch - 1:30pm

Break - 2:30pm

Lab 7 - 3:45pm

Break - 4:00pm

Resuming - 9:00am

http://aiotestking.com