Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Training Videos
SQL Server 2005 Videos in Series Home  Subscriber Videos  

Installing SQL Server 2005 SP2: A Look at the Installation and New Features in Service Pack 2 (Video Series)

Video Image Video Category: Installing, Deploying, and Upgrading to SQL Server 2005

Skill Level: 100 (Beginner)

Versions/Editions Covered: SQL Server 2005
SQL Server 2005's Service Pack 2 (SP2) is full of both bug fixes and new features and this series talks about installing SP2 and previewing the new features.

Highlights from this video series include:
  • An overview of the issues regarding SP2 including  discussions of KB933508 and versions 9.00.3042 (a.k.a. build 3042), 9.00.3043 (build 3043), 9.00.3050 (build 3050)
  • Differences between builds
  • Discussions of how to integrate custom reports in SP2 (a new featuree)
  • Understanding what you need to install
  • An overview of the installation of SQL Server 2005 SP2
  • Installing SP2
  • Discussions of the features and screens of the SP2 installation
  • An overview of how to install KB933508 as well as a look at the new GUI/UI features in SSMS regarding scripting
  • How to write custom reports for SQL Server 2005's SSMS
  • Deploying the reports to the server
  • System requirements for using custom reports
  • Suggestions for using custom reports in SQL 2005

Videos in this Series:


Miscellaneous Bits & Pieces:
You can use the table hint "WITH (NOLOCK)" to minimize the locks you place on resources during a SELECT statement - SELECT * FROM MyTable WITH (NOLOCK) places no "Shared" locks on MyTable
Helpful Keyboard Shortcuts: "Windows key" + "F" brings up the Search window
It is very easy to disable a trigger: ALTER TABLE MyTable DISABLE TRIGGER MyTrigger. If you want to disable all triggers for a table just replace the trigger name with the word ALL. To re-enable the triggers just replace DISABLE with ENABLE

Other Websites We Offer
LearnReportingServices.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/19/2008 5:04:29 PM