MSDN Blogs

Xbox - A New Generation Revealed

Usman Ur Rehman Ahmed — Sat, 18 May 2013 21:11:11 GMT

On Tuesday, May 21, we’ll mark the beginning of a new generation of games, TV and entertainment as Xbox is revealed; a New Generation of Xbox. You can watch it live on May 21 (Tuesday), 10pm Pakistan Standard Time
on Xbox Live or Xbox.com.

Stream Url: http://www.xbox.com/en-US/hub/reveal

How to be a good web service? Syncronous or asyncronous, let's straight!

Albert (Gong) Cheng — Sat, 18 May 2013 18:47:57 GMT

Web service method can be either syncronous or asyncronous. A high quality web service should be very clear about whether each end point is syncronous or asyncronous.

What are syncrhonous operations?

Syncronous operations completes the operation at the time of completion of sending response. It is suitable for operations that can be completed at milliseconds level. Operations only involve database reading operation typically can be completed at this time frame. Syncronous operation returns result in the response to the client.

What is asyncronous operation?

Asyncronous operations completes the operation after the completion of sending response. It is suitable for operations that may last longer than a typical http request timeout. Examples include async Blob copy method of Azure Storage service, create job method of Azure media services. Both method operate on Gigabyte level of data, it may take hours to complete those operations depending on the job size and work load on server side. The response of these operations typically contain a unique id to identify the submitted request, and client can check the status of the operation using the ID given.

What are the common pitfalls?

There are two possible types of error. Among them, type I error is much more common than type II error.

I. Asyncronous operation was implemented as syncronous.

Type I error occurs when the response is returned prior to the completion of the operation. Upon receiving the response, the client may take action based on the assumption that the prior operation had already been completed. This type of error basically breaks the atomicity of the web service operation.

The fix of the operation can be either delay the response until the operation is completed or convert this "syncronous" operation into an asyncronous one.

II. Syncronous operation was implemented as asyncronous.

This type of the error is very rare simply because implementation of asyncronous operation typically takes a significant more resources, it is unlikely that developer will take the pain to write a complicated async web service which can be completed instantaneously. :)

How to teach yourself programming in Two Words!!!

Ed Price - MSFT — Sat, 18 May 2013 17:36:52 GMT

Read this

Understanding XAMARIN – Create iOS, Android, Mac and Windows apps in C#.

BrunoTerkaly — Sat, 18 May 2013 16:51:05 GMT

Introduction to XAMARIN

This is a continuation of the Windows 8 App Factor challenge material. See http://www.windows8appfactor.com

Key Facts In short, XAMARIN is about writing code in one language to support the major mobile platforms.

Created by the engineers that created Mono and MonoTouch
Leverages cross-platform implementations of .NET
Consists of a community of 314,588 developers.
All about cross-platform
- Support iOS, Android, Mac and Windows all in C#.
Reuse existing code
- Use your favorite .NET libraries in Xamarin apps.
- Easily use third-party native libraries and frameworks.
2 IDEs
- Visual Studio or Xamarin Studio
  - Xamarin Studio is a fully-featured IDE that is built for mobile app development.
Access to native APIs
- Allows you to create native apps with device-specific experiences.

One language, not 3 is the goal of XAMARIN Traditionally this means using each platform’s provided technology and SDK, i.e. Objective-C for iOS, Java for Android and .NET for Windows.

Reasons why you should care
- Realize tremendous code sharing across mobile platforms
- Reduce your time to market
- Leverage existing talent
- Meet customer demand for multiple device mobile access
- Reduce cross-platform complexity
You can do both productivity apps and game apps
- Works best when the focus is on productivity and utility (non-game applications).
Core strength of XAMARIN
- Implement native user interfaces specifically for each platform
- But still be able to share most of the non-user interface code and get the best of both worlds
  - Write your data storage and business logic code once
  - Leverage native UIs on each platform

Key Facts Each of the core platforms that are supported has custom tooling.

Windows Phone	Use the XAML/Silverlight presentation layer, using Visual Studio or Blend’s UI designer
Windows 8	Use the Windows Store APIs to create a native user experience.
iOS	Use the MonoTouch.UIKit APIs to create native-looking applications, optionally utilizing Apple’s Interface Builder.
Android	Use Android.Views to create native-looking applications, taking advantage of Xamarin’s UI designer

The major pieces The interesting news here is that XAMARIN is capable of creating a native app.

C# language	Allows you to use a familiar syntax and sophisticated features like Generics, Linq and the Parallel Task Library.
Mono .NET framework	Provides a cross-platform implementation of the extensive features in Microsoft’s .NET framework.
Compiler	Depending on the platform, produces a native app (eg. iOS) or an integrated .NET application and runtime (eg. Android). The compiler also performs many optimizations for mobile deployment such as linking away un-used code.
IDE tools	The Xamarin Studio IDE and the Xamarin plug-in for Visual Studio allow you to create, build and deploy Xamarin projects.

More to come I will take this a step or 2 further in the next few days.

When and When Not To Use the SharePoint 2013 App Model (v5)

Alex Randall — Sat, 18 May 2013 12:53:04 GMT

Here is the most recent version of my PowerPoint slide deck for my "When and When Not To Use the SharePoint 2013 App Model" presentation I gave at SharePoint Saturday Baltimore on Saturday, 5/18/2013.

WhenAndWhenNotToUseTheNewSP2013AppModel-Presentationv5.pptx

I hope it is helpful in understanding what the App Model is all about! Please feel free to comment or ask questions!

Imagine Cup 2013 – локални финали (част 3)

DPE BG — Sat, 18 May 2013 12:29:13 GMT

Иновации при правенето на Игри в Imagine Cup 2013 ни показаха цели 5 отбора. Вижте кои бяха участниците и какво ни демонстрираха те:

MG Power Екип: Атанас Атанасов, Мартин Стоянов, Станислав Славев МГ “Баба Тонка”, Русе	MG Power ни предлагат да се научим как да използваме логическото си мислене и да развиваме знанията си за света около нас, като разрушаваме сгради. Използвайки различни методи, трябва да съборим поставената за цел сграда, без да нараним нищо около нея. И всичко това под формата на една много приятна и потенциално зарибяваща Windows 8 игра.
Umbra Team Екип: Александър Брестнички, Ангел Радоев, Виктор Лалев (Софийски университет “Св. Климент Охридски”), Даниел Стаменов (УАСГ) Ментор: Теодор Райчев	Представете си стандартна сутрин, в която преди да влезете в офиса трябва да се преборите с огромния трол, препречил пътя към сградата. А докато чакате автобуса разбирате, че сте заобиколени не от обикновени хора, а от магьосници, войни и други приказни същества. Звучи интересно нали? Това е светът на сенките, в който ни пренася мобилната игра Umbra. Използвайки реалните карти и местоположението ни, играта ни кара да погледнем на всичко около нас по по-различен начин и ни води една стъпка по-близо до това да бъдем истински герои.
Alfa Aliens Екип: Valeriya Inyusheva, Ростислав Неделчев, Tatevik Mkrtchyan Американски университет в Благоевград	В Alfa Aliens помагаме на извънземни същества, изгонени от собствената си планета да построят отново своята цивилизация и в последствие да си върнат дома. Класическите техники за развитие на селища са обогатени с образователни мини-игри, които дават възможност на децата да обогатят знанията си и да упражняват вече наученото, докато се забавляват.
Blitz Games Екип: Борислав Иванов, Юрий Попов (Технически университет - София), Петър Добрев (Софийски университет “Св. Климент Охридски”), Радослав Цонев (Нов български университет)	Войнът Гром и магьосникът Удохан се отправят на пътешествие към невъзможното – да намерят сферата на реалността и да подчинят силата, която съдържа тя. Но при битката за магическото кълбо двамата го разрушават и реалността е заплашена от разпадане. Изправени пред безисходицата от разрухата н света двамата обединяват силите си и се впускат в събиране на разпиляните парчета от ценния обект. Blitz Games съчетават доброто старо време на двуизмерните jump-n-run игри с модерните технологии и интересната история и отново правят жанра актуален.
Mirvam Екип: Димитър Вулджев (НПМГ), Иван Стефанов (ПМГ "Акад. Н. Обрешков", Казанлък)	Mirvam работят върху виртуален човек, с който можем да общуваме с помощта на жестове и глас. Проектът им е базиран на Kinect и представя нестандартен поглед върху въображаемите ни приятели :)

Scripting : Toggle proxy server in IE settings with PowerShell

Aymeric Mouillé - Consultant — Sat, 18 May 2013 07:43:37 GMT

My current Customer use a proxy server for Internet and I need to change this settings each morning (when I start to work for him) and each evening (when I return at home). To save precious time, I wrote a little script that toggle this setting at each script execution :

$regKey="HKCU:\Software\Microsoft\Windows\CurrentVersion\Internet Settings"
$proxyServer = ""
$proxyServerToDefine = "{Proxy}:{Port}"
Write-Host "Retrieve the proxy server ..."
$proxyServer = Get-ItemProperty -path $regKey ProxyServer -ErrorAction SilentlyContinue
Write-Host $proxyServer
if([string]::IsNullOrEmpty($proxyServer))
{
    Write-Host "Proxy is actually disabled"
    Set-ItemProperty -path $regKey ProxyEnable -value 1
    Set-ItemProperty -path $regKey ProxyServer -value $proxyServerToDefine
    Write-Host "Proxy is now enabled"
}
else
{
    Write-Host "Proxy is actually enabled"
    Set-ItemProperty -path $regKey ProxyEnable -value 0
    Remove-ItemProperty -path $regKey -name ProxyServer
    Write-Host "Proxy is now disabled"
}

Hope this helps!

//Build/2013 Conference See what's next • Learn from our engineers • Network with your peers

Lee Stott — Sat, 18 May 2013 06:37:34 GMT

The right content for your role

There are hundreds of thousands of topics in the Dev Center, http://dev.windows.com and http://dev.windowsphone.com. We know in any organisation discoverability and sharing of content is critical to success.

So why not get to grips with this detail in person at Microsoft //Build/2013.

Last month Steve Guggenheimer announced //Build/ 2013, the conference is taking place June 26-28, 2013 at the Moscone Center in San Francisco. //build/ is a great opportunity to learn more about developing Windows Store apps.

The conference will include great presentations, demos, info sessions, etc. There will be no better place to get the latest and greatest info on Windows Store app development.

You can see all the details about the conference and register at www.buildwindows.com.

Here are some key resources for the each roles in your organisation.

Developers

When you go to the Windows Store apps home page, you’ll see:

“Key tasks and content” prominently called out to help you jump into the content you need. Events as well as new resources.
Downloads to help you dive right into coding, all the resources you need to get started, and our detailed guidance on getting your app into the Windows Store.
Important code samples are highlighted, and how-to guidance is more easily navigated with an eye toward the development lifecycle.
“One Dev Minute” videos throughout the site, which give you a quick look at how to add features to your app.

