Friday, September 28, 2007

New SQL Server Integration Services Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
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 server proxy account, job credentials

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job?

Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job? - view details
The final overview topic is on how to execute Integration Services packages with ASP.NET (C# and Visual Basic). This video covers the main choices and provides a nice wrap up at the end with suggestions for your own best practices.

Highlights from this video:
  • What options are available in ASP.NET?
  • What do local, remote and 'context' mean in SSIS?
  • What accounts does ASP.NET use to execute the SSIS package in each instance?
  • Should I use or consider ASP.NET impersonation?
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 server proxy account, job credentials, c#, visual basic, .net

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job?

Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job? - view details
The final overview topic is on how to execute Integration Services packages with ASP.NET (C# and Visual Basic). This video covers the main choices and provides a nice wrap up at the end with suggestions for your own best practices.

Highlights from this video:
  • What options are available in ASP.NET?
  • What do local, remote and 'context' mean in SSIS?
  • What accounts does ASP.NET use to execute the SSIS package in each instance?
  • Should I use or consider ASP.NET impersonation?
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 server proxy account, job credentials, c#, visual basic, .net

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
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 server proxy account, job credentials

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
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 server proxy account, job credentials

posted by Scott Whigham @ 4:35 AM  

Thursday, September 27, 2007

New Visual Basic Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables 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: dts package, execute package

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell

Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell - view details
This video covers a ton of material - a little more on DTEXEC, some good info about how to execute an SSIS package in Windows PowerShell, and then the finale: how to execute packages from Transact-SQL.

Highlights from this video:
  • What syntax errors are common in PowerShell when you execute SSIS packages and how to fix them
  • Should you use T-SQL to execute SSIS packages?
  • What are the pros and cons of using DTEXEC vs. TSQL?
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: xp_cmdshell, Surface area configuration, security

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell

Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell - view details
This video covers a ton of material - a little more on DTEXEC, some good info about how to execute an SSIS package in Windows PowerShell, and then the finale: how to execute packages from Transact-SQL.

Highlights from this video:
  • What syntax errors are common in PowerShell when you execute SSIS packages and how to fix them
  • Should you use T-SQL to execute SSIS packages?
  • What are the pros and cons of using DTEXEC vs. TSQL?
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: xp_cmdshell, Surface area configuration, security

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell

Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell - view details
This video covers a ton of material - a little more on DTEXEC, some good info about how to execute an SSIS package in Windows PowerShell, and then the finale: how to execute packages from Transact-SQL.

Highlights from this video:
  • What syntax errors are common in PowerShell when you execute SSIS packages and how to fix them
  • Should you use T-SQL to execute SSIS packages?
  • What are the pros and cons of using DTEXEC vs. TSQL?
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: xp_cmdshell, Surface area configuration, security

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables 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: dts package, execute package

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables 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: dts package, execute package

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic

Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with Visual Basic. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with Visual Basic?
  • What DLLs do I need to reference in my Visual Basic project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via Visual Basic - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in Visual Basic
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
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: remote package execution, in process, package execution

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 2 - An Overview of How to Execute SSIS Packages With C#

Pt. 2 - An Overview of How to Execute SSIS Packages With C# - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with C#. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with C#?
  • What DLLs do I need to reference in my C# project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via C# - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in C#
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: remote package execution, in process, package execution, .NET, C#

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic

Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with Visual Basic. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with Visual Basic?
  • What DLLs do I need to reference in my Visual Basic project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via Visual Basic - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in Visual Basic
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 2 - An Overview of How to Execute SSIS Packages With C#

Pt. 2 - An Overview of How to Execute SSIS Packages With C# - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with C#. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with C#?
  • What DLLs do I need to reference in my C# project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via C# - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in C#
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: remote package execution, in process, package execution, .NET, C#

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
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: remote package execution, in process, package execution

posted by Scott Whigham @ 4:35 AM  

Wednesday, September 26, 2007

New SQL Server Integration Services Video Tutorial: Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job?

Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job? - view details
The final overview topic is on how to execute Integration Services packages with ASP.NET (C# and Visual Basic). This video covers the main choices and provides a nice wrap up at the end with suggestions for your own best practices.

Highlights from this video:
  • What options are available in ASP.NET?
  • What do local, remote and 'context' mean in SSIS?
  • What accounts does ASP.NET use to execute the SSIS package in each instance?
  • Should I use or consider ASP.NET impersonation?
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 server proxy account, job credentials, c#, visual basic, .net

posted by Scott Whigham @ 9:56 AM  

New SQL Server Integration Services Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
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 server proxy account, job credentials

posted by Scott Whigham @ 9:56 AM  

New SQL Server Integration Services Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 9:55 AM  

New SQL Server Integration Services Video Tutorial: Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell

Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell - view details
This video covers a ton of material - a little more on DTEXEC, some good info about how to execute an SSIS package in Windows PowerShell, and then the finale: how to execute packages from Transact-SQL.

Highlights from this video:
  • What syntax errors are common in PowerShell when you execute SSIS packages and how to fix them
  • Should you use T-SQL to execute SSIS packages?
  • What are the pros and cons of using DTEXEC vs. TSQL?
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: xp_cmdshell, Surface area configuration, security

posted by Scott Whigham @ 9:55 AM  

New SQL Server Integration Services Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables 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: dts package, execute package

posted by Scott Whigham @ 9:54 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of How to Execute SSIS Packages With C#

Pt. 2 - An Overview of How to Execute SSIS Packages With C# - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with C#. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with C#?
  • What DLLs do I need to reference in my C# project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via C# - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in C#
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: remote package execution, in process, package execution, .NET, C#

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic

Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with Visual Basic. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with Visual Basic?
  • What DLLs do I need to reference in my Visual Basic project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via Visual Basic - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in Visual Basic
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
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: remote package execution, in process, package execution

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: How to Setup a Windows Certificate Authority

How to Setup a Windows Certificate Authority - view details
Windows Certificate Services allows us to setup our own internal certificate authority so that we can issue digital certificates for internal applications. You typically do not want to use an internally-generated certificate for public-facing applications; your internal certificate authority will only really be used in-house (in your own company). This videos shows you how to install a local certificate authority which boosts your Windows Server security and your network security.

Highlights from this video:
  • Using Add/Remove Programs to add Microsoft Certificate Services
  • What are the various types of certificate authorities in Windows 2003?
  • Should I choose an Enterprise root CA, Enterprise subordinate CA, Stand-alone root CA, or Stand-alone subordinate CA?
  • Understanding the custom settings of certificates
  • Encryption options and key/value pairs in your CA (md5, SHA-1, etc)
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: security, md5, SHA-1

posted by Scott Whigham @ 4:35 AM  

Tuesday, September 25, 2007

New SQL Server Integration Services Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 2:01 PM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic, C#

posted by Scott Whigham @ 1:58 PM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic

Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with Visual Basic. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with Visual Basic?
  • What DLLs do I need to reference in my Visual Basic project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via Visual Basic - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in Visual Basic
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: remote package execution, in process, package execution, .NET, VB.NET, Visual Basic

posted by Scott Whigham @ 1:55 PM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of How to Execute SSIS Packages With C#

Pt. 2 - An Overview of How to Execute SSIS Packages With C# - view details
This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with C#. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:
  • Can I execute SSIS packages remotely with C#?
  • What DLLs do I need to reference in my C# project to execute an SSIS package?
  • Why does everything still say 'DTS'? I thought that was long gone...
  • What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  • What's a DtsServer anyway?
  • How to execute an SSIS package via C# - stored in the msdb SQL Server database
  • How to execute a file-based SSIS package in C#
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: remote package execution, in process, package execution, .NET, C#

posted by Scott Whigham @ 1:51 PM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
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: remote package execution, in process, package execution

posted by Scott Whigham @ 1:50 PM  

Saturday, September 22, 2007

New Windows 2003 Video Tutorial: How to Tweak the BOOT.INI File to Simulate One Less Processor and Less RAM

How to Tweak the BOOT.INI File to Simulate One Less Processor and Less RAM - view details
This is an awesome tip/trick from our resident Windows guru, Grant Moyle. Grant shows us how to force our operating system to show us 1 CPU, 512MB RAM and more with nothing more than modifications of the BOOT.INI file. Ever wondered what's in BOOT.INI? This video explains the multi(0)disk(0)rdisk(0)partition(1) switches and the fastdetect switch and much more.

All serious administrators will want to know this trick.
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: boot, safe mode

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers

Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers - view details
This video highlights the use of a few stored procedures and scripts to help migrate the logins including using sp_hexadecimal and sp_help_rev_login.
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: How to Install Windows Vista Ultimate Edition

How to Install Windows Vista Ultimate Edition - view details
This video shows you the basics of installing Windows Vista Ultimate Edition, the most likely version of Vista that a professional will want to run at home. This video walks you through the entire installation from start to finish and features a great discussion of the entire process - you'll learn the insider's terms for all the screens, the 'behind the scenes' 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: windows xp, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for d

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Adding a New Disk to Your Windows 2003 Cluster

Adding a New Disk to Your Windows 2003 Cluster - view details
Once you have your cluster up and running, there may be a point in time when you need to add a new disk (or RAID array) to this cluster. This video shows you how to add a new disk to your cluster easily and in a very understandable manner.

Highlights from this video:
  • How to add new disk(s) to a Windows cluster
  • Should my LUNs be added before or after?
  • What steps need to be taken before I try to add the new disk?
  • Adding disks to your cluster group
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: clustering, failover, disaster recovery, raid 1, raid 5, raid 10, raid 0

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Create a Shortcut to a Blank Screen or a Screensaver

Create a Shortcut to a Blank Screen or a Screensaver - view details
In this short video, Grant Moyle (our author) shows you how to create a shortcut that pops up a blank screen or a screensaver. This is really useful if you use PowerPoint or if you give presentations and you want to blank the screen or to show a quick screensaver.

This is a great tip for Windows users and admins alike!

Highlights from this video:
  • Screensaver files and creating shortcuts
  • how to assign key stroke combinations to cut to a blank screen (using your new shortcut)
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: An Explanation of the Windows Boot Menu (Hit F8 During Startup)

An Explanation of the Windows Boot Menu (Hit F8 During Startup) - view details
This video is a quick introduction to using the F8 button to get to the boot menu and an explanation of the various options of the boot menu. Want to learn how to get to Safe Mode? Run Windows without Networking? Watch this video!
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: boot, safe mode

posted by Scott Whigham @ 4:35 AM  

Friday, September 21, 2007

New SQL Server 2005 Video Tutorial: Pt. 3 - The Cleanup History, Execute SQL Server Agent job, and Back Up Database Tasks

Pt. 3 - The Cleanup History, Execute SQL Server Agent job, and Back Up Database Tasks - view details
This video finishes off the discussion on the individual tasks and ties on with Parts 1 and 2 in this series as the final video on choosing the tasks in the Maintenance Plan Wizard. After watching this video, you'll understand the intricacies of the Cleanup History Task, the SQL Server Agent job Task, and the individual Back Up Database tasks (the Full, Differential, and the Transaction Log).

Included in this video are discussions on how often you should run the Cleanup History Task and how the SQL Server Agent job Task can work in conjunction with your existing jobs. This is definitely one of the best improvements to the Maintenance Plan architecture and allows your maintenance plans to be extensible beyond anything that was available in the SQL Server 7.0 or 2000 Database Maintenance Plans.

Of course, the main features of the Maintenance Plans that most people will use are the Back up Database tasks. This gives us the option for scheduling our full backups, differentials and transaction log backups. Job Schedules for maintaining backups are included and you'll see how the text file reports are generated as well as how the Maintenance Plan Wizard can create separate files for each backup with a time-stamp (DatabaseName_yyyymmddhhmmss.bak, for example).
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: schedule log backup, maintenance plan backup, how to backup sql server database, cleanup history, how to schedule sql server bac

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers

Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers - view details
This video helps you synchronize the logins by matching up SIDs in the sysusers and SIDs in the server_principals (syslogins) views.

Highlights from this video:
  • sys.sysusers catalog view
  • Using sp_change_users_login REPORT, AUTO_FIX and the gotchas of said stored proc
  • Why AUTO_FIX may do more harm than good
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options)

Pt. 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options) - view details
Continuing our discussion on SQL Server 2005 Maintenance Plan tasks in the wizard, this video gives a nice overview of the index-related tasks, the 'Rebuild Index', 'Reorganize Index' and the 'Update Statistics' tasks.

Scott Whigham, author of LearnSqlServer.com, walks you through a simple-to-understand discussion of how index fragmentation works, how data-distribution statistics are calculated and why tasks such as the Rebuild Index tasks are vitally important to the health of your SQL Server. Included in this video is a discussion of online defragmentation vs. offline defragmentation and a quick overview of the new ALTER INDEX ... WITH REBUILD or WITH REORGANIZE (instead of the DBCC DBREINDEX and DBCC INDEXDEFRAG).

Also included in this video is a discussion of how often you should run these tasks along with the impact that each task will have on your server and users. You'll also understand why fragmentation occurs and how these tasks can help your database run faster.
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: index defragmentation, index defrag, how to defragment indexes, defragment sql server, alter index, dbcc

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans

Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans - view details
Maintenance Plans (and the Maintenance Plan Wizard) are not new in SQL Server; Microsoft introduced Maintenance Plans in SQL Server 7.0 as a great way to automatically schedule common DBA tasks such as backups. In SQL Server 2005, Microsoft has really listened to its customers and vastly improved the Maintenance Plans (and wizard). If you've used Maintenance Plans in the past, things have changed considerably but for the good.

This video walks you through (1) what maintenance plans are, (2) launching the Maintenance Plan Wizard, and the basic choices of the wizard. There are so many choices in the Maintenance Plan Wizard that this video can only cover so many; the remaining videos of the series will help you walk through all of the choices in the maintenance plans. This particular video focuses on the "Check Database Integrity" choice including a walk-through of DBCC CHECKDB and what impact selecting this option may have on your server and a discussion on how often you'll want to schedule this option.

Another option covered in this video is the "Shrink Database" task along with Scott Whigham's discussion of Best Practices for shrinking databases.
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 server maintenance plan, maintenance plans, maintenance plan task, maintenance plan wizard

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - Modifying Maintenance Plans

Pt. 4 - Modifying Maintenance Plans - view details
One of the most exciting improvements to Maintenance Plans in SQL Server 2005 is the SSIS-based interface that you get when you modify the Maintenance Plans. This interface will allow you to create very intricate Maintenance Plans that go well beyond the wizard's basic functionality. You can add Operator notifications (i.e., send an email to an Operator whenever a Maintenance Plan task fails), add complex error handling or any type of auditing/SQL/etc.

This video is just an overview of how to modify the Maintenance Plans along with a quick walk-through of the drag-and-drop features of the SSIS interface. It does not go too deep, however, since you need some familiarity with SSIS to really expose the more interesting/flexible parts of the Maintenance Plan.

One suggestion: watch this series in conjunction with some of our introductory videos on SSIS to get the most out of your Maintenance Plans.
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: edit maintenance plan, schedule maintenance plan

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins)

Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins) - view details
This video shows you the underlying architecture of logins in SQL Server, both for SQL Server authentication logins and for Windows logins. This video also shows you the challenges of migrating logins between separate SQL Servers.

