«

»

Nov 29

SQL Server All in One Video Turtorials

Share & Comment

SQL Server All in One Video Turtorials

Pluralsight SQL Server All in One Video Turtorials

1. Collecting and Analyzing Trace Data
2. Transact-SQL Basic Data Retrieval
3. Myths and Misconceptions
4. Transact-SQL Basic Data Modification
5. Introduction to Query Tuning

pluralsight-training.net] SQL Server – Collecting and Analyzing Trace Data

1. Introduction / 1. Introduction.wmv 2.8 MB
1. Introduction / 2. Collecting Trace Information.wmv 1.6 MB
1. Introduction / 3. Workload Analysis.wmv 1.2 MB
1. Introduction / 4. Course Structure.wmv 1.6 MB
2. SQL Trace Architecture / 1. Introduction.wmv 1.7 MB
2. SQL Trace Architecture / 10. Summary.wmv 1.4 MB
2. SQL Trace Architecture / 2. What is SQL Trace.wmv 1.3 MB
2. SQL Trace Architecture / 3. What are Events.wmv 1.8 MB
2. SQL Trace Architecture / 4. The Trace Controller.wmv 1.3 MB
2. SQL Trace Architecture / 5. Event Producers.wmv 900.4 KB
2. SQL Trace Architecture / 6. Traces.wmv 780.1 KB
2. SQL Trace Architecture / 7. IO Providers.wmv 1.3 MB
2. SQL Trace Architecture / 8. When to use SQL Trace.wmv 1.5 MB
2. SQL Trace Architecture / 9. Security Considerations.wmv 2.3 MB
3. Using SQL Server Profiler / 1. Introduction.wmv 3.1 MB
3. Using SQL Server Profiler / 10. Trace Templates – TSQL and TSQL_Duration.wmv 1.4 MB
3. Using SQL Server Profiler / 11. Demo – TSQL_Duration Template.wmv 5.4 MB
3. Using SQL Server Profiler / 12. Trace Templates – TSQL_Grouped and TSQL_Locks.wmv 1.6 MB
3. Using SQL Server Profiler / 13. Trace Templates – TSQL_Replay and TSQL_SPs.wmv 3.1 MB
3. Using SQL Server Profiler / 14. Trace Templates – Tuning.wmv 1.3 MB
3. Using SQL Server Profiler / 15. Demo – Trace Templates.wmv 9 MB
3. Using SQL Server Profiler / 16. Saving Captured Data.wmv 2 MB
3. Using SQL Server Profiler / 17. Demo – Saving Captured Data.wmv 17.8 MB
3. Using SQL Server Profiler / 18. Tips for Tracing with Profiler.wmv 3 MB
3. Using SQL Server Profiler / 19. Summary.wmv 3.1 MB
3. Using SQL Server Profiler / 2. What is Profiler.wmv 2.3 MB
3. Using SQL Server Profiler / 3. Creating New Traces.wmv 2.4 MB
3. Using SQL Server Profiler / 4. Demo – Creating a New Trace from Scratch.wmv 6.7 MB
3. Using SQL Server Profiler / 5. Demo – Creating a New Trace from a Template.wmv 5.7 MB
3. Using SQL Server Profiler / 6. Demo – Creating a New Trace from a Trace File.wmv 4.3 MB
3. Using SQL Server Profiler / 7. Filtering Trace Events.wmv 3.7 MB
3. Using SQL Server Profiler / 8. Trace Templates – Introduction.wmv 2.1 MB
3. Using SQL Server Profiler / 9. Trace Templates – SP_Counts and Standard.wmv 1.5 MB
4. Server-Side Trace / 1. Introduction.wmv 3.1 MB
4. Server-Side Trace / 10. Demo – Programatically Creating Traces.wmv 12.5 MB
4. Server-Side Trace / 11. Generating Trace Scripts with Profiler.wmv 2.2 MB
4. Server-Side Trace / 12. Demo – Scripting Trace from Profiler.wmv 6.9 MB
4. Server-Side Trace / 13. Summary.wmv 1.6 MB
4. Server-Side Trace / 2. Performance Comparison.wmv 3.4 MB
4. Server-Side Trace / 3. The SQL Trace DMVs.wmv 1.5 MB
4. Server-Side Trace / 4. Demo – Trace DMVs.wmv 6.2 MB
4. Server-Side Trace / 5. Programmatically Creating Traces.wmv 2.8 MB
4. Server-Side Trace / 6. sp_trace_create.wmv 3.7 MB
4. Server-Side Trace / 7. sp_trace_setevent.wmv 1.5 MB
4. Server-Side Trace / 8. sp_trace_setfilter.wmv 2.6 MB
4. Server-Side Trace / 9. sp_trace_setstatus.wmv 1.8 MB
5. Tracing Scenarios / 1. Introduction.wmv 1.8 MB
5. Tracing Scenarios / 10. Demo – Identifying Deadlock Issues.wmv 9.5 MB
5. Tracing Scenarios / 11. Identifying Recompile Issues.wmv 1.9 MB
5. Tracing Scenarios / 12. Demo – Identifying Recompile Issues.wmv 9.9 MB
5. Tracing Scenarios / 13. Security and Compliance Auditing.wmv 1.8 MB
5. Tracing Scenarios / 14. Demo – Security and Compliance Auditing.wmv 19.1 MB
5. Tracing Scenarios / 15. Capturing a Tuning Workload.wmv 2.5 MB
5. Tracing Scenarios / 16. Demo – Capturing a Tuning Workload.wmv 10.1 MB
5. Tracing Scenarios / 17. Capturing a Replay Workload.wmv 1.7 MB
5. Tracing Scenarios / 18. Demo – Capturing a Replay Workload.wmv 5.5 MB
5. Tracing Scenarios / 19. Common Trace Mistakes.wmv 4.3 MB
5. Tracing Scenarios / 2. Default Trace in SQL Server.wmv 3.4 MB
5. Tracing Scenarios / 20. Summary.wmv 1.7 MB
5. Tracing Scenarios / 3. Events Captured by the Default Trace.wmv 2.2 MB
5. Tracing Scenarios / 4. Common Questions about the Default Trace.wmv 2.9 MB
5. Tracing Scenarios / 5. Scenarios to use the Default Trace.wmv 2.4 MB
5. Tracing Scenarios / 6. Demo – Default Trace.wmv 15.4 MB
5. Tracing Scenarios / 7. Identifying Blocking Issues.wmv 2.8 MB
5. Tracing Scenarios / 8. Demo – Identifying Blocking Issues.wmv 10.3 MB
5. Tracing Scenarios / 9. Identifying Deadlock Issues.wmv 2.3 MB
6. Analzying Trace Data / 1. Introduction.wmv 2.7 MB
6. Analzying Trace Data / 10. Demo – sp_get_query_template.wmv 12.4 MB
6. Analzying Trace Data / 11. Demo – ReadTrace from RML Utilities.wmv 10.3 MB
6. Analzying Trace Data / 12. Demo – ClearTrace.wmv 5.4 MB
6. Analzying Trace Data / 13. Database Tuning Advisor Workload Analysis.wmv 3.4 MB
6. Analzying Trace Data / 14. Demo – DTA Workload Analysis.wmv 10 MB
6. Analzying Trace Data / 15. Summary.wmv 1.5 MB
6. Analzying Trace Data / 2. Analyzing Trace Data with Transact-SQL.wmv 3 MB
6. Analzying Trace Data / 3. Demo – Analyzing Trace Data with Transact-SQL.wmv 6.6 MB
6. Analzying Trace Data / 4. Analyzing Data in Profiler.wmv 3 MB
6. Analzying Trace Data / 5. Demo – Analyzing Data in Profiler.wmv 12.4 MB
6. Analzying Trace Data / 6. Demo – Merging PerfMon Data in Profiler.wmv 10.9 MB
6. Analzying Trace Data / 7. Extracting Trace Events.wmv 2.8 MB
6. Analzying Trace Data / 8. Demo – Extracting Trace Events.wmv 8.8 MB
6. Analzying Trace Data / 9. Normalizing Trace Data.wmv 3 MB
7. Replaying Trace Workloads / 1. Introduction.wmv 2.5 MB
7. Replaying Trace Workloads / 10. Demo – Distributed Replay.wmv 14 MB
7. Replaying Trace Workloads / 11. Replay Tool Limitiations.wmv 3.4 MB
7. Replaying Trace Workloads / 12. Replay Tool Benefits.wmv 3.8 MB
7. Replaying Trace Workloads / 13. Which Tool to Use.wmv 1.9 MB
7. Replaying Trace Workloads / 14. Summary.wmv 1.8 MB
7. Replaying Trace Workloads / 2. Profiler Replay.wmv 3 MB
7. Replaying Trace Workloads / 3. Profiler Replay Requirements.wmv 3.1 MB
7. Replaying Trace Workloads / 4. Demo – Profiler Replay.wmv 10.4 MB
7. Replaying Trace Workloads / 5. RML Utilities OStress Replay.wmv 3.5 MB
7. Replaying Trace Workloads / 6. RML OStress Replay Requirements.wmv 3.3 MB
7. Replaying Trace Workloads / 7. Demo – RML Ostress.wmv 12.4 MB
7. Replaying Trace Workloads / 8. SQL Server 2012 Distributed Replay.wmv 3.5 MB
7. Replaying Trace Workloads / 9. Distributed Replay Requirements.wmv