Designers

The Design section. You can find useful downloads and reusable design assets more easily, and design inspiration and case studies give you the tools you need to make a unique experience on Windows.

Businesses

The business opportunity of the Windows Store is significant, with a better economic model than competitive platforms and flexibility that enables you to build the business you want. The new Market section of the site provides great tips for marketing your apps, evaluating telemetry data, and passing app certification.

There’s more to come

With //BUILD/2013 less than a month away, stay connected by following @windevs @ukmsdn on Twitter and subscribing to the Windows Store newsletter for the latest information on Windows 8.

//Build/2013 Conference See what's next • Learn from our engineers • Network with your peers

Lee Stott — Sat, 18 May 2013 06:37:34 GMT

The right content for your role There are hundreds of thousands of topics in the Dev Center, http://dev.windows.com and http://dev.windowsphone.com . We know in any organisation discoverability and sharing of content is critical to success. So why not get to grips with this detail in person at Microsoft //Build/2013. Last month Steve Guggenheimer announced //Build/ 2013, the conference is taking place June 26-28, 2013 at the Moscone Center in San Francisco. //build/ is a great opportunity to learn...(read more)

Just released - Prism for Windows Runtime

bmw1122 — Sat, 18 May 2013 05:58:57 GMT

Last December, we announced our thoughts on a new version of Prism for Windows 8 which we code named Kona. We are excited to announce that Prism for the Windows Runtime and the associated AdventureWorks Shopper reference implementation is now available on the Windows Dev Center,

What is Prism for Windows Runtime?

Similar to Prism for WPF and Silverlight or “Prism Classic”, Prism for Windows Runtime provides guidance to help you more easily design and build flexible and easy-to-maintain Windows Store business apps using C#, Extensible Application Markup Language (XAML), the Windows Runtime, and modern development practices. These are apps that are “built to last” and “build to change”. Using design patterns that embody important architectural design principles, such as separation of concerns and loose coupling.

Prism comes with the AdventureWorks Shopper reference implementation which uses the Prism library to demonstrate modern development practices such as Model-View-ViewModel (MVVM) pattern with navigation and app lifecycle management. Additionally the reference implementation demonstrates validation, application data management, accessibility, localizability, touch, search, tiles, tile notification, and multiple view states. It also provides guidance on testing your app and tuning its performance.

What’s in the box?

Reference implementation: AdventureWorks Shopper
Quickstarts

Hello World
Event Aggregator
Validation

Prism library

Microsoft.Practices.Prism.PubSubEvents: Event Aggregator in a portable class library
Microsoft.Practices.Prism.StoreApps: Bootstrapping, MVVM, Navigation, Lifecycle Management, Delegate Command, Settings Charm, Search, and Flyout Support

Documentation: on Windows Dev Center and in PDF

How to get it?

The Prism library source code is available with the AdventureWorks Shopper reference implementation on the MSDN Code Gallery at http://aka.ms/prism-winrt-code. The Prism binaries will be available on NuGet starting Monday May 20. Search for Prism.

You can view the documentation at http://aka.ms/prism-winrt-doc or download a PDF version at http://aka.ms/prism-winrt-pdf.

How to get started?

For an overview of the guidance, watch this Channel 9 Video of Francis Cheung and myself giving a walk through of Prism. To evaluate and see the guidance in action go to Getting Started chapter of the documentation. This chapter tells you how to build and run the reference implementation as well as describes the different projects in the solution.

To create your first app see Using Prism for the Windows Runtime chapter in the documentation. You should also follow Francis Cheung’s blog post if you want more detailed instructions. Additionally our CodePlex Knowledge Base page provides additional resources to get started.

How to provide feedback?

If you’d like to provide feedback, please post it via the Codeplex forum. This is where you can also get support. We have a dedicated sustained engineering team monitoring the forum regularly. To report a bug, use online Issue Tracker. We will start planning the next release soon so your feedback is appreciated.

If you have a story of how your team leverages Prism and would like to share it with the broader community, please contact us. We’ll be happy to work with you on a case study.

Happy coding.

如何比對資料表筆數(值)

jchiou — Sat, 18 May 2013 05:40:49 GMT

資料庫轉移到不同伺服器後, 想要比對各資料表筆數有沒有不同

若資料值或是筆數不同，代表在移轉過程仍有應用程式在操作資料庫，會造成資料不一致。

RESOLUTION 1:

使用 Visual Studio 2010 資料比較工具，可以比對到每一個資料值。

RESOLUTION 2:

使用 TSQL + Excel 來做

--此語法相容於 SQL 2000

--DROP TABLE temp_table

--TRUNCATE TABLE temp_table

CREATE TABLE temp_table

(

no_of_rows INTEGER,

table_name VARCHAR(30),

)

EXEC sp_MSforeachtable 'INSERT INTO temp_table SELECT COUNT(*) AS nr_of_rows, ''?'' AS table_name FROM ?'

SELECT * FROM temp_table

--DROP TABLE temp_table

--TRUNCATE TABLE temp_table

在兩個伺服器執行上述的 Script

在將值貼到 Excel 中, 我在 C 欄位寫了一個公式: =IF(ISERROR(MATCH(A4,D4,0)),A4,"")

若兩邊的資料有所不同, 會顯示在 C 欄位中

Enjoy.

I don’t have to do anything and my credit card information gets breached

tzink — Sat, 18 May 2013 05:20:29 GMT

Yesterday, while reading a book on my Kindle app (on my PC), I got an email from American Express with the subject line “Fraud Protection Alert.”

“Fraud protection?” I said (out loud, to no one in particular, except for possibly my cat who did not respond).

Yes, fraud protection. In the email message, it had the last 5-digits of my account number so I knew it was probably my card and then it had the name of a merchant – Shell Canada – and a charge of $20.00 Cdn funds.

I racked my brain. Did anyone I know have my credit card in Canada at the moment? No, they don’t. I looked at the contact information and gave Amex a call where I subsequently reversed the charges, got the card cancelled and got a new one.

I don’t know how this card could have been breached. It is my corporate credit card, and I use it very rarely – only to travel on business. It stays with me at all times. How did some scammer steal it and use it?

I started making a paper trail in my head. Since nobody had physical access to my card, I could only assume that it was a breach – some hacker broke in to a business I had used and leaked all the credit card data, probably pasting it online somewhere. Some other scammer (or possibly the same one) used that leak to buy gasoline.

Working my way backwards, my theory is that the probable source of the leak is proportional to how recently I used the card. That is, if the last time I used the card was May 1, then that is the most likely source of the leak. If the second last time I used the card was April 28, then that is the second most likely source.

Now, you may not agree with this theory; however, because I use this card so rarely and the time space between major transactions is weeks (or months), it’s a good place to start for my usage-pattern.

Using this as a starting point, I started thinking about what I’ve purchased in the past two months:

Airline tickets
Booked a hotel

Well, that doesn’t help much. Either the airline leaked it, or the hotel leaked it. If I were to guess, I’d guess the hotel leaked it since they are tempting targets for identity thieves because of their clientele (business travelers) and hotels don’t always have the same safeguards that banks do (airlines are under more scrutiny).

I called up my credit card company and canceled the card. They sent me a new one and it arrived today. Upon checking my account, I discovered that said thief charged three different purchases at a gas station in Montreal.

I am no closer to figuring out where this leak may have happened.

* * * * * * * * * * * * *

Fast forward to today, and I got a letter from my bank. I opened it up and inside is a new debit card. For you see, while they were doing routine fraud detection, they discovered some fraudulent activity on my card and sent me a new one.

What in the world?

First my credit card, now my debit card?

As disconcerting as this is to lose two cards in a week, it also potentially helps narrow down the target. Where did I use my debit card and credit card in the same place?

I went to my credit card website and made a list of all purchases from the start of the year. I figured that a likely suspect was this past February while I was at the MAAWG conference in San Francisco. That’s when I would use my corporate credit card.

Next, I checked my debit card purchases during that same time frame, looking to see if there were any vendors that were in common.

There was: the Buckhorn Grill in San Francisco. One day I went there because I was there on business, but I stayed an extra day in San Francisco and paid for it myself.

Two cards in one place.

Both cards leaked this week.

This could be a coincidence, but I don’t think so. I think that’s where the data leak occurred. I don’t remember much about the transaction, but either the card information wasn’t encoded and someone wrote down the number, or they had a breach.

My theory about the “recentcy” effect was right, but I didn’t go back far enough. I had to go back 3 months in time rather than a few weeks.

While I don’t like getting my data exposed, it does make me feel better to engage in this detective work and figure out a likely place of origin.

Você precisa de todas as colunas em uma QueryExpression?

Marco A. Rodrigues Neto — Sat, 18 May 2013 05:14:00 GMT

Essa semana trabalhei em um cliente e notei que suas customizações (plugins, webservices) possuíam em grande maioria as queries (QueryExpression) construídas com o objeto ColumnSet definindo todas as colunas na pesquisa.
Em várias situações, as queries eram utilizadas com o propósito de verificar apenas o valor de um ou dois campos dos registros.

Vamos ver abaixo a diferença de performance quando temos uma QueryExpression com o objeto ColumnSet requisitando todos atributos e outro cenário requisitando somente os necessários.

Considere o seguinte trecho de código de exemplo* executado em uma organização com o Sample Data instalado:

ConditionExpression condition = new ConditionExpression();
condition.AttributeName = "address1_city";
condition.Operator = ConditionOperator.Equal;
condition.Values.Add("Redmond");
 
ColumnSet columns = new ColumnSet(true);

QueryExpression query = new QueryExpression();
query.EntityName = "contact";
query.ColumnSet = columns;
query.Criteria.AddCondition(condition);

EntityCollection results = service.RetrieveMultiple(query);

foreach (Entity contact in results.Entities)
{
 Console.WriteLine(contact["fullname"] + ": " + contact["emailaddress1"]); 
}

Repare que preciso apenas do Nome Completo e Endereço de E-mail dos contatos onde a cidade é igual a Redmond. Vamos ver como essa QueryExpression foi traduzida no SQL Server e respectivos números:

exec sp_executesql N'select top 5001 "contact0".SpousesName as "spousesname", "contact0".EMailAddress3 as "emailaddress3", "contact0".Address2_ShippingMethodCode as "address2_shippingmethodcode", "contact0".PreferredServiceId as "preferredserviceid"
 , "contact0".AnnualIncome as "annualincome", "contact0".Address2_Line2 as "address2_line2", "contact0".Fax as "fax", "contact0".Telephone3 as "telephone3", "contact0".PreferredAppointmentDayCode as "preferredappointmentdaycode"
 , "contact0".Address2_StateOrProvince as "address2_stateorprovince", "contact0".CreatedBy as "createdby", "contact0".Address2_Line1 as "address2_line1", "contact0".LastUsedInCampaign as "lastusedincampaign", "contact0".YomiLastName as "yomilastname"
 , "contact0".Pager as "pager", "contact0".EmployeeId as "employeeid", "contact0".TerritoryCode as "territorycode", "contact0".ParentCustomerId as "parentcustomerid", "contact0".ManagerName as "managername"
 , "contact0".BirthDate as "birthdate", "contact0".NumberOfChildren as "numberofchildren", "contact0".Address1_AddressTypeCode as "address1_addresstypecode", "contact0".OwningTeam as "owningteam", "contact0".Address2_PostalCode as "address2_postalcode"
 , "contact0".UTCConversionTimeZoneCode as "utcconversiontimezonecode", "contact0".OwningUser as "owninguser", "contact0".AssistantPhone as "assistantphone", "contact0".MasterId as "masterid", "contact0".CreatedOnBehalfBy as "createdonbehalfby"
 , "contact0".Address1_Latitude as "address1_latitude", "contact0".MobilePhone as "mobilephone", "contact0".CustomerTypeCode as "customertypecode", "contact0".ManagerPhone as "managerphone", "contact0".Address1_FreightTermsCode as "address1_freighttermscode"
 , "contact0".Address1_Longitude as "address1_longitude", "contact0".Address2_Telephone2 as "address2_telephone2", "contact0".StatusCode as "statuscode", "contact0".YomiFullName as "yomifullname", "contact0".Aging90_Base as "aging90_base"
 , "contact0".FamilyStatusCode as "familystatuscode", "contact0".FirstName as "firstname", "contact0".Address2_Latitude as "address2_latitude", "contact0".Department as "department", "contact0".OriginatingLeadId as "originatingleadid"
 , "contact0".Aging60 as "aging60", "contact0".StateCode as "statecode", "contact0".Address2_FreightTermsCode as "address2_freighttermscode", "contact0".Address1_Name as "address1_name", "contact0".YomiMiddleName as "yomimiddlename"
 , "contact0".ModifiedOnBehalfBy as "modifiedonbehalfby", "contact0".Description as "description", "contact0".EducationCode as "educationcode", "contact0".Address1_Telephone3 as "address1_telephone3", "contact0".Address2_Telephone1 as "address2_telephone1"
 , "contact0".ImportSequenceNumber as "importsequencenumber", "contact0".GenderCode as "gendercode", "contact0".OwnerId as "ownerid", "contact0".Address2_AddressTypeCode as "address2_addresstypecode", "contact0".Address1_UTCOffset as "address1_utcoffset"
 , "contact0".CreditLimit_Base as "creditlimit_base", "contact0".Aging60_Base as "aging60_base", "contact0".Address1_County as "address1_county", "contact0".OwningBusinessUnit as "owningbusinessunit", "contact0".JobTitle as "jobtitle"
 , "contact0".Address1_Telephone2 as "address1_telephone2", "contact0".TimeZoneRuleVersionNumber as "timezoneruleversionnumber", "contact0".Address1_Fax as "address1_fax", "contact0".Address2_PostOfficeBox as "address2_postofficebox", "contact0".Address1_Line2 as "address1_line2"
 , "contact0".WebSiteUrl as "websiteurl", "contact0".DoNotPostalMail as "donotpostalmail", "contact0".Address2_UTCOffset as "address2_utcoffset", "contact0".ExchangeRate as "exchangerate", "contact0".CreatedOn as "createdon"
 , "contact0".EMailAddress2 as "emailaddress2", "contact0".Address2_Line3 as "address2_line3", "contact0".Address2_AddressId as "address2_addressid", "contact0".OverriddenCreatedOn as "overriddencreatedon", "contact0".AnnualIncome_Base as "annualincome_base"
 , "contact0".Address1_Telephone1 as "address1_telephone1", "contact0".ChildrensNames as "childrensnames", "contact0".PreferredContactMethodCode as "preferredcontactmethodcode", "contact0".Aging90 as "aging90", "contact0".DoNotBulkPostalMail as "donotbulkpostalmail"
 , "contact0".EMailAddress1 as "emailaddress1", "contact0".DoNotBulkEMail as "donotbulkemail", "contact0".CustomerSizeCode as "customersizecode", "contact0".Address1_StateOrProvince as "address1_stateorprovince", "contact0".FullName as "fullname"
 , "contact0".PreferredAppointmentTimeCode as "preferredappointmenttimecode", "contact0".TransactionCurrencyId as "transactioncurrencyid", "contact0".PaymentTermsCode as "paymenttermscode", "contact0".Aging30 as "aging30", "contact0".LeadSourceCode as "leadsourcecode"
 , "contact0".Merged as "merged", "contact0".Address2_County as "address2_county", "contact0".Address1_ShippingMethodCode as "address1_shippingmethodcode", "contact0".FtpSiteUrl as "ftpsiteurl", "contact0".PreferredSystemUserId as "preferredsystemuserid"
 , "contact0".Address1_AddressId as "address1_addressid", "contact0".NickName as "nickname", "contact0".Address1_PostOfficeBox as "address1_postofficebox", "contact0".PreferredEquipmentId as "preferredequipmentid", "contact0".AssistantName as "assistantname"
 , "contact0".Address2_Country as "address2_country", "contact0".ModifiedOn as "modifiedon", "contact0".ExternalUserIdentifier as "externaluseridentifier", "contact0".Address2_Name as "address2_name", "contact0".CreditOnHold as "creditonhold"
 , "contact0".ParticipatesInWorkflow as "participatesinworkflow", "contact0".AccountRoleCode as "accountrolecode", "contact0".Address2_Telephone3 as "address2_telephone3", "contact0".DoNotPhone as "donotphone", "contact0".ContactId as "contactid"
 , "contact0".DoNotFax as "donotfax", "contact0".Aging30_Base as "aging30_base", "contact0".Address1_UPSZone as "address1_upszone", "contact0".Suffix as "suffix", "contact0".Address1_PrimaryContactName as "address1_primarycontactname"
 , "contact0".Salutation as "salutation", "contact0".ModifiedBy as "modifiedby", "contact0".GovernmentId as "governmentid", "contact0".Address2_PrimaryContactName as "address2_primarycontactname", "contact0".DoNotSendMM as "donotsendmm"
 , "contact0".Address2_Longitude as "address2_longitude", "contact0".Address1_Country as "address1_country", "contact0".LastName as "lastname", "contact0".Address2_City as "address2_city", "contact0".DoNotEMail as "donotemail"
 , "contact0".Address1_City as "address1_city", "contact0".YomiFirstName as "yomifirstname", "contact0".Telephone1 as "telephone1", "contact0".Address1_Line1 as "address1_line1", "contact0".ShippingMethodCode as "shippingmethodcode"
 , "contact0".CreditLimit as "creditlimit", "contact0".Anniversary as "anniversary", "contact0".Telephone2 as "telephone2", "contact0".HasChildrenCode as "haschildrencode", "contact0".Address2_Fax as "address2_fax"
 , "contact0".IsBackofficeCustomer as "isbackofficecustomer", "contact0".Address1_Line3 as "address1_line3", "contact0".Address2_UPSZone as "address2_upszone", "contact0".DefaultPriceLevelId as "defaultpricelevelid", "contact0".MiddleName as "middlename"
 , "contact0".Address1_PostalCode as "address1_postalcode", "contact0".new_customfield as "new_customfield", "contact0".PreferredServiceIdName as "preferredserviceidname", "contact0".CreatedByYomiName as "createdbyyominame", "contact0".CreatedByName as "createdbyname"
 , "contact0".ParentCustomerIdName as "parentcustomeridname", "contact0".ParentCustomerIdYomiName as "parentcustomeridyominame", "contact0".ParentCustomerIdType as "parentcustomeridtype", "contact0".MasterContactIdYomiName as "mastercontactidyominame", "contact0".MasterContactIdName as "mastercontactidname"
 , "contact0".CreatedOnBehalfByYomiName as "createdonbehalfbyyominame", "contact0".CreatedOnBehalfByName as "createdonbehalfbyname", "contact0".OriginatingLeadIdName as "originatingleadidname", "contact0".OriginatingLeadIdYomiName as "originatingleadidyominame", "contact0".ModifiedOnBehalfByYomiName as "modifiedonbehalfbyyominame"
 , "contact0".ModifiedOnBehalfByName as "modifiedonbehalfbyname", "contact0".OwnerIdType as "owneridtype", "contact0".OwnerIdName as "owneridname", "contact0".OwnerIdYomiName as "owneridyominame", "contact0".TransactionCurrencyIdName as "transactioncurrencyidname"
 , "contact0".PreferredSystemUserIdName as "preferredsystemuseridname", "contact0".PreferredSystemUserIdYomiName as "preferredsystemuseridyominame", "contact0".PreferredEquipmentIdName as "preferredequipmentidname", "contact0".ModifiedByYomiName as "modifiedbyyominame", "contact0".ModifiedByName as "modifiedbyname"
 , "contact0".DefaultPriceLevelIdName as "defaultpricelevelidname" from Contact as "contact0" where (("contact0".Address1_City = @Address1_City0)) order by
 "contact0".ContactId asc',N'@Address1_City0 nvarchar(7)',@Address1_City0=N'Redmond'

Uma grande quantidade desnecessária de colunas são retornadas. Adicionalmente, várias outras tabelas são incluídas nessa pesquisa (Left Outer Join) gerando cerca de 68 logical reads.

(2 row(s) affected)
Table 'OwnerBase'. Scan count 1, logical reads 5, physical reads 0, …
Table 'TransactionCurrencyBase'. Scan count 1, logical reads 5, physical reads 0, …
Table 'SystemUserBase'. Scan count 5, logical reads 30, physical reads 0, …
Table 'ServiceBase'. Scan count 1, logical reads 0, physical reads 0, …
Table 'PriceLevelBase'. Scan count 1, logical reads 5, physical reads 0, …
Table 'EquipmentBase'. Scan count 1, logical reads 0, physical reads 0, …
Table 'LeadBase'. Scan count 0, logical reads 0, physical reads 0, …
Table 'ContactBase'. Scan count 0, logical reads 10, physical reads 0, …
Table 'CustomerAddressBase'. Scan count 1, logical reads 9, physical reads 0, …
Table 'ContactExtensionBase'. Scan count 0, logical reads 4, physical reads 0, …

Dessa vez, vamos executar o mesmo código de exemplo, porém, informando as colunas necessárias para este exemplo no ColumnSet:

ColumnSet columns = new ColumnSet();
columns.AddColumns("fullname", "emailaddress1");
 
QueryExpression query = new QueryExpression();
query.EntityName = "contact";
query.ColumnSet = columns;
query.Criteria.AddCondition(condition);

A diferença é notável na query e nos respectivos números (reduzimos de 10 tabelas para 3 e de 68 logical reads para apenas 19):

