Free SQL Server videos

SQL Server 2000 video training:

FREE sql server video samples from the above training series:

Recommended websites on learning sql server 2000

SQL Server 2000 Solution Center
Introduction to Microsoft SQL Server 2000
SQL Server Resources
FREE SQL Server Videos

SQL Server 2008 video training:

FREE sql server videos from the training series:

Installation of sql server 2008 - We kick off this training video series with setting up sql server 2008 enterprise edition running on Windows platform.  First we show you how to get the free ms sql server download from Microsoft's web site.  We also discuss options like installation center, setup support rules and feature selection. (Running time 11 + 23 mins)

SQL 2008 Server configuration manager - In ms sql 2008,  configuration manager is primarily used for setting up sql server 2008 services and managing network protocols. In this sql tutorial, we go over all these topics and also mention some of the industry best practices form a security point of view. (Running time 17 mins)

Using SQL Server Management Studio (SSMS) - SSMS has replaced the enterprise manager from sql 2000. sql server 2008 management studio is an essential tool used equally by SQL developers and SQL DBA's alike. Important tabs like object explorer, security, server objects, replication and management are explained. (Running time 32 mins)

Working with sql server 2008 database -  SQL Databases and tables are at the heart of any relational database management system (RDBMS).  In addition to creating a sql database, we point out other vital options like auto shrink, recovery model, tsql scripts, alter database, template explorer, etc. (Running time 33 mins)

Security in sql server 2008 - Database security is a critical focus when working with a database system like ms sql server.  In this video seminar, we hit concepts like principals, logins, schemas, server roles, database roles, catalog views, object permissions, user access to securables. (Running time 28 mins)

Using SQL statements on sql 2008 - In this SQL 2008 video training, we will use the adventureworks 2008 sample database to learn how to use basic sql statements.  We only scratch the surface of sql server 2008 query language by looking at select sql, insert sql, update sql and delete sql tsql statements. (Running time 32 mins)

sql server 2008sql server 2008 administration, maintenance and job automation - Job automation and maintenance are important if you want to learn sql server 2008 administration. We cover concepts like events, alerts and operators. We continue with sql server 2008 agent, job activity monitor, database mail and setting up maintenance plans. (Running time 46 mins)

SQL backup and restore plus compression feature in sql server 2008 - Using first the management studio and then TSQL code, we discover sql server 2008 backup choices i.e. full, differential and log backup.  Next item on the training agenda is how to restore a database and we walk you through some scenarios as well. (Running time 38 mins)

Entity relationships in a sql database design - Database relationships are critical when it comes to understanding sql server 2008 architecture.  Using the adventureworks 2008 sql database, we discuss 1 to 1, 1 to many, many to many  relationships. In addition we go over inner and outer sql joins and referential integrity. (Running time 28 mins)

Monitoring sql server 2008 - As a SQL Server DBA, monitoring the database server is an essential daily task.  In this elaborate database tutorial, we dig deeper into tools like event viewer, perfmon, sql profiler, dmv's and sql server 2008 error logs. We end the lesson with a comparison of two tsql scripts using Profiler traces. (Running time 68 mins)

Using SQL Views, Functions and SQL Stored Procedures - In this last video session, we brush up a bit on other important objects besides a database table.  We go over sql views which can help you with complex sql select queries. Next we explain sql functions and sql stored procedures that are used for efficient database programming. Using database mail, we send an email notifications from sql server 2008. (Running time 45 mins)

If you would like additional information on these video lessons, please visit this page:
http://www.learningsqlserver2008.com/products.htm

Recommended websites with additional information on sql server 2008

FREE SQL Server Training Videos
SQL Server 2008 Resource Center
sql server 2008 Sample Databases
SQL Server Information

sql server 2008 PowerPoint Presentations

Additional Video Training on MS SQL Server 2008:

FREE Supplemental Information on sql server 2008 administration and development:

Useful SQL Server 2008 Scripts

Use WAITFOR DELAY to set delay between sql statements
using sp_change_users_login in sql server 2008 to fix orphan user issue
How do you find high CPU utilization with t sql code in MS 2008
Using xp_fixeddrives extended stored procedure to find drive space on your database server
removing data from a BIG table using truncate table sql command

how do I kill orphan processes with mssearch in microsoft sql server
Getting a baseline query optimization with DBCC DROPCLEANBUFFERS
tsql script to make a quick copy of a database table in sql 2008 server
TSQL code to drop or delete a database using if exists clause
How to create a database using SQL code with MAXSIZE and FILEGROWTH options

using_sql xp_cmdshell stored procedure to execute OS commands from within sql server!
change_recovery_model_for all_databases at once in 2008 SQL Server using a cursor
Examples of how to add modify (alter) or drop columns_from an existing sql database table
start and stop MS SQL Server services
basic dml statements select sql insert update sql and delete sql command

using while loop to perform row by row operation in sql server 0016
t sql examples of using if else then in sql server_0017
useful extented stored procedures like xp_readerrorlog and xp_fixeddrives
sql programming code on create sql server 2008 login 0019
check if record exists in a table before you do an insert into a table 0020


set_transaction_isolation_level_read_uncommitted_0021
drop_and_create_sql_operators_using_tsql_0022
performance_tip _in_SQL_Server_with_DBCC_and_Statistics_0023
moving_tempdb_in_sql_server_using_alter_database_0024
find_missing_indexes_with_dynamic_management_views_0025

insert_data_to_sql_table_with_a_sub_select_0026
SQL_server_aggregate_functions_MIN_MAX_SUM_COUNT_0027
ms_sql_example_on_using_a_cursor_0028
looping_in_sql_server_stored_procedurer_with_while_loop_0029
get_list_columns_and_user_tables_using_catalog_view_0030

More on the way ....