Highlights from this video:
  • Using system objects and catalog views to learn SQL Server architecture
  • Understanding sys.server_principals and sys.syslogins
  • What are SIDs and how are they used internally?
  • CREATE LOGIN scripts and syntax
  • Understanding the process of migrating/synchronizing logins
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - Issues With SIDs, Server Logins, Principals and Users

Pt. 4 - Issues With SIDs, Server Logins, Principals and Users - view details
More on using sp_change_users_login including more discussions why AUTO_FIX is often evil as well as discussion of using UPDATE_ONE.

Highlights from this video:
  • Options available for migrating logins
  • Should I use SSIS's Transfer Logins Task or Transfer Database Task to migrate my logins?
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Using Integration Services (SSIS) to Migrate Tables from Access to SQL Server 2005

Pt. 3 - Using Integration Services (SSIS) to Migrate Tables from Access to SQL Server 2005 - view details
This video walks you through how to migrate tables from Access 2007/2003/2000 to SQL Server 2005 using SQL Server Integration Services (SSIS).

Highlights from this video:
  • Using the Import/Export Wizard in SSIS
  • Using BIDS (SQL Server Business Intelligence Development Studio) to create and manage SSIS packages
  • Creating custom packages for migrating Access to SQL Server
  • Common problems when migrating from Access to SQL Server 2005
  • Customizing the transformations to avoid datatype mismatch errors (i.e., Unicode to non-unicode string transformation errors)
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: transformations, DT_R4, DT_I4

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - How to Synchronize Logins Between Two Servers

