Silverlight 4 Training Kit - Download

Microsoft Released "Silverlight 4 Training" Setup kit, Version 1.0.1 and Published on 1/27/2010, It Includes the Following

*. Hands-on-labs

*. A video and

*. A whitepaper

These are all designed to help you learn about the new features in Silverlight 4 focusing on three major areas:

1. Enabling Business Application Development,

2. Empowering Richer Experiences and

3. Moving Beyond the Browser.

Some of the new highly anticipated features includes

*. Printing

*. WebCam and Microphone support

*. custom right-click

*. rich text

*. HTML support and access to local files with trusted applications.

Download Silverlight 4 Training Kit

Get a sneak peek—Download Microsoft Office 2010 Beta today

Take your projects to a higher level with Microsoft Office 2010 Discover how you can bring your ideas to life with Microsoft Office 2010 With the Microsoft Office 2010 Beta, you can try out all the new features that will help take your projects to a higher level — long before the new version of Office is available for purchase. Express your ideas, connect with others, and create amazing results virtually anywhere life takes you with Office 2010. • Turn ideas into powerful presentations. In addition to the enhanced image-editing tools, now you can edit video files right in Microsoft PowerPoint 2010. And with Broadcast Slide Show, you can deliver your presentations in real time to virtually anyone with an Internet connection.1 • Manage email easily. Gain control over your email with Microsoft Outlook 2010. The new Conversation view lets you consolidate the discussions you're interested in, ignore the ones you're not, and get more things done faster. • Organize your thoughts. Keep track of your best ideas with Microsoft OneNote 2010. It gives you one convenient place to collect any thoughts, images, videos, or Web links for a project — and then find them with a simple search tool. • Work however and whenever you want. Microsoft Office Backstage view has a quick way to store documents online and access them from virtually anywhere. And Microsoft Office Web Applications make it easy to work on group projects together, whether you're miles apart or just down the hall.2 Experience how Office 2010 adds impact, energy, and efficiency to every project. Download the Office 2010 Beta today. 1 An appropriate device, Internet connection, supported browser (Internet Explorer 7 or later, Firefox 3.56 or later, or Safari 4 or later), and Windows Live ID are required. 2 Microsoft Office Web Apps are currently only available to individuals using the Office 2010 Beta. Please note that only select Office Web Apps support online editing at this time. Discover new ways to share your ideas with Microsoft Office 2010. Watch the new features video   Visit the Microsoft Office Beta Web Site | Unsubscribe © 2010 Microsoft Corporation. Terms of Use | Trademarks | Privacy Statement

---

http://windows.microsoft.com/shop Find the right PC for you.

Indexed View Error - select list does not include a proper use of COUNT_BIG

Problem:

I Tried to Create a Index on the Existing View, then i got the following Error:

Msg 10138, Level 16, State 1, Line 1
Cannot create index on view 'EISA.dbo.VIEW_CLIENT_GLOBAL' because its select list does not include a proper use of COUNT_BIG. Consider adding COUNT_BIG(*) to select list.

Code1:

I Created View By using following Query:

Code2:

I Used the Following Query to Create an Index on the Created View "VIEW_CLIENT_GLOBAL" By using following Query:

Solution:

If you want to create a Index on the view, we need follow the rules given in the following link,

http://technet.microsoft.com/en-us/library/ms191432.aspx

If GROUP BY is specified, the view select list must contain a COUNT_BIG(*) expression, and the view definition cannot specify HAVING, CUBE, or ROLLUP.

I Altered My View with COUNT_BIG(*) AS COUNT as shown below:

Then i created the index on the view by Query which is available in "Code2" Section, it works fine.

SQL SCHEMABINDING Error - Names must be in two-part format and an object cannot reference itself

Problem:

Today I Tried to Create a View WITH SCHEMABINDING then i received the following error.

Msg 4512, Level 16, State 3, Procedure VIEW_CLIENT_GLOBAL, Line 4

Cannot schema bind view 'VIEW_CLIENT_GLOBAL' because name 'FACT_CLIENT_GLOBAL' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

I used the following Query:

Solution:

I think, you aware the use of "WITH SCHEMABINDING". If Not, Please Check My Post Here

By Error message Itself we can find out what is wrong.

When You Create a view "WITH SCHEMABINDING", Database will keep the reference with object name. many database object can be created with same name from difference user, if we create the view by using only name. There are lot of difficulties to handle. To avoid that, SQL Server expects the Object Name in Proper Format like

Owner.Object_Name.

In My Query I changed to DBO.FACT_CLIENT_GLOBAL, then i tried to create the view then it works fine.

Note: Also You have to Ensure that your Table and View should be exists in the Same Database, if you are Enabling "WITH SCHEMABINDING". Otherwise you may get the same error message

Hope it Helps you!

Visual Studio 2010 and .NET Framework 4 Training Kit - January Release

The Visual Studio 2010 and .NET Framework 4 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including:

• C# 4.0
• Visual Basic 10
• F#
• Parallel Extensions
• Windows Communication Foundation
• Windows Workflow
• Windows Presentation Foundation
• ASP.NET 4
• Windows 7
• Entity Framework
• ADO.NET Data Services
• Managed Extensibility Framework
• Visual Studio Team System

This version of the Training Kit works with VS 2010 Beta 2 & .NET Framework 4 Beta 2.

Download VS2010TrainingKitJanuarySetup.exe