Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.
MVP Brian Knight walks through the scripting capabilities of Management Studio to show how the code for table creation and the various dependent objects. Brian looks at the options available with scripting and what the implication of choosing them will be.
Learn how you can add a new database to your instance if you receive the MDF and LDF files from another source. MVP Brian Knight covers this very useful technique that is used for moving databases to new instances, servers, or even recovering from an disaster.
Excel is a wonderful tool for examining the data in your SSAS cubes. MVP Brian Knight shows how you can access the data in Analysis Services or a SQL Server database from Excel 2007.
MVP Brian Knight covers the basics of creating stored procedures in SQL Server. Stored Procedures are ways of encapsulating a section of code inside of a function, and this video shows how you to convert your queries to stored procedures.