Pt. 1 - How to Synchronize Logins Between Two Servers - view details
One of the more confusing topics for people coming into SQL Server - even if you have a lot of experience with other database management systems like Oracle, DB2, MySQL, etc - is how to move a database from Server A to Server B (or Instance A to Instance B) and how to keep the logins in sync. This video, part 1 in our series on how to sync logins between servers in SQL Server, covers the scenario, the reason we need to know this, and gets into a little bit of SQL Server security architecture.

Highlights from this video:
  • How to view the orphaned logins (those Without Login)
  • How SIDs work as well as what sys.server_principals and sys.syslogins are
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 3 - A Stored Procedure and Function to Return All Objects in a Given Schema

Pt. 3 - A Stored Procedure and Function to Return All Objects in a Given Schema - view details
Now that you have dbo.Split() created, you'll want to use it, right? This video shows you one of Scott Whigham's scripts for returning all objects in a schema. This uses dbo.Split(), the dbo.SequenceNumbers table from Part 1 of this series, and sys.objects to return all of the objects in specified schema.

So why is this stored proc/function here in our discussion of a table of numbers and how to work with arrays? The GetObejctsInSchema stored proc has a parameter, @ObjectTypesToExclude, that allows you to specify the object types you do not want to see. You then use dbo.Split() to return each as an element and then pass your array to a NOT IN statement!
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: arrays, sequence numbers, csv, comma separated values

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - How to Work With Arrays and Split() Functions in SQL Server

