9 Wired In February
 

From the Editor


Welcome to February's edition of Wired In! This month, we are excited to announce new courses for SharePoint 2010, Exchange 2010 and Windows 7! Along with these courses, we are introducing specially priced career packages through our career portal that will help you get certified on many of the new MS technologies.

 

Also, check out:

We are Listening!

 

Exchange 2010 Courses

 

Information Technology Career Portal

 

Citrix Training

 

VM Training

 

Microsoft Specials!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Specially Priced Career Packages for MS Certification

In a challenging professional marketplace, managing your career has never been more important. Technology expertise, combined with proven job-role qualifications can help you differentiate your resume, move up the organizational chart, and tackle new professional opportunities. With our IT Career Portal, you have access to career guidance, detailed learning plans for all MS technologies and many positions, and special offers on certification and instructor-led training to help you reach your goals.

IT Career Packages:

What is your goal?

Last Chance Courses

February

6232A: Implementing a Microsoft SQL Server 2008 Database Feb. 22

Citrix XenApp Feb. 22

March

5047B: Introduction to Installing and Managing MS Exchange Server 2007 SP1 Mar. 1

5050: Recovering Messaging Servers and Databases Using MS Exchange Server 2007 Mar. 5

6368A: Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2008 Mar.8

50261A: Microsoft Office SharePoint Server 2007: Power End Users Mar. 8

6231: Maintaining a Microsoft SQL Server 2008 Database Mar. 15

6419: Configuring, Managing and Maintaining Windows Server 2008 Servers Mar. 15

VM Training - VMware vSphere 4.0 Ultimate Bootcamp Mar. 22

10135A: Configuring, Managing and Troubleshooting Microsoft Exchange Server 2010 Mar. 22

6417: Updating your Applications Infrastructure Technology Skills to Windows Server 2008 Mar. 29

50311A: Updating Your Technology Skills from Windows XP to Windows 7 Mar. 29

April

6430A: Planning and Administering Windows Server 2008 Servers Apr.5

Mindsharp - SharePoint Server 2010 Administrator Beta Apr. 5

6426A: Configuring & Troubleshooting Identity & Access Solutions with Windows Server 2008 AD Apr.7

2957B: Advanced Foundations of Microsoft .NET 2.0 Development Apr. 7

50028B: Managing System Centre Operations 2007 Apr. 12

6416C: Updating your Network Infrastructure & Active Directory Technology Skills to Windows Server Apr. 12

6435A: Designing a Windows Server 2008 Network Infrastructure Apr. 12

6292A: Installing and Configuring Windows 7 Client Apr. 7

 

Upcoming Course Information

View all Microsoft Courses
Microsoft SQL Courses
Microsoft Exchange Courses
Microsoft System Center Courses
Microsoft SharePoint Courses
Microsoft Windows Server Courses
Microsoft .NET Development Courses

Microsoft Communication Server Courses

 

IT Professional's Connection

IT Professional

by: Christian Millar, MCT, Manager Microsoft Infrastructure Training

 

A deeper look into the new Features of Windows Server 2008 R2 with the Windows 7 Client: Part 1 Branch Cache


In our last newsletter, we spoke about some of the latest features that are new with Windows Server 2008 R2. As per this article I will focus on some technologies around the integration with Windows 7 as the new Desktop Client. We have been receiving excellent interest in the New Windows 7 classes, so I wanted this article to cover off a real money saver now available if your organization is thinking of moving forward with implementing Windows 7 Desktops and Windows Server 2008 R2 backend Servers. Since most of the courseware I deliver is Infrastructure Based with a Rock Solid Desktop OS like Windows 7 which seems to be the client to run now. And most of the new Releases of our Microsoft Official Curriculum Based Courses are very informational based which allows the student to grasp a firm knowledge of Excellent Quality Content with new revamped labs. I am happy to say that all of the newer Server 2008 classes now focus on teaching the Windows Server 2008 R2 fundamentals as well.

In this edition, we will start examining the New Features that 2008 R2 has to offer as mentioned in our last month’s article we would be looking at each particular new Feature separately over the course of the year. This month we will examine all the latest add-ons to the Client Server section.

  

BranchCache™ in the Windows® 7 and Windows Server® 2008 R2 operating systems can help increase network responsiveness of centralized applications when accessed from remote offices, giving users in those offices the experience of working on your local area network. BranchCache also helps reduce wide area network (WAN) utilization.
When BranchCache is enabled, a copy of data accessed from intranet Web and file servers is cached locally within the branch office. When another client on the same network requests the file, the client downloads it from the local cache without downloading the same content across the WAN.