exec sp_executesql N'select 
 top 5001 "contact0".FullName as "fullname"
 , "contact0".EMailAddress1 as "emailaddress1"
 , "contact0".ContactId as "contactid" 
 from Contact as "contact0" where
 (("contact0".Address1_City = @Address1_City0)) order by
 "contact0".ContactId asc',N'@Address1_City0 nvarchar(7)',@Address1_City0=N'Redmond'

(2 row(s) affected)
Table 'ContactExtensionBase'. Scan count 0, logical reads 4, physical reads 0, …
Table 'ContactBase'. Scan count 0, logical reads 10, physical reads 0, …
Table 'CustomerAddressBase'. Scan count 1, logical reads 5, physical reads 0, …

Resumo: No exemplo acima, notamos melhor performance nas queries criadas via QueryExpression quando utilizamos o objeto ColumnSet para retornar somente os campos necessários para este cenário.

Código de Exemplo: fornecido apenas como ilustração, sem qualquer tipo de garantia ou suporte da Microsoft.

Implementing Role Based Access for PowerPivot

Rakesh M J — Sat, 18 May 2013 04:09:19 GMT

This has been a very long week, and I have written a paper which will guide you step by step in implementing role based access for PowerPivot.

You can download the file from here.

[ SQL ] 一次修改所有的 User Databases 的 PAGE_VERIFY 為 CHECKSUM

jchiou — Sat, 18 May 2013 02:40:46 GMT

What it is: 一次修改所有的 User Databases 的 PAGE_VERIFY 為 CHECKSUM

Why it is important: 當針對 PAGE_VERIFY 資料庫選項啟用 CHECKSUM 時，SQL Server Database Engine 會針對整頁的內容計算總和檢查碼，並在將頁面寫入磁碟時，於頁首中儲存值。從磁碟讀取頁面時，會重新計算總和檢查碼，並與頁首所儲存的總和檢查碼值作比較。如此有助於提供高層級的資料檔完整性。此設定為建議值。

RESOLUTION:

DECLARE @DBName varchar (50), @msg varchar (60), @sql varchar(60)

DECLARE GetDBNames CURSOR

FOR

SELECT name FROM sys.databases WHERE page_verify_option < 2 AND database_id > 4 AND is_read_only = 0

OPEN GetDBNames

FETCH NEXT FROM GetDBNames INTO @DBName

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT ' '

SELECT @msg = '----- Change ' + UPPER(RTRIM(@DBName)) + ' -----'

PRINT @msg

SET @sql='ALTER Database ' + @DBName + ' SET PAGE_VERIFY CHECKSUM'

PRINT 'SQL Statement is ' + @sql

EXEC (@sql)

PRINT 'PAGE_VERIFY changed to CHECKSUM for database = ' + @DBName

FETCH NEXT FROM GetDBNames INTO @DBName

END

CLOSE GetDBNames

DEALLOCATE GetDBNames

Enjoy.

Você precisa de todas as colunas em uma QueryExpression?

Marco A. Rodrigues Neto — Sat, 18 May 2013 01:34:00 GMT

ConditionExpression condition = new ConditionExpression();
condition.AttributeName = "address1_city";
condition.Operator = ConditionOperator.Equal;
condition.Values.Add("Redmond");
 
ColumnSet columns = new ColumnSet(true);

QueryExpression query = new QueryExpression();
query.EntityName = "contact";
query.ColumnSet = columns;
query.Criteria.AddCondition(condition);

EntityCollection results = service.RetrieveMultiple(query);

foreach (Entity contact in results.Entities)
{
 Console.WriteLine(contact["fullname"] + ": " + contact["emailaddress1"]); 
}

exec sp_executesql N'select top 5001 "contact0".SpousesName as "spousesname", "contact0".EMailAddress3 as "emailaddress3", "contact0".Address2_ShippingMethodCode as "address2_shippingmethodcode", "contact0".PreferredServiceId as "preferredserviceid"
 , "contact0".AnnualIncome as "annualincome", "contact0".Address2_Line2 as "address2_line2", "contact0".Fax as "fax", "contact0".Telephone3 as "telephone3", "contact0".PreferredAppointmentDayCode as "preferredappointmentdaycode"
 , "contact0".Address2_StateOrProvince as "address2_stateorprovince", "contact0".CreatedBy as "createdby", "contact0".Address2_Line1 as "address2_line1", "contact0".LastUsedInCampaign as "lastusedincampaign", "contact0".YomiLastName as "yomilastname"
 , "contact0".Pager as "pager", "contact0".EmployeeId as "employeeid", "contact0".TerritoryCode as "territorycode", "contact0".ParentCustomerId as "parentcustomerid", "contact0".ManagerName as "managername"
 , "contact0".BirthDate as "birthdate", "contact0".NumberOfChildren as "numberofchildren", "contact0".Address1_AddressTypeCode as "address1_addresstypecode", "contact0".OwningTeam as "owningteam", "contact0".Address2_PostalCode as "address2_postalcode"
 , "contact0".UTCConversionTimeZoneCode as "utcconversiontimezonecode", "contact0".OwningUser as "owninguser", "contact0".AssistantPhone as "assistantphone", "contact0".MasterId as "masterid", "contact0".CreatedOnBehalfBy as "createdonbehalfby"
 , "contact0".Address1_Latitude as "address1_latitude", "contact0".MobilePhone as "mobilephone", "contact0".CustomerTypeCode as "customertypecode", "contact0".ManagerPhone as "managerphone", "contact0".Address1_FreightTermsCode as "address1_freighttermscode"
 , "contact0".Address1_Longitude as "address1_longitude", "contact0".Address2_Telephone2 as "address2_telephone2", "contact0".StatusCode as "statuscode", "contact0".YomiFullName as "yomifullname", "contact0".Aging90_Base as "aging90_base"
 , "contact0".FamilyStatusCode as "familystatuscode", "contact0".FirstName as "firstname", "contact0".Address2_Latitude as "address2_latitude", "contact0".Department as "department", "contact0".OriginatingLeadId as "originatingleadid"
 , "contact0".Aging60 as "aging60", "contact0".StateCode as "statecode", "contact0".Address2_FreightTermsCode as "address2_freighttermscode", "contact0".Address1_Name as "address1_name", "contact0".YomiMiddleName as "yomimiddlename"
 , "contact0".ModifiedOnBehalfBy as "modifiedonbehalfby", "contact0".Description as "description", "contact0".EducationCode as "educationcode", "contact0".Address1_Telephone3 as "address1_telephone3", "contact0".Address2_Telephone1 as "address2_telephone1"
 , "contact0".ImportSequenceNumber as "importsequencenumber", "contact0".GenderCode as "gendercode", "contact0".OwnerId as "ownerid", "contact0".Address2_AddressTypeCode as "address2_addresstypecode", "contact0".Address1_UTCOffset as "address1_utcoffset"
 , "contact0".CreditLimit_Base as "creditlimit_base", "contact0".Aging60_Base as "aging60_base", "contact0".Address1_County as "address1_county", "contact0".OwningBusinessUnit as "owningbusinessunit", "contact0".JobTitle as "jobtitle"
 , "contact0".Address1_Telephone2 as "address1_telephone2", "contact0".TimeZoneRuleVersionNumber as "timezoneruleversionnumber", "contact0".Address1_Fax as "address1_fax", "contact0".Address2_PostOfficeBox as "address2_postofficebox", "contact0".Address1_Line2 as "address1_line2"
 , "contact0".WebSiteUrl as "websiteurl", "contact0".DoNotPostalMail as "donotpostalmail", "contact0".Address2_UTCOffset as "address2_utcoffset", "contact0".ExchangeRate as "exchangerate", "contact0".CreatedOn as "createdon"
 , "contact0".EMailAddress2 as "emailaddress2", "contact0".Address2_Line3 as "address2_line3", "contact0".Address2_AddressId as "address2_addressid", "contact0".OverriddenCreatedOn as "overriddencreatedon", "contact0".AnnualIncome_Base as "annualincome_base"
 , "contact0".Address1_Telephone1 as "address1_telephone1", "contact0".ChildrensNames as "childrensnames", "contact0".PreferredContactMethodCode as "preferredcontactmethodcode", "contact0".Aging90 as "aging90", "contact0".DoNotBulkPostalMail as "donotbulkpostalmail"
 , "contact0".EMailAddress1 as "emailaddress1", "contact0".DoNotBulkEMail as "donotbulkemail", "contact0".CustomerSizeCode as "customersizecode", "contact0".Address1_StateOrProvince as "address1_stateorprovince", "contact0".FullName as "fullname"
 , "contact0".PreferredAppointmentTimeCode as "preferredappointmenttimecode", "contact0".TransactionCurrencyId as "transactioncurrencyid", "contact0".PaymentTermsCode as "paymenttermscode", "contact0".Aging30 as "aging30", "contact0".LeadSourceCode as "leadsourcecode"
 , "contact0".Merged as "merged", "contact0".Address2_County as "address2_county", "contact0".Address1_ShippingMethodCode as "address1_shippingmethodcode", "contact0".FtpSiteUrl as "ftpsiteurl", "contact0".PreferredSystemUserId as "preferredsystemuserid"
 , "contact0".Address1_AddressId as "address1_addressid", "contact0".NickName as "nickname", "contact0".Address1_PostOfficeBox as "address1_postofficebox", "contact0".PreferredEquipmentId as "preferredequipmentid", "contact0".AssistantName as "assistantname"
 , "contact0".Address2_Country as "address2_country", "contact0".ModifiedOn as "modifiedon", "contact0".ExternalUserIdentifier as "externaluseridentifier", "contact0".Address2_Name as "address2_name", "contact0".CreditOnHold as "creditonhold"
 , "contact0".ParticipatesInWorkflow as "participatesinworkflow", "contact0".AccountRoleCode as "accountrolecode", "contact0".Address2_Telephone3 as "address2_telephone3", "contact0".DoNotPhone as "donotphone", "contact0".ContactId as "contactid"
 , "contact0".DoNotFax as "donotfax", "contact0".Aging30_Base as "aging30_base", "contact0".Address1_UPSZone as "address1_upszone", "contact0".Suffix as "suffix", "contact0".Address1_PrimaryContactName as "address1_primarycontactname"
 , "contact0".Salutation as "salutation", "contact0".ModifiedBy as "modifiedby", "contact0".GovernmentId as "governmentid", "contact0".Address2_PrimaryContactName as "address2_primarycontactname", "contact0".DoNotSendMM as "donotsendmm"
 , "contact0".Address2_Longitude as "address2_longitude", "contact0".Address1_Country as "address1_country", "contact0".LastName as "lastname", "contact0".Address2_City as "address2_city", "contact0".DoNotEMail as "donotemail"
 , "contact0".Address1_City as "address1_city", "contact0".YomiFirstName as "yomifirstname", "contact0".Telephone1 as "telephone1", "contact0".Address1_Line1 as "address1_line1", "contact0".ShippingMethodCode as "shippingmethodcode"
 , "contact0".CreditLimit as "creditlimit", "contact0".Anniversary as "anniversary", "contact0".Telephone2 as "telephone2", "contact0".HasChildrenCode as "haschildrencode", "contact0".Address2_Fax as "address2_fax"
 , "contact0".IsBackofficeCustomer as "isbackofficecustomer", "contact0".Address1_Line3 as "address1_line3", "contact0".Address2_UPSZone as "address2_upszone", "contact0".DefaultPriceLevelId as "defaultpricelevelid", "contact0".MiddleName as "middlename"
 , "contact0".Address1_PostalCode as "address1_postalcode", "contact0".new_customfield as "new_customfield", "contact0".PreferredServiceIdName as "preferredserviceidname", "contact0".CreatedByYomiName as "createdbyyominame", "contact0".CreatedByName as "createdbyname"
 , "contact0".ParentCustomerIdName as "parentcustomeridname", "contact0".ParentCustomerIdYomiName as "parentcustomeridyominame", "contact0".ParentCustomerIdType as "parentcustomeridtype", "contact0".MasterContactIdYomiName as "mastercontactidyominame", "contact0".MasterContactIdName as "mastercontactidname"
 , "contact0".CreatedOnBehalfByYomiName as "createdonbehalfbyyominame", "contact0".CreatedOnBehalfByName as "createdonbehalfbyname", "contact0".OriginatingLeadIdName as "originatingleadidname", "contact0".OriginatingLeadIdYomiName as "originatingleadidyominame", "contact0".ModifiedOnBehalfByYomiName as "modifiedonbehalfbyyominame"
 , "contact0".ModifiedOnBehalfByName as "modifiedonbehalfbyname", "contact0".OwnerIdType as "owneridtype", "contact0".OwnerIdName as "owneridname", "contact0".OwnerIdYomiName as "owneridyominame", "contact0".TransactionCurrencyIdName as "transactioncurrencyidname"
 , "contact0".PreferredSystemUserIdName as "preferredsystemuseridname", "contact0".PreferredSystemUserIdYomiName as "preferredsystemuseridyominame", "contact0".PreferredEquipmentIdName as "preferredequipmentidname", "contact0".ModifiedByYomiName as "modifiedbyyominame", "contact0".ModifiedByName as "modifiedbyname"
 , "contact0".DefaultPriceLevelIdName as "defaultpricelevelidname" from Contact as "contact0" where (("contact0".Address1_City = @Address1_City0)) order by
 "contact0".ContactId asc',N'@Address1_City0 nvarchar(7)',@Address1_City0=N'Redmond'