Pt. 2 - How to Work With Arrays and Split() Functions in SQL Server - view details
This video shows you one technique for working with arrays in SQL (such as a,b,c,d,e,f,g,h) and it uses a table of numbers as its 'base'.

Highlights from this video:
  • What are arrays? Why would we need them in SQL?
  • What are the elements of an array?
  • Understanding the algorithm for the dbo.Split() function
  • Working with CSV values (comma separated values)
  • Explanations of CHARINDEX, SUBSTRING, LEFT, RIGHT, LEN, and REPLACE functions
and much more

N.B. Included in this video download are the script files to create your own Split() function
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: arrays, sequence numbers, csv, comma separated values

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 3 - Best Practices for Using Schemas and How to Transfer Objects to New Schema

Pt. 3 - Best Practices for Using Schemas and How to Transfer Objects to New Schema - view details
Should you use schemas? What are the best practices for using SQL schemas? And just exactly how do you move an object from one schema to another? This video helps you answer those questions and 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: schemas, dbo, object owners

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - Default Schemas and How SQL Server Performs Naming Resolution

Pt. 2 - Default Schemas and How SQL Server Performs Naming Resolution - view details
Okay - quick quiz: you have two tables, dbo.ErrorLog and dev.ErrorLog, and you login to your SQL Server and you execute the query, 'SELECT * FROM ErrorLog'. Which table will you see?

dbo?

dev?

How do you know that your answer is correct?

The answer really is, 'Well it depends on what my default schema is'!

Highlights from this video:
  • What is a default schema?
  • What happens if I don't assign a default schema?
  • What is the default, default schema?
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: schemas, dbo, object owners

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: How to Boot Windows Into Safe Mode From the Command Prompt

How to Boot Windows Into Safe Mode From the Command Prompt - view details
This video shows you how to use the Windows Boot menu to get you to a command prompt and not to Windows Explorer (explorer.exe). This is useful for troubleshooting difficult problems.

This video is for serious administrators only!
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: boot, safe mode

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 4 - A Stored Procedure to Search for a String Value in All Columns in a Database

Pt. 4 - A Stored Procedure to Search for a String Value in All Columns in a Database - view details
The last video in this series is Scott Whigham dissecting another of his scripts, the dbo.SearchForTermInAllStringColumnsInDatabase stored procedure. This uses dbo.Split() to parse the @IgnoreColumns parameter which means you need the table of numbers and the dbo.Split() function yet again.
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: arrays, sequence numbers, csv, comma separated values

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - How to Create and Use a Table of Numbers to Find Gaps in Another Table

Pt. 1 - How to Create and Use a Table of Numbers to Find Gaps in Another Table - view details
In this video, Scott Whigham lets you in on one of the SQL developer's secrets: using a table of numbers (i.e., a numbers table). This video shows you how to create a numbers table as well as reasons to use it and how to use it to locate gaps in a sequence of numbers. Example: you have an Accounts table and you want to find all of the missing CheckNumber values in what should have been a sequential list of numbers.

Highlights from this video:
  • How to create a table of numbers
  • How to spot gaps in a numbered sequence
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: gaps, numbers, numeric, sequences, identity

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: How to Restore a SharePoint Site From the Command Line But to a Different Site/Url/Port

How to Restore a SharePoint Site From the Command Line But to a Different Site/Url/Port - view details
This is a very advanced video - it shows you how to restore your SharePoint backups to a different location/site/Port/Url. This way you have the data twice: the current 'live' data and this new copy of the data (perfect for doing a partial restore or verifying your restores).
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: backup, disaster recovery, job scheduling, automation

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008

Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008 - view details
One of the challenging things anyone coming into SQL Server faces is trying to figure out which version of the word 'schema' someone is using at any given time. Example: 'You need to put the Person schema in the People schema inside your database schema' is a perfectly legitimate instruction but the word schema means three different things in that sentence!

So which 'version' of the word schema does this video talk about? The second version.

:)

