When several users access data at the same time, they’re said to be using the database concurrently. These concurrent users can experience side effects of the interaction, depending on the actions that they’re performing.
- [Instructor] When two or more users…access the same tables at the same time,…they're considered concurrent users.…If the operations that they are performing…are simple reads, then SQL Server…can easily accommodate both users simultaneously.…But once one or more users begin updating…and inserting records into a table…that someone else is reading,…things start to get a little bit more complicated.…SQL Server 2016 provides a number of ways…to manage concurrent data access.…Before we take a look at how to design…a concurrency strategy, it's important to better understand…the problems that can arise so that…we know to deal with them.…
Without any concurrency controls in place,…users might experience lost updates,…uncommitted dependencies, or what's known as a dirty read,…inconsistent analysis, or a nonrepeatable read,…phantom reads, or missing and double reads…caused by row updates.…Let's take a look at what each of these issues looks like…and how to mitigate against them.…A lost update occurs when two or more users…
Author
Adam Wilbert
Released
2/23/2017This course maps to the Microsoft Certified Solutions Expert: Data Platform exam, Designing Database Solutions for SQL Server. If you're planning on taking this exam, this course is a good place to start your test preparation.
- Building a database structure
- Identifying backup and recovery solutions
- Designing a database and table design
- Setting up security
- Creating automated maintenance plans
- Troubleshooting and optimizing
- Maintaining high availability
- Planning a disaster recovery solution
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome54s
-
-
1. Database Structure
-
Physical database design8m 18s
-
Leverage file groups6m 19s
-
Develop an indexing strategy4m 32s
-
2. Backup and Recovery Solutions
-
Database snapshots6m 5s
-
Backup encryption6m 29s
-
Restore tail-log backups5m 41s
-
3. Database Design
-
Create a database schema4m 56s
-
Automation strategies4m 4s
-
-
4. Table Design
-
Create table expressions5m 3s
-
5. Data Management Considerations
-
Create stored procedures4m 22s
-
6. Database Security
-
Object owner permissions4m 5s
-
Encrypting data4m 38s
-
7. Troubleshooting and Optimization
-
Repair fragmented indexes4m 17s
-
Database auditing strategies3m 16s
-
SQL Server utility2m 19s
-
8. Planning High Availability and Disaster Recovery
-
Log shipping2m 42s
-
Conclusion
-
Next steps36s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Locking and concurrency strategy