Creating an administrative install of SSDT update for Visual Studio 2013

Since we are offering our VS2013 update via the Visual Studio update channel, there aren’t any specific instructions on how to get the download if you need to create an administrative layout.  You may need to do this if your firewall or proxy settings do not allow some computers to access the download center.

You can either choose the update from within visual studio on a machine that has internet access and instead of running the SSDTSetup.exe, download it locally; or you can use this fwlink to get to the download:

*Disclaimer – this FWLink may change in the future, so while it works for the July update, that doesn’t mean it will work for upcoming updates


Once you have the SSDTSetup.exe file downloaded locally, you can run the administrative layout command on a computer with internet access to create a copy that you can burn or place on a share

  • Run the following command using an administrator command prompt (cmd.exe run as administrator):

    SSDTSetup.exe /layout <destination>

    Where <destination> is the location you wish to create the administrative install point (e.g on a USB drive, a LAN drive or other accessible location). 

  • To use the install point once created on a computer without internet access, simply run SSDTSetup.exe from the <destination> location with no arguments. This will use the install point rather than attempting to download new copies of the relevant chained components.

How to upload your Windows Phone Application to the store ?

How to upload your windows Phone Application to the store ?

Step # 1 :

Go to :
Click on Sign-In

Step # 2 :

Go to Dashboard
Choose Windows Phone Store

Step # 3 :

Click on Submit App

Step # 4:

It’s time to fill out our application information which include :

1. App Name
2. App Category
3. Pricing
4. Distribution

Step # 5 :

Get your XAP !

Open your application in Visual Studio
Choose Release option
Run the Application

GO to the directory for your Application.
Click on BIN Folder.
Then : Release Folder
You will find your XAP file !

Step # 6 :

Click on Add new
Upload your .xap file

After Uploading your XAP , The Data read from the XAP File :

1. Package Version
2. Package Details ( Name , Size , O.S, Language , Capabilities)

Now , Fill the package store listing info :

 Description for the Store

Now : Let’s specify special keywords that help us to reach more users!

Finally : Let’s Upload Required Images and Screenshot for our application!

1. App Title Icon (300 x 300 PX)
2. Background Image(1000×800 PX)
3. Square Icon (358 x 358 PX)
4. Wide Icon ( 358 x173 PX)
5. Screenshot for the Resolutions your app Support !

Your are Mostly Done ! Congrats !
Final Review and Then Submit  it !

Trip Report: Community Leadership Summit 2014


I had the opportunity to attend the Community Leadership Summit in Portland, Oregon this last weekend, held right before OSCON. This free event brings together all kinds of community leaders, not just technical communities, but anyone that is interested in growing and empowering a strong community. I know I usually write up trip reports of technical conferences, but this particular conference was such a refreshing experience for me I had to tell others about it here.

The lead organizer, Jono Bacon, is a true leader in community management. He was the Ubuntu Community Manager at Canonical for many years and has a ton of experience in open source software communities. He now works as Senior Director of Community at the XPRIZE Foundation. This event brings together leaders in community management to “discuss, debate and continue to refine the art of building an effective and capable community.

CLS has an open, unconference style where everyone who attends is encouraged to lead discussions and contribute sessions on whatever topic they find relevant. These discussions happen in a circle of chairs where everyone can participate freely. There are also more structured 5 and 15 minute presentations that leaders in the field present in an area of their expertise. Of course, the best part of any conference is the networking opportunities.

Here are some of my favorite parts of CLS.

Unconference-style format. Planning each day’s sessions. Capturing learnings.

I’ve been to a couple unconferences before but I think this one was the most organized. The basic idea of an unconference is that the attendees themselves propose topics and sign up to lead the discussions. CLS was held in a couple (large) rooms at the Oregon Convention Center. Those rooms (plus the wide hallway) were broken up into 10 areas with chairs organized in a circle. Signs above each area designated the session number (Session 1, … Session 10).

Each session was an hour with 30 minute breaks in between and an hour lunch break. So the schedule board reflected that. In order to fill the schedule, the organizers made session cards available where you could write down the topic you wanted to lead. I’d say over a third of the attendees proposed sessions!

To kick it off, Jono spoke to everyone on the importance of community management and set the tone for the entire conference. Then it was up to us, the attendees, to create content. It took about an hour to fill the schedule for the day. Here’s how it worked.

  • Those interested in leading discussions wrote their topic on a session card.
  • Those people then lined up in front of a mic and quickly introduced themselves and their topic to the audience (about 1-2 minutes per person).
  • Jono then took just those folks over to the schedule board and similar topics were combined and figured out timing. That way if one leader wanted to attend another discussion at the same time they could fix that.
  • When finished, all the attendees are invited to the schedule board to figure out the sessions they want to go to.


