@@ -42,8 +42,8 @@ https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
4242 - Simple
4343 - [dBase ;-)](https://en.wikipedia.org/wiki/DBase)
4444 - Foxbase ;-)
45- - [FoxPro;-)](https://en.wikipedia.org/wiki/FoxPro)
46- - [Visual FoxPro;-)](https://msdn.microsoft.com/en-us/vfoxpro/bb190225.aspx)
45+ - [FoxPro ;-)](https://en.wikipedia.org/wiki/FoxPro)
46+ - [Visual FoxPro ;-)](https://msdn.microsoft.com/en-us/vfoxpro/bb190225.aspx)
4747 - [Access](https://products.office.com/en-us/access)
4848 - [Sqlite](https://www.sqlite.org/)
4949 - Basics
@@ -107,7 +107,7 @@ https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
107107 - TCP/IP
108108 - Named pipes
109109 - Shared memory
110- - Virtual Interface Adapter (VIA)
110+ - Virtual Interface Adapter (VIA, discontinued from 2012 )
111111 - Web Services
112112 - Core Concepts
113113 - Instance
@@ -160,9 +160,21 @@ https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
160160 - Core Objects
161161 - Database
162162 - Recovery Models
163- - Simple
164- - Full
165- - Bulk logged
163+ - Purpose
164+ - Backup transaction log
165+ - Affect backup types
166+ - Affect replication types
167+ - Models
168+ - Simple
169+ - Not point-in-time recovery
170+ - Minimum space
171+ - Full (default)
172+ - Point-in-time recovery
173+ - Large space
174+ - Bulk logged
175+ - Point-in-time recovery
176+ - No bulk operation logged
177+ - Save space
166178 - Compatibility Levels
167179 - Version Number
168180 - Effectively SQL Server version number
@@ -218,6 +230,7 @@ https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
218230 - Drop
219231 - Column
220232 - columnstore
233+ - Suitable for Data warehouse
221234 - NTFS FileStream
222235 - Schema
223236 - Trigger
@@ -339,7 +352,7 @@ https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
339352 - Transactional
340353 - Merge
341354 - Snapshot
342- - Mirroring
355+ - Mirroring (deprecated from 2012)
343356 - Core
344357 - Principal
345358 - Witness
@@ -421,6 +434,7 @@ https://rawgit.com/unruledboy/DatabaseStack/master/ux/DatabaseStack.htm
421434 - Extract-Transform-Load (ETL)
422435 - SQL Server Reporting Service (SSRS)
423436 - SQL Server Analysis Service (SSAS)
437+ - OLAP
424438 - Troubleshoot
425439 - Dedicated Administrator Connection (DAC)
426440 - ADMIN:INSTANCE
0 commit comments