|
|
01. Introduction.mp4
|
MP4
|
2.8 MB
|
|
|
01. Introduction.vtt
|
VTT
|
3.1 KB
|
|
|
01_Basic_Template.sql
|
SQL
|
3.1 KB
|
|
|
01_Creating_Demo_Environment.sql
|
SQL
|
8.2 KB
|
|
|
01_SQL_Errors.sql
|
SQL
|
1.5 KB
|
|
|
01_Transaction_Modes.sql
|
SQL
|
2.9 KB
|
|
|
02. Anatomy of an Error.mp4
|
MP4
|
5.8 MB
|
|
|
02. Anatomy of an Error.vtt
|
VTT
|
5.1 KB
|
|
|
02. Exploring the ACID Principle.mp4
|
MP4
|
5.8 MB
|
|
|
02. Exploring the ACID Principle.vtt
|
VTT
|
5 KB
|
|
|
02. Why Error Handling Matters.mp4
|
MP4
|
3 MB
|
|
|
02. Why Error Handling Matters.vtt
|
VTT
|
2.1 KB
|
|
|
02_Actionable_Message.sql
|
SQL
|
3.1 KB
|
|
|
02_Isolation_Levels_Read.sql
|
SQL
|
716.8 B
|
|
|
02_Isolation_Levels_Update.sql
|
SQL
|
921.6 B
|
|
|
02_Transferring_Funds.sql
|
SQL
|
2.6 KB
|
|
|
02_Using_RAISERROR.sql
|
SQL
|
1.7 KB
|
|
|
03. Define Best Practices.mp4
|
MP4
|
2.8 MB
|
|
|
03. Define Best Practices.vtt
|
VTT
|
2.6 KB
|
|
|
03. Importance of Severity.mp4
|
MP4
|
6.3 MB
|
|
|
03. Importance of Severity.vtt
|
VTT
|
3.2 KB
|
|
|
03. Transaction Modes.mp4
|
MP4
|
5.5 MB
|
|
|
03. Transaction Modes.vtt
|
VTT
|
4.8 KB
|
|
|
03_Enforce_Business_Logic.sql
|
SQL
|
2 KB
|
|
|
03_Handling_Conversion_Errors.sql
|
SQL
|
1.2 KB
|
|
|
03_Nested_Transactions.sql
|
SQL
|
1.4 KB
|
|
|
03_Using_THROW.sql
|
SQL
|
716.8 B
|
|
|
04. Demo - SQL Server Error Log.mp4
|
MP4
|
11.8 MB
|
|
|
04. Demo - SQL Server Error Log.vtt
|
VTT
|
6.7 KB
|
|
|
04. Demo - Transaction Modes.mp4
|
MP4
|
16.4 MB
|
|
|
04. Demo - Transaction Modes.vtt
|
VTT
|
7.9 KB
|
|
|
04. Plan for Failure.mp4
|
MP4
|
4.3 MB
|
|
|
04. Plan for Failure.vtt
|
VTT
|
2.7 KB
|
|
|
04_Row_Count_Mismatch.sql
|
SQL
|
1.1 KB
|
|
|
04_Save_Points.sql
|
SQL
|
1.2 KB
|
|
|
04_TRY_CATCH.sql
|
SQL
|
4.3 KB
|
|
|
05. Common Isolation Levels.mp4
|
MP4
|
4.2 MB
|
|
|
05. Common Isolation Levels.vtt
|
VTT
|
3.1 KB
|
|
|
05. Exploring RAISERROR.mp4
|
MP4
|
4.4 MB
|
|
|
05. Exploring RAISERROR.vtt
|
VTT
|
3 KB
|
|
|
05. Three Ways to Plan.mp4
|
MP4
|
3.2 MB
|
|
|
05. Three Ways to Plan.vtt
|
VTT
|
2.7 KB
|
|
|
05_Error_Table.sql
|
SQL
|
4.7 KB
|
|
|
05_XACT_ABORT_XACT_STATE.sql
|
SQL
|
5.1 KB
|
|
|
06. Atomic Transactions.mp4
|
MP4
|
5.6 MB
|
|
|
06. Atomic Transactions.vtt
|
VTT
|
4 KB
|
|
|
06. Demo - Users Colliding.mp4
|
MP4
|
12.4 MB
|
|
|
06. Demo - Users Colliding.vtt
|
VTT
|
6.4 KB
|
|
|
06. Demo - Using RAISERROR.mp4
|
MP4
|
10.2 MB
|
|
|
06. Demo - Using RAISERROR.vtt
|
VTT
|
6.2 KB
|
|
|
07. Demo - Setting up Your Environment.mp4
|
MP4
|
15.4 MB
|
|
|
07. Demo - Setting up Your Environment.vtt
|
VTT
|
8.2 KB
|
|
|
07. Exploring THROW.mp4
|
MP4
|
6 MB
|
|
|
07. Exploring THROW.vtt
|
VTT
|
3.4 KB
|
|
|
07. Nested Transactions.mp4
|
MP4
|
3.8 MB
|
|
|
07. Nested Transactions.vtt
|
VTT
|
2.6 KB
|
|
|
08. Demo - Atomic in Action.mp4
|
MP4
|
11.5 MB
|
|
|
08. Demo - Atomic in Action.vtt
|
VTT
|
7.6 KB
|
|
|
08. Demo - Nested Transactions.mp4
|
MP4
|
6.8 MB
|
|
|
08. Demo - Nested Transactions.vtt
|
VTT
|
4.5 KB
|
|
|
08. Demo - Using THROW.mp4
|
MP4
|
4.7 MB
|
|
|
08. Demo - Using THROW.vtt
|
VTT
|
3.6 KB
|
|
|
09. Demo - Savepoints.mp4
|
MP4
|
6 MB
|
|
|
09. Demo - Savepoints.vtt
|
VTT
|
4.4 KB
|
|
|
09. Making Use of NULL.mp4
|
MP4
|
4.7 MB
|
|
|
09. Making Use of NULL.vtt
|
VTT
|
3.3 KB
|
|
|
09. TRY...CATCH.mp4
|
MP4
|
5.3 MB
|
|
|
09. TRY...CATCH.vtt
|
VTT
|
3.6 KB
|
|
|
1. Course Overview.mp4
|
MP4
|
3.6 MB
|
|
|
1. Course Overview.vtt
|
VTT
|
2 KB
|
|
|
1. Introduction.mp4
|
MP4
|
3.1 MB
|
|
|
1. Introduction.vtt
|
VTT
|
2.7 KB
|
|
|
10. Demo - Using NULL with Conversions.mp4
|
MP4
|
6.9 MB
|
|
|
10. Demo - Using NULL with Conversions.vtt
|
VTT
|
3.9 KB
|
|
|
10. Error Handling Syntax.mp4
|
MP4
|
2.7 MB
|
|
|
10. Error Handling Syntax.vtt
|
VTT
|
2.9 KB
|
|
|
10. Summary.mp4
|
MP4
|
1.9 MB
|
|
|
10. Summary.vtt
|
VTT
|
2.2 KB
|
|
|
11. Demo - TRY...CATCH.mp4
|
MP4
|
12.8 MB
|
|
|
11. Demo - TRY...CATCH.vtt
|
VTT
|
4.6 KB
|
|
|
11. Summary.mp4
|
MP4
|
1.7 MB
|
|
|
11. Summary.vtt
|
VTT
|
1.7 KB
|
|
|
12. Demo - XACT_ABORT and XACT_STATE.mp4
|
MP4
|
15.3 MB
|
|
|
12. Demo - XACT_ABORT and XACT_STATE.vtt
|
VTT
|
5.7 KB
|
|
|
13. Summary.mp4
|
MP4
|
2.2 MB
|
|
|
13. Summary.vtt
|
VTT
|
2.4 KB
|
|
|
2. Comparing THROW and RAISERROR.mp4
|
MP4
|
4.2 MB
|
|
|
2. Comparing THROW and RAISERROR.vtt
|
VTT
|
3.9 KB
|
|
|
3. Demo - Error Handling Template.mp4
|
MP4
|
8.6 MB
|
|
|
3. Demo - Error Handling Template.vtt
|
VTT
|
5.8 KB
|
|
|
4. Demo - Actionable Message.mp4
|
MP4
|
11.4 MB
|
|
|
4. Demo - Actionable Message.vtt
|
VTT
|
7.5 KB
|
|
|
5. Demo - Enforce Business Logic.mp4
|
MP4
|
5.6 MB
|
|
|
5. Demo - Enforce Business Logic.vtt
|
VTT
|
3.9 KB
|
|
|
6. Demo - Row Count Mismatch.mp4
|
MP4
|
4.5 MB
|
|
|
6. Demo - Row Count Mismatch.vtt
|
VTT
|
3.5 KB
|
|
|
7. Demo - Error Table and Stored Procedure.mp4
|
MP4
|
11.3 MB
|
|
|
7. Demo - Error Table and Stored Procedure.vtt
|
VTT
|
7.4 KB
|
|
|
8. Action Items.mp4
|
MP4
|
4.6 MB
|
|
|
8. Action Items.vtt
|
VTT
|
3.5 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
examining-error-handling-methods-slides.pdf
|
PDF
|
13.5 MB
|
|
|
exploring-transactions-in-sql-server-slides.pdf
|
PDF
|
33.9 MB
|
|
|
getting-started-with-error-handling-in-t-sql-slides.pdf
|
PDF
|
23.2 MB
|
|
|
handling-errors-in-the-real-world-slides.pdf
|
PDF
|
8.7 MB
|
