An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.  Read more...

Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.  Read more...

In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.  Read more...

Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.  Read more...

The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.  Read more...

The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.  Read more...

The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.  Read more...

This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.  Read more...

This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.  Read more...

In this video written by MVP Brad McGehee you can learn how to get started using the Profiler GUI.  Read more...

This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.  Read more...

Learn how to get started integrating mail with your SQL Server in this SQL School video. MVP Andy Warren shows how to set up Database Mail.  Read more...

This SQL School video looks at how you add a publication to a replication scenario.  Read more...

In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering the basics of SQL Server Profiler, a powerful performance monitoring and analysis tool.  Read more...

SQL School expands its replication series with a look at how you can set up a subscriber with MVP Andy Warren.  Read more...

Replication can be a complicated undertaking for many people. Learn how to get started by creating a publisher in this SQL School video from MVP Andy Warren.  Read more...

The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.  Read more...

Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.  Read more...

This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.  Read more...

In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.  Read more...