————————————————————————————————- ———————————-

Directory: [pluralsight-training.net] SQL Server – Transact-SQL Basic Data Retrieval

1. Introduction / 1. Introduction.wmv
1. Introduction / 2. Course Structure.wmv
2. Setting Up a Transact-SQL Learning Environment / 1. Introduction.wmv
2. Setting Up a Transact-SQL Learning Environment / 10. Demo – Installing SSDT.wmv
2. Setting Up a Transact-SQL Learning Environment / 11. AdventureWorks Sample Database.wmv
2. Setting Up a Transact-SQL Learning Environment / 12. Demo – Attaching the AdventureWorks Sample Database.wmv
2. Setting Up a Transact-SQL Learning Environment / 13. Basic Data Retrieval.wmv
2. Setting Up a Transact-SQL Learning Environment / 14. Demo – Execute a Data Retrieval Query in SSMS.wmv
2. Setting Up a Transact-SQL Learning Environment / 15. Demo – Execute a Data Retrieval Query in SSDT.wmv
2. Setting Up a Transact-SQL Learning Environment / 2. SQL Server 2012 Express with Tools.wmv
2. Setting Up a Transact-SQL Learning Environment / 3. SQL Server 2012 Express Abridged Requirements.wmv
2. Setting Up a Transact-SQL Learning Environment / 4. Demo – Checking Hardware and OS Specifications.wmv
2. Setting Up a Transact-SQL Learning Environment / 5. Demo – Checking .NET 3.5 SP1 Prerequisites.wmv
2. Setting Up a Transact-SQL Learning Environment / 6. Demo – Installing SQL Server 2012 Express with Tools.wmv
2. Setting Up a Transact-SQL Learning Environment / 7. SQL Server Management Studio (SSMS).wmv
2. Setting Up a Transact-SQL Learning Environment / 8. Demo – Using SSMS.wmv
2. Setting Up a Transact-SQL Learning Environment / 9. SQL Server Data Tools (SSDT).wmv
3. Writing a Basic SELECT Statement / 1. Introduction.wmv
3. Writing a Basic SELECT Statement / 10. Semicolon Statement Terminator.wmv
3. Writing a Basic SELECT Statement / 11. FROM Clause.wmv
3. Writing a Basic SELECT Statement / 12. Demo – FROM Clause.wmv
3. Writing a Basic SELECT Statement / 13. Table Aliases.wmv
3. Writing a Basic SELECT Statement / 14. Demo – Table Aliases.wmv
3. Writing a Basic SELECT Statement / 15. Expressions, Operators, Predicates.wmv
3. Writing a Basic SELECT Statement / 16. WHERE Clause.wmv
3. Writing a Basic SELECT Statement / 17. Demo – WHERE Clause.wmv
3. Writing a Basic SELECT Statement / 18. DISTINCT.wmv
3. Writing a Basic SELECT Statement / 19. Demo – DISTINCT.wmv
3. Writing a Basic SELECT Statement / 2. Thinking in ‘Sets’.wmv
3. Writing a Basic SELECT Statement / 20. TOP.wmv
3. Writing a Basic SELECT Statement / 21. Demo – TOP.wmv
3. Writing a Basic SELECT Statement / 22. GROUP BY Clause.wmv
3. Writing a Basic SELECT Statement / 23. Demo – GROUP BY Clause.wmv
3. Writing a Basic SELECT Statement / 24. HAVING Clause.wmv
3. Writing a Basic SELECT Statement / 25. Demo – HAVING Clause.wmv
3. Writing a Basic SELECT Statement / 26. ORDER BY Clause.wmv
3. Writing a Basic SELECT Statement / 27. Demo – ORDER BY Clause.wmv
3. Writing a Basic SELECT Statement / 28. Query Paging.wmv
3. Writing a Basic SELECT Statement / 29. Demo – Query Paging.wmv
3. Writing a Basic SELECT Statement / 3. Where to Begin.wmv
3. Writing a Basic SELECT Statement / 30. Binding Order.wmv
3. Writing a Basic SELECT Statement / 31. Demo – Binding Order.wmv
3. Writing a Basic SELECT Statement / 32. Best Practice – Commenting Your Code.wmv
3. Writing a Basic SELECT Statement / 33. Demo – Commenting Your Code.wmv
3. Writing a Basic SELECT Statement / 4. SELECT Clause.wmv
3. Writing a Basic SELECT Statement / 5. Demo – SELECT Clause.wmv
3. Writing a Basic SELECT Statement / 6. Column Aliases.wmv
3. Writing a Basic SELECT Statement / 7. Demo – Column Aliases.wmv
3. Writing a Basic SELECT Statement / 8. Identifiers.wmv
3. Writing a Basic SELECT Statement / 9. Demo – Regular versus Delimited Identifiers.wmv
4. Querying Multiple Data Sources / 1. Introduction.wmv
4. Querying Multiple Data Sources / 10. Demo – Self Joins.wmv
4. Querying Multiple Data Sources / 11. Equi vs. Non-Equi Joins.wmv
4. Querying Multiple Data Sources / 12. Demo – Equi vs. Non-Equi Joins.wmv
4. Querying Multiple Data Sources / 13. Multi-Attribute Joins.wmv
4. Querying Multiple Data Sources / 14. Demo – Multi-Attribute Joins.wmv
4. Querying Multiple Data Sources / 15. Joining More than Two Tables.wmv
4. Querying Multiple Data Sources / 16. Demo – Joining More than Two Tables.wmv
4. Querying Multiple Data Sources / 17. CROSS APPLY Operator.wmv
4. Querying Multiple Data Sources / 18. Demo – CROSS APPLY and OUTER APPLY Operator.wmv
4. Querying Multiple Data Sources / 19. Joining Sub-Queries.wmv
4. Querying Multiple Data Sources / 2. Inner Joins.wmv
4. Querying Multiple Data Sources / 20. Defining the Sub-Query.wmv
4. Querying Multiple Data Sources / 21. Demo – Using Sub-Queries.wmv
4. Querying Multiple Data Sources / 22. UNION Operator.wmv
4. Querying Multiple Data Sources / 23. Demo – UNION Operator.wmv
4. Querying Multiple Data Sources / 24. INTERSECT and EXCEPT.wmv
4. Querying Multiple Data Sources / 25. Demo – INTERSECT and EXCEPT Operators.wmv
4. Querying Multiple Data Sources / 26. Data Types and Joining Tables.wmv
4. Querying Multiple Data Sources / 27. Introduction to Common Table Expressions.wmv
4. Querying Multiple Data Sources / 28. Demo – Introduction to Common Table Expressions.wmv
4. Querying Multiple Data Sources / 3. Demo – Inner Joins.wmv
4. Querying Multiple Data Sources / 4. Outer Joins.wmv
4. Querying Multiple Data Sources / 5. Outer Joins (2).wmv
4. Querying Multiple Data Sources / 6. Demo – Outer Joins.wmv
4. Querying Multiple Data Sources / 7. Cross Joins.wmv
4. Querying Multiple Data Sources / 8. Demo – Cross Joins.wmv
4. Querying Multiple Data Sources / 9. Self Joins.wmv
5. Using Functions / 1. Introduction.wmv
5. Using Functions / 10. Demo – Ranking Functions.wmv
5. Using Functions / 11. Conversion Functions.wmv
5. Using Functions / 12. Demo – Conversion Functions.wmv
5. Using Functions / 13. Validating Data Types.wmv
5. Using Functions / 14. Demo – Validating Data Types.wmv
5. Using Functions / 15. System Time Functions.wmv
5. Using Functions / 16. Demo – System Time Functions.wmv
5. Using Functions / 17. Returning Date and Time Parts.wmv
5. Using Functions / 18. Demo – Returning Date and Time Parts.wmv
5. Using Functions / 19. Constructing Date and Time Values.wmv
5. Using Functions / 2. Aggregate Functions.wmv
5. Using Functions / 20. Demo – Constructing Date and Time Values.wmv
5. Using Functions / 21. Constructing Date and Time Values (2).wmv
5. Using Functions / 22. Demo – Constructing Date and Time Values (2).wmv
5. Using Functions / 23. Calculating Time Differences.wmv
5. Using Functions / 24. Demo – Calculating Time Differences.wmv
5. Using Functions / 25. Modifying Dates.wmv
5. Using Functions / 26. Demo – Modifying Dates.wmv
5. Using Functions / 27. Logical Functions.wmv
5. Using Functions / 28. Demo – Logical Functions.wmv
5. Using Functions / 29. Logical Functions (2).wmv
5. Using Functions / 3. Demo – Aggregate Functions.wmv
5. Using Functions / 30. Demo – Logical Functions (2).wmv
5. Using Functions / 31. Working with NULL.wmv
5. Using Functions / 32. Demo – Working with NULL.wmv
5. Using Functions / 33. String Functions.wmv
5. Using Functions / 34. Demo – String Functions.wmv
5. Using Functions / 35. String Functions (2).wmv
5. Using Functions / 36. Demo – String Functions (2).wmv
5. Using Functions / 37. String Functions (3).wmv
5. Using Functions / 38. Demo – String Functions (3).wmv
5. Using Functions / 39. String Functions (4).wmv
5. Using Functions / 4. Aggregate Functions (2).wmv
5. Using Functions / 40. Demo – String Functions (4).wmv
5. Using Functions / 41. String Functions (5).wmv
5. Using Functions / 42. Demo – String Functions (5).wmv
5. Using Functions / 43. String Functions (6).wmv
5. Using Functions / 44. Demo – String Functions (6).wmv
5. Using Functions / 45. Analytic Functions.wmv
5. Using Functions / 46. Demo – Analytic Functions.wmv
5. Using Functions / 47. Analytic Functions (2).wmv
5. Using Functions / 48. Demo – Analytic Functions (2).wmv
5. Using Functions / 49. Course Summary.wmv
5. Using Functions / 5. Demo – Aggregate Functions (2).wmv
5. Using Functions / 6. Mathematical Functions.wmv
5. Using Functions / 7. Demo – Mathematical Functions.wmv
5. Using Functions / 8. OVER Clause.wmv
5. Using Functions / 9. Ranking Functions.wmv

