VIDEOS BY CATEGORY
VIDEOS BY AUTHOR
VIDEOS BY YEAR
Microsoft training videos created in 2013 by Wise Owl (page 1 of 2)
Showing videos 1-20 (out of 29)
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.
Posted by Andy Brown on 13 December 2013
How to create loops in SSIS, and how to limit variable scope using sequence containers
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
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.
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.
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.
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!
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
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
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.
Posted by Andy Brown on 13 September 2013
Learn how to create basic transformations, to sort, aggregate, sample and combine your data sources.
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.
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.
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.
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.
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.
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.
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!
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!