Monday, January 29, 2007

New Microsoft SQL Server Video Tutorial: Pt. 2 - Using Views in the Real World

Pt. 2 - Using Views in the Real World - view details
This video, part 2 in our series on using views, helps you understand the logic behind using views as well as providing real world examples for designing and using views in your databases and applications.
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: sql view, stored query, stored queries, views, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 5:29 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Create View Syntax and Creating Views in SQL Server

Pt. 3 - Create View Syntax and Creating Views in SQL Server - view details
Part three in our series on views focuses on the dirty work: the CREATE VIEW statement. There are various ways to write the CREATE VIEW statement, all of which end up the same way (with a new view) and this video helps you understand the syntax.
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 sql view, create view syntax, alter view, drop view, views, beginner, beginning, for beginners, introduction, step by ste

posted by Scott Whigham @ 5:29 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View)

Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View) - view details
Our final video in this series is on how to modify data through your videos. There are certain rules that you must adhere to before you can issue an INSERT, UPDATE or DELETE statement using your view so you'll want to watch this video to be aware of these rules.
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: update sql view, updateable view, views as security mechanism, view security

posted by Scott Whigham @ 5:29 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Introduction to Using XML with SQL Server

Pt. 1 - Introduction to Using XML with SQL Server - view details
This video, part one in our series, is a high level overview of what XML is and when it's appropriate to use XML in a relational system. This is our entry point into using XML in SQL Server. The videos in this series are shot using SQL Server 2005 but, for those of you on SQL Server 2000, you'll be able to follow along as well.

Highlights from this video:
  • When would you use XML in SQL Server?
  • Working with FOR XML AUTO
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 mu st have the TSCC codec installed to view this video

Keywords Associated with this video: FOR XML AUTO, ROOT, PATH, part 1, beginning, beginners, intro, introduction

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Setting Up Publications for Transactional Replication

Pt. 2 - Setting Up Publications for Transactional Replication - view details
This video, part 2 in our series, walks you through creating publications using the "Create Publication Wizard" in SQL Server Enterprise Manager. You'll learn about publishing tables and doing vertical as well as horizontal filters.

Highlights from this video:
  • What requirements are there for publishing tables?
  • How to publish an entire table and how to publish only certain columns
  • How to publish all columns but only rows that meet a WHERE clause
  • Should you change the destination object owner?
  • Syntax for writing filters
  • Determining snapshot creation and snapshot agent location/properties
  • How frequently should the snapshot agent run?
  • Scripting your publication for easier maintenance/reinitialization
  • After running the wizard, how to modify and view the publication's properties
  • How to generate new snapshots
  • What does the snapshot look like? How is it implemented?
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: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot, filters, horizont

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Using FOR XML Clauses in SQL Server

Pt. 2 - Using FOR XML Clauses in SQL Server - view details
This video takes you through several examples of building hierarchies using XML and using the FOR XML PATH clause. This video talks about using XQuery and XPath to work with the database and generate hierarchical list of XML data.
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: querying xml data

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace

Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace - view details
This video, part 2 in our "Intro to Profiler" series, provides a great overview of the various Events (also called "Event Classes") and how the Data Columns work. You'll also see how to choose the various options and how to group columns in Profiler for easier navigation over large traces. You can significantly impact your trace's "drag" on your SQL Server by wisely choosing your events, data columns, and filters when you start your trace. This video walks you through the Event Classes (and makes suggestions as to which to use for what purpose), what common Data Columns are used (and what are Data Columns anyway?), and gives you several creative ideas for doing yo ur own traces.

Highlights from this video:
  • New Events in SQL Server 2005
  • How templates affect your events and columns
  • Tracing for performance tuning
  • Tracing errors
  • What's the difference between "Profiler" and a "trace"?
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: sql trace, RPC:Complete, CursorOpen, Deadlock, Exception, Data File Auto Grow, SP:CacheMiss, SP:CacheInsert

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication

Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication - view details
This video is a continuation from our introductory series on SQL Server replication and walks you through setting up the distributor and the publisher for transactional replication. You'll walk through setting up replication using the "Configure Distribution Wizard" to configure each option. Included is a detailed explanation of each of the screens in the wizard and recommendations for best practices.