————————————————————————————————- ————————————

pluralsight: SQL Server – Myths and Misconceptions

1. Introduction / 1. Introduction.wmv 2.4 MB
1. Introduction / 2. Why is Some Information Incorrect.wmv 3.3 MB
1. Introduction / 3. Why Does Incorrect Information Cause Problems.wmv 2.5 MB
1. Introduction / 4. Summary.wmv 2 MB
1. Introduction / 5. Course Structure.wmv 3.2 MB
10. High-Availability Myths and Misconceptions / 1. Introduction.wmv 1.2 MB
10. High-Availability Myths and Misconceptions / 10. Replication is a Valid High-Availability Choice.wmv 2.2 MB
10. High-Availability Myths and Misconceptions / 2. Database Snapshot Size.wmv 3.5 MB
10. High-Availability Myths and Misconceptions / 3. Database Snapshot Efficiency.wmv 2.8 MB
10. High-Availability Myths and Misconceptions / 4. Demo – Database Snapshot Memory Usage.wmv 10.4 MB
10. High-Availability Myths and Misconceptions / 5. Database Mirroring Failure Detection.wmv 3 MB
10. High-Availability Myths and Misconceptions / 6. Database Mirroring Failover Speed.wmv 2 MB
10. High-Availability Myths and Misconceptions / 7. Failover Clustering is the Best High-Availability Technology.wmv 1.7 MB
10. High-Availability Myths and Misconceptions / 8. Multiple Database Mirrors.wmv 947.4 KB
10. High-Availability Myths and Misconceptions / 9. Transactions After a Failover.wmv 1.6 MB
2. Performance Myths and Misconceptions / 1. Introduction.wmv 1.4 MB
2. Performance Myths and Misconceptions / 10. Updating Index Key Columns.wmv 3 MB
2. Performance Myths and Misconceptions / 11. Demo – Updating Index Key Columns.wmv 5.7 MB
2. Performance Myths and Misconceptions / 12. Snapshot Isolation.wmv 3.9 MB
2. Performance Myths and Misconceptions / 13. Checkpoints.wmv 2 MB
2. Performance Myths and Misconceptions / 14. NULL Bitmap.wmv 3.8 MB
2. Performance Myths and Misconceptions / 15. Tempdb Data Files.wmv 4.4 MB
2. Performance Myths and Misconceptions / 16. Solid State Disk Uses.wmv 3.2 MB
2. Performance Myths and Misconceptions / 17. Disk Queue Length.wmv 2 MB
2. Performance Myths and Misconceptions / 18. Page Life Expectancy Threshold.wmv 3.5 MB
2. Performance Myths and Misconceptions / 19. NUMA Effect on Page Life Expectancy.wmv 2 MB
2. Performance Myths and Misconceptions / 2. Controlling Instant File Initialization.wmv 3.5 MB
2. Performance Myths and Misconceptions / 20. CXPACKET Waits.wmv 3.7 MB
2. Performance Myths and Misconceptions / 21. ASYNC_NETWORK_IO Waits.wmv 2.9 MB
2. Performance Myths and Misconceptions / 22. Demo – Wait Statistics.wmv 7.3 MB
2. Performance Myths and Misconceptions / 23. Overriding MAXDOP.wmv 1.9 MB
2. Performance Myths and Misconceptions / 3. Demo – Enabling Instant File Initialization.wmv 7 MB
2. Performance Myths and Misconceptions / 4. Temporary Table Abuse.wmv 3.1 MB
2. Performance Myths and Misconceptions / 5. Demo – Using Temporary Tables.wmv 9.2 MB
2. Performance Myths and Misconceptions / 6. Tempdb Sizing.wmv 2.6 MB
2. Performance Myths and Misconceptions / 7. Data Compression.wmv 3.5 MB
2. Performance Myths and Misconceptions / 8. Data File Shrinking.wmv 3.7 MB
2. Performance Myths and Misconceptions / 9. Demo – Effect of Data File Shrinking.wmv 5 MB
3. Transaction Log Myths and Misconceptions / 1. Introduction.wmv 1.3 MB
3. Transaction Log Myths and Misconceptions / 10. Transaction Log Sizing.wmv 4.8 MB
3. Transaction Log Myths and Misconceptions / 11. Log Record Removal.wmv 2.1 MB
3. Transaction Log Myths and Misconceptions / 12. Log Record Movement.wmv 1.9 MB
3. Transaction Log Myths and Misconceptions / 13. Using BULK_LOGGED to Reduce Log Backup Size.wmv 3.5 MB
3. Transaction Log Myths and Misconceptions / 14. Demo – Log Backup Size Using BULK_LOGGED.wmv 5.3 MB
3. Transaction Log Myths and Misconceptions / 15. Log Backup Size vs. Log Size.wmv 2.6 MB
3. Transaction Log Myths and Misconceptions / 16. Disaster Recovery and BULK_LOGGED.wmv 2.3 MB
3. Transaction Log Myths and Misconceptions / 17. Demo – Disaster Recovery and BULK_LOGGED.wmv 17.5 MB
3. Transaction Log Myths and Misconceptions / 2. Log Truncation and Clearing.wmv 2.5 MB
3. Transaction Log Myths and Misconceptions / 3. Transaction Log Analysis.wmv 2.6 MB
3. Transaction Log Myths and Misconceptions / 4. Demo – Analyzing the Transaction Log.wmv 14.9 MB
3. Transaction Log Myths and Misconceptions / 5. TRUNCATE TABLE Logging.wmv 3.8 MB
3. Transaction Log Myths and Misconceptions / 6. Efficient Logging of Index Operations.wmv 2.7 MB
3. Transaction Log Myths and Misconceptions / 7. Demo – Showing Efficient Logging.wmv 6.4 MB
3. Transaction Log Myths and Misconceptions / 8. Multiple Log Files.wmv 2.4 MB
3. Transaction Log Myths and Misconceptions / 9. Instant File Initialization.wmv 2.6 MB
4. Indexing Myths and Misconceptions / 1. Introduction.wmv 1.3 MB
4. Indexing Myths and Misconceptions / 2. FILLFACTOR Usage.wmv 2.7 MB
4. Indexing Myths and Misconceptions / 3. Clustered Index Rebuilds.wmv 2.7 MB
4. Indexing Myths and Misconceptions / 4. Nonclustered Index Choice.wmv 3.1 MB
4. Indexing Myths and Misconceptions / 5. SSDs and Fragmentation.wmv 3.1 MB
4. Indexing Myths and Misconceptions / 6. Removing Heap Fragmentation.wmv 2.2 MB
4. Indexing Myths and Misconceptions / 7. GUIDs as a Cluster Key Choice.wmv 3 MB
4. Indexing Myths and Misconceptions / 8. Demo – GUID Cluster Keys.wmv 8.7 MB
4. Indexing Myths and Misconceptions / 9. Rebuilding Indexes and Statistics.wmv 1.8 MB
5. Locking Myths and Misconceptions / 1. Introduction.wmv 991.4 KB
5. Locking Myths and Misconceptions / 2. Online Index Operations and Blocking.wmv 3 MB
5. Locking Myths and Misconceptions / 3. Demo – Locks held by Online Index Rebuild.wmv 8.1 MB
5. Locking Myths and Misconceptions / 4. Backups and Blocking.wmv 2.9 MB
5. Locking Myths and Misconceptions / 5. DBCC CHECKDB and Blocking.wmv 2.6 MB
5. Locking Myths and Misconceptions / 6. Lock Escalation.wmv 2.7 MB
5. Locking Myths and Misconceptions / 7. Demo – Lock Escalation.wmv 12.1 MB
5. Locking Myths and Misconceptions / 8. Invalid Blocking and Deadlocks.wmv 2.5 MB
5. Locking Myths and Misconceptions / 9. NOLOCK and READ UNCOMMITTED.wmv 2.2 MB
6. Transact-SQL Myths and Misconceptions / 1. Introduction.wmv 1 MB
6. Transact-SQL Myths and Misconceptions / 2. Nested Transactions.wmv 3.1 MB
6. Transact-SQL Myths and Misconceptions / 3. Demo – Nested Transactions.wmv 5.7 MB
6. Transact-SQL Myths and Misconceptions / 4. DDL Triggers.wmv 2 MB
6. Transact-SQL Myths and Misconceptions / 5. SELECT COUNT(star).wmv 3.3 MB
6. Transact-SQL Myths and Misconceptions / 6. Demo – SELECT COUNT(star).wmv 6 MB
6. Transact-SQL Myths and Misconceptions / 7. Physical Record Location.wmv 3 MB
6. Transact-SQL Myths and Misconceptions / 8. Demo – Physical Record Location.wmv 5.5 MB
6. Transact-SQL Myths and Misconceptions / 9. Running DMVs in 80 Compatibility Mode.wmv 2.7 MB
7. Backup Myths and Misconceptions / 1. Introduction.wmv 1.1 MB
7. Backup Myths and Misconceptions / 10. Replacing Backups with Database Snapshots.wmv 3.4 MB
7. Backup Myths and Misconceptions / 2. Concurrent Data and Log Backups.wmv 1.9 MB
7. Backup Myths and Misconceptions / 3. Data Backups and Log Clearing.wmv 1.6 MB
7. Backup Myths and Misconceptions / 4. Demo – When Does the Log Clear.wmv 11.8 MB
7. Backup Myths and Misconceptions / 5. Backup Completion Guarantees.wmv 3.2 MB
7. Backup Myths and Misconceptions / 6. Differential Backups.wmv 1.6 MB
7. Backup Myths and Misconceptions / 7. Planning a Backup Strategy.wmv 2.2 MB
7. Backup Myths and Misconceptions / 8. Restarting the Log Backup Chain.wmv 1.7 MB
7. Backup Myths and Misconceptions / 9. Demo – Log Backup Chain.wmv 6.2 MB
8. Restore Myths and Misconceptions / 1. Introduction.wmv 1.2 MB
8. Restore Myths and Misconceptions / 2. Mix-and-Match Filegroups.wmv 2.7 MB
8. Restore Myths and Misconceptions / 3. Demo – Filegroup Restores.wmv 7.5 MB
8. Restore Myths and Misconceptions / 4. Using WITH STOPAT for Data Backups.wmv 1.9 MB
8. Restore Myths and Misconceptions / 5. Restoring to Older Versions of SQL Server.wmv 3.1 MB
8. Restore Myths and Misconceptions / 6. Demo – Down-level Restore.wmv 4.9 MB
8. Restore Myths and Misconceptions / 7. Restoring to Non-Enterprise Editions.wmv 3.2 MB
8. Restore Myths and Misconceptions / 8. 32-Bit vs. 64-Bit Compatibility.wmv 2 MB
9. Corruption Myths and Misconceptions / 1. Introduction.wmv 1.3 MB
9. Corruption Myths and Misconceptions / 10. Repair Can Fix Everything.wmv 2.8 MB
9. Corruption Myths and Misconceptions / 11. Repairing System Databases and Tables.wmv 2.8 MB
9. Corruption Myths and Misconceptions / 12. Transaction Rollbacks.wmv 2.5 MB
9. Corruption Myths and Misconceptions / 13. Demo – Transaction Rollbacks.wmv 4.5 MB
9. Corruption Myths and Misconceptions / 2. Detaching and Attaching a SUSPECT Database.wmv 2.8 MB
9. Corruption Myths and Misconceptions / 3. Offloading Consistency Checks.wmv 2.8 MB
9. Corruption Myths and Misconceptions / 4. Causing Corruption Using T-SQL.wmv 1.6 MB
9. Corruption Myths and Misconceptions / 5. Enabling Page Checksums.wmv 2.6 MB
9. Corruption Myths and Misconceptions / 6. DBCC CHECKDB vs. BACKUP … WITH CHECKSUM.wmv 1.7 MB
9. Corruption Myths and Misconceptions / 7. Restarting SQL Server to Fix Corruption.wmv 1.8 MB
9. Corruption Myths and Misconceptions / 8. Disappearing Corruptions.wmv 3.3 MB
9. Corruption Myths and Misconceptions / 9. Corruption-Free Guarantee.wmv