Okay, okay - this video talks about the container-type of schema (#1 was an Xml schema Collection and #3 was a Database Schema).

Highlights from this video:
  • What are schemas? What are containers?
  • How are schemas used?
  • Should I use schemas?
  • What about schemas like db_owner, db_ddladmin, et al - is it safe to remove those?
  • Where should I put my schemas?
  • I'm upgrading from SQL Server 2000 to 2005/2008 - what is different between users, object owners, and schemas?
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: security, users, tables, stored procedures, triggers, functions

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: How to Setup a Windows Certificate Authority

How to Setup a Windows Certificate Authority - view details
Windows Certificate Services allows us to setup our own internal certificate authority so that we can issue digital certificates for internal applications. You typically do not want to use an internally-generated certificate for public-facing applications; your internal certificate authority will only really be used in-house (in your own company). This videos shows you how to install a local certificate authority which boosts your Windows Server security and your network security.

Highlights from this video:
  • Using Add/Remove Programs to add Microsoft Certificate Services
  • What are the various types of certificate authorities in Windows 2003?
  • Should I choose an Enterprise root CA, Enterprise subordinate CA, Stand-alone root CA, or Stand-alone subordinate CA?
  • Understanding the custom settings of certificates
  • Encryption options and key/value pairs in your CA (md5, SHA-1, etc)
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: security, md5, SHA-1

posted by Scott Whigham @ 4:30 AM  

New Windows 2003 Video Tutorial: How to Install Windows Vista Ultimate Edition

How to Install Windows Vista Ultimate Edition - view details
This video shows you the basics of installing Windows Vista Ultimate Edition, the most likely version of Vista that a professional will want to run at home. This video walks you through the entire installation from start to finish and features a great discussion of the entire process - you'll learn the insider's terms for all the screens, the 'behind the scenes' 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: windows xp, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for d

posted by Scott Whigham @ 4:22 AM  

New Windows 2003 Video Tutorial: Adding a New Disk to Your Windows 2003 Cluster

Adding a New Disk to Your Windows 2003 Cluster - view details
Once you have your cluster up and running, there may be a point in time when you need to add a new disk (or RAID array) to this cluster. This video shows you how to add a new disk to your cluster easily and in a very understandable manner.

Highlights from this video:
  • How to add new disk(s) to a Windows cluster
  • Should my LUNs be added before or after?
  • What steps need to be taken before I try to add the new disk?
  • Adding disks to your cluster group
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: clustering, failover, disaster recovery, raid 1, raid 5, raid 10, raid 0

posted by Scott Whigham @ 4:20 AM  

Thursday, September 20, 2007

New Windows 2003 Video Tutorial: Create a Shortcut to a Blank Screen or a Screensaver

Create a Shortcut to a Blank Screen or a Screensaver - view details
In this short video, Grant Moyle (our author) shows you how to create a shortcut that pops up a blank screen or a screensaver. This is really useful if you use PowerPoint or if you give presentations and you want to blank the screen or to show a quick screensaver.

This is a great tip for Windows users and admins alike!

Highlights from this video:
  • Screensaver files and creating shortcuts
  • how to assign key stroke combinations to cut to a blank screen (using your new shortcut)
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 1:15 PM  

New Windows 2003 Video Tutorial: How to Tweak the BOOT.INI File to Simulate One Less Processor and Less RAM

How to Tweak the BOOT.INI File to Simulate One Less Processor and Less RAM - view details
This is an awesome tip/trick from our resident Windows guru, Grant Moyle. Grant shows us how to force our operating system to show us 1 CPU, 512MB RAM and more with nothing more than modifications of the BOOT.INI file. Ever wondered what's in BOOT.INI? This video explains the multi(0)disk(0)rdisk(0)partition(1) switches and the fastdetect switch and much more.

All serious administrators will want to know this trick.
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: boot, safe mode

posted by Scott Whigham @ 1:08 PM  

New Windows 2003 Video Tutorial: An Explanation of the Windows Boot Menu (Hit F8 During Startup)

An Explanation of the Windows Boot Menu (Hit F8 During Startup) - view details
This video is a quick introduction to using the F8 button to get to the boot menu and an explanation of the various options of the boot menu. Want to learn how to get to Safe Mode? Run Windows without Networking? Watch this video!
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: boot, safe mode

posted by Scott Whigham @ 1:04 PM  

New Windows 2003 Video Tutorial: How to Boot Windows Into Safe Mode From the Command Prompt

How to Boot Windows Into Safe Mode From the Command Prompt - view details
This video shows you how to use the Windows Boot menu to get you to a command prompt and not to Windows Explorer (explorer.exe). This is useful for troubleshooting difficult problems.

This video is for serious administrators only!
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: boot, safe mode

posted by Scott Whigham @ 1:01 PM  

New Transact SQL Video Tutorial: Pt. 4 - A Stored Procedure to Search for a String Value in All Columns in a Database

Pt. 4 - A Stored Procedure to Search for a String Value in All Columns in a Database - view details
The last video in this series is Scott Whigham dissecting another of his scripts, the dbo.SearchForTermInAllStringColumnsInDatabase stored procedure. This uses dbo.Split() to parse the @IgnoreColumns parameter which means you need the table of numbers and the dbo.Split() function yet again.
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: arrays, sequence numbers, csv, comma separated values

posted by Scott Whigham @ 12:18 PM  

New Transact SQL Video Tutorial: Pt. 3 - A Stored Procedure and Function to Return All Objects in a Given Schema

Pt. 3 - A Stored Procedure and Function to Return All Objects in a Given Schema - view details
Now that you have dbo.Split() created, you'll want to use it, right? This video shows you one of Scott Whigham's scripts for returning all objects in a schema. This uses dbo.Split(), the dbo.SequenceNumbers table from Part 1 of this series, and sys.objects to return all of the objects in specified schema.

So why is this stored proc/function here in our discussion of a table of numbers and how to work with arrays? The GetObejctsInSchema stored proc has a parameter, @ObjectTypesToExclude, that allows you to specify the object types you do not want to see. You then use dbo.Split() to return each as an element and then pass your array to a NOT IN statement!
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: arrays, sequence numbers, csv, comma separated values

posted by Scott Whigham @ 12:18 PM  

New Transact SQL Video Tutorial: Pt. 2 - How to Work With Arrays and Split() Functions in SQL Server

Pt. 2 - How to Work With Arrays and Split() Functions in SQL Server - view details
This video shows you one technique for working with arrays in SQL (such as a,b,c,d,e,f,g,h) and it uses a table of numbers as its 'base'.

Highlights from this video:
  • What are arrays? Why would we need them in SQL?
  • What are the elements of an array?
  • Understanding the algorithm for the dbo.Split() function
  • Working with CSV values (comma separated values)
  • Explanations of CHARINDEX, SUBSTRING, LEFT, RIGHT, LEN, and REPLACE functions
and much more

N.B. Included in this video download are the script files to create your own Split() function
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: arrays, sequence numbers, csv, comma separated values

posted by Scott Whigham @ 12:17 PM  

New Transact SQL Video Tutorial: Pt. 1 - How to Create and Use a Table of Numbers to Find Gaps in Another Table

Pt. 1 - How to Create and Use a Table of Numbers to Find Gaps in Another Table - view details
In this video, Scott Whigham lets you in on one of the SQL developer's secrets: using a table of numbers (i.e., a numbers table). This video shows you how to create a numbers table as well as reasons to use it and how to use it to locate gaps in a sequence of numbers. Example: you have an Accounts table and you want to find all of the missing CheckNumber values in what should have been a sequential list of numbers.

Highlights from this video:
  • How to create a table of numbers
  • How to spot gaps in a numbered sequence
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: gaps, numbers, numeric, sequences, identity

posted by Scott Whigham @ 12:17 PM  

New Transact SQL Video Tutorial: Pt. 3 - Best Practices for Using Schemas and How to Transfer Objects to New Schema

Pt. 3 - Best Practices for Using Schemas and How to Transfer Objects to New Schema - view details
Should you use schemas? What are the best practices for using SQL schemas? And just exactly how do you move an object from one schema to another? This video helps you answer those questions and 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: schemas, dbo, object owners

posted by Scott Whigham @ 10:56 AM  

New Transact SQL Video Tutorial: Pt. 2 - Default Schemas and How SQL Server Performs Naming Resolution

Pt. 2 - Default Schemas and How SQL Server Performs Naming Resolution - view details
Okay - quick quiz: you have two tables, dbo.ErrorLog and dev.ErrorLog, and you login to your SQL Server and you execute the query, 'SELECT * FROM ErrorLog'. Which table will you see?

dbo?

dev?

How do you know that your answer is correct?

The answer really is, 'Well it depends on what my default schema is'!

Highlights from this video:
  • What is a default schema?
  • What happens if I don't assign a default schema?
  • What is the default, default schema?
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: schemas, dbo, object owners

posted by Scott Whigham @ 10:56 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008

Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008 - view details
One of the challenging things anyone coming into SQL Server faces is trying to figure out which version of the word 'schema' someone is using at any given time. Example: 'You need to put the Person schema in the People schema inside your database schema' is a perfectly legitimate instruction but the word schema means three different things in that sentence!

So which 'version' of the word schema does this video talk about? The second version.

:)