Uma grande quantidade desnecessária de colunas são retornadas. Adicionalmente, várias outras tabelas são incluídas nessa pesquisa (Left Outer Join) gerando cerca de 68 logical reads.

Dessa vez, vamos executar o mesmo código de exemplo, porém, informando as colunas necessárias para este exemplo no ColumnSet:

ColumnSet columns = new ColumnSet();
columns.AddColumns("fullname", "emailaddress1");
 
QueryExpression query = new QueryExpression();
query.EntityName = "contact";
query.ColumnSet = columns;
query.Criteria.AddCondition(condition);

A diferença é notável na query e nos respectivos números (reduzimos de 10 tabelas para 3 e de 68 logical reads para apenas 19):

exec sp_executesql N'select 
 top 5001 "contact0".FullName as "fullname"
 , "contact0".EMailAddress1 as "emailaddress1"
 , "contact0".ContactId as "contactid" 
 from Contact as "contact0" where
 (("contact0".Address1_City = @Address1_City0)) order by
 "contact0".ContactId asc',N'@Address1_City0 nvarchar(7)',@Address1_City0=N'Redmond'

SharePoint Adventures : Claims, Named Pipes and Kerberos

Adam W. Saxton — Fri, 17 May 2013 21:17:15 GMT

I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related to this blog post. It’s rare that I actually see a case related to the Named Pipes protocol. When I do, it is usually a customer trying to get it setup with a Cluster deployment. I have never had a Named Pipes case related to Kerberos. On top of that, I’ve never had a SQL related Kerberos issue that looked like an actual network related issue. I usually see a traditional “Login failed for user” type error from the SQL Server itself.

As part of my troubleshooting for the other blog post with the Claims configuration, I stumbled upon some information and theories about how Named Pipes responds when Kerberos is in the picture that I hadn’t ever seen or dealt with before. I love when I see new things! It is very humbling and always reminds me there are a lot of things that I don’t know. And, if you have read my other blog posts, or have seen me present at conferences like PASS, you know I have a passion for Kerberos!

Here is what I saw from an error perspective using SharePoint 2013 and Reporting Services 2012 SP1.

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception: Access is denied

This is a typical error if we can’t connect to SQL. Think of this like a “Server doesn’t exist” type error. We didn’t get the normal “Login failed for user” error that would possibly point towards Kerberos. In this error, we didn’t even make it to SQL. The interesting piece here though is the “Access is denied” inner exception. That does possibly point to a permission issue.

I had talked in the last Blog Post about protocol order with connecting to SQL and that the default was TCP. In this case, I was forcing Named Pipes, so the fact that the error is a Named Pipes error is expected.

I dropped down to a network trace to see how far we actually got and to see if that revealed any other information. One thing to keep in mind here is that we are in a Claims to Windows Token Service (C2WTS) scenario with the SharePoint/RS 2012 integration. So, Kerberos/Constrained Delegation will be in the picture here. A lot of people aren’t necessarily familiar with how Named Pipes actually works. Named Pipes actually uses the SMB (simple message block) protocol from a network perspective. This is the same protocol used for file shares and you’ll see the traffic on port 445. It can be a little confusing because SMB sits on top of TCP, but we aren’t actually using the TCP 1433 port. It is just a different way to connect to SQL Server. The IP 10.0.0.20 was the SharePoint Server hosting the Reporting Services Service.

300    9:04:40 AM 5/17/2013    10.0.0.20    captthrace.battlestar.local    SMB    SMB:C; Negotiate, Dialect = PC NETWORK PROGRAM 1.0, LANMAN1.0, Windows for Workgroups 3.1a, LM1.2X002, LANMAN2.1, NT LM 0.12, SMB 2.002, SMB 2.???    {SMBOverTCP:42, TCP:41, IPv4:1}

302    9:04:40 AM 5/17/2013    captthrace.battlestar.local    10.0.0.20    SMB2    SMB2:R   NEGOTIATE (0x0), Revision: (0x2ff) - SMB2 wildcard revision number., ServerGUID={97B805C2-296C-477B-82B4-DEB6170A2A01} Authentication Method: GSSAPI,     {SMBOverTCP:42, TCP:41, IPv4:1}

303    9:04:40 AM 5/17/2013    10.0.0.20    captthrace.battlestar.local    SMB2    SMB2:C   NEGOTIATE (0x0), ClientGUID= {9CB563F9-BEF4-11E2-9403-00155D4CB97B},     {SMBOverTCP:42, TCP:41, IPv4:1}

304    9:04:40 AM 5/17/2013    captthrace.battlestar.local    10.0.0.20    SMB2    SMB2:R   NEGOTIATE (0x0), Revision: (0x300) - SMB 3.0 dialect revision number., ServerGUID={97B805C2-296C-477B-82B4-DEB6170A2A01} Authentication Method: GSSAPI,     {SMBOverTCP:42, TCP:41, IPv4:1}

323    9:04:40 AM 5/17/2013    10.0.0.20    captthrace.battlestar.local    SMB2    SMB2:C   SESSION SETUP (0x1) Authentication Method: GSSAPI,     {SMBOverTCP:42, TCP:41, IPv4:1}

326    9:04:40 AM 5/17/2013    captthrace.battlestar.local    10.0.0.20    SMB2    SMB2:R - NT Status: System - Error, Code = (22) STATUS_MORE_PROCESSING_REQUIRED SESSION SETUP (0x1), SessionFlags=0x0 Authentication Method: GSSAPI,     {SMBOverTCP:42, TCP:41, IPv4:1}

327    9:04:40 AM 5/17/2013    10.0.0.20    captthrace.battlestar.local    SMB2    SMB2:C   SESSION SETUP (0x1) Authentication Method: GSSAPI,     {SMBOverTCP:42, TCP:41, IPv4:1}
     - ResponseToken: NTLM AUTHENTICATE MESSAGE Version:NTLM v2, Workstation: CAPTHELO
          Signature: NTLMSSP

328    9:04:40 AM 5/17/2013    captthrace.battlestar.local    10.0.0.20    SMB2    SMB2:R - NT Status: System - Error, Code = (34) STATUS_ACCESS_DENIED SESSION SETUP (0x1) ,     {SMBOverTCP:42, TCP:41, IPv4:1}

329    9:04:40 AM 5/17/2013    10.0.0.20    captthrace.battlestar.local    TCP    TCP:Flags=...A.R.., SrcPort=49665, DstPort=Microsoft-DS(445), PayloadLen=0, Seq=2945236632, Ack=2852397926, Win=0 (scale factor 0x8) = 0    {TCP:41, IPv4:1}

In the Network Trace we can see that we were trying to connect via NTLM. I already know that that will be a problem as we have to go Kerberos. We started supporting Kerberos with Named Pipes starting in SQL 2008, so it should work. At this point, I’m thinking we actually have a Kerberos issue even though it looked like a network issue from the original error message. So, lets go see if we can validate that. I already had Kerberos Event Logging enabled. These entries will be located in the System Event Log. You can ignore errors that show “KDC_ERR_PREAUTH_REQUIRED”. That is just noise and expected. Also realize that errors may be cached and if they are, you will not see them in the Event Log or a Network Trace. It may require an IISRESET, a reset of the C2WTS Windows Service, or even a reboot of the box to get the items to show in the Event log or Network Trace. See this Blog Post.

Log Name:      System
Source:        Microsoft-Windows-Security-Kerberos
Date:          5/17/2013 9:04:40 AM
Event ID:      3
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      CaptHelo.battlestar.local
Description:
A Kerberos error message was received:
on logon session
Client Time:
Server Time: 14:4:40.0000 5/17/2013 Z
Error Code: 0xd KDC_ERR_BADOPTION
Extended Error: 0xc0000225 KLIN(0)
Client Realm:
Client Name:
Server Realm: BATTLESTAR.LOCAL
Server Name: cifs/captthrace.battlestar.local
Target Name: cifs/captthrace.battlestar.local@BATTLESTAR.LOCAL
Error Text:
File: 9
Line: 12be
Error Data is in record data.

This entry was the only non-PREAUTH_REQUIRED error. Two things that were interesting about this. First was KDC_ERR_BADOPTION. When I see this, especially in a Claims type configuration, it tells me we have a Constrained Delegation issue. The other item that was interesting was the CIFS SPN. CIFS is used for File Sharing. It stands for “Common Internet File System”. This was our SMB traffic. We can also see this in the Network Trace.