————————————————————————————————-

pluralsight.com] SQL Server – Transact-SQL Basic Data Modification

1. Introduction / 1. Introduction.wmv 2.7 MB
1. Introduction / 2. Course Structure.wmv 1.8 MB
2. Setting Up a Transact-SQL Learning Environment / 1. Module Introduction.wmv 1.3 MB
2. Setting Up a Transact-SQL Learning Environment / 10. Demo – Installing SSDT.wmv 5.8 MB
2. Setting Up a Transact-SQL Learning Environment / 11. AdventureWorks Sample Database.wmv 923.9 KB
2. Setting Up a Transact-SQL Learning Environment / 12. Demo – Attaching the AdventureWorks Sample Database.wmv 10.3 MB
2. Setting Up a Transact-SQL Learning Environment / 13. Basic Data Modification Query in SSMS and SSDT.wmv 1.1 MB
2. Setting Up a Transact-SQL Learning Environment / 14. Demo – Execute a Data Modification Query in SSMS.wmv 8.4 MB
2. Setting Up a Transact-SQL Learning Environment / 15. Demo – Execute a Data Modification Query in SSDT.wmv 8.1 MB
2. Setting Up a Transact-SQL Learning Environment / 2. SQL Server 2012 Express with Tools.wmv 1.5 MB
2. Setting Up a Transact-SQL Learning Environment / 3. SQL Server 2012 Express Abridged Requirements.wmv 2.6 MB
2. Setting Up a Transact-SQL Learning Environment / 4. Demo – Checking Hardware and OS Specifications.wmv 4.4 MB
2. Setting Up a Transact-SQL Learning Environment / 5. Demo – Checking .NET 3.5 SP1 Prerequisites.wmv 3.5 MB
2. Setting Up a Transact-SQL Learning Environment / 6. Demo – Installing SQL Server 2012 Express with Tools.wmv 11.9 MB
2. Setting Up a Transact-SQL Learning Environment / 7. SQL Server Management Studio (SSMS).wmv 1.2 MB
2. Setting Up a Transact-SQL Learning Environment / 8. Demo – Using SSMS.wmv 6.4 MB
2. Setting Up a Transact-SQL Learning Environment / 9. SQL Server Data Tools (SSDT).wmv 2 MB
3. Exploring Table Metadata / 1. Module Introduction.wmv 1.7 MB
3. Exploring Table Metadata / 10. Triggers.wmv 1.1 MB
3. Exploring Table Metadata / 11. Demo – Trigger Catalog View.wmv 5.2 MB
3. Exploring Table Metadata / 12. sys.dm_sql_referencing_entities.wmv 604 KB
3. Exploring Table Metadata / 13. Demo – sys.dm_sql_referencing_entities.wmv 3 MB
3. Exploring Table Metadata / 2. Using sp_help.wmv 994.3 KB
3. Exploring Table Metadata / 3. Identity and RowGuidCol sp_help Information.wmv 1.1 MB
3. Exploring Table Metadata / 4. Constraint sp_help Information.wmv 897.4 KB
3. Exploring Table Metadata / 5. Demo – sp_help.wmv 5.6 MB
3. Exploring Table Metadata / 6. Catalog Views.wmv 1 MB
3. Exploring Table Metadata / 7. Demo – Catalog Views.wmv 11.4 MB
3. Exploring Table Metadata / 8. Catalog Views (2).wmv 1.2 MB
3. Exploring Table Metadata / 9. Demo – Catalog Views (2).wmv 13.2 MB
4. Inserting Data / 1. Module Introduction.wmv 1 MB
4. Inserting Data / 10. Handling Defaults.wmv 918 KB
4. Inserting Data / 11. Demo – Handling Defaults.wmv 7.1 MB
4. Inserting Data / 12. Populating via Derived Table and EXECUTE.wmv 1 MB
4. Inserting Data / 13. Demo – Populating via Derived Table and EXECUTE.wmv 8.3 MB
4. Inserting Data / 2. Demo – Backing up and restoring your sample database.wmv 9.3 MB
4. Inserting Data / 3. Basic Row Insert.wmv 1.2 MB
4. Inserting Data / 4. Demo – Basic Row Insert.wmv 4.8 MB
4. Inserting Data / 5. Column List.wmv 1.5 MB
4. Inserting Data / 6. Demo – Column List Usage.wmv 10.1 MB
4. Inserting Data / 7. Specifying Data Values.wmv 1.5 MB
4. Inserting Data / 8. Transact-SQL Row Constructors.wmv 888.6 KB
4. Inserting Data / 9. Demo – Transact-SQL Row Constructors.wmv 8.9 MB
5. Updating Data / 1. Module Introduction.wmv 891.6 KB
5. Updating Data / 10. Updating with Sub-Query Values.wmv 369.3 KB
5. Updating Data / 11. Demo – Updating with Sub-Query Values.wmv 8.1 MB
5. Updating Data / 12. Updating Views.wmv 1.2 MB
5. Updating Data / 13. Demo – Updating Views.wmv 8.2 MB
5. Updating Data / 2. Simple Update.wmv 1.4 MB
5. Updating Data / 3. Demo – Simple UPDATE.wmv 5.8 MB
5. Updating Data / 4. UPDATE with FROM.wmv 794.7 KB
5. Updating Data / 5. Demo – UPDATE with FROM.wmv 5.1 MB
5. Updating Data / 6. Defaults.wmv 592.3 KB
5. Updating Data / 7. Demo – Handling Defaults.wmv 5.9 MB
5. Updating Data / 8. Compound assignment operators.wmv 683.2 KB
5. Updating Data / 9. Demo – Compound assignment operators.wmv 3.5 MB
6. Deleting Data / 1. Module Introduction.wmv 774.2 KB
6. Deleting Data / 2. Basic DELETE.wmv 830 KB
6. Deleting Data / 3. Demo – Basic DELETE.wmv 8.8 MB
6. Deleting Data / 4. WHERE and FROM clause with DELETE.wmv 648 KB
6. Deleting Data / 5. Demo – WHERE and FROM clauses with DELETE.wmv 4 MB
6. Deleting Data / 6. DELETE vs. TRUNCATE TABLE.wmv 1.2 MB
6. Deleting Data / 7. Demo – DELETE vs. TRUNCATE TABLE.wmv 12.6 MB
7. Beyond the Basics / 1. Module Introduction.wmv 1.4 MB
7. Beyond the Basics / 10. Demo – Referencing Sequence Objects.wmv 9.7 MB
7. Beyond the Basics / 11. OUTPUT Clause.wmv 601.1 KB
7. Beyond the Basics / 12. Demo – OUTPUT Clause.wmv 7.3 MB
7. Beyond the Basics / 13. Consistent Data Type Usage.wmv 1.2 MB
7. Beyond the Basics / 14. Batching Modifications with TOP.wmv 1.2 MB
7. Beyond the Basics / 15. Demo – Batching Modifications with TOP.wmv 8.6 MB
7. Beyond the Basics / 16. Explicit Transactions.wmv 1.3 MB
7. Beyond the Basics / 17. Demo – Using Explicit Transactions.wmv 3.7 MB
7. Beyond the Basics / 18. @@ROWCOUNT and ROWCOUNT_BIG.wmv 739 KB
7. Beyond the Basics / 19. Error Handling.wmv 615.8 KB
7. Beyond the Basics / 2. MERGE.wmv 1.2 MB
7. Beyond the Basics / 20. Demo – Error Handling.wmv 5.8 MB
7. Beyond the Basics / 21. Course Summary.wmv 1.1 MB
7. Beyond the Basics / 3. Demo – MERGE.wmv 18.2 MB
7. Beyond the Basics / 4. Data Modifications with CTEs.wmv 815.3 KB
7. Beyond the Basics / 5. Demo – Data Modifications with CTES.wmv 6.4 MB
7. Beyond the Basics / 6. Updating Large-Value Data Types.wmv 1.7 MB
7. Beyond the Basics / 7. Demo – Updating Large-Value Data Types.wmv 8.8 MB
7. Beyond the Basics / 8. Minimal Logging Operations.wmv 1.6 MB
7. Beyond the Basics / 9. Referencing Sequence Objects.wmv

