SQL Server Basics (Part 2 : An introduction to using the product - "What is SQL Server? The component parts: cache, databases, files, logs."); Tony Rogerson, SQL Server MVP
|
LiveMeeting Attendee URL |
Click here to join Meeting
|
| Time |
Starts (UK time) at 15:00 , Finishes 15:30 |
|
Cost
|
Free
|
|
Organiser
|
UK SQL Server User Group
|
|
|
| Tags |
SQL Server Basics, Cache, Database Compostion - File Groups, Files, Schemas, Transaction Log, RAID, Recovery Model |
Tony Rogerson, SQL Server MVP will give a series of 30 minute online tutorials delivered through Live Meeting.
Tutorial 2 - Components of SQL Server
The bits you really need to know about in order to manage, maintain and feel comfortable with SQL Server and using it.
I will talk about the following starting from a basic level and delving into a more advanced understanding:
- Cache - how SQL Server uses memory, also touching on NUMA
- What are databases? (File Groups, Files, Objects, Schema's)
- Transaction Log - what it does and why its important even for Simple recovery
- Disk Placement - RAID 10/RAID 5 - how does the log behave?
- Recovery model (Simple, Full, Bulk-Logged)
If I've missed something them email me tonyrogerson@torver.net
If you want to attend please register and you will be emailed the Live Meeting details on the morning of the event