Most of the sessions were ad-hoc discussions around the topic but some leaders had more structured activities like post-it note brainstorming sessions. 15 minutes before the end of the hour, the organizers rang a bell to signal wrap-up and then rang it again when the hour was up.

Another session format that you could sign up for were 15 minute plenaries and 5 minute “lightning talks”. The hour after lunch was reserved for these talks which could include a presentation. (I find it amazing that only one projector was needed for the entire conference!)

In order to capture notes and learnings from each session, we simply added notes to – the forum Jono created before the conference. I encourage you to take a look at the notes and ask questions.

I think for this particular conference this format worked extremely well because it was all about discussing best practices and being excellent to each other. If you’re interested in running a CLS conference in your local area, Jono announced the CLSx local event format and was hoping to get at least 5 volunteers. Turns out there were more than 15! If you’re interested in organizing one, see 

Learning about community challenges in Open Source projects.

Content-wise I think the connection with folks running OSS communities was really helpful for me. It seems that most community leaders of OSS projects struggle with similar issues – number one being attracting and retaining contributors. (This actually extends to any community that relies on volunteers.) Rewards and recognition is an important part of that retention as well as a solid set of expectations for achievements. Recognizing any contribution, large or small, from code contributions to a simple bug report, is very important. 

Visibility is also challenging because most people contributing to an OSS project are busy developers that don’t necessarily want to worry about (or have time for) “marketing” their project. This is why many projects are backed by companies or Foundations which can help a lot here.

There are also a slew of tactical things to do like setting up a smooth development infrastructure so that you can make it as easy as possible for people to contribute. Another interesting debate was around contributor license agreements and how there seems to be a movement away from them to lower the bar and make it as simple as possible for people to contribute. It’s an interesting, complicated, legal & social debate for sure.

Check out some of these session notes and ask questions on the forum.

Amazing people.

I met a ton of people at CLS. I tended to gravitate toward the technical folks, but I did have a couple very interesting chats with community leaders of inner city volunteer programs as well. It was definitely the people at this conference that made it so unique for me. There were a ton of small startups and OSS project leaders, but there we’re also some big companies like Oracle and Adobe there (and some good people working in communities there too). I got to meet the person behind @Java, Tori, which was pretty cool. She proposed a session called “Working at the Deathstar – Managing communities for large companies”. I can relate! :-)

I think I was the only person from Microsoft there. Now THAT was different. I introduced myself as “Beth Massi, Microsoft Developer Division” and I had a couple stares like “what the hell is Microsoft doing here?”. I explained that we’re doing a lot with OSS these days (i.e. .NET Foundation) and I was here to learn more about those communities. After that, everyone was extremely supportive and a few people even congratulated Microsoft for our participation in OSS and our long time sponsorship of OSCON. A gentleman from Mozilla even walked up to me as I was heading to a session and shook my hand and said “Thank you Microsoft for your work in Open Source. Please keep it up!”

That was awesome.

Of course, a conference isn’t complete without social activities! I chatted with some awesome people from Chef, Meteor, Mozilla, Neo4j, OpenStack and many others at the evening event on Friday. I even went dancing with Jono and company – he’s a good dancer but not as good as me ;-).


Thanks to everyone, particularly Jono Bacon, for a great summit! Here’s to new friendships! See you next time.


Fundamentals of Azure Internal Load balancers (ILBs)

  1. Internal load balancing (ILB) enables you to run highly available services behind a private IP address

  2. Internal load balancers are only accessible only within a cloud service or Virtual Network (VNet)

  • This provides additional security on that endpoint.

Some questions I am hearing

  1. I am able to access internal load balancer using IP address but not via load balancer or service name?

    • See Accessing the ILB below
  2. Is there any option on Azure portal to view load balancer configuration?

    • Internal load balancing cannot be configured through the portal as of today, this will be supported in the future
    • However, it can be configured using powershell cmdlets.

      • ILB can be used in a deployment inside a Regional Virtual Network as well in a new deployment that is outside the Virtual Network
  3. How do I monitor the traffic and which server it is redirecting it to?

  4. How do I setup the probing and rules/alerts for it?

    • See the links below


  1. Between virtual machines within a cloud service.

  2. Between virtual machines in different cloud services that are themselves contained within a virtual network.

  3. Between on-premises computers and virtual machines in a cross-premises virtual network.