319 9:04:40 AM 5/17/2013 10.0.0.20 10.0.0.1 KerberosV5 KerberosV5:TGS Request Realm: BATTLESTAR.LOCAL Sname: cifs/captthrace.battlestar.local {TCP:44, IPv4:14}

321 9:04:40 AM 5/17/2013 10.0.0.1 10.0.0.20 KerberosV5 KerberosV5:KRB_ERROR - KDC_ERR_BADOPTION (13) {TCP:44, IPv4:14}

This was interesting, because I never gave Constrained Delegation rights to CIFS for the C2WTS or the Computer Account. When we talk about SPN’s and Delegation and placement, we talk about that the SPN should be on the account that is running the servers. For CIFS, it will be the system itself and therefore on the machine account of the SQL Server that we are trying to connect to.

CIFS is one of those special Service Classes, similar to HTTP. It is covered by the HOST SPN on the Machine Account and we won’t see an actual CIFS SPN defined, but when we go to the delegation side of things you will see it.

I added this to both the Claims Service account and the Computer Account. I say computer account, because the actual SMB request will come from the machine and not directly from the RS Process. Under the hoods, it is affectively making a call to the CreateFile Windows API.

After resetting IIS and cycling the C2WTS Service, I still saw the same exact error. This was one of those reboot moments. After rebooting the server, I then got the following:

I didn’t necessarily expect this as I expected to fail on the Kerb side to SQL. So, I ran a report and stuck a WAITFOR DELAY in there so I could see the connection. had a look at dm_exec_connections on the SQL Server and saw that we had connected with NTLM:

For our purposes this will work as I’m not going further than SQL. This is technically a single hop between the SharePoint Server System context and the SQL Server. You can configure it for Kerberos if you really want that auth_scheme by creating the appropriate Named Pipes SPN and configuring the appropriate Delegation for the C2WTS Service Account and the Machine Account for where the SMB request is originating from. Also realize that if you have a misplaced Named Pipes SQL SPN, you will encounter a “Cannot Generate SSPI Context” similar to the following:

Adam W. Saxton | Microsoft Escalation Services
http://twitter.com/awsaxton

AX 2012 - Dimensiones financieras para las letras de cambio

FelixVazquez [MSFT] — Fri, 17 May 2013 21:04:37 GMT

En los diarios contables es posible definir dimensiones financieras específicas para la Cuenta y para la Cuenta de contrapartida, utilizando el Menú Dimensiones financieras.

Sin embargo, se ha detectado que en el diario de creación de Letras de cambio, la opción para registrar la Cuenta de contrapartida está deshabilitada. Mediante el procedimiento abajo, se consigue activar esa opción.

1. Abre el AOT (Ctrl+D)

2. En el nodo Forms, selecciona la forma LedgerJournalTransCustBillOfExchange

3. Expande:

LedgerJournalTransCustBillOfExchange > Designs > Design > [ActionPane:ActionPane] > [ActionPaneTab:ActionPaneTab] > [ButtonGroup:ButtonGrop] > Select [MenuButton:FinacialDimension] > MenuItemButton:OffsetAccountDimension

4. En la propiedad Visible, definir ‘YES’

DISCLAIMER:

"Esto es una recomendación, la cual no ha sido publicada a través del sitio Web de Microsoft ya que no ha sido sometida a un ciclo de pruebas de regresión. Por favor tenga en cuenta que esto tiene que ser probado en un ambiente de prueba por usted como si se tratara de una personalización. Microsoft no puede garantizar este código".

Para M

The CORRECT Way to Code a Custom Exception Class

Doug Seelinger — Fri, 17 May 2013 20:36:00 GMT

There is a lot of advice out there on how to go about building your own custom exception classes. A lot of these sources are at least partially correct. Some are totally wrong. Some even advocate abandoning the base System.Exception class altogether, but that’s throwing the baby out with the bathwater, in my opinion. None that I've seen show how to serialize/deserialize your custom exception class should it have additional data in it's subclass. It’s enough to make one despair of ever finding the “right” way to build an exception class.

A lot of the confusion around exceptions comes about if you’ve ever actually tried to serialize an exception using an Xml-based serializer. You are testing the code you write, correct? When attempting to serialized your nice new exception class with something like XmlSerializer, the serializer will simply choke, stating that it can’t serialize any class that has an IDictionary member. And System.Exception has an IDictionary in it. Yet every piece of literature coming out of Microsoft says that we should build custom exceptions (sub-typed from Exception, and not ApplicationException) and mark them as [Serializable]. What gives? Well, there are more serializers in the world than just the XML-based serializers, and that’s when it’s important to serialize exceptions. The System.Runtime.Serialization.Formatters.Binary.BinaryFormatter, for example, serializes exceptions just fine.

So, how do you derive from Exception correctly, particularly if you’ve got additional information in your custom exception class? I thought you’d never ask.

    [Serializable]
    public class AuthorizationRequiredException : Exception
    {
        public string ResourceReferenceProperty { get; set; }

        public AuthorizationRequiredException()
        {
        }

        public AuthorizationRequiredException(string message)
            : base(message)
        {
        }

        public AuthorizationRequiredException(string message, Exception inner)
            : base(message, inner)
        {
        }

        protected AuthorizationRequiredException(SerializationInfo info, 
            StreamingContext context)
            : base(info, context)
        {
            ResourceReferenceProperty = info.GetString("ResourceReferenceProperty");
        }

        [SecurityPermission(SecurityAction.Demand, SerializationFormatter = true)]
        public override void GetObjectData(SerializationInfo info, 
            StreamingContext context)
        {
            if (info == null)
                throw new ArgumentNullException("info");
            info.AddValue("ResourceReferenceProperty", ResourceReferenceProperty);
            base.GetObjectData(info, context);
        }

    }

  And here are the tests that drive it to completion (and drove me to the correct solution):

    [TestClass]
    public class AuthorizationRequiredExceptionTests
    {
        [TestMethod]
        public void AuthorizationRequiredException_default_ctor()
        {
            Assert.IsNotNull(new AuthorizationRequiredException());
        }

        [TestMethod]
        public void AuthorizationRequiredException_ctor_string()
        {
            Assert.IsNotNull(new AuthorizationRequiredException("message"));
        }

        [TestMethod]
        public void AuthorizationRequiredException_ctor_string_ex()
        {
            var innerEx = new Exception("foo");

            Assert.IsNotNull(new AuthorizationRequiredException("message", 
                innerEx));
        }

        [TestMethod]
        public void AuthorizationRequiredException_serialization_test()
        {
            var ex1 = new AuthorizationRequiredException("message") 
                { ResourceReferenceProperty = "MyReferenceProperty" };

            var buffer = new byte[4096];
            var ms = new MemoryStream(buffer);
            var ms2 = new MemoryStream(buffer);
            var formatter = new BinaryFormatter();

            formatter.Serialize(ms, ex1);

            var ex2 = (AuthorizationRequiredException)formatter.Deserialize(ms2);

            Assert.AreEqual(ex1.Message, ex2.Message);
            Assert.AreEqual(ex1.ResourceReferenceProperty, 
                ex2.ResourceReferenceProperty);
        }

        [TestMethod]
        [ExpectedException(typeof(ArgumentNullException))]
        public void GetObjectData_throws_when_info_null()
        {
            var sut = new AuthorizationRequiredException("message") 
                { ResourceReferenceProperty = "MyReferenceProperty" };

            // ReSharper disable AssignNullToNotNullAttribute
            sut.GetObjectData(null, new StreamingContext());
            // ReSharper restore AssignNullToNotNullAttribute
        }
    }

If you use this code as a template for creating your custom exceptions, you won’t go too far wrong, I think.

As far as XML-based serializers goes, I hope that the Base Class Library team will take some time and just fix the "chokes on IDictionary" issue. Frankly, it's quite embarrassing.

My desk after 19 Years at Microsoft

Brian Groth — Fri, 17 May 2013 20:34:43 GMT

In the past, I have blogged on my 10-year, 15-year, and 17-year anniversaries at Microsoft. I just recently passed the 19-year mark and decided to share a picture of some of the stuff I’ve kept over the years that now clutter my desk. I’ve tossed much more than I have kept during my office moves around Redmond and Seattle, then to/from London and now in San Francisco. But, here’s what I’ve still got on my desk in terms of awards, anniversary items, patents, and so on:

Troubleshooting e-Discovery with SharePoint and Exchange 2013

Ali Mazaheri — Fri, 17 May 2013 20:09:00 GMT

Working on implementing a POC to demonstrate the new e-Discovery capabilities in SharePoint and Exchange 2013 I hit an interesting issue which I could not find any resources online to troubleshoot. To setup the e-Discovery I successfully:

Installed the EWS components on SP2013 servers
Established S2S auth between Exchange and SharePoint 2013 by following the TechNet article
Configured permissions on the Exchange side
Added and validated a Search Result Source for Exchange

After provisioning an e-Discovery site ,I managed to successfully add a mailbox but then notice the following error on the page:

"This source may be invalid, you do not have permission to access this location, or the location is not indexed by Search."

Looking at the ULS log I noticed the following exception:

"ExecuteDiscoveryQuery: Query to Mailbox with Id [/o=ALIMAZ/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=12f2304707574b4c88a645db9e7c09e2-Administrator], IsArchive [True] failed with error code [0] and error message [Search AdminRpc call failed on Mailbox database instance 1b061d06-19a9-4fcd-b61b-9dcac1a1c97b with return code 2802.]"

After searching online and not finding anything related to the above error I suspected that our friend Exchange should be the cause of this error :), wearing my Exchange admin hat (Kinda scary) I saw the same error in the event log on Exchange server and running Test-ExchangeSearch cmdlet noticed that Content Index State for the mailbox database is in "FailedandSuspended" mode.

Following TechNet article Reseed the search catalog and manually resetting the index on Exchange resolved the issue and I managed to conduct queries against Exchange from e-Discovery site and wrap up the POC:

Worth knowing when you leave part of your application broken

axtools — Fri, 17 May 2013 20:07:55 GMT

We've seen a number of instances where part of the application was left in broken state "because we don't use that part anyway". While we understand the sentiment behind this statement and attempt to accommodate the behavior through e.g. the suppression list for IL generation, there's something you need to understand when you do this: your compile time will suffer - sometimes quite significantly. So why is that? Let's examine how the X++ compiler and metadata validation works:

AX doesn't employ a dependency driven build system, but rather an algorithm that is driven by the amount of errors it encounters in each compile pass through the AOT. This strategy requires a minimum of two passes - exactly two in the best case, and more if there are "unfortunate" dependencies as these might turn out as errors in the second pass as dependencies are yet to be compiled. The third pass will typically take care of this subset. However, the compile time is proportional to the size of each pass and the elements processed. If an element fails to compile successfully in a pass, it is added to the next pass and thus increases the effort in that next pass. Compilation ends (success or fail) when the last pass didn't provide further progress on resolving the pending errors.

