SQL Server 2008 and using Transact SQL (TSQL)
July 5, 2009 - 12:34 am
http://www.learningsqlserver2008.com/
If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background and the database we will use AdventureWorks2008. We start off with the SELECT statement which is used to return data. The basic syntax is discuss with an e.g. from Person and SalesOrderHeader table. We move onto the INSERT statement using the Person table in the database. The next two statements are UPDATE and DELETE which are very powerful. Using a where clause is extremely important here. We show you how to change data in Person table. (Running time is 32 mins)
Duration : 0:9:17
ISA 2004 is part of SBS 2003 Premium and can be used to control access to web sites. This video demonstrates how to create a new blocking rule using ISA 2004 on SBS 2003 and the results that the rule produces on network workstations.
Guy Kawasaki and other well-known entrepreneurs give advice on how to build a successful mission statement for your small business.