Some diagrams


  1. Multi-Tier Web App


    Figure 1: Architecture for a Multi-Tier Web App


  1. Traffic from clients on the on-premises network get load-balanced across the set of LOB servers running in a cross-premises virtual network

  2. You don’t need a separate load balancer in the on-premises network or in the virtual network


    Figure 2: Architecture for an Intranet Network


  1. ILB also allows traffic from servers on the on-premises network to be load-balanced across virtual machines running in a cross-premises virtual network.


    Figure 3: Architecture for an On-Premises Network


  1. When used within a Virtual Network the ILB endpoint is also accessible from on-premises and other inter-connected VNets allowing some powerful hybrid scenarios



  1. VMs inside a cloud service have private IP address spaces

  2. You can talk to the ILB using this private IP address


  1. A customer can specify a static VNet IP address

  2. A customer can retrieve the load balanced IP is acquired from a virtual subnet

  3. This allows you to be connected VNets through the secure IP Sec tunnel

Some useful links

Regional Virtual Networks
Internal Load Balancing
Configure an internal load-balanced set
Azure Load Balancer
Configure a load-balanced set

Getting Started : Windows Phone Development

What is Windows Phone ?

Windows Phone is a  smartphone operating system developed by Microsoft. 
Windows Phone is the successor to Windows Mobile.

What types of Applications I can develop ?

There are several types of application categories :

1. Games
2. Entertainment
3. Social
4. Tools and Productivity
5. Information & Promotion

Why to build Mobile applications ?

1. Making Money
2. Contact with Customers
3. Offer mobile version for Desktop/Web Application
4. Publish Media
5. Deliver location based information

And More !

What is the Development Environment for building Windows Phone Applications?

Environment : Visual Studio 2012 or Visual Studio 2013

Programming Languages : C# , VB , C++ , HTML5 & CSS

SDK : Windows Phone SDK 8.0

Windows Phone Development Life Cycle

Well, It’s a very easy & organized Development Life Cycle :

1. Planning : It’s the first important step in building any application . Good Planning for your application well produce a successful application.

2. Develop Application : You can develop windows phone application using Visual Studio ( If you are new to windows phone development or you still don’t
have the required programming skills ; You can use Windows Phone App Studio : A web based development environment that allow you to create and build rich
windows Phone Application without writing Code !) .

3. It’s time to run and test our application on Windows Phone Emulator or test it on a real device.

4. Finally : It’s time to publish your application to the store !

Now. Monitor your application and read the feedback from users about your application !

Compliance Settings Status Views

–status views select * from v_CIAssignmentStatus –1 16777219 0 NULL NULL NULL NULL NULL NULL 2 NULL NULL 2014-07-23 19:39:57.537 select * from v_CIComplianceHistory –ScopeId_58F4A231-8C1E-41AA-8D16-9A00A103AC78/Baseline_dd7581c1-4cab-49c5-9ae2-5dca0ba0e0b0 211 1 1 16777219 (SYSTEM) (SYSTEM) 0 2014-07-23 08:10:07.890 NULL 1 1 0 1 2 0 0 0 3 ScopeId_58F4A231-8C1E-41AA-8D16-9A00A103AC78/Baseline_dd7581c1-4cab-49c5-9ae2-5dca0ba0e0b0 select * from v_CIComplianceStatusDetail –193 ScopeId_58F4A231-8C1E…(read more)

How to Create Windows Phone & Windows Developer Store account if you are a student?

How to create Windows Phone & Windows Developer Store account if you are a student?

Step # 1 : 

- Go to

- Click on “Accept and Continue “ 

 Step # 2 :

Sign in with your Microsoft account ( For Example : Hotmail)

  Step # 3 : 

- Choose your country /region .

- Enroll yourself under “Individual” account type.

Step # 4 :

Fill out your information and click Next.

Step # 5 :

Now , Accept the agreement for
Windows Phone and Windows Store , then click Next!

 Step # 6 :

Step # 7 :

Where to get the token ?

Go to Dreamspark website and sign in with your verified account and get your code from the Development – Windows Phone 8 section in the Dreamspark website.

 Step # 8

Once you fill your token , Automatically the Total you have to pay is 0.00 ! 

Click Purchase  !

Congratulations !

Your account is created.
Now you are ready to publish your first Application on the Store

Microsoft Australia Education Partner Summits 2014

In the first week of August we are running half-day partner training events for Microsoft Education partners in Sydney, Brisbane, Melbourne and Perth.

This year’s education ICT buying season is almost underway, and it promises to be like no buying season in history. There are significant changes in the market including a shift to BYOD, a growing move away from institutional purchase towards students buying devices from retailers, and the devolution of the decision making from systems to schools and parents.

All of these provide unprecedented opportunities and challenges for the existing business model of many of our education partners.