Highlights from this video:
  • Replication architecture
  • What is the "distribution" database?
  • Suggestions for configuring the SQL Server agent for replication
  • What is the snapshot? Where is it stored? How often should it be generated?
  • Scripting the wizard's output for easier replay/debugging/maintenance
  • Using the Replication Monitor
  • Using the Distributor Properties and Publisher Properties
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: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View)

Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View) - view details
Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View)
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: update sql view, updateable view, views as security mechanism, view security

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Using Output Parameters To Pass Data To the Caller

Pt. 2 - Using Output Parameters To Pass Data To the Caller - view details
This continues our discussion of OUTPUT parameters from Part 1. Please ensure that you have viewed Part 1 before watching this video.

Highlights from this video:
  • When to Use Output Parameters
  • Output Parameter or Result Set?
  • Passing Data Between Stored Procedures
  • Master-Detail Inserts with IDENTITY values
  • @@IDENTITY or SCOPE_IDENTITY?
  • OUT or OUTPUT?
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: output, out params, sql parameters, sqlparameter, parameterdirection.output

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2b - Introduction to Using XML with SQL Server

Pt. 2b - Introduction to Using XML with SQL Server - view details
This video finishes out our discussion of when to use XML in SQL Server with a final discussion of using the XML datatype in SQL Server to store our Newsletter information.
To downloa d 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: newsletter, multiple outputs, xml, xsl, xslt

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Best Practices for Using Return Values

Pt. 3 - Best Practices for Using Return Values - view details
The final video in this series on using return values talks about using RETURN to send @@ERROR values back to the caller and whether or not this is a common/good practice.

Highlights from this video:
  • Using RETURN with @@ERROR
  • Making Decisions with SqlParameter and ParameterDirection.ReturnValue
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: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2a - Introduction to Using XML with SQL Server

Pt. 2a - Introduction to Using XML with SQL Server - view details
This video continues our discussion on beginning XML with SQL Server with a discussion on when you should/could/would use XML with SQL Server.

Highlights from this video:
  • Using XML with SQL Server 2005/2000
  • When is it appropriate to store XML in the database?
  • What datatypes are supported for working with XML?
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: semistructured data, semi-structured data, hierarchical data

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication

Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication - view details
This video is a continuation from our introductory series on SQL Server replication and walks you through setting up the distributor and the publisher for transactional replication. You'll walk through setting up replication using the "Configure Publishing and Distribution Wizard" to configure each option. Included is a detailed explanation of each of the screens in the wizard and recommendations for best practices.

Highlights from this video:
  • Replication architecture
  • What is the "distribution" database?
  • Suggestions for configuring the SQL Server agent for replication
  • What is the snapshot? Where is it stored? How often sh ould it be generated?
  • Scripting the wizard's output for easier replay/debugging/maintenance
  • Using the Replication Monitor
  • Using the Distributor Properties and Publisher Properties
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subs criber-only video so a subscription is required.

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

Keywords Associated with this video: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Using FOR XML Clauses in SQL Server

Pt. 1 - Using FOR XML Clauses in SQL Server - view details
The FOR XML clauses allow you to generate XML based on your SELECT statements. There are several different ways to generate XML - FOR XML AUTO, FOR XML RAW, FOR XML EXPLICIT, FOR XML PATH, and more. How do you know which to use? What's the difference between RAW and AUTO? Which of these can auto-detect relationships in the data?

Highlights from this video:
  • An overview of the different FOR XML options
  • When should I use FOR XML?
  • Using FOR XML RAW
  • USING FOR XML AUTO
  • Changes in SQL Server 2005
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.

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

Keywords Associated with this video: sqlxml, msxml, sql xml, msxml4

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace

Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace - view details
You can significantly impact your trace's "drag" on your SQL Server by wisely choosing your events, data columns, and filters when you start your trace. This video walks you through the Event Classes (and makes suggestions as to which to use for what purpose), what common Data Columns are used (and what are Data Columns anyway?), and how filters can be used (what Event Classes use what Filters?).