BranchCache can operate in one of two modes:

  • Distributed Cache. Using a peer-to-peer architecture, Windows 7 client computers cache copies of files and send them directly to other Windows 7 client computers as they need it. Improving performance is as easy as enabling BranchCache on your Windows 7 client and Windows Server 2008 R2 computers. Distributed Cache is especially beneficial for branch offices that do not have a local server.

Watch the distributed cache videocast from TechNet featuring Kevin Remde Senior IT Pro Evangelist from Microsoft as he demonstrates
http://edge.technet.com/Media/Install-and-Configure-Distributed-BranchCache-for-File-Services-SRV311-Part-5-of-5/

  • Hosted Cache. Using a client/server architecture, Windows 7 client computers cache content to a computer on the local network running Windows Server 2008 R2, known as the Hosted Cache. Other clients who need the same content retrieve it directly from the Hosted Cache. The Hosted Cache computer can run the Server Core installation option of Windows Server 2008 R2 and can also host other applications.

Watch the Hosted cache videocast from TechNet featuring Kevin Remde Senior IT Pro Evangelist  from Microsoft as he demonstrates
http://edge.technet.com/Media/Install-and-Configure-Hosted-BranchCache-for-Web-Services-SRV311-Part-4-of-5/

The following diagram illustrates these two models:

Branch Cache Diagram

 

BranchCache can improve the performance of applications that use one of the following protocols:

  • HTTP and HTTPS. The protocols used by Web browsers and many other applications (such as Internet Explorer®, Windows Media®, and more).
  • SMB (including signed SMB traffic). The protocol used for shared folders.

BranchCache only retrieves data from a server when the client requests it. Because it is a passive cache, it will not increase WAN utilization. BranchCache only caches read requests, and thus will not interfere with a user saving a file.


BranchCache improves the responsiveness of common network applications that access intranet servers across slow links. Because it does not require any infrastructure, you can improve the performance of remote networks simply by deploying Windows 7 to client computers, deploying Windows Server 2008 R2 to server computers, and enabling BranchCache.


BranchCache works seamlessly alongside network security technologies, including SSL, SMB Signing, and end-to-end IPsec. You can use BranchCache to reduce network bandwidth utilization and improve application performance even if the content is encrypted.

 

Check back with us next time when we continue our look at the new features that are being offered and if you would like to contact me regarding anything in this article please feel free to email me at cmillar@neweratechnology.com.

 

See you next time!

Developer's Connection

Developerby: Scott Jackson, MCT, Manager .NET Development Training  

 

Subqueries in SQL Server 2008


Sometimes when writing a query, there is a need to add a query within a query to pull the correct subset of data. This is where a subquery comes into play. It is a query nested inside a Select, Insert, Update, or Delete statement. It can be used anywhere that an expression is allowed.
A subquery is also called an inner query or inner select, while the statement containing a subquery is also called an outer query or outer select. Many times, a T-SQL statement that includes a subquery can also be formulated as a join. There is usually no performance difference between a statement that includes a subquery and a semantically equivalent version that does not.

However, in some cases where existence must be checked, a join yields better performance.

 

An example:

Select ProductID, Name
From
Production.Product
Where Color Not In
(Select Color from Production.Product where productID = 5)


In this example, the “Not In” where clause is specifically iterating through the rows in Production. A Product where any color with the productID of 5 will not show up in the query.


The following example adds the subquery to the select statement rather than the where clause:
Select Name, ListPrice, (Select AVG(ListPrice) FROM Production.Product) as Average
From Production.Product
Where ProductSubCategoryID = 1


When I was working in the tax software business, we found that in order to achieve the best results subqueries were necessary.  They are the most useful when dealing with data that is scattered across multiple tables (as opposed to just using a regular where clause). Subqueries give you a way to bring the scattered pieces together again.
MSDN contains more examples on using subqueries.
http://msdn.microsoft.com/en-us/library/ms189575.aspx

 

Happy Coding!


If you want to give Scott feedback on this article, email him @ sjackson@neweratechology.com

New Era Technology
#300, 633 - 6th Ave S.W., Ford Tower Calgary, Alberta Canada T2P 2Y5
Phone: 403-265-1150
Fax: 403-265-9797

www.neweratechnology.com

Unsubscribe 		New Era Technology