We’d like to invite you to attend a half day event in Sydney, Brisbane, Melbourne or Perth to learn how your business model can evolve, and how Microsoft can help you to grow your education sales.

The Education Partner Summit is an opportunity to get deep insight into the changing dynamics of the schools sectors from the Microsoft Education team.

Education is one of the biggest IT markets in the country, and increasingly a competitive and critical market for Microsoft and our partners, with key organisations seeing the long term value of winning the institution and seeding their brand through these schools to reach teachers, students and parents. The combination of the consumerisation of IT, technology adoption at younger ages, the accelerating desire for 1:1 computing, and BYOD are requiring schools to continue to take more innovative approaches to learning in the classroom.

The agenda is specifically focused on meeting the needs of sales and marketing personnel in Microsoft partners who want the most effective messages and strategies to grow in a transformed marketplace. With traditional revenue streams being disrupted by increasingly fragmented decision making, the Education Partner Summit will focus on ensuring that you walk away with the information you need to develop an effective and profitable strategy to serve your customers and grow your business, with practical sales resources, and understanding how you can leverage your Microsoft relationship and the resources of the Microsoft Education business to sell alongside you.

The day will benefit sales and marketing teams dealing with schools, TAFEs and Universities. Additionally, the seminar will provide valuable insight to product marketing and development teams who are looking to identify new product and service opportunities within the education sector.

Venues and dates

For each half-day event the agenda will include:

  • Overview of the education market and changes happening today
  • Deep dive into the Office 365 Education suite, and how partners can use it to deliver educational solutions for schools
  • How to position Windows devices for education customers, and the supporting programmes available for partners and customers to support improved educational outcomes from their investments, including the new “Microsoft in the Classroom” and “Expert Educator” programme
  • Updates on the Microsoft Academic Licensing programmes

We will be hosting the summits in the following Microsoft offices next month:

  • Sydney – 4th August 2014 – 12:30PM to 5:30PM
  • Brisbane – 5th August 2014 – 8AM to 12:30PM
  • Melbourne – 6th August 2014 – 8AM to 12:30PM
  • Perth – 8th August 2014 – 8AM to 12:30PM


We’ll shortly publish a registration link for the Microsoft Partner Network, but click the link below to register your interest, and to receive a registration link and a placeholder request for your calendar by email.

Make a dateRegister now for your local Education Partner Summit event

SQL Server Profiler showing 9003 Exception when CDC is configured

While troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler.


“The log scan number (42:358:1) passed to log scan in database ‘<db name>’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.”


This had me concerned as I thought SQL Server Change Data Capture (CDC) was working correctly.  Exploring further, I used SQL Server function  fn_dblog to retrieve the transaction “42:358:1” being reported in SQL Profiler error text.  Running fn_dblog multiple times, each time increasing the “end” I was able to quickly spot the entire transaction wrapped in LOP_BEGIN_XACT and LOP_COMMIT_XACT.

– Retrieve TLOG entries for CDC Log Scan
select [Current LSN], Operation, [Transaction ID], [Savepoint Name]
from ::fn_dblog(’42:358:1′, ’42:358:3′)

Current LSN             Operation                       Transaction ID Savepoint Name
———————– ——————————- ————– ———————————
0000002a:00000166:0001  LOP_BEGIN_XACT                  0000:000004b4  NULL
0000002a:00000166:0002  LOP_MARK_SAVEPOINT              0000:000004b4  tr_sp_cdc_scan
0000002a:00000166:0003  LOP_COMMIT_XACT                 0000:000004b4  NULL

(3 row(s) affected)

Tracking back the “tr_sp_cdc_scan” “Savepoint Name”, I learned the entire transaction consisted of a “dummy update” CDC makes to periodically update cdc.lsn_time_mapping table and can be ignored.

–Chris Skorlinski, Microsoft SQL Server Escalation Services

Australia Partner Conference 2014 – Create Incredible – this year’s host revealed

As this year’s Australia Partner Conference continues to take shape, we’ll be revealing more and more details over the coming weeks.

We’re delighted to announce that Adam Spencer will be our host for APC 2014.  Blending a sharp mind, quick wit and an intense passion for science and technology, Australia’s favourite geek is the perfect choice as host.

Sitting at the heart of this year’s APC is The Hub – a space that offers you the chance to explore the latest devices, visit sponsor booths and meet with experts and peers.

With an agenda reflecting the big trends shaping our industry – Cloud Platform, Enterprise Social & Productivity, Big Data & Analytics, Mobility & Devices, plus a Leadership track – APC is the must-attend Microsoft event for Partners looking to capitalise on the growth opportunities here in Australia.

Hundreds of Partners have already registered and spaces are filling fast. So if you’ve yet to register, do so today.