Highlights from this video:
  • Suggestions for using filters to create more manageable traces
  • Tracing for performance tuning
  • Tracing errors
  • Viewing trace data and interpreting Profiler's results
  • What's the difference between "Profiler" and a "trace"?
  • SQL Batches and the SP:BatchCompleted Event Class
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: sql trace, RPC:Complete, CursorOpen, Deadlock, Exception, Data File Auto Grow, SP:CacheMiss, SP:CacheInsert

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Publications and Subscriptions

Pt. 3 - Publications and Subscriptions - view details
This video, our final overview video on SQL replication, finishes out our discussion with a lecture on publications and subscriptions.

Highlights from this video:
  • What objects (tables, views, stored procedures, etc) can I replicate?
  • Do I have to replicate the whole database or can I just replicate part of the database?
  • Can I replicate only certain columns of a table or do I have to replicate the entire table?
  • What types of subscriptions are available and what are the differences?
  • How to work with mobile and/or frequently disconnected systems
  • How synchronization schedules control replication and dictate "latency"
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction, publication, article, pu

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Create View Syntax and Creating Views in SQL Server

Pt. 3 - Create View Syntax and Creating Views in SQL Server - view details
Pt. 3 - Create View Syntax and Creating Views in SQL Server
To download this video, log in, then visit the vid eo'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 sql view, create view syntax, alter view, drop view, views, beginner, beginning, for beginners, introduction, step by ste

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - What Return Values Are and How to Use Them

Pt. 1 - What Return Values Are and How to Use Them - view details
This video is an excellent introduction to using Return Values in your SQL Server stored procedures. Return values can speed up performance of your applications as well as helping make a more logical flow. Anyone writing or maintaining stored procedures needs to know this information. NOTE: This video was shot on SQL Server 2005 but the same concepts apply to all versions of SQL Server.

Highlights from this video:
  • Making decisions using return values
  • Returning values to the caller
  • Using RAISERROR and RETURN values
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: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Introduction to Using XML with SQL Server

Pt. 4 - Introduction to Using XML with SQL Server - view details
This video discusses using XQuery, XPath and XML DML as options for working with XML data.
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: xquery standard, xdr

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Introduction to Using XML with SQL Server

Pt. 3 - Introduction to Using XML with SQL Server - view details
Even more discussion of when to use XML in the database
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: xml, for xml, xml datatype, xml schema collections

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Setting Up Push and Pull Subscriptions

Pt. 3 - Setting Up Push and Pull Subscriptions - view details
This video walks you through setting up a push subscriptions and pull subscriptions as well as synchronizing servers. You'll be able to view latency and how to diagnose replication problems.

Highlights from this video:
  • Push Subscriptions vs. Pull Subscriptions
  • Synchronization Schedules and Latency
  • How to initialize a new publication using the "New Publication Wizard"
  • Discussion of the Distribution Agent and how it works (does it run at subscriber?)
  • Discussion of using non-SQL Server subscribers (Oracle subscribers, DB2 subscribers for example)
  • Discussion of service account usage and recommendations
  • Snapshot initialization and how to start the Snapshot Agent
  • Working with multiple subscriptions for a single publication
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction, publication, article, pu

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens

Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens - view details
SQL Server Profiler is just an amazing tool and one that every sysadmin should know "backwards and forwards." This video, the first in our series, covers what Profiler is, what traces are, and gives you an introduction to using Profiler. You'll also cover the basic screens when you start Profiler.

Highlights from this video:
  • Differences between SQL Server 2000 Profiler and SQL Server 2005 Profiler
  • Permissions required for SQL Server 2005 Profiler
  • Making decisions on the "General" screen
  • Should you save to file or save to table?
  • Using templates with Profiler
  • What sort of performance impact will Profiler cause? How much?
  • How to minimize the "drag" that Profiler creates
  • Server side vs. client side traces
  • What are rollover files (file rollover)? What should the setting be?
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: sql trace, sql profiler, sql server 2005 profiler, profiling, sql sniffer, sniffing sql, tracing sql

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Setting Up Publications for Transactional Replication