Okay, okay - this video talks about the container-type of schema (#1 was an Xml schema Collection and #3 was a Database Schema).

Highlights from this video:
  • What are schemas? What are containers?
  • How are schemas used?
  • Should I use schemas?
  • What about schemas like db_owner, db_ddladmin, et al - is it safe to remove those?
  • Where should I put my schemas?
  • I'm upgrading from SQL Server 2000 to 2005/2008 - what is different between users, object owners, and schemas?
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: security, users, tables, stored procedures, triggers, functions

posted by Scott Whigham @ 10:56 AM  

Wednesday, September 19, 2007

New SharePoint Video Tutorial: How to Restore a SharePoint Site From the Command Line Using STSADM.exe

How to Restore a SharePoint Site From the Command Line Using STSADM.exe - view details
In a previous video (How to Backup a SharePoint Site From the Command Line Using STSADM.exe), you learned how to do the backups. This video shows you how to restore those backups. What more of a description could we write?

Link: How to Backup a SharePoint Site From the Command Line Using STSADM.exe
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: backup, disaster recovery, job scheduling, automation

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: How to Backup Your SharePoint Site(s) With STSADM.exe

How to Backup Your SharePoint Site(s) With STSADM.exe - view details
One of the most important things you can do is to frequently backup your SharePoint site(s). One of the ways you can do this is to use the command line utility, stsadm.exe. This video covers advanced backup and administration of SharePoint and does require a solid understanding of how to use the command line/DOS.

Highlights from this video:
  • Where is stsadm.exe?
  • What does stsadm.exe do?\
  • The switches needed to backup your SharePoint site with stsadm
  • How to create a batch file that backs up your SharePoint site
  • How to schedule a task (job) that will backup your SharePoint site
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: backup, disaster recovery, job scheduling, automation

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Create and Manage Shared Calendars

Create and Manage Shared Calendars - view details
One really useful capability in SharePoint 2007 is the ability to create Shared Calendars, sometthing that, if you're coming from the Microsoft Exchange world and you're starting to roll out Exchange 2007, you realize that the idea of having Shared Calendars is missing in Exchange 2007 - all because Microsoft wants you to use SharePoint for this type of collaboration.

Highlights from this video:
  • Learn how to create new calendars
  • Setting up email alerts when calendar items are added/deleted/changed
  • Creating calendar views (i.e., how to view by week, month, day, etc)
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: shared calendars, exchange, email, alerts

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Creating and Working With Contacts in SharePoint

Creating and Working With Contacts in SharePoint - view details
When you first start working with SharePoint, you'll find that Microsoft starts you out with some of the common types of data collection tools you'll utilitize in a shared environment. They start you off with the Shared Documents, Calendar and Tasks, all listed under Lists. This video shows you how to add in a shared contacts List.
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: shared contacts

posted by Scott Whigham @ 8:35 AM  

New Windows 2003 Video Tutorial: Pt. 5 - How Pipelines Work in Windows PowerShell

Pt. 5 - How Pipelines Work in Windows PowerShell - view details
One of the powerful features of Windows PowerShell is the ability to 'pipeline', or to string a series of commands together. This video helps you understand how to do even more with Windows PowerShell.
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 8:35 AM  

New SharePoint Video Tutorial: Creating and Working With Contacts in SharePoint

Creating and Working With Contacts in SharePoint - view details
When you first start working with SharePoint, you'll find that Microsoft starts you out with some of the common types of data collection tools you'll utilitize in a shared environment. They start you off with the Shared Documents, Calendar and Tasks, all listed under Lists. This video shows you how to add in a shared contacts List.
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: shared contacts

posted by Scott Whigham @ 4:52 AM  

New SharePoint Video Tutorial: Create and Manage Shared Calendars

Create and Manage Shared Calendars - view details
One really useful capability in SharePoint 2007 is the ability to create Shared Calendars, sometthing that, if you're coming from the Microsoft Exchange world and you're starting to roll out Exchange 2007, you realize that the idea of having Shared Calendars is missing in Exchange 2007 - all because Microsoft wants you to use SharePoint for this type of collaboration.

Highlights from this video:
  • Learn how to create new calendars
  • Setting up email alerts when calendar items are added/deleted/changed
  • Creating calendar views (i.e., how to view by week, month, day, etc)
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: shared calendars, exchange, email, alerts

posted by Scott Whigham @ 4:51 AM  

New SharePoint Video Tutorial: How to Restore a SharePoint Site From the Command Line But to a Different Site/Url/Port

How to Restore a SharePoint Site From the Command Line But to a Different Site/Url/Port - view details
This is a very advanced video - it shows you how to restore your SharePoint backups to a different location/site/Port/Url. This way you have the data twice: the current 'live' data and this new copy of the data (perfect for doing a partial restore or verifying your restores).
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: backup, disaster recovery, job scheduling, automation

posted by Scott Whigham @ 4:50 AM  

New SharePoint Video Tutorial: How to Restore a SharePoint Site From the Command Line Using STSADM.exe

How to Restore a SharePoint Site From the Command Line Using STSADM.exe - view details
In a previous video (How to Backup a SharePoint Site From the Command Line Using STSADM.exe), you learned how to do the backups. This video shows you how to restore those backups. What more of a description could we write?

Link: How to Backup a SharePoint Site From the Command Line Using STSADM.exe
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: backup, disaster recovery, job scheduling, automation

posted by Scott Whigham @ 4:47 AM  

New SharePoint Video Tutorial: How to Backup Your SharePoint Site(s) With STSADM.exe

How to Backup Your SharePoint Site(s) With STSADM.exe - view details
One of the most important things you can do is to frequently backup your SharePoint site(s). One of the ways you can do this is to use the command line utility, stsadm.exe. This video covers advanced backup and administration of SharePoint and does require a solid understanding of how to use the command line/DOS.

Highlights from this video:
  • Where is stsadm.exe?
  • What does stsadm.exe do?\
  • The switches needed to backup your SharePoint site with stsadm
  • How to create a batch file that backs up your SharePoint site
  • How to schedule a task (job) that will backup your SharePoint site
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: backup, disaster recovery, job scheduling, automation

posted by Scott Whigham @ 4:45 AM  

Friday, September 7, 2007

New Windows 2003 Video Tutorial: Pt 2. - Writing Your First PowerShell Script

Pt 2. - Writing Your First PowerShell Script - view details
In this video, Grant Moyle walks you through using PowerShell for your first script - pretty simple really.

Highlights from this video:
  • Using write-warning, Set-ItemProperty, -path, HKLM and generating code comments
  • Using start-sleep and launching applications from PowerShell
  • Writing a ps1 PowerShell script
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Pt. 4 - Understanding How Aliases Work in PowerShell (for both Windows and *NIX)

Pt. 4 - Understanding How Aliases Work in PowerShell (for both Windows and *NIX) - view details
One of the things that Microsoft is trying to accomplish with Windows PowerShell is for administrators to be able to manage Windows from the command prompt, even if Windows isn't necessarily their first-choice operating system. This video shows you how to leverage your UNIX/LINUX knowledge to manage your Windows environment with PowerShell!
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: scripting, wmi, vbs, batch files, dos prompt, command prompt, redhat, mandrake, solaris

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Pt. 3 - How to Work With files and Folders With Windows PowerShell

Pt. 3 - How to Work With files and Folders With Windows PowerShell - view details
File and Folder manipulation is quite easy in Windows PowerShell. This video takes you through the basics of working with files and folders with PowerShell.

Highlights from this video:
  • Using copy-item (and even get-help)
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Pt. 1 - Windows PowerShell - A Quick Introduction to PowerShell and How to Install

Pt. 1 - Windows PowerShell - A Quick Introduction to PowerShell and How to Install - view details
In preparation for Windows 2008 and Exchange 2007, Microsoft has released Windows PowerShell - their brand new scripting and automation language and tool. You'll need to download this from Microsoft's website (Windows PowerShell) but, once you do, you'll be very happy (after learning how to use it of course). The future of a lot of Windows administration is moving more and more to the command line and scripting so this video series is a great start for your future!
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers

Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers - view details
This video highlights the use of a few stored procedures and scripts to help migrate the logins including using sp_hexadecimal and sp_help_rev_login.
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 4:35 AM  

Thursday, September 6, 2007

New Windows 2003 Video Tutorial: Pt. 5 - How Pipelines Work in Windows PowerShell

Pt. 5 - How Pipelines Work in Windows PowerShell - view details
One of the powerful features of Windows PowerShell is the ability to 'pipeline', or to string a series of commands together. This video helps you understand how to do even more with Windows PowerShell.
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 9:53 AM  

New Windows 2003 Video Tutorial: Pt. 4 - Understanding How Aliases Work in PowerShell (for both Windows and *NIX)

Pt. 4 - Understanding How Aliases Work in PowerShell (for both Windows and *NIX) - view details
One of the things that Microsoft is trying to accomplish with Windows PowerShell is for administrators to be able to manage Windows from the command prompt, even if Windows isn't necessarily their first-choice operating system. This video shows you how to leverage your UNIX/LINUX knowledge to manage your Windows environment with PowerShell!
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: scripting, wmi, vbs, batch files, dos prompt, command prompt, redhat, mandrake, solaris

posted by Scott Whigham @ 9:53 AM  

New Windows 2003 Video Tutorial: Pt. 3 - How to Work With files and Folders With Windows PowerShell

Pt. 3 - How to Work With files and Folders With Windows PowerShell - view details
File and Folder manipulation is quite easy in Windows PowerShell. This video takes you through the basics of working with files and folders with PowerShell.

Highlights from this video:
  • Using copy-item (and even get-help)
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 9:53 AM  

New Windows 2003 Video Tutorial: Pt 2. - Writing Your First PowerShell Script

Pt 2. - Writing Your First PowerShell Script - view details
In this video, Grant Moyle walks you through using PowerShell for your first script - pretty simple really.

Highlights from this video:
  • Using write-warning, Set-ItemProperty, -path, HKLM and generating code comments
  • Using start-sleep and launching applications from PowerShell
  • Writing a ps1 PowerShell script
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 9:53 AM  

New Windows 2003 Video Tutorial: Pt. 1 - Windows PowerShell - A Quick Introduction to PowerShell and How to Install

Pt. 1 - Windows PowerShell - A Quick Introduction to PowerShell and How to Install - view details
In preparation for Windows 2008 and Exchange 2007, Microsoft has released Windows PowerShell - their brand new scripting and automation language and tool. You'll need to download this from Microsoft's website (Windows PowerShell) but, once you do, you'll be very happy (after learning how to use it of course). The future of a lot of Windows administration is moving more and more to the command line and scripting so this video series is a great start for your future!
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: scripting, wmi, vbs, batch files, dos prompt, command prompt

posted by Scott Whigham @ 9:52 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers

Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers - view details
This video helps you synchronize the logins by matching up SIDs in the sysusers and SIDs in the server_principals (syslogins) views.

Highlights from this video:
  • sys.sysusers catalog view
  • Using sp_change_users_login REPORT, AUTO_FIX and the gotchas of said stored proc
  • Why AUTO_FIX may do more harm than good
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins)

Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins) - view details
This video shows you the underlying architecture of logins in SQL Server, both for SQL Server authentication logins and for Windows logins. This video also shows you the challenges of migrating logins between separate SQL Servers.

