Friday, January 30, 2009

New SQL Server Programming Video Tutorial: Why You Need to Refres h Your Views After Adding Columns to a Table, Part 1

Why You Need to Refresh Your Views After Adding Columns to a Table, Part 1 - view details
Have you ever found yourself working in a table where you made a change to that table and now your view of the data does not reflect the changes? After you add a column to a table, the view you created will not pickup the changes. In this first video in the series Scott will set-up the situation and demonstrate the discrepancy between the table and the view. In later videos he will demonstrate who goes on behind the scenes and show you some suggested fixes.

Highlights from this video:
  • Setting up the table and view
  • Modifying the table
  • Table vs View: Updated data
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: table, view, metadata, sql, server, tsql, t-sql, column, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Why Y ou Don't Want to Use the dbcreator Role

Why You Don't Want to Use the dbcreator Role - view details
In this video we will discuss the risks and disadvantages��in assigning the dbcreator server role membership to a��user��in SQL Server 2008.

Highlights from this video:
  • Determining when users are DBOs (database owner)
  • Adding additional members to server roles
  • The danger in dropping databases
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: dbcreator, server role, sql, server, security, 2008, database, user, login

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: What All SQL Server Logins Must Have, Part 2

What All SQL Server Logins Must Have, Part 2 - view details
Continuing in this video is our discussion and demonstration on the elements that all SQL Server logins must have. Also in this video, we will demonstrate how some of the elements work.

Highlights from this video:
  • Brief overview of Server roles
    • bulkadmin, dbcreator, public, diskadmin
    • processadmin, securityadmin, serveradmin, setupadmin, sysadmin
  • Setting a default database and default language for new logins
  • User mapping
  • What if my default database is offline or non-existent
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is re quired.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, 2008, security, login, admin, database, user,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Programming Video Tutorial: Why You Need to Refres h Your Views After Adding Columns to a Table, Part 1

Why You Need to Refresh Your Views After Adding Columns to a Table, Part 1 - view details
Have you ever found yourself working in a table where you made a change to that table and now your view of the data does not reflect the changes? After you add a column to a table, the view you created will not pickup the changes. In this first video in the series Scott will set-up the situation and demonstrate the discrepancy between the table and the view. In later videos he will demonstrate who goes on behind the scenes and show you some suggested fixes.

Highlights from this video:
  • Setting up the table and view
  • Modifying the table
  • Table vs View: Updated data
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated w ith this video: table, view, metadata, sql, server, tsql, t-sql, column, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 12:34 PM  

New SQL Server Programming Video Tutorial: Why You Need to Refres h Your Views After Adding Columns to a Table, Part 2

Why You Need to Refresh Your Views After Adding Columns to a Table, Part 2 - view details
So what actually happens when we create a view in SQL Server? In this second video in the series, Scott will show you�� two queries you can use to find the differences in your table vs. view as well as demonstrate three techniques used to refresh the metadata of the view

Highlights from this video:
  • About system views and catalog views
  • Using the information_schema query to identify where the views differ from the tables
  • Using sys.columns to identify where the views differ from the tables
  • Three techniques for refreshing metadata of a view
  • Scott's suggested technique