Pt. 2 - Setting Up Publications for Transactional Replication - view details
This video, part 2 in our series, walks you through creating publications using the "New Publication Wizard" in SQL Server Management Studio (SSMS). You'll learn about publishing tables and doing vertical as well as horizontal filters.

Highlights from this video:
  • What requirements are there for publishing tables?
  • How to publish an entire table and how to publish only certain columns
  • How to publish all columns but only rows that meet a WHERE clause
  • Should you change the destination object owner?
  • Syntax for writing filters
  • Determining snapshot creation and snapshot agent location/properties
  • How frequently should the snapshot agent run?
  • Configuring Agent Security for the snapshot agent and the log reader agent
  • Should you run the agent accounts as the SQL Server Agent service account?
  • Scripting your publication for easier maintenance/reinitialization
  • After running the wizard, how to modify and view the publication's properties
  • How to generate new snapshots
  • What does the snapshot look like? How is it implemented?
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: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot, filters, horizont

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces

Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces - view details
This is a huge video - one that you should definitely watch if you'll be working with Profiler often. In this video our resident guru, Scott Whigham, walks you through all the various techniques for saving and exporting trace data: saving trace data as SQL files (for performance tuning and index tuning), exporting as a template, saving your traces as a SQL Server table and more. One of the best things in this video is seeing how, once you export/save your trace to a SQL table, you can write queries against the data. You could write queries that would tell you how many times a particular table appears in the trace, average/min/max execution times, and more.

Highlights from this video:
  • Importing and Exporting trace data and trace files
  • Working with TextData column in your trace table
  • Interpreting Reads/CPU/Duration and other 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 T SCC codec installed to view this video

Keywords Associated with this video: profile, profiler table, write queries against profiler data, save trace to sql file

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Configuring Profiler for Common Tasks (Templates)

Pt. 4 - Configuring Profiler for Common Tasks (Templates) - view details
Scott Whigham, author of LearnSqlServer.com, walks you through one of his favorite tweaks for SQL Server Profiler - creating and customizing templates. This is a very quick video but it's content will save you a ton of frustration and time!

Highlights from this video:
  • Creating templates
  • Best Practices for Backing Up templates
  • Configuring Profiler to auto-start a trace upon connection
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: trace template, start automatically, profile startup

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace

Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace - view details
Do you want to know how many times a query has run in your trace? What about finding aggregates like what the minimum duration, maximum duration, and average durations/page reads/CPU? This is a great video that teaches you how to manipulate the trace data into a table for querying. Even then, you still have some work to do...

Highlights from this video:
  • How to save a trace to a table
  • Querying trace tables
  • Writing reporting-style queries against traces
  • Working with ntext data types and GROUP BY/WHERE clauses
  • Modifying your trace table to make it usable in aggregates
  • Saving the queries traced to a SQL 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 subscription is required.

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

Keywords Associated with this video: profile, profiler table, write queries against profiler data

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - The Three Most Common Types of SQL Server Replication

Pt. 2 - The Three Most Common Types of SQL Server Replication - view details
This video, part 2 in our series, focuses on Snapshot, Merge and Transactional replication architectures. You'll learn what the purpose of each type of replication is, common uses of each, and just a general overview of the replication types in SQL Server 2005 and SQL Server 2000.

Highlights from this video:
  • Understanding how synchronization affects replication
  • Snapshot replication architecture
  • Merge replication architecture
  • Transactional replication architecture
  • Useful analogies that help you understand and remember each type
  • Which type(s) of replication are "One Way" by default?
  • Which type(s) of replication supports conflict resolution?
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - What Output Parameters Are and When to Use Them

