FREE Tutorial Videos of SQL Server 2008 training

• sql server 2008 samples video on Profiler (sql profiler tutorial)
• sql server samples video on Installation  (sql server 2008 installation guide)
• sql server 2008 samples video on sql commands (using sql commands in sql server)
• sql server samples video on Management Studio (sql server 2008 management studio tutorial)
• sql server samples video on Backup Database with compression (sql server 2008 compression)

Microsoft Training Kits

Microsoft has been releasing some Training Kits for the technologies that are running on market today. I’ve found some of them and the links are below:

SharePoint 2007 Training Kit: http://www.microsoft.com/downloads/details.aspx?FamilyID=673dc932-626a-4e59-9dca-16d685600a51&displaylang=en

Windows 7 Training Kit for Developers http://www.microsoft.com/downloads/details.aspx?familyid=1C333F06-FADB-4D93-9C80-402621C600E7&displaylang=en

Visual Studio 2008 Training Kit http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=8BDAA836-0BBA-4393-94DB-6C3C4A0C98A1&displaylang=en

Visual Studio 2010 and .NET Framework 4 Training Kit http://www.microsoft.com/downloads/details.aspx?familyid=752CB725-969B-4732-A383-ED5740F02E93&displaylang=en

SQL Server 2008 Training Kit http://www.microsoft.com/downloadS/details.aspx?familyid=E9C68E1B-1E0E-4299-B498-6AB3CA72A6D7&displaylang=en

ASP.NET MVC Training Kit http://www.microsoft.com/downloads/details.aspx?FamilyID=1E0BE0B2-910A-4676-9F3A-41E4D9C0FC08&displaylang=en

.NET 3.5 Enhancements Training Kit http://www.microsoft.com/downloads/details.aspx?FamilyID=355c80e9-fde0-4812-98b5-8a03f5874e96&displaylang=en

Hope you would find these useful.

Free Microsoft Press E-Book: Introducing Microsoft SQL Server 2008

Introducing Microsoft SQL Server 2008

by Peter DeBetta, Greg Low, and Mark Whitehorn
ISBN: 9780735625587

Learn about major new features in SQL Server 2008 including security, administration, and performance.

Introducing Microsoft SQL Server 2008:
Chapter 1: Security and Administration
Chapter 2: Performance
Chapter 3: Type System
Chapter 4: Programmability
Chapter 5: Storage
Chapter 6: Enhancements for High Availability
Chapter 7: Business Intelligence Enhancements

Download it from here: http://csna01.libredigital.com/?urss1q2we6

SQL Server 2008 Express How-to Guide Series

SQL Server 2008 Express How-to Guide Series

This series of short on-demand how-to videos will touch on SQL Server Express 2008 features such as: how to back up a local or remote SQL Express database, how to restore a SQL Express database, how to update SQL Server Express 2005 to SQL Server Express 2008, and more.

MSL news: Big discounts on cert exams and E-Learning collections

There are too many details to list here, so visit Special Offers on Training and Certifications from Microsoft now. Microsoft Learning is offering up to 25% off select (many) certification exams and E-Learning collections.

Also, don’t miss this offer:

Train on SQL Server 2008 and get the software for free!

Whether your focus is database administration, development, or business intelligence, you can quickly become an expert within your organization. Enroll in and attend any one of eight Microsoft SQL Server 2008 courses before December 31, 2009 (while supplies last), and you will receive a fully licensed copy of SQL Server 2008 Standard Edition with one client access license. This offer is valid through Microsoft Certified Partners for Learning Solutions.

Available courses for this offer:

Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact—SQL

Course 6231A: Maintaining a Microsoft SQL Server 2008 Database

Course 6232A: Implementing a Microsoft SQL Server 2008 Database

Course 6234A: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Course 6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Course 6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Service

Course 6158C: Updating Your SQL 2005 Skills to SQL Server 2008

Course 6317A: Upgrading Your SQL Server 2000 Skills to SQL Server 2008

Source: MS Press (RSS)

Microsoft WebsiteSpark

Visibility, support and software for professional Web Developers and Designers – at no upfront cost!

Does your company have 10 or fewer employees?

Receive Windows Web Server and SQL Server Web Edition at no cost to host new websites.   Learn More

SQL Server Express 2008

SQL Server Express 2008 and Service Pack

SQL Server 2008 Express Edition is the new version of MSDE or SQL Server 2005 Express. This version includes SQL Server 2008 is free, easy to use and light. You can compare the various features by looking up the documentation :

- Compare SQL server Editions
- Features Supported by the Editions of SQL Server 2008

You have various version of SQL Server 2008 Express :

Microsoft® SQL Server® 2008 Express Edition
SQL Server 2008 Express is a free edition of SQL Server that is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.

Microsoft® SQL Server® 2008 Express with Tools
Microsoft SQL Server 2008 Express with Tools is a free, easy-to use version of the SQL Server Express data platform. This edition includes graphical management tools that make it easier than ever to start developing powerful data-driven applications for the Web or local desktop.

Microsoft® SQL Server® 2008 Express with Advanced Services
Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to use version of the SQL Server Express data platform. This edition includes an advanced graphical management tool and powerful reporting features to make it easier than ever to start developing powerful data-driven applications for the Web or local desktop.

As with SQL Server 2005 Express, when a service package is delivered for SQL server SQL Server 2008 Express Edition, a special version is put online including directly the service pack : Microsoft® SQL Server® 2008 Express Edition Service Pack 1 