Highlights from this video:
  • Using system objects and catalog views to learn SQL Server architecture
  • Understanding sys.server_principals and sys.syslogins
  • What are SIDs and how are they used internally?
  • CREATE LOGIN scripts and syntax
  • Understanding the process of migrating/synchronizing logins
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - How to Synchronize Logins Between Two Servers

Pt. 1 - How to Synchronize Logins Between Two Servers - view details
One of the more confusing topics for people coming into SQL Server - even if you have a lot of experience with other database management systems like Oracle, DB2, MySQL, etc - is how to move a database from Server A to Server B (or Instance A to Instance B) and how to keep the logins in sync. This video, part 1 in our series on how to sync logins between servers in SQL Server, covers the scenario, the reason we need to know this, and gets into a little bit of SQL Server security architecture.

Highlights from this video:
  • How to view the orphaned logins (those Without Login)
  • How SIDs work as well as what sys.server_principals and sys.syslogins are
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - Issues With SIDs, Server Logins, Principals and Users

Pt. 4 - Issues With SIDs, Server Logins, Principals and Users - view details
More on using sp_change_users_login including more discussions why AUTO_FIX is often evil as well as discussion of using UPDATE_ONE.

Highlights from this video:
  • Options available for migrating logins
  • Should I use SSIS's Transfer Logins Task or Transfer Database Task to migrate my logins?
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: How to Change the Master Database's File Locations

