SQL Server School (17 Hours): Sql Server Connection, Sql Server Stored Procedure, Sql Server Profiler, Trusted Sql Server, Sql Query Analyzer, and More
These 17 hours of video tutorials from the SQL Server School cover the following topics: sql server connection, sql server stored procedure, sql server profiler, trusted sql server, sql query analyzer. Brian Knight and his cohorts give very a concise explanation of many fundamental Sql Server concepts. Very practical information. Each video is just a couple of minutes long.
photo credit: pvera
SQL Server School
| Num | Series | Title | Date | Presenter | Min |
|---|---|---|---|---|---|
| 1 | Administration(2) | Detaching Databases | 8/14/2008 | Brian Knight | 2 |
| 2 | Administration(2) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 3 | Adventure Works (1) | Installing Sample 2008 Databases | 2/3/2009 | Brian Knight | 4 |
| 4 | Aggregate Transform (1) | Using the Aggregate Transform | 12/4/2008 | Brian Knight | 3 |
| 5 | Aggregates(1) | Summarizing Data with Aggregate Queries | 8/28/2008 | Kathi Kellenberger | 12 |
| 6 | Analysis Services(6) | Viewing Analysis Services Data in Excel 2007 | 8/7/2008 | Brian Knight | 6 |
| 7 | Analysis Services(6) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 8 | Analysis Services(6) | Writing a Basic MDX Query Pt.2 | 12/11/2008 | Brian Knight | 8 |
| 9 | Analysis Services(6) | Creating Mining Structure | 2/17/2009 | Brian Knight | 6 |
| 10 | Analysis Services(6) | Running A Basic DMX Query | 2/9/2009 | Brian Knight | 6 |
| 11 | Analysis Services(6) | Formatting SSAS Measures | 3/5/2009 | Brian Knight | 5 |
| 12 | Auditing(2) | Basic Auditing | 3/10/2009 | Andy Warren | 4 |
| 13 | Auditing(2) | Removing Audit History | 3/12/2009 | Andy Warren | 2 |
| 14 | Backup / Restore(3) | Detaching Databases | 8/14/2008 | Brian Knight | 2 |
| 15 | Backup / Restore(3) | Creating a Full Backup in SSMS | 9/18/2008 | Brian Knight | 3 |
| 16 | Backup / Restore(3) | Restoring a Full Database in SSMS | 10/28/2008 | Brian Knight | 3 |
| 17 | Backup and Recovery(2) | Creating Mirrored Backups | 12/2/2008 | Andy Warren | 2 |
| 18 | Backup and Recovery(2) | Creating Striped Backups | 3/19/2009 | Andy Warren | 2 |
| 19 | Checksum(1) | Using the CheckSum Function | 12/18/2008 | Brian Knight | 3 |
| 20 | Configuration(1) | SQL Server Options to Avoid | 1/6/2009 | Brian Knight | 6 |
| 21 | Data Corruption(1) | Surviving Database Corruption – From Detection to Resolution | 11/7/2008 | Paul Randal | 80 |
| 22 | Data Mining(9) | Creating Lift Charts | 8/21/2008 | Brian Knight | 7 |
| 23 | Data Mining(9) | Creating a Data Mining Reporting Services Report | 9/4/2008 | Brian Knight | 5 |
| 24 | Data Mining(9) | Mining Model Viewers | 2/5/2009 | Brian Knight | 8 |
| 25 | Data Mining(9) | Data Mining in Excel 2007 Pt.1 | 2/10/2009 | Brian Knight | 8 |
| 26 | Data Mining(9) | Data Mining in Excel 2007 Pt.2 | 2/12/2009 | Brian Knight | 7 |
| 27 | Data Mining(9) | Creating Mining Structure | 2/17/2009 | Brian Knight | 6 |
| 28 | Data Mining(9) | Installing & Congfiguring DM Add-in for Excel | 2/19/2009 | Brian Knight | 6 |
| 29 | Data Mining(9) | Running Singleton Queries Against a DMX Data Mining Model | 2/24/2009 | Brian Knight | 4 |
| 30 | Data Mining(9) | Running A Basic DMX Query | 2/26/2009 | Brian Knight | 6 |
| 31 | Data Profiling Task(1) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 32 | Data Types(1) | Using the Timestamp Data Type | 1/29/2009 | Brian Knight | 3 |
| 33 | Database Diagram(1) | Creating a Database Diagram in SSMS | 10/2/2008 | Brian Knight | 6 |
| 34 | Database Mail(1) | Setting Up Database Mail | 4/28/2009 | Andy Warren | 2 |
| 35 | DBCC(1) | Surviving Database Corruption – From Detection to Resolution | 11/7/2008 | Paul Randal | 80 |
| 36 | Excel(3) | Data Mining in Excel 2007 Pt.1 | 2/10/2009 | Brian Knight | 8 |
| 37 | Excel(3) | Data Mining in Excel 2007 Pt.2 | 2/12/2009 | Brian Knight | 7 |
| 38 | Excel(3) | Installing & Congfiguring DM Add-in for Excel | 2/19/2009 | Brian Knight | 6 |
| 39 | Indexing(1) | Disabling Indexes | 1/13/2009 | Andy Warren | 4 |
| 40 | Integration Services(14) | Adding a timestamp to files in SSIS | 9/16/2008 | Brian Knight | 6 |
| 41 | Integration Services(14) | Execute an SSIS Package in SSMS | 9/23/2008 | Brian Knight | 7 |
| 42 | Integration Services(14) | Making SSIS Connections Dynamic | 9/25/2008 | Brian Knight | 3 |
| 43 | Integration Services(14) | Scheduling SSIS Packages | 10/9/2008 | Brian Knight | 4 |
| 44 | Integration Services(14) | Row Count Transform | 10/16/2008 | Brian Knight | 4 |
| 45 | Integration Services(14) | Parameterizing an Execute SQL Task | 10/23/2008 | Brian Knight | 5 |
| 46 | Integration Services(14) | SSIS Configuration Files | 10/30/2008 | Brian Knight | 4 |
| 47 | Integration Services(14) | Using Break Points in SSIS | 11/4/2008 | Brian Knight | 4 |
| 48 | Integration Services(14) | Using the File System Task | 11/13/2008 | Brian Knight | 4 |
| 49 | Integration Services(14) | Using Script Component as a Transformation | 11/20/2008 | Brian Knight | 5 |
| 50 | Integration Services(14) | Using the Sort Transform | 11/25/2008 | Brian Knight | 3 |
| 51 | Integration Services(14) | Using SSIS Precedence Constraints | 11/27/2008 | Brian Knight | 6 |
| 52 | Integration Services(14) | Using the Aggregate Transform | 12/4/2008 | Brian Knight | 3 |
| 53 | Integration Services(14) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 54 | Intersect(1) | Using Intersect | 3/17/2009 | Andy Warren | 2 |
| 55 | Jobs(1) | Creating One-Time Jobs | 12/23/2008 | Andy Warren | 2 |
| 56 | Linked Server(1) | Creating a Linked Server | 4/7/2009 | Andy Warren | 5 |
| 57 | Main(1) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 58 | Maintenance Plans(1) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 59 | Management Studio(6) | Scripting Table Management | 8/26/2008 | Brian Knight | 5 |
| 60 | Management Studio(6) | Execute an SSIS Package in SSMS | 9/23/2008 | Brian Knight | 7 |
| 61 | Management Studio(6) | Creating a Database Diagram in SSMS | 10/2/2008 | Brian Knight | 6 |
| 62 | Management Studio(6) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 63 | Management Studio(6) | SQL Server Management Studio for Beginners | 1/1/2009 | Brian Knight | 6 |
| 64 | Management Studio(6) | Creating and Modifying Tables in SSMS | 3/3/2009 | Brian Knight | 6 |
| 65 | MDX(2) | Writing a Basic MDX Query Pt.1 | 12/9/2008 | Brian Knight | 5 |
| 66 | MDX(2) | Writing a Basic MDX Query Pt.2 | 12/11/2008 | Brian Knight | 8 |
| 67 | Measures(1) | Formatting SSAS Measures | 3/5/2009 | Brian Knight | 5 |
| 68 | Moving Databases(1) | Moving TempDB | 12/30/2008 | Brian Knight | 2 |
| 69 | OpenDataSource(1) | Using OpenDataSource | 4/9/2009 | Andy Warren | 4 |
| 70 | OpenRowSet | Using OpenRowSet | 3/31/2009 | Andy Warren | 2 |
| 71 | PBM(1) | Creating a Basic Policy in SSMS | 11/18/2009 | Brian Knight | 5 |
| 72 | Policy Based Management(1) | Creating a Basic Policy in SSMS | 11/18/2009 | Brian Knight | 5 |
| 73 | Presedence Constraints(1) | Using SSIS Precedence Constraints | 11/27/2008 | Brian Knight | 6 |
| 74 | Profiler(9) | Using Profiler | 9/2/2008 | Brian Knight | 9 |
| 75 | Profiler(9) | Mastering SQL Server Profiler | 4/30/2009 | Brad McGehee | 69 |
| 76 | Profiler(9) | Introduction | 4/30/2009 | Brad McGehee | 7 |
| 77 | Profiler(9) | Part 1: Introduction to Profiler Concepts | 5/5/2009 | Brad McGehee | 8 |
| 78 | Profiler(9) | Part 2: Profiler Architecture | 5/7/2009 | Brad McGehee | 5 |
| 79 | Profiler(9) | Part 3: Getting Started | 5/12/2009 | Brad McGehee | 11 |
| 80 | Profiler(9) | Part 4: Profiler Events | 5/14/2009 | Brad McGehee | 12 |
| 81 | Profiler(9) | Part 5: Data Columns | 5/19/2009 | Brad McGehee | 10 |
| 82 | Profiler(9) | Part 6: Creating Custom Traces | 5/21/2009 | Brad McGehee | 16 |
| 83 | Publication(1) | Creating a Publication | 4/23/2009 | Andy Warren | 3 |
| 84 | Publisher(1) | Setting Up a Publisher | 4/16/2009 | Andy Warren | 3 |
| 85 | RANDOM(1) | Generating Random Results | 1/15/2009 | Andy Warren | 1 |
| 86 | Replication(3) | Setting Up a Publisher | 4/16/2009 | Andy Warren | 3 |
| 87 | Replication(3) | Creating a Subscription | 4/21/2009 | Andy Warren | 3 |
| 88 | Replication(3) | Creating a Publication | 4/23/2009 | Andy Warren | 3 |
| 89 | Reporting Services(6) | Creating a Data Mining Reporting Services Report | 9/4/2008 | Brian Knight | 5 |
| 90 | Reporting Services(6) | Creating a Matrix Report | 9/9/2008 | Brian Knight | 4 |
| 91 | Reporting Services(6) | Creating a Tabular Report | 9/11/2008 | Brian Knight | 4 |
| 92 | Reporting Services(6) | Parameterizing SSRS Reports | 10/7/2008 | Brian Knight | 2 |
| 93 | Reporting Services(6) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 94 | Reporting Services(6) | Multi Select Parameters in SSRS | 10/21/2008 | Brian Knight | 2 |
| 95 | Sample Databases(1) | Installing Sample 2008 Databases | 2/3/2009 | Brian Knight | 4 |
| 96 | Scheduling(1) | Creating One-Time Jobs | 12/23/2008 | Andy Warren | 2 |
| 97 | Script Component(1) | Using Script Component as a Transformation | 11/20/2009 | Brian Knight | 5 |
| 98 | Sort Transformation(1) | Using the Sort Transform | 11/25/2008 | Brian Knight | 3 |
| 99 | sp_MSForEachDB(1) | Using SP_MSForEachDB and SP_MSForEachTable | 3/26/2009 | Andy Warren | 2 |
| 100 | SQL Agent(1) | Creating One-Time Jobs | 12/23/2008 | Andy Warren | 2 |
| 101 | SQL Server 2008(4) | Installing SQL Server 2008 | 8/5/2008 | Brad McGehee | 7 |
| 102 | SQL Server 2008(4) | Creating a Basic Policy in SSMS | 11/18/2008 | Brian Knight | 5 |
| 103 | SQL Server 2008(4) | Post SQL Server 2008 Upgrade | 1/8/2009 | Brian Knight | 5 |
| 104 | SQL Server 2008(4) | Installing Sample 2008 Databases | 2/3/2009 | Brian Knight | 4 |
| 105 | SQL Skills(1) | Surviving Database Corruption – From Detection to Resolution | 11/7/2008 | Paul Randal | 80 |
| 106 | SASS(3) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 107 | SASS(3) | Running A Basic DMX Query | 2/26/2009 | Brian Knight | 6 |
| 108 | SASS(3) | Formatting SSAS Measures | 3/5/2009 | Brian Knight | 5 |
| 109 | SSIS(13) | Execute an SSIS Package in SSMS | 9/23/2008 | Brian Knight | 7 |
| 110 | SSIS(13) | Making SSIS Connections Dynamic | 9/25/2008 | Brian Knight | 3 |
| 111 | SSIS(13) | Scheduling SSIS Packages | 10/9/2008 | Brian Knight | 4 |
| 112 | SSIS(13) | Row Count Transform | 10/16/2008 | Brian Knight | 4 |
| 113 | SSIS(13) | Parameterizing an Execute SQL Task | 10/23/2008 | Brian Knight | 5 |
| 114 | SSIS(13) | SSIS Configuration Files | 10/30/2008 | Brian Knight | 4 |
| 115 | SSIS(13) | Using Break Points in SSIS | 11/4/2008 | Brian Knight | 4 |
| 116 | SSIS(13) | Using the File System Task | 11/13/2008 | Brian Knight | 4 |
| 117 | SSIS(13) | Using Script Component as a Transformation | 11/20/2008 | Brian Knight | 5 |
| 118 | SSIS(13) | Using SSIS Precedence Constraints | 11/27/2008 | Brian Knight | 6 |
| 119 | SSIS(13) | Using the Aggregate Transform | 12/4/2008 | Brian Knight | 3 |
| 120 | SSIS(13) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 121 | SSIS(13) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 122 | SSMS(5) | Creating a Database Diagram in SSMS | 10/2/2008 | Brian Knight | 6 |
| 123 | SSMS(5) | Restoring a Full Database in SSMS | 10/28/2008 | Brian Knight | 3 |
| 124 | SSMS(5) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 125 | SSMS(5) | SQL Server Management Studio for Beginners | 1/1/2009 | Brian Knight | 7 |
| 126 | SSMS(5) | Creating and Modifying Tables in SSMS | 3/3/2009 | Brian Knight | 7 |
| 127 | SSRS(3) | Parameterizing SSRS Reports | 10/7/2008 | Brian Knight | 2 |
| 128 | SSRS(3) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 129 | SSRS(3) | Multi Select Parameters in SSRS | 10/21/2008 | Brian Knight | 2 |
| 130 | Stored Procedures(1) | Creating Stored Procedures | 7/29/2008 | Brian Knight | 4 |
| 131 | Striped Backups(1) | Creating Striped Backups | 3/19/2009 | Brian Knight | 2 |
| 132 | Subscriptions(1) | Creating a Subscription | 4/21/2009 | Andy Warren | 3 |
| 133 | Synonyms(2) | Creating a Synonym for a Table | 1/20/2009 | Andy Warren | 2 |
| 134 | Synonyms(2) | Using Views and Synonyms for Abstraction | 1/22/2009 | Brian Knight | 3 |
| 135 | System Databases(1) | Moving TempDB | 12/30/2009 | Andy Warren | 2 |
| 136 | System Development Lifecycle(1) | Object Dependencies in SQL Server | 1/2/2008 | Randy Dyess | 11 |
| 137 | Tables(1) | Creating and Modifying Tables in SSMS | 3/3/2009 | Andy Warren | 6 |
| 138 | TempDB(1) | Moving TempDB | 12/30/2009 | Andy Warren | 2 |
| 139 | Timestamp(1) | Using the Timestamp Data Type | 1/29/2009 | Brian Knight | 3 |
| 140 | Triggers(1) | Bypassing a Trigger | 12/16/2008 | Andy Warren | 3 |
| 141 | T-SQL(8) | Summarizing Data with Aggregate Queries | 8/28/2008 | Kathi Kellenberger | 12 |
| 142 | T-SQL(8) | Modifying Data | 9/30/2008 | Kathi Kellenberger | 15 |
| 143 | T-SQL(8) | Bypassing a Trigger | 12/16/2008 | Andy Warren | 3 |
| 144 | T-SQL(8) | Using the CheckSum Function | 12/18/2008 | Brian Knight | 3 |
| 145 | T-SQL(8) | Generating Random Results | 1/15/2009 | Andy Warren | 1 |
| 146 | T-SQL(8) | Using Views and Synonyms for Abstraction | 1/22/2009 | Brian Knight | 3 |
| 147 | T-SQL(8) | Using Intersect | 3/17/2009 | Andy Warren | 2 |
| 148 | T-SQL(8) | Using the Union Statement | 3/24/2009 | Andy Warren | 2 |
| 149 | UNION(1) | Using the Union Statement | 3/24/2009 | Andy Warren | 2 |
| 150 | Upgrade(1) | Post SQL Server 2008 Upgrade | 1/8/2009 | Brian Knight | 5 |
| 151 | Views(2) | Creating Views | 7/31/2008 | Brian Knight | 4 |
| 152 | Views(2) | Using Views and Synonyms for Abstraction | 1/22/2009 | Brian Knight | 3 |
| Total | 1019 |
