Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL
                        Training Videos

How to Install and Configure the SQL Server 2005 and C# Sample Applications (Video Series)

Video Image Video Category: The Development Environment - Tools, Code Generation, and More

Skill Level: 200 (Beginner - Intermediate)

Versions/Editions Covered: SQL Server 2005
SQL Server 2005 ships with a plethora of sample applications - way too many to list - and many of them include C# examples. This video series shows you how to install the SQL Server sample apps as well as how to configure/build the C# applications and assemblies.

Videos in this Series:


Miscellaneous Bits & Pieces:
"Collation" is one of the most misunderstood terms in SQL Server. In a nutshell collation defines (a) the characters that are allowed in a column, (b) the way those characters will be sorted in the ORDER BY, and (c) how those characters will be compared (using the WHERE clause, for example)
Which of these queries will perform faster? (a) SELECT * FROM Table WHERE Salary-1000 > 10000 or (b) SELECT * FROM Table WHERE Salary > 9000. (b) will perform faster since (a) would have to calculate (Salary-1000) first and then compare that value to 10000
Security Tip: Do not allow applications to issue SELECT,INSERT,UPDATE, or DELETE statements to your database. Instead create a set of stored procedures and require that your applications use these "interfaces" into your database

Other Websites We Offer
LearnSqlServer.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/20/2008 5:08:56 PM