Pt. 1 - What Output Parameters Are and When to Use Them - view details
This video is a great introduction to using OUTPUT parameters. Modern SQL programmers use output parameters in so many stored procedures that it's tough to be a decent SQL developer without a solid understanding of how they work. This video series walks you through what OUTPUT parameters are, how they work, and gives you several business cases for how to use them effectively. Please note that this video needs to be downloaded with Part 2 of this series since the demo/discussion is completed in Part 2.

NOTE: This video series was shot using SQL Server 2005 but the concepts are the same for all versions of SQL Server.

Highlights from this video:
  • When to Use Output Parameters
  • Output Parameter or Result Set?
  • Passing Data Between Stored Procedures
  • Master-Detail Inserts with IDENTITY values
  • @@IDENTITY or SCOPE_IDENTITY?
  • OUT or OUTPUT?
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: output, out params, sql parameters, sqlparameter, parameterdirection.output

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces

Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces - view details
The filters you choose (or don't choose) can definitely give you improved throughput for your traces. This video walks you through how to set up the filters and designing traces for performance. At the end of this video, a great demo of how organize your traces for easier readability and troubleshooting.

Highlights from this video:
  • What filters should I use when I want to filter for long running/slow queries?
  • What are Reads and Duration and why are they important?
  • How can I only trace my application (not SQL Server Agent, for example)
  • Tracing for performance tuning
  • What Event Classes use what Filters
  • Suggestions for using filters to create more manageable traces
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 TS CC codec installed to view this video

Keywords Associated with this video: sql trace, sql profiler, sql server 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql, grouping, filtering, limit

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 5 - Templates and Working Within the Profiler UI

Pt. 5 - Templates and Working Within the Profiler UI - view details
This is a quick video that teaches you how to work with templates in Profiler so that you can quickly start tracing and get helpful data.

Highlights from this video:
  • Default templates
  • How to Backup templates
  • Importing and Exporting templates
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 TS CC codec installed to view this video

Keywords Associated with this video: trace template, start automatically, profile startup

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Using Return Values to Control Program Execution

Pt. 2 - Using Return Values to Control Program Execution - view details
This video expands on the use of return values in SQL Server and shows you how to make decisions in your code based on a stored procedure's return value.

Highlights from this video:
  • What value does RETURN return by default?
  • What are the most likely conventions/uses of RETURN?
  • Using RETURN to return @@ERROR and SQL error codes
  • Best Practices for stored procedure programming
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: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Setting Up Push Subscriptions

Pt. 3 - Setting Up Push Subscriptions - view details
This video walks you through setting up a push subscriptions and pull subscriptions as well as synchronizing servers. You'll be able to view latency and how to diagnose replication problems.

Highlights from this video:
  • Push Subscriptions vs. Pull Subscriptions
  • Synchronization Schedules and Latency
  • How to initialize a new publication using the "Create Publication Wizard"
  • Discussion of the Distribution Agent and how it works (does it run at subscriber?)
  • Discussion of using non-SQL Server subscribers
  • Discussion of service account usage and recommendations
  • Snapshot initialization and how to start the Snapshot Agent
  • Working with multiple subscri ptions for a single publication
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction, publication, article, pu

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Using SQL Profiler - Concepts and Screens

Pt. 1 - Using SQL Profiler - Concepts and Screens - view details
SQL Server Profiler is one of the greatest SQL Server admin tools ever - you absolutely need to know it! This video walks you through the basics of "What is SQL Server Profiler?" and "How do I run Profiler?"

Highlights from this video:
  • What traces are and how to use them
  • Security requirements for running Profiler
  • Using (local) or . or any alias in Profiler - good or bad?
  • Concepts of server-side tracing vs. client-side traces
  • Suggestions for naming traces
  • Explanation of rollover files and Best Practices for using Profiler
  • Should You Trace to File or Trace to Table? What's the "Best Practice"?
  • Using templates
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: sql trace, sql profiler, sql server 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql

posted by Scott Whigham @ 5:12 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Using Views in the Real World

Pt. 2 - Using Views in the Real World - view details
Pt. 2 - Using Views in the Real World
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