How to Change the Master Database's File Locations - view details
Do you need to know how to move the master database? How to move the master database data file or log file? Then this video is for you! It's short, it's quick and to the point, and it gives you exactly what you need to know to move the SQL Server system database master database files.

Highlights from this video:
  • How to edit the server configuration to move the files in SQL Server 2005 and SQL Server 2008
  • Registry changes
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: service, mssqlserver, configuration manager

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 5 - How to Setup and Configure Your First NUnit Project

Pt. 5 - How to Setup and Configure Your First NUnit Project - view details
Pt. 5 - How to Setup and Configure Your First NUnit Project
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: Pt. 5 - How to Setup and Configure Your First NUnit Project

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers

Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers - view details
This video highlights the use of a few stored procedures and scripts to help migrate the logins including using sp_hexadecimal and sp_help_rev_login.
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:23 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins)

Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins) - view details
This video shows you the underlying architecture of logins in SQL Server, both for SQL Server authentication logins and for Windows logins. This video also shows you the challenges of migrating logins between separate SQL Servers.

Highlights from this video:
  • Using system objects and catalog views to learn SQL Server architecture
  • Understanding sys.server_principals and sys.syslogins
  • What are SIDs and how are they used internally?
  • CREATE LOGIN scripts and syntax
  • Understanding the process of migrating/synchronizing logins
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:22 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - Issues With SIDs, Server Logins, Principals and Users

Pt. 4 - Issues With SIDs, Server Logins, Principals and Users - view details
More on using sp_change_users_login including more discussions why AUTO_FIX is often evil as well as discussion of using UPDATE_ONE.

Highlights from this video:
  • Options available for migrating logins
  • Should I use SSIS's Transfer Logins Task or Transfer Database Task to migrate my logins?
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:22 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers

Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers - view details
This video helps you synchronize the logins by matching up SIDs in the sysusers and SIDs in the server_principals (syslogins) views.

Highlights from this video:
  • sys.sysusers catalog view
  • Using sp_change_users_login REPORT, AUTO_FIX and the gotchas of said stored proc
  • Why AUTO_FIX may do more harm than good
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:22 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - How to Synchronize Logins Between Two Servers

Pt. 1 - How to Synchronize Logins Between Two Servers - view details
One of the more confusing topics for people coming into SQL Server - even if you have a lot of experience with other database management systems like Oracle, DB2, MySQL, etc - is how to move a database from Server A to Server B (or Instance A to Instance B) and how to keep the logins in sync. This video, part 1 in our series on how to sync logins between servers in SQL Server, covers the scenario, the reason we need to know this, and gets into a little bit of SQL Server security architecture.

Highlights from this video:
  • How to view the orphaned logins (those Without Login)
  • How SIDs work as well as what sys.server_principals and sys.syslogins are
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: migrate login script, sp_help_revlogin, sp_help_rev_login, sp_helprevlogin

posted by Scott Whigham @ 8:22 AM  

New SQL Server 2005 Video Tutorial: How to Change the Master Database's File Locations

How to Change the Master Database's File Locations - view details
Do you need to know how to move the master database? How to move the master database data file or log file? Then this video is for you! It's short, it's quick and to the point, and it gives you exactly what you need to know to move the SQL Server system database master database files.

Highlights from this video:
  • How to edit the server configuration to move the files in SQL Server 2005 and SQL Server 2008
  • Registry changes
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: service, mssqlserver, configuration manager

posted by Scott Whigham @ 8:07 AM