So you see how that gets effected by broken application? You've effectively added dead weight to each pass after the second and depending on what you've left broken, it might entail quite significant increase in compile time. E.g. forms are quite intricate to compile and verify, so are tables and classes, so if you leave a significant number of these broken, your compile time might suffer quite significantly.

Bottom line: leaving part of your application broken is not just a risk from an execution perspective. It also negatively effects the turn-around time when you need to compile.

Windows Azure Community News Roundup (Edition #66)

Mark_BrownMS — Fri, 17 May 2013 20:00:00 GMT

Welcome to the newest edition of our weekly roundup of the latest community-driven news, content and conversations about cloud computing and Windows Azure.

Here is what we pulled together for the past week based on your feedback:

Articles, Videos and Blog Posts

Where Is .NET Headed? (posted May 15)
Windows Azure SDK 2.0 For .Net – Taking A Second Look At Windows Azure Diagnostics (posted May 12)
My Google Reader alternative using windows azure mobile services. Part 1 (posted May 12)
My Google Reader alternative using windows azure mobile services. Part 2 (posted May 14)
Active Directory in Azure – Step by Step (posted May 9)
Nifty #windowsazure tips and things you perhaps didn’t know (posted May 3)
Setup my first Azure Virtual Machine! (posted May 16)
Going to Microsoft TechEd to Speak About Cloud Integration (posted May 13)
Interesting Official #windowsazure posters at your disposal…and free ebooks (posted May 12)

Upcoming Events and User Group Meetings

North America

October - June, 2013: Windows Azure Developer Camp – Various (50+ cities)
May 17, 2013: Stir Trek: Darkness Edition - Columbus, OH
May 30, 2013: Matthew Grace has an Azure Framework – Cambridge, MA
June 1, 2013: Pittsburgh TechFest 2013 - Pittsburgh, PA

Europe

May 22, 2013 Law in the cloud and Azure—Stockholm, Sweden
May 27, 2013: WAZUGNL 14: Info Support in Veenendaal – Veenendaal, Netherlands
June 18, 2013: Scott Klein – All things Azure – Manchester
June 19, 2013: High Availability and Disaster Recovery in a SQL VM – London

Rest of World/Virtual

May 18, 2013 Developers Day In Saudi Aramco –Dhahran, Saudi Arabia
May 25, 2013: Welcome to SQLSaturday #224 - Sydney, Australia
June 5, 2013 Windows Azure? - Herzliyya, Israel

Code:

Interesting Recent Windows Azure Discussions on Stack Overflow

Possible to view azure performance diagnostics via Perfmon – 1 answer, 0 votes
Azure Media Services upload from HTML from – 1 answer, 1 vote
How to control NServiceBus queue name when hosted on Azure? – 1 answer, 0 votes
Windows Azure REST API MediaLink – 1 answer, 1 vote
azure download subscription file link – 1 answer, 0 votes
Why does it take so long to get through first level retries? – 3 answers, 0 votes
How to migrate from Azure SQL to SQL Server? [duplicate] – 2 answers, 2 votes

Mark

Windows 8 and Windows Phone 8 .NET Development Overview - Windows8AppFactor

BrunoTerkaly — Fri, 17 May 2013 19:45:55 GMT

Key Facts This is based on the slides created by West Region DPE. You can get the slides, the code, and more at http://windows8appfactor.com.

Developer Tooling
Design tools
Working with the Simulator
Exploration of the Built in Templates
Type of controls
Working with Controls
- Events
- Properties
Data Binding
Data Context
Value Converters
Item Controls/Item Templates
Binding Collections
Windows Phone 8
- Development Tools
- Windows Phone 8 Emulator
- The Shared Kernel
- The Phone API

Key FactsAt this time there are two separate marketplaces and two separate SDKs, one for tablets and PCs and one for phones. While there are many similarities in the programming models between Windows 8 and Windows phone, you will need to create separate projects for each platform. Microsoft realizes this is not the ideal scenario, but one that is work in progress, since Windows phone came before Windows 8.

Download the Windows phone SDK
1. https://dev.windowsphone.com/en-us/downloadsdk
Download Windows 8 SDK
1. http://msdn.microsoft.com/en-us/windows/desktop/hh852363.aspx
Windows Phone Store
1. http://www.windowsphone.com/en-us/store
Windows 8 Store Info
1. http://windows.microsoft.com/en-US/windows-8/apps#Cat=t1

Key Facts Windows 8 offers additional support for CPUs. The ARM processor is known to be a low energy CPU, allowing tablets and laptops to run for longer periods of time. Windows 8 also supports a number of sensors, allowing application developers to determine location, orientation of the device relative to gravity, and of course touch. Perhaps the biggest change is touch for a Windows 8 and the fact that there is this global marketplace, which makes it safe and reliable to download applications. It also provides a revenue model for developers and dramatically lowers the barriers to entry, freeing the developer from having to worry about billing and collection, creating a storefront, and raising awareness.

Windows 8 supports a variety of applications
- Windows store apps
- Browser-based applications
- Desktop applications
Windows 8 also supports several programming languages
- C/C++
- C#/VB.NET
- JavaScript
Windows 8 also supports declarative visual design languages
- XAML
- HTML5/CSS3
Windows 8 also supports older programming models
- Win32/COM
- .NET/Silverlight

Essential Downloads For Windows 8 Development Don't miss out on these links to start your downloading.

MSDN subscribers can get Windows 8 from MSDN Subscriber Downloads	http://msdn.microsoft.com/subscriptions/default.aspx#
Download Visual Studio Express 2012 for Windows 8 (392 mb)	http://www.microsoft.com/click/services/Redirect2.ashx?CR_EAC=300051951#
Test your app before you submit it for certification and listing in the Windows Store - Windows App Certification Kit	http://msdn.microsoft.com/windows/apps/jj572486#
Visual Studio Extensions for the Windows Library for JavaScript	http://msdn.microsoft.com/library/windows/apps/hh770842.aspx#
Standalone tools to easily install, test, and profile the performance of a Windows Store app on a PC running Windows 8 without Visual Studio 2012 installed	http://go.microsoft.com/fwlink/?LinkId=255953#
SSO - A set of controls and APIs that enable apps to integrate Single Sign On (SSO) with your Microsoft account and access information from SkyDrive and Hotmail	http://go.microsoft.com/fwlink/?LinkID=247807&clcid=0x409#
Use advertising to monetize your applications while presenting a rich, engaging and immersive advertising experience to your users - Get the Windows 8 Ads SDK	http://advertising.microsoft.com/windowsadvertising/developer#
Add a scalable and secure cloud backend as well as incorporate structured storage, user authentication, and push notifications - Get Windows Azure Mobile Services	http://go.microsoft.com/fwlink/?LinkId=267242#
Windows 8 samples gallery	http://code.msdn.microsoft.com/windowsapps/#
Download Sample pack (193 mb)	http://go.microsoft.com/fwlink/?LinkID=243667&clcid=0x409#
Learn more about designing Windows apps	http://msdn.microsoft.com/library/windows/apps/hh779072#
Essential .psd assets including templates, common controls, and common components such as contracts, notifications, and tiles - Download design assets	http://www.microsoft.com/click/services/Redirect2.ashx?CR_EAC=300050688#

SkyDrive, Outlook and Identity Management with the Live SDKMake your apps or websites work with SkyDrive, Skype, and Outlook.com.

Live SDK developer guide	http://msdn.microsoft.com/en-US/library/live/hh243641#
Live SDK core concepts	http://msdn.microsoft.com/en-US/library/live/hh826528#
Live API reference	http://msdn.microsoft.com/en-US/library/live/hh243650#
SkyDrive API	http://msdn.microsoft.com/en-US/library/live/hh826521#
Identity API	http://msdn.microsoft.com/en-US/library/live/hh826537#
Outlook.com API	http://msdn.microsoft.com/en-US/library/live/hh826535#

Key Facts There is an ever-growing list of supported programming environments, beyond the ones in the slide above.

Some other options that are available
- Support for Direct 2D and 3D programming
  - This programming model offers a collection of APIs for handling advanced graphics, such as multimedia graphics, animation, vectors.
  - There is also support for advanced sound and music
  - It is the same programming model used by Xbox game developers
  - Requires the use of C and C++ programming
- Can take advantage of hardware acceleration ( GPU )
Third-party gaming platforms are supported
- Scirra
- Gamemaker
- Unity

Key Facts Visual Studio only runs in Windows 8. But even if you have a Mac, it is possible to run Windows 8 and a VM. There are free versions of Visual Studio, called Visual Studio Express.

You can view and download the samples here:
- http://code.msdn.microsoft.com/windowsapps/Windows-8-Modern-Style-App-Samples/view/SamplePack#content

Key FactsMicrosoft has pioneered the modern UI, which is a collection of design guidelines that are changing the face of computing. Many of the leading high-tech companies are now embracing this new way of designing applications, focusing on the content, not the chrome. Gone are the days of 3-D shadows, gratuitous animations, and the concept of skeumorphism. Users want a clean interface without distractions. Here are some other pointers :

The modern UI was inspired by the Swiss movement of the 1960s
From a font perspective, the UI was built upon the Segoe UI font, which was inspired by Helvetica and the Swiss movement
Minimize dependencies on graphics and focus on typography
1. Often described as sleek, quick, modern
Influences the design of Windows phone, the Microsoft Web properties,and the Xbox dashboard
Animation does play a role, with respect to touch gestures such as swipe and so on

Key FactsIt is important to know why Windows phone uses a simulator and why Windows 8 applications use an emulator.

Windows phone requires an emulator because it doesn’t run natively on a Windows 8 developer computer. The Windows Phone app is not running on its native OS, which would be the phone itself.
Windows 8 runs in the simulator. The simulator is nothing more than a fancy remote desktop app, that provides added features for the developer to test with, such as changing device orientation and resolutions - to name a few.

Key FactsDevelopers can choose from among a variety of templates. Each of these template types is available for various programming languages. The blank app template has the fewest bells and whistles, and requires the most work for the developer. You are basically starting from scratch here - there is no user interface to start with. Developers must add the necessary controls and markup to design the interface .

Key Facts The grid app template is very powerful. It makes it very easy to model applications where the data is hierarchical in nature. An application can have many groups , and each group can have many items. All the necessary navigation and relationships exist within the template. Even a default data model is provided that the developer can modify to suit his application needs.

The four built in objects are:

SampleDataCommon
SampleDataGroup
SampleDataItem
SampleDataSource

The important step here is to understand the data model.
As explained previously, groups have many items.
You will see this reflected in the code.
Also note that both groups and items share similar or common properties, such as a title, description, and image.

Class How used What it is What it contains

SampleDataCommon Base class to both SampleDataGroup and SampleDataItem Represents data that is common to both groups and items. Title, Subtitle, Description, Image

SampleDataItem Represents an item The SampleDataItem represents a child or single item Content. SampleDataItem is stored as a collection withing SampleDataGroup

SampleDataGroup Represents a group The SampleDataGroup is the group or parent of many SampleDataItems Contains a collection of many SampleDataItems

SampleDataSource Represents a collection of Groups. This is the master data source for the application. It is the container of all data. Contains a collection of many SampleDataGroups

Key Facts This template is similar to the grid app template. Instead of having separate pages for groups and for items, they are combined into a split screen scenario. This allows end-users to minimize paging in and paging out of groups and items.

Key Facts There are dozens of controls available to the Windows 8 developer. There is also a vibrant ecosystem where developers can purchase third-party controls. To view the built-in controls from within Visual Studio you will select view/toolbox. Some of the controls are simply containers for other controls, such as the layout panels.

Key Facts Building a user interface typically means dragging controls from the toolbox onto the designer surface. This can be done either from Blend or from Visual Studio. Wwhen dragging controls into a XAML page, you are essentially typing in example code into the designer automatically. This means that developers can directly type in XAML and not drag controls from the toolbox if desired. Itworks the same way as web development works in that you don't have to use a designer and you can do it by hand.

There are generally two activities that developers engage in:

Creating the user interface as described above

Working with the .xaml page

Entering code behind, which is code that execute based on the changing state of controls ( for example the user clicks on a button and code must execute )

Working with the .cs page

Key Facts Properties allow you to customize the appearance and behavior of controls. More complex uses of properties involve nesting and elements. Be aware that there are default values. If, for example, you do not specify the grid and row attributes of a control, they will default to zero. There are various other default values depending on the control.

Properties can be changed in several ways at design time:

You can use the properties Windows of both Blend and Visual Studio
You can edit the XAML directly, and bypass the properties Windows completely

Properties can be changed at runtime

Explained in the next section

Key FactsControl properties can be modified with code at runtime. This is always easier if you provide a name for a control. If you do not, you will need to navigate the visual tree and make use of the inherit parent-child relationship among controls. The code in the slide above illustrates both approaches.

Key Facts Events get triggered due to a user action or an internal change due to a sensor or a programmatically generated event. To enable controls to respond to user input, you will need to attach an event procedure. This can be done either through the declarative markup, or using code behind techniques. It is sometimes necessary to attach events at runtime .

Key Facts Data binding is important because it minimizes the code you have to write. It allows your user interface to automatically get populated with data from bound objects. You would normally have to write a lot of code behind to achieve the same result that you can declaratively using the binding syntax described here and on the next few slides.

There is generally a source and a target

The source is typically an object that implements INotifyPropertyChanged

The source is generally an object that contains the data to be displayed to the user
This makes it possible for the object to "notify" the control when the data has changed, thus enabling the controls to request the new data from their bound object and update the user interface

The target is generally a user interface element

It implements DependencyObject
Dependencies allow user interface elements to communicate with the underlying data source ( typically poco objects )

Key Facts There is a special syntax for binding expressions. Note the use of the curly brace and the keyword "Binding." It is even possible to convert from the source to the target, using a value converter.

Key Facts Data context is a concept where objects can inherit data binding information from successive parent objects in an object relationship hierarchy. Binding would not be possible without a corresponding data context.

It generally represents the data source that is used for data binding.
A typical use of DataContext is to set it directly to a data source object.

This data source might be an instance of a class such as a business object.
Or you can create a data source as an observable collection, so that the data context enables detecting changes in the backing collection.

Key Facts Note the use of the item template in the list view control. Without any code we can display a list of students in the <ListView> control.

The item template is bound to the student object
The student object implements INotifyPropertyChanged
A student has a first name and last name
Students is an observable collection and is bound to the list control

Key Facts There are a few basic steps to binding collections to controls. You can see those requirements above.

INotifyCollectionChanged notifies listeners ( controls ) when an individual item in the collection gets added or removed. This allows the control to get the latest data.
If you need to loop through the collection, think about using the IEnumerable interface. The list in the collection is represented by ObservableCollection.
ObservableCollection is simply a collection class that provides notifications to listeners when anything gets added or removed from the collection.

This collection implements INotifyCollectionChanged and INotifyPropertyChanged.
The INotifyCollectionChanged takes place when something in the collection is added, removed, removed etc.
The INotifyPropertyChanged gets fired as an event when any property value gets changed

The user will modify a customer record, for example, and the resulting event will be INotifyPropertyChanged, which will notify the user interface that a property has changed and that it should redraw itself the new data.

Key Facts Let's switch gears and now talk about Windows phone development. As you recall there is a separate store or marketplace for the phone platform. It is separate from the Windows 8 store or marketplace. There is also a separate SDK.

Some of the built in templates differ. some of the templates include the following Windows phone template types:

Data Bound app
Panorama app
Pivot app
Direct 3D
XNA
HTML 5
Audio playback
Audio streaming
Scheduled task

But there are a lot of similarities too.

They both share the use of XAML, C#/VB, C++
Much of the primitives in the .NET framework are identical
Too many more to list

Key Facts There are 10 general steps to getting not only developing, but getting your app into the store.

Step 1 Idea Conception

Step 2 Download Tooling, SDKs

Step 3 Establish Windows Store Developer Account at Microsoft Dev Center Portal

Step 4 (optional) Advertising

Step 5 App Development, App Package Creation

Step 6 Upload App package to Dev Center Portal

Step 7 Finish completing work at Dev Center Portal

Step 8 Wait for Certification

Step 9 Fix non-compliance errors and re-submit.

Step 10 Raise awareness, Make adjustments, Enhance application

Key Facts It is relatively easy to set up your Windows 8 computer to develop Windows Phone 8 applications. your typical 64-bit setup of Windows 8 should work.

The SDK is for building games for Windows Phone 8 or Windows phone 7.5
The SDK includes Visual Studio express 2012 for Windows Phone
The SDK will also work as an add-in to higher versions of Visual Studio
The SDK includes multiple emulators and some profiling tools
Some testing tools are also provided

Key Facts Microsoft's dream about one platform for all devices is coming true. The latest mobile operating system for Windows phone is a full-fledged NT kernel.

It is called "Shared Windows Core"
Massive amounts of plumbing code around the filesystem and security infrastructure is common
This allows developers to create apps and drivers that span three distinct environments of phone, tablet, and desktop
This also means hardware manufacturers only have to write the device drivers once
This also goes a long way in bringing browsers to parity between desktop, tablet, and phone
The good news is for enterprises because now Windows Phone 8 includes Secure Boot, BitLocker and a bunch of encryption
There's also shared libraries for C and C++, and Direct X

Key Facts You will notice that Windows phone 8 brings a lot to the table compared to its predecessor of phone 7.1

For serious game writers Direct 2D and 3D bring incredible power to the forefront
Direct 3D allows you to leverage the GPU, giving you hardware acceleration for the entire 3-D rendering pipeline
Direct3D competes with OpenGL ( as a frame of reference )

Introduction to the Multilingual App Toolkit http://channel9.msdn.com/Series/Introducing-Windows-8/Introduction-to-the-Multilingual-App-Toolkit#

Windows Azure SDK for Windows 8 and Windows Phone 8 http://www.windowsazure.com/en-us/downloads/#

Live SDK for Windows Phone http://go.microsoft.com/fwlink/?LinkId=267558#

Windows Phone Toolkit http://go.microsoft.com/fwlink/?LinkId=267555#

Windows Phone Power Tools http://wptools.codeplex.com/#

Coding4Fun Toolkit for Windows Phone http://go.microsoft.com/fwlink/?LinkId=267557#

Key Facts The Windows phone Offers some unique features.

Win32 and COM APIs give you some low level features not previously available, such as Winsock, for those that want to do direct TCP/IP sessions.
There's a brand-new API for speech synthesis and recognition
The Windows lock screen background can leverage background image providers

The user can customize notifications on the lock screen

The SharedMediaTask allows an application to launch a dialogue that allows a user to share a picture or video on social networks
A wallet namespace is available to define payment instruments that work with Near Field Communications and the Secure Element on the phone

Conclusion This content was meant as additional guidance to that already posted on:
http://www.windows8appfactor.com
If you have material you think I should add I would love to hear about it. This was my first pass through so I'm sure I will enhance it over time.

Setting Up before you arrive at an AppFactor EventIf you are planning to attend some of the in-person events, here are some links to some of the tooling. Be ready before arriving.

Trial version of Windows 8
http://aka.ms/AppFactorWin8

Related tooling
http://aka.ms/AppFactorDownloads

Class	How used	What it is	What it contains
SampleDataCommon	Base class to both SampleDataGroup and SampleDataItem	Represents data that is common to both groups and items.	Title, Subtitle, Description, Image
SampleDataItem	Represents an item	The SampleDataItem represents a child or single item	Content. SampleDataItem is stored as a collection withing SampleDataGroup
SampleDataGroup	Represents a group	The SampleDataGroup is the group or parent of many SampleDataItems	Contains a collection of many SampleDataItems
SampleDataSource	Represents a collection of Groups.	This is the master data source for the application. It is the container of all data.	Contains a collection of many SampleDataGroups

AX 2012 R2 - Lista de nuevas funcionalidades

FelixVazquez [MSFT] — Fri, 17 May 2013 19:17:01 GMT

Listado de las nuevas funcionalidades incluídas en AX 2012 R2 que se adicionaron a AX 2012

https://mbs.microsoft.com/customersource/documentation/setupguides/ax2012_newfeaturelist.htm?printpage=false&sid=puv5bg5rykao4d5fipzevsuv&stext=Microsoft

Para U

Step 1	Idea Conception
Step 2	Download Tooling, SDKs
Step 3	Establish Windows Store Developer Account at Microsoft Dev Center Portal
Step 4 (optional)	Advertising
Step 5	App Development, App Package Creation
Step 6	Upload App package to Dev Center Portal
Step 7	Finish completing work at Dev Center Portal
Step 8	Wait for Certification
Step 9	Fix non-compliance errors and re-submit.
Step 10	Raise awareness, Make adjustments, Enhance application

Introduction to the Multilingual App Toolkit	http://channel9.msdn.com/Series/Introducing-Windows-8/Introduction-to-the-Multilingual-App-Toolkit#
Windows Azure SDK for Windows 8 and Windows Phone 8	http://www.windowsazure.com/en-us/downloads/#
Live SDK for Windows Phone	http://go.microsoft.com/fwlink/?LinkId=267558#
Windows Phone Toolkit	http://go.microsoft.com/fwlink/?LinkId=267555#
Windows Phone Power Tools	http://wptools.codeplex.com/#
Coding4Fun Toolkit for Windows Phone	http://go.microsoft.com/fwlink/?LinkId=267557#

Trial version of Windows 8	http://aka.ms/AppFactorWin8
Related tooling	http://aka.ms/AppFactorDownloads