SQL Server 2012 Virtual Labs

February 5, 2012 Leave a Comment

Want to play around with SQL Server 2012 but don’t have an environment to play around in?  Check out the following SQL Server 2012 Virtual Labs:

SQL Server 2012: AlwaysOn Availability Groups (SQL 142)

In this hands-on-lab you will learn take advantage of the new AlwaysOn features in SQL Server 2012. You will learn how to implement High-Availability and Data Recovery using SQL Server 2012 Availability Groups.

SQL Server 2012 – Working with Contained Databases (SQL 145)

In this lab, learn how to implement Contained Databases in SQL Server 2012.

SQL Server 2012 – What’s new in Manageability (SQL 147)

In this hands-on-lab you will learn about new manageability features in SQL Server 2012. You will learn how to take advantage of new features in SQL Server Management Tools, PowerShell, and features that will increase your productivity.

SQL Server 2012 – Installation and Configuration (SQL 149)

In this hands-on-lab you will build out a network environment that includes a Domain Controller, an multiple instances of SQL Server 2012.

SQL Server 2012 – Security and Compliance (SQL 150)

In this in hands-on-lab you will learn how to implement security and compliance in SQL Server 2012.

SQL Server 2012 – Upgrading to SQL Server 2012 (SQL 151)

In this hands-on-lab you will learn on how to upgrade to SQL Server 2012.You will learn how to use SQL Server Upgrade Advisor and Distributed Replay to upgrade a SQL Server 2005/2008 database to SQL Server 2012

SQL Server 2012 – What’s new in T-SQL (SQL 152)

In this hands-on-lab you will learn about the new T-SQL enhancements for SQL Server 2012.You will learn about new scalar functions, T-SQL constructs and how to take advantage of these new features.

SQL Server 2012 – Installing and managing SQL Server 2012 on Windows Server Core (SQL 153)

In this hands-on-lab you will learn how to deploy SQL Server on Windows Server core, and how configure connectivity and management of a Windows Server core based installation.

SQL Server 2012 – What’s new in Data warehousing and EIM

In this hands-on-lab you will learn about the enhancements in SQL Server 2012 for Data warehousing.

Filed under Certification, Denali, Links, SQL Server 2012, Training

SQL Server 2012 Developer Training Kit BOM

February 1, 2012 Leave a Comment

The SQL Server 2012 Early Adoption Team has put together some great resources to assist developers with skilling up on SQL Server 2012; one of which is the SQL Server 2012 Developer Training Kit BOM wiki.

The wiki, which is based on the SQL Server 2012 Developer Training Kit, has been designed from a training perspective and organises content into an agenda like format (complete with presentations, demos and hands-on-labs) making it easy for individuals and organisations to develop their own SQL Server 2012 upgrade workshop.

Check it out today!

Sample Agenda

Day 1: Introduction and Database Engine Topics

Module 1: Introduction to SQL Server 2012

image

Day 2: Visual Studio, .NET and Business Intelligence Topics

Module 7: SQL Server 2012 Business Intelligence

image

Filed under Links, SQL Server 2012, Training

Microsoft Virtual Academy

January 13, 2012 1 Comment

The Microsoft Virtual Academy (MVA) is a free cloud-based learning environment focusing on Microsoft Technologies (Although the site states that it focuses on cloud-based technologies, I have found content in some countries not specific to the cloud).

The concept behind the MVA is similar to that of a “Virtual University”; students select a course(s) to study and then do a self-assessment exam to gauge how well they’ve understood the study material. Students also accrue points for material studied and courses completed which are used to promote them through a recognition system (Bronze, Silver, Gold or Platinum Level) and provide them with a comparison on how they rank against other students in their country and around the world.

As it currently stands, there is only 1 SQL Server related course (Introduction To SQL Azure) currently available in Australia (and the United States and United Kingdom) however I have been advised by the Dean that new material will become available in the near future. I also mentioned earlier that there is additional content (SQL 2008/R2/Azure, .Net, Sharepoint, Silverlight, Windows Phone) available in other countries (mainly Spain and Colombia) with some of this content being in English and some in the native language of the selected country (the Microsoft study links are good as all you need to do is change the language setting of the site to a language of your choice and the content is translated. You can also use Google Translate on some of the content).

More information about the MVA can be found in the FAQ.

Filed under Links, SQL Azure, SQL Server 2012, Training, Visual Studio

SQL Server 2012 Developer Training Kit

December 31, 2011 1 Comment

There’s been an update to the SQL Server 2012 Developers Training Kit (November 2011).

This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2012 and SQL Azure improvements from a developer perspective. It contains a rich set of demos, hands-on labs and presentations that are perfect for self-paced learning or for conducting your own training.

Please Note: You will need to install Microsoft Web Platform Installer 3.0 before you can install this training kit.

Filed under SQL Azure, SQL Server 2012, Training

Free SQL Server 2008 R2 Training

June 27, 2011 1 Comment

There’s been an update to the SQL Server 2008 R2 Developers Training Kit (May 2011).

This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It contains a rich set of presentations, demos, hands-on labs and videos that are perfect for self-paced learning or for conducting your own training.

There’s also some SQL Server Developer content in the Visual Studio 2010 and .NET Framework 4 Training Course.

In this introductory unit, the Visual Studio 2010 and .NET Framework 4 evangelism team welcomes you to the training course and goes over the significant changes to Visual Studio 2010 and the .NET Framework 4. We’ll also cover what you’ll see in the course and how to follow along with the labs.

If you’re into Business Intelligence, check out the SQL Server 2008 R2 Business Intelligence Training Course. (a.k.a. SQLInsights).

The SQL Server 2008 R2 Business Intelligence Training Course (SQLInsights) will help you learn how to build your first Microsoft Business Intelligence solution. SQLInsights is a great resource for developers, consultants and evangelists who need to learn the basics of how to build solutions that deliver integrated reporting, analytics and dashboard experiences. It contains a rich set of videos and hands-on labs that are perfect for self-paced learning.

Filed under Certification, Training

Follow

Get every new post delivered to your Inbox.

Join 469 other followers