Microsoft training videos created in 2013 by Wise Owl (page 1 of 2)

Showing videos 1-20 (out of 29)

Using FOREACH containers to loop over files

Posted by Andy Brown on 22 December 2013

Learn now to use the FOREACH container task to loop over files, including using parameters and expression constraints.

Creating FOR loops and using sequence containers

Posted by Andy Brown on 13 December 2013

How to create loops in SSIS, and how to limit variable scope using sequence containers

Lookup transforms in SSIS

Posted by Andy Brown on 04 December 2013

Learn how to create lookup transforms, manage matching and non-matching rows and speed up processing with caching and cache transforms

SQL Programming Part 16 - DDL Triggers

Posted by Andrew Gould on 27 November 2013

Triggers are special stored procedures that you can attach to various events within a database. This video covers DDL, or Data Definition Language triggers, which you can use to handle events associated with changing the objects in a datatbase. This video concentrates on creating triggers to handle the CREATE, ALTER and DROP events and will show you how to scope a trigger to a single database or to an entire server. You'll also see how to disable and enable triggers, as well as how to change the order in which your triggers fire.

Debugging in SSIS

Posted by Andy Brown on 27 November 2013

Learn how to use data viewers to debug data flow tasks, set breakpoints to debug control flow tasks and use the output window to track down run-time errors.

SQL Programming Part 15 - DML Triggers

Posted by Andrew Gould on 22 November 2013

Triggers are special stored procedures that you can attach to various events within a database. This video covers DML, or Data Manipulation Language triggers, which you can use to handle events associated with inserting, updating and deleting data in tables and views.

Excel VBA Part 6 - Worksheets, Charts and Sheets

Posted by Andrew Gould on 09 November 2013

In order to navigate a workbook using VBA it's essential to understand how to refer to, activate and select the various types of sheet. This video explains the difference between worksheet, chart and sheet objects and also demonstrates how to select, copy, move, delete and rename them. You'll also see how to change the visibility of the sheets in a workbook, including how to make sheets not just hidden, but VERY hidden!

Conditional split and derived column transforms

Posted by Andy Brown on 07 November 2013

A tutorial video explaining how - and why - to create Conditional Split and Derived Column transforms in Integration Services

Integration Services expressions

Posted by Andy Brown on 06 November 2013

Learn how to create expressions using the expression builder, and how to create and configure Expression Tasks

Data types and data conversions

Posted by Andy Brown on 27 September 2013

Learn how to convert data types using the data conversion transformation, and what data types are available to you in SSIS.

Using variables in SSIS

Posted by Andy Brown on 20 September 2013

Learn how to create and use variables in Integration Services, how to create RowCount transformations and how to show the values of variables in script tasks.

Basic transformations in SSIS

Posted by Andy Brown on 13 September 2013

Learn how to create basic transformations, to sort, aggregate, sample and combine your data sources.

Performing basic tasks

Posted by Andy Brown on 04 September 2013

Learn how to import data from (for example) a flat file source to a SQL Server destination table, learn different ways to execute packages, learn how to run SQL commands and how to use data viewers to monitor data flows.

Getting started with SSIS

Posted by Andy Brown on 02 September 2013

Learn how to create your first packages in SSIS in Visual Studio, to import data from a SQL Server table into an Excel workbook.

SSRS Part 23 - Report Variables and Group Variables

Posted by Andrew Gould on 06 August 2013

Report variables are expressions which are calculated once when your report loads. They can be very useful for speeding up certain expressions and creating reliable, time-dependent calculations. This video shows you how to create and use report variables and group variables using a couple of practical examples.

Excel VBA Part 5 - Selecting Cells

Posted by Andrew Gould on 23 May 2013

You won't get far in Excel VBA without understanding how to refer to cells! This fairly long video covers most of the common, and some uncommon, techniques for selecting and referring to cells. You'll learn how to select cells by cell reference using the Range property, how to refer to cells by row and column number using the Cells property, and how to refer to the currently selected cell using the Activecell property. We also cover how to select multiple cells and how to refer to range names as well as a variety of relative selection tricks such as using the End property to jump to the bottom of a list, using the Offset property to move a specific number of rows and columns, and how to select an entire region of data with one simple instruction. Along the way you'll also learn several techniques for formatting and modifying cells, as well as how to copy and paste data in VBA.

SSRS Part 13 - Null values in parameters

Posted by Andrew Gould on 21 May 2013

Parameters allow your users to filter reports by typing in values or selecting from drop down lists. But what if they want to leave a parameter blank and still see results in the report? This video teaches you how to handle Null values in parameters to make this possible. You'll learn how to allow a null value in a parameter and how to write a WHERE clause to handle the null properly. We'll also look at how you can create drop down list parameters which allow null values, including how to append a null value to a dataset, how to mask the null value with descriptive text and how to sort the drop down list to make sure the null appears at the top.

SQL Programming Part 14 - Transactions

Posted by Andrew Gould on 20 May 2013

Transactions take place whenever you modify data in your database. Normally this process is handled by SQL Server but this video teaches you how to control your transactions. You'll learn how to specify when your transactions begin, when the changes are committed and even how to undo the changes using the Rollback statement. We'll also cover how to use transactions with error handling code, how to create savepoints within a transaction, and how to use nested transactions in stored procedures.

Excel VBA Part 4 - Buttons, Toolbars and Keyboard Shortcuts

Posted by Andrew Gould on 10 May 2013

As a developer you'll be used to running most of your code from within the Visual Basic Editor environment. Your users, on the other hand, are more likely to require a simple interface (most likely involving buttons to click) that they can use to run your code. This video covers the main ways to provide users with the means to run your code including keyboard shortcuts, buttons and drawing objects with attached macros. We'll even show you how to customise the ribbon and toolbars in Excel for that extra, professional touch!

Excel VBA Part 3 - What To Do When Things Go Wrong

Posted by Andrew Gould on 10 May 2013

If you've written at least one subroutine in VBA you'll probably already be familiar with the feeling of frustration when things don't work! This video teaches you about the different types of error that you're likely to encounter when programming in VBA and what to do when things go wrong. You'll learn the difference between syntax, compile and runtime errors, when each type is likely to happen and we'll even show you a few useful debugging techniques to help you when you're trying to figure out what went wrong!

This page has 0 threads Add post