————————————————————————————————-

Pluralsight – Introduction to Query Tuning

1. Introduction / 1. Introduction.wmv 4.4 MB
1. Introduction / 2. Query Tuning.wmv 4.2 MB
1. Introduction / 3. Demo.wmv 7.6 MB
2. Execution Plan Basics / 1. Introduction.wmv 5.5 MB
2. Execution Plan Basics / 10. Demo – Key Lookup.wmv 5.9 MB
2. Execution Plan Basics / 11. Index Seek vs Index Scan.wmv 2.1 MB
2. Execution Plan Basics / 12. Types of Joins.wmv 2.7 MB
2. Execution Plan Basics / 13. Demo – Types of Joins.wmv 10.9 MB
2. Execution Plan Basics / 14. Summary.wmv 1.7 MB
2. Execution Plan Basics / 2. Demo.wmv 13.5 MB
2. Execution Plan Basics / 3. Various Execution Plan Types.wmv 4 MB
2. Execution Plan Basics / 4. Demo – Execution Plan Types.wmv 13.7 MB
2. Execution Plan Basics / 5. Clustered Index.wmv 6 MB
2. Execution Plan Basics / 6. Demo – Clustered Index.wmv 7.1 MB
2. Execution Plan Basics / 7. Non-clustered Index.wmv 2.4 MB
2. Execution Plan Basics / 8. Demo – Non-clustered Index.wmv 7.1 MB
2. Execution Plan Basics / 9. Key Lookup.wmv 1.1 MB
3. Essential Indexing Techniques / 1. Introduction.wmv 5.7 MB
3. Essential Indexing Techniques / 2. Demo – Basics of Index.wmv 10.5 MB
3. Essential Indexing Techniques / 3. Index Behaviors.wmv 1.4 MB
3. Essential Indexing Techniques / 4. Demo – Included Columns.wmv 12.2 MB
3. Essential Indexing Techniques / 5. Demo – Seek vs Scan vs Lookup.wmv 11.2 MB
3. Essential Indexing Techniques / 6. Demo – WHERE clause and ORDERs of Column.wmv 22.6 MB
3. Essential Indexing Techniques / 7. Demo – Usage of Functions in WHERE clause.wmv 10.6 MB
3. Essential Indexing Techniques / 8. Summary.wmv 3.2 MB
4. Query Design for Performance / 1. Introduction.wmv 2.9 MB
4. Query Design for Performance / 10. Dynamic SQL and Performance.wmv 1.6 MB
4. Query Design for Performance / 11. Demo – Dynamic SQL and Performance.wmv 10.3 MB
4. Query Design for Performance / 12. User Defined Functions, Views and Performance.wmv 2.8 MB
4. Query Design for Performance / 13. Demo – UDFs, Views and Performance.wmv 15.6 MB
4. Query Design for Performance / 14. Summary.wmv 1.1 MB
4. Query Design for Performance / 2. EXISTS vs IN vs JOIN.wmv 4 MB
4. Query Design for Performance / 3. Demo – EXISTS vs IN vs JOIN.wmv 22 MB
4. Query Design for Performance / 4. Common Table Expression (CTE).wmv 1.4 MB
4. Query Design for Performance / 5. Demo – Common Table Expression (CTE).wmv 11.4 MB
4. Query Design for Performance / 6. Order of Table and Query Hints.wmv 1.6 MB
4. Query Design for Performance / 7. Demo – Order of Table and Query Hints.wmv 15.7 MB
4. Query Design for Performance / 8. Plan Guide and Parameter Sniffing.wmv 2.2 MB
4. Query Design for Performance / 9. Demo – Plan Guide and Parameter Sniffing.wmv 16.5 MB
5. Performance Tuning Tools / 1. Introduction.wmv 2.3 MB
5. Performance Tuning Tools / 10. Demo – SQL Server Profiler.wmv 17.1 MB
5. Performance Tuning Tools / 11. Demo – SQL Server Extended Events.wmv 12.1 MB
5. Performance Tuning Tools / 12. SQL Server Wait Stats.wmv 5 MB
5. Performance Tuning Tools / 13. Demo – SQL Server Wait Stats – CXPACKET.wmv 14.3 MB
5. Performance Tuning Tools / 14. Demo – Wait Stats – Identify Offending Query.wmv 6.6 MB
5. Performance Tuning Tools / 15. Demo – Dynamic Management Views (DMV).wmv 15.9 MB
5. Performance Tuning Tools / 16. Demo – SQLDiag.wmv 8 MB
5. Performance Tuning Tools / 17. Summary.wmv 833 KB
5. Performance Tuning Tools / 2. SSMS Performance Dashboard.wmv

.

Premium Account is highly recommended for download

.

http://letitbit.net/download/60412.67a6940f1c75613d364a973931b6/pluralsight.part1.rar.html
http://letitbit.net/download/19289.1d6dc1fca515e3e23de3213f3141/pluralsight.part2.rar.html
http://letitbit.net/download/91928.92a9e72eebb9ec35a2ea388576a9/pluralsight.part3.rar.html
http://letitbit.net/download/91782.975ebe256e23c08f160ddbee3a0c/pluralsight.part4.rar.html

.

http://uploaded.net/file/6p7ipqji/pluralsight.part4.rar
http://uploaded.net/file/rqm1yedb/pluralsight.part1.rar
http://uploaded.net/file/j2zs7nel/pluralsight.part2.rar
http://uploaded.net/file/ojwm9f59/pluralsight.part3.rar

.

Permanent link to this article: http://www.tutorial-ebook.com/sql-server-all-in-one-video-turtorials/

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>