and much more
  • Source: http://www.LearnTransactSQL.com
  • Category: Views in SQL Server
  • Skill Level: 100 (Beginner)
  • Length: 07:45 (12.0MB)
  • Applies to Versions: SQL Server - All Versions
  • Full Details
    • To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: metadata, view, table, refresh, update, sql, server, t-sql, tsql, introduction, step by step, beginner, beginning, for dummies

    posted by Scott Whigham @ 12:34 PM  

    New SQL Server Programming Video Tutorial: Why You Need to Refres h Your Views After Adding Columns to a Table, Part 3

    Why You Need to Refresh Your Views After Adding Columns to a Table, Part 3 - view details
    In this last video Scott will show you how to find all views that depend on a modified object. Scott's sql scripts are included with this download.

    Highlights from this video:
    • Review of modifications made to table and view
    • SQL 2008: Method of finding dependencies
    • SQL 2000/2005: Method of finding dependencies
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: table, view, metadata, sql, server, tsql, t-sql, column, dependencies, dependency, , introduction, step by step, beginner, begin

    posted by Scott Whigham @ 12:34 PM  

    Wednesday, January 14, 2009

    New SQL Server Integration Services Video Tutorial: Part 2 - The Various Tabs in the Toolbox; How to Customize the SSIS Toolbox

    Part 2 - The Various Tabs in the Toolbox; How to Customize the SSIS Toolbox - view details
    In this second video in the series, we will begin our actual tour of the toolbox in BIDS. We will cover the three main expandable sections on the toolbox by answering the questions: Who uses it? What is it? What does it do?

    Highlights from this video:
    • Three expandable sections
      • Control Flow Items
      • Maintenance Plan Tasks
      • General
    • Adding new controls to the Toolbox
    • Removing/Resetting controls on the Toolbox
    • Containers��vs Tasks
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscripti on is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer,

    posted by Scott Whigham @ 2:34 PM  

    New SQL Server Video Tutorial: Part 5 - Writing the Stored Proced ure to Copy a Database

    Part 5 - Writing the Stored Procedure to Copy a Database - view details
    Continued in this fifth video in the series, Scott will show you how to create a handy stored procedure to copy a database by building off your knowledge from the backup and restore procedures.

    Highlights from this video:
    • Required parameters for the copy database stored procedure
    • Working with the backup and restore procedures
    • Assigning the datafile and the log via dynamic sql
    • Demo of backup/restore/copy procedures
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: stored, procedure, database, backup, file, copy, restore,

    posted by Scott Whigham @ 2:34 PM  

    New SQL Server Video Tutorial: Part 4- Writing the Stored Procedu re to Restore a Database

    Part 4- Writing the Stored Procedure to Restore a Database - view details
    After you complete your stored procedure to backup a databse, you can then create a stored procedure to restore a database from those backups. With a stored procedure like this, you will have several credentials to first set. In this fourth video in the series Scott will cover those parameters and demonstrate the exact way to create this awesome stored procedure.

    Highlights from this video:
    • Required parameters for restoring a database
    • Creating a base restore database command
      • Why does the command fail?
    • Obtaining the logical file names
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: stored, procedure, database, restore, file,

    posted by Scott Whigham @ 2:34 PM  

    New SQL Server Video Tutorial: Part 3- Writing the Stored Procedu re to Backup a Database: Part B

    Part 3- Writing the Stored Procedure to Backup a Database: Part B - view details
    In this third video in our series, your instructor Scott will wrap up the creation of��a stored procedure to backup a database.

    Highlights from this video:
    • Various date formats for generate a filename
    • Setting a TimeString and CONVERT process
    • ��Setting the path for the backup file
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscrip tion is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: stored procedure, procedure, backup, database, file, .bak,

    posted by Scott Whigham @ 2:34 PM  

    New SQL Server Video Tutorial: Part 2- Writing the Stored Procedu re to Backup a Database: Part A

    Part 2- Writing the Stored Procedure to Backup a Database: Part A - view details
    In this second video in the series, we will continue piecemealing our previous coding to create a stored procedure to backup a database. Scott will cover the database name, the backup folder, and the backup extension.

    Highlights from this video:
    • Review of Input Output parameters
    • Working with unclosed quotation marks and apostrophes
    • Stringing Dynamic SQL
    • Using CONVERT syntax to generate a file name from the date
    • The problem with the default of appending backup files
      • How to overwrite existing backup files
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: stored procedure, database, backup, automate, automation,file

    posted by Scott Whigham @ 2:34 PM  

    New SQL Server Video Tutorial: Part 1- Automation with Stored Pro cedures: Automate Backup,Restore, Copy with Stored Procedures

    Part 1- Automation with Stored Procedures: Automate Backup,Restore, Copy with Stored Procedures - view details
    As a database administrator, you often have to copy a database, restore a database, or backup a database. These monotonous tasks, however, can basically be done for you via automation with stored procedures by simply passing��a few��parameters. In this video series your instructor Scott will not only show you how to create these stored procedures, but he will also talk about the things that are used in creating the stored procedures that will do backups, copy a database, and/or restore a database. In this first video in the series, Scott will walk you through the process of creating a stored procedure that will backup a database, a very essential maintenance task.

    Highlights from this video:

    • Building a backup database stored procedure from scratch
      • Requirements
    • About using SYSNAME
    • How to set required/default parameters
    • Two types of parameters with stored procedures
      • Inputs
      • Input Output
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is requ ired.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: stored procedure, backup, copy, restore, database, automate, automation,

    posted by Scott Whigham @ 2:34 PM  

    New Reporting Services Video Tutorial: Part 2: Customizing Templa tes and How to Work With Multiple Templates

    Part 2: Customizing Templates and How to Work With Multiple Templates - view details
    After your custom template has been defined and created, you will more than likely want to continue customizing your template until it is just perfect or you might even��want to create multiple templates based off your new template. In this video Scott will walk you through how further customize your template and also how to work with multiple new templates.


    Highlights from this video:

    • Finishing up with designing your template
    • How to create multiple templates
      • Minor glitches in Visual Studio in file-building
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscrib er-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: customize, template, multiple template, create template,

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 2 - Still Working on Choosing the Data Items for the Invoices

    Part 2 - Still Working on Choosing the Data Items for the Invoices - view details
    In this second video, Scott will continue walking you through the AdventureWorks database to point out what kind of information and queries you'll want to use in creating your invoice.

    Highlights from this video:
    • Non-repeating information in the AW database
    • JOINing tables and queries
    • Deciding what data to use
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: invoice, data items, adventure works

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 3 - Determining Wheth er to Use One Result Set or Multiple Result Sets

    Part 3 - Determining Whether to Use One Result Set or Multiple Result Sets - view details
    Once you have your summary query with order and product information, you will have two choices for assembling your invoice. In this third video Scott will present your two options and begin to demonstrate how to create your invoice using multiple result sets.

    Highlights from this video:
    • Does it matter if I use one result set or multiple result sets?
    • Difference between using the one-query option and the multi-query option

    and much more

    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: create invoice, invoice, generate, adventure works, result set,

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 7 - An Example of Usi ng Multiple Result Sets to Build Your Invoice

    Part 7 - An Example of Using Multiple Result Sets to Build Your Invoice - view details
    In this final video, Scott will show you how to use two seperate result sets, also known in this series as��Option A, ��to generate your invoice.

    Highlights from this video:
    • Is there a difference in the apperance of the invoices between the two options?
    • Creating your header dataset and detail dataset
    • Replacing your parameters and updating your table
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only v ideo so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: invoice, multiple reseult sets, create invoice,

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 6 - Making Your Invoi ces Dynamically Generated With Report Parameters and DropDownLists

    Part 6 - Making Your Invoices Dynamically Generated With Report Parameters and DropDownLists - view details
    One of the last things you will need to do to enhance your invoice will be to add the ability to generate��the invoice��based off of report parameters. Scott will also show you how to add a drop-down list for your invoice��to facilitate its��creation.��

    Highlights from this video:
    • Adding the report parameters
    • Creating a dropdown list
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: invoice, report parameters, dropdown list,

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 5 - Completing the Ba sic Invoice Layout and Adding Data

    Part 5 - Completing the Basic Invoice Layout and Adding Data - view details
    In this fifth video in the series you will be adding the products of the invoice to the body table and filling in the additional data!

    Highlights from this video:
    • Assembling��a table based off your datasets
    • Modifying/formatting your table's appearance
    • Populating your table
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: invoice, create, invoice layout,

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 4 - Creating the 'She ll' of the Invoice and Adding the Datasets

    Part 4 - Creating the 'Shell' of the Invoice and Adding the Datasets - view details
    After you've identified the queries that your invoicing system will be based on, it is now time to start creating the actual invoice...finally!

    Highlights from this video:
    • Adding a page header/footer/ etc
    • Working in the body of the invoice
      • Setting up your datasets and datasource
      • Implementing your queries
      • Adding in report items
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: creating invoice, invoice, generate, dataset,

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 1 - The Goals of the Project and Defining the Data to Use for Invoices

    Part 1 - The Goals of the Project and Defining the Data to Use for Invoices - view details
    In this first video in the series, Scott will walk you through the process of how to easily create an invoicing system��in Reporting Services using the approach that you'll want to dynamically derive your invoice based on report parameters. It is essential for the videos in this series for you to understand how templates work and about report parameters. This video is based off of the AdventureWorks sample database and therefore provides great real-world examples of how to generate an invoice.

    Highlights from this video:
    • Goals of the invoice
    • Familiarizing yourself with the AdventureWorks database
    • What kind of tables will we bo working wi th?
    • Repeating and Non-Repeating order information
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: invoice, adventure works, create, generate, make, , introduction, step by step, beginner, beginning, for dummies

    posted by Scott Whigham @ 11:34 AM  

    New Reporting Services Video Tutorial: Part 1: What Are Templates and How Can I Make My Own?

    Part 1: What Are Templates and How Can I Make My Own? - view details
    A��quick, and helpful��timesaver you can do with Reporting Services��is to create your own template that will have the same header, footer��etc��for newly created��report server projects. In this first video in the two-part series, Scott will show you can you can generate a custom template for your report projects and demonstrate to you the various ways the templates can be customized to meet your needs.

    Highlights from this video:
    • How does Reporting Services use its .rdl files it installs?
    • Creating a new .rdl file based off the original Report.rdl file
    • Designing and editing your own template
    and much more
    To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

    Note: You must have the TSCC codec installed to view this video

    Keywords Associated with this video: template, customize, rdl, report project,

    posted by Scott Whigham @ 11:34 AM