SQL Server Express 2008

SQL Server 2008 Express Edition est la nouvelle version de MSDE ou SQL Server 2005 Express. Cette version inclue SQL Server 2008 est gratuit, facile à utiliser et léger. Vous pouvez comparer les différentes caractéristiques en consultant la documentation:

- Compare SQL server Editions
- Fonctionnalités prises en charge par les éditions de SQL Server 2008

Vous avez diffèrentes versions de SQL Server 2008 Express :

Microsoft® SQL Server® 2008 Express Edition
SQL Server 2008 Express est une édition gratuite de SQL Server qui représente une plateforme de données idéale pour apprendre et créer de petites applications (locales et serveur) ; elle est également parfaitement adaptée pour être redistribuée par les éditeurs de logiciels indépendants.

Microsoft SQL Server 2008 Express with Tools
Microsoft SQL Server 2008 Express with Tools est une version conviviale et gratuite de la plateforme de données SQL Server Express. Cette édition comprend des outils d’administration graphiques qui facilitent encore plus le développement de puissantes applications pilotées par les données pour le Web ou l’ordinateur local.

Microsoft® SQL Server® 2008 Express with Advanced Services
Microsoft SQL Server 2008 Express with Advanced Services est une version conviviale et gratuite de la plateforme de données SQL Server Express. Cette édition comprend un outil d’administration graphique avancé et de puissantes fonctionnalités de création de rapports qui facilitent le développement de puissantes applications pilotées par les données pour le Web ou l’ordinateur local.

Comme pour la version SQL 2005 Server Express, quand un service pack est fourni pour SQL Server 2008 Express Edition, une version spéciale est mise en ligne comprenant directement le Service Pack: Microsoft® SQL Server® 2008 Express Edition Service Pack 1 

SQL Server Express 2008

SQL Server 2008 Express Edition es la nueva versión de MSDE o SQL Server Express. Esta versión incluye SQL Server 2008 es gratuito, fácil de usar y legero. Usted puede comparar las diversas características consultando la documentación:

- Comparar SQL server Editions
- Características compatibles con las ediciones de SQL Server 2008

Usted tiene diferentes versiones de SQL Server 2008 Express :

Microsoft® SQL Server® 2008 Express Edition
SQL Server 2008 Express es una edición gratuita de SQL Server y es una plataforma de datos ideal para aprender y ejecutar pequeñas aplicaciones de servidor y de escritorio, y para su redistribución a través de ISV.

Microsoft SQL Server 2008 Express with Tools
Microsoft SQL Server 2008 Express with Tools es una versión gratuita y fácil de utilizar de la plataforma de datos SQL Server Express. Esta edición incluye herramientas de administración gráfica con las que es más fácil que nunca empezar a desarrollar aplicaciones sólidas controladas por datos para la Web o el escritorio local.

Microsoft® SQL Server® 2008 Express with Advanced Services
Microsoft SQL Server 2008 Express with Advanced Services es una versión gratuita y fácil de utilizar de la plataforma de datos SQL Server Express. Esta edición incluye una herramienta de administración gráfica avanzada y sólidas funciones de informes con las que es más fácil que nunca empezar a desarrollar aplicaciones sólidas controladas por datos para la Web o el escritorio local.

Ya que 2005 Server Express, cuando un Service Pack se entrega para SQL Server 2008 Express Edition, una versión especial se pone en línea, incluyendo directamente el Service Pack : Microsoft® SQL Server® 2008 Express Edition Service Pack 1 

Donwload SQL Server Express	If your system is?	If your system is?	If your system is?
Microsoft® SQL Server® 2008 Express Edition with Service Pack 1	X86	X64	WOW64
Microsoft® SQL Server® 2008 Express with Tools	X86	X64	.
Microsoft® SQL Server® 2008 Express with Advanced Services	X86	X64	.
Microsoft® SQL Server® 2008 Management Studio Express	X86	X64	.

 

SQL Server 2008 Express How-to Video Series

SQL Server 2008 Express How-to Video Series

Available on demand starting September 21, this series of short how-to videos will touch on SQL Server Express 2008 features such as how to back up and restore a SQL Express database, how to back up a remote SQL Express database, how to update SQL Server Express 2005 to SQL Server Express 2008, and more.

New SQL Server 2008 E-Learning

Looking to ramp up on SQL Server 2008? We just released a new 16-hour e-learning collection (8 individual two-hour courses):

Get it here: Implementing and Maintaining Microsoft SQL Server 2008 

Source: Born to Learn

RTM’d today: Inside Microsoft SQL Server 2008: T-SQL Programming

MS Press is pleased to announce that Inside Microsoft SQL Server 2008: T-SQL Programming, by Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, and Isaac Kunen (Kalen Delaney Series Editor; Solid Quality Mentors) shipped to the printer today (Microsoft Press, 2010; ISBN: 9780735626027; 832 pages)!

 

This book provides a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Some of the tasks you’ll learn include:

• Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
• Handle transactions, concurrency, and error handling.
• Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
• Evaluate when to use set-based programming techniques and when to use cursors.
• Work with dynamic SQL in an efficient and secure manner.•    Treat date- and time-related data in a robust manner.
• Develop CLR user-defined types and learn about temporal support in the relational model.
• Use XML and XQuery and implement a dynamic schema solution.

All the book’s code samples will be available for download from the companion Web site.

I’ll post excerpts from the book soon, in the middle of September, when the book is available.