MSDN Forum Jam 2012 Updates Cross Post Original by Chris Givens

Chris Givens put together a contest for fun and a couple of Beers. But there are so many MVPs that are more active in the forums than I am I don’t think I stand a chance..


I have included the results from 01/23/2013, but you will need to visit Chris’s Blog in order to be kept up to date… http://blogs.architectingconnectedsystems.com/blogs/cjg/archive/2012/12/07/MSDN-Forum-Jam-2013-Updates.aspx


MSDN Forum Jam 2012 Updates -Latest Results – 1/23/2013


Name

Points

Posts

Answers

MaartenSundman

2140

59 126

Amit V

1170

28 62

Chris Givens

815

17 60

Ivan Sanders

725

20 46

Marc D Anderson

690

30 43

CoreyRoth

420

10 17

Doug Hemminger

135

6 8

Fabian G Williams

130

7 8

Gavin Barron

125

3 8

Nicholas Holloway

90

1 8

EricaToelle

60 1 5

Xenox

35 3 2

cimares

25 1 1

In other new I have created 2 new sites on Codeplex


The first SharePoint Demo Builds http://sharepointdemobuilds.codeplex.com/ where I have created Content Packs for Populating Active Directory, Installing and Configuration of SQL 2012 SP1 with AS Tabular, Multidimensional, and PowerPivot modes and of course Integrated mode. Along with Self Service BI with documentation and walkthroughs of the Labs and Demos, ECM primarily Focused on Search and Social features, Big data which is all about data Mining and displaying the results in SharePoint 2013.


The second site SharePoint 2013 Databases Documented http://sharepoint2013dbdocs.codeplex.com/. I have used tools Apex SQL DOC to list all of the stored procedures, tables, dependencies, functions and much more for every SharePoint 2013 Database.


Anyway to all my felloow MVPs I cant wait to hang out with Everyone in 3 weeks in Redmond. As always it will be a blast… Have fun…


 


-Ivan


SharePoint Technologies Test and Hands on Labs

I HAVE INCLUDED A FEW OF THE SharePoint 2013 Labs hat are available for download. I hope everyone can make the time to download the LABs and walkthrough them, as this will give you a better Idea of the new features in SharePoint 2013

Test Lab Guide: Demonstrate SAML-based Claims Authentication with SharePoint Server 2013

Test Lab Guide: Demonstrate Intranet Collaboration with SharePoint Server 2013

This paper helps you configure an environment to demonstrate the intranet collaboration features of SharePoint Server 2013.

Test Lab Guide: Configure SharePoint Server 2013 in a Three-Tier Farm

This paper provides a brief introduction to SharePoint Server 2013 and illustrates how to create a three-tier test lab. http://www.microsoft.com/en-us/download/details.aspx?id=30386

Test Lab Guide: Demonstrate Forms-Based Authentication with SharePoint Server 2013

Hands-on Lab Online: Advanced Web and Worker Roles

Starts:  Thursday, January 17, 2013 9:00 AM  Time zone: (GMT-08:00) | Duration: 3 hour(s)

  • Sign up for our Hands-on Lab Online (HOLO) event today. What is a HOLO event? It’s an online event where you listen to a live presentation and work on lab exercises. As you work on your labs, Microsoft experts can assist and provide guidance by chatting with you one-on-one or by virtually taking control of your lab. Sign up soon as registration and seating is limited.
  • https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032537777&culture=en-US

Hands-on Lab Online: Introduction to Windows Azure Virtual Machines

Starts:  Thursday, February 14, 2013 9:00 AM  Time zone: (GMT-08:00) Duration: 3 hour(s)

  • Sign up for our Hands-on Lab Online (HOLO) event today. What is a HOLO event? It’s an online event where you listen to a live presentation and work on lab exercises. As you work on your labs, Microsoft experts can assist and provide guidance by chatting with you one-on-one or by virtually taking control of your lab.  Sign up soon as registration and seating is limited.
  • https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032540778&culture=en-US

SharePoint Composite Handbook

A SharePoint Composite combines data, documents, and business process in a useful, productive way by assembling, connecting, and configuring the basic building blocks of functionality available in SharePoint 2013 and Microsoft Office 2013 so you can rapidly create business solutions.

http://www.microsoft.com/en-us/download/details.aspx?id=36055

 

-Ivan

Technorati Tags:

SQL 2012 Business Intelligence Automation of Demo Builds Part 2

Reporting Services Installation using a Configuration.ini for use with SQL 2012. Probably next most asked question is how do I setup Report Server in SharePoint Mode. Just like in my last post we have a SQL 2012 Configuration File.ini (RSIntegrated.ConfigurationFile.ini) for the installation. The really cool thing is now SQL 2012 will be configured the same way every time.. The ConfigurationFile will ensure the installation of  Reporting Services 2012 and the Reporting Services Add-in are installed.

Just like my Last Post on SQL 2012 Business Intelligence the Automation of Demo Builds I discussed using a ConfigurationFile to configure PowerPivot. There are a couple changes that you will need to make for your environment and on depending how hands on you want to be with the installation.. You can choose to use the file as it is now in Simplified UI mode which is much faster and less tedious than waiting for all of the tests and entering the information by hand, I don’t know about you but whenever I have that many choices to click on I am bound to make a mistake.

However, you can also run it in silent mode by entering your Product Key, Uncommenting the PID parameter.

Then Comment out UIMODE and change either parameter QUITE or QUITESIMPLE value to True

The last change you will need to make unless your installing in the Contoso.com AD Domain is to Change the Service Account Username and Password  on Line 93

Then add or remove any additional Administrators on Line 130.

I have included a link to the file on SkyDrive so you can download all of the SQL 2012 Configuration Files.

    1. MSSQL.ConfigurationFile – installs the default instance with SQL Server Database Engine, SQL Server Agent,  REPLICATION, SQL Server Full Text, Data Quality Server, , Analysis Services Tabular Mode, , Data Quality Client, SQL Server Data Tools (SSDT), connectivity components, Integration Services, backward compatibility components, software development kit, SQL Server Books Online, SQL Server Management Tools Basic& Advanced, SDK for Microsoft SQL Server Native Client, and the Master Data Services

    2. MultiDimensional.ConfigurationFile – installs an instance named MultiDimensional with SQL Server Database Engine, SQL Server Agent,  REPLICATION, SQL Server Full Tex, Data Quality Server, Analysis Services Multidimensional mode, and Native Reporting Services

    3. PowerPivot.ConfigurationFile – installs Analysis Services  Power Pivot Mode calculation engine, preconfigured for in-memory data storage and processing. PowerPivot solution packages, SQL Server Books Online, Database Engine, Configuration Tools, SQL Server Management Studio,

    4. RSIntegrated.ConfigurationFile – installs Reporting Services for SharePoint Mode and the Reporting Services add-in for SharePoint Products.

    The reason behind the configuration files will become more apparent in my next post. Needless to say it allows us to have the 3 Analysis Services Modes, both Reporting Services Mode and the environments are configured exactly the same way every time or perhaps with different UserNames and Passwords but for consistency that doesn’t matter. However, between the 4 lines of Code that it takes to configure SQL 2012 and by code I mean Setup /CONFIGURATION=D:\My.ConfigurationFile.ini  for Erich of the SQL Instances we are creating then its pretty simple . Since we are calling the 4 lines from PowerShell it looks something like the following: Note: the Configuration Files I use are set with QUITE=”True”

    cmd /c "Setup /CONFIGURATION=$Install:\MSSQL.ConfigurationFile.ini"
    cmd /c "Setup /CONFIGURATION=$Install:\MultiDimensional.ConfigurationFile.ini"
    cmd /c "Setup /CONFIGURATION=$Install:\PowerPivot.ConfigurationFile.ini"
    cmd /c "Setup /CONFIGURATION=$Install:\RSIntegrated.ConfigurationFile.ini"

    The next command that runs is in the PowerShell Script is cmd /c "AutoSPInstallerLaunch.bat" which I am sure everyone who is reading this post knows what happens next… Anyhow, SharePoint 2010 or SharePoint 2013 is installed by using an answer file (AutoSPInstallerInput.xml) much like the SQL Configuration File Approach…

    However, it doesn’t stop there as we still have all of our SharePoint 2013, SQL 2012, and other customizations to work with in a repeatable manner that a SharePoint Admin can handle with having to Open Visual Studio to create WSP / Solutions to be deployed..

    I look forward to Sharing the rest with you in my next post…

    You can download the 4 SQL 2012 Configuration Files here http://sdrv.ms/RrMBi9

     

    -Ivan

     

SharePoint Saturday – Utah January 19th

Join us SharePoint architects, developers, and other professionals that work with Microsoft SharePoint Server 2010 and 2013 for ‘SharePoint Saturday’ event.  Follow Us On Twitter #SPSUTAH

SharePoint Saturday Utah is an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint topics.  SharePoint Saturday Utah is FREE, open to the public and is your local chance to immerse yourself in SharePoint!

Come join us on January 19th! at the Miller Campus bears the name of its benefactors, Larry H. and Gail Miller owners of the Utah Jazz and Miller Enterprises which includes other sport and businesses in the region.

9750 S 300 W. Sandy, UT  84070 Phone: 801-957-5200

The Miller Campus houses SLCC’s Culinary Institute, continuing education classes, The Miller Business Resource Center, The Miller Business Innovation Center and a conference center. 

If you can take Friday off all your favorite SharePoint Peeps will be hitting the slopes at Brighton Park. 

Brighton Resort 12601 E. Big Cottonwood Canyon Brighton, Utah 84121 Phone: 801-532-4731

image

I will be speaking on the Practical Business Intelligence with SharePoint 2013

Registration is Open: http://spsutah2013.eventbrite.com/#

 

-Ivan

SQL 2012 Business Intelligence Automation of Demo Builds

Happy New Year!!!

Pretty much everyone one I know for the past year in the SharePoint community has been working on keeping their VMs up to date with the latest SQL and SharePoint Releases.

This is especially true if your Demos include Business Intelligence… In addition, unless you have a Shared environment in the cloud its difficult when writing books on Business Intelligence to keep everyone on the same page and see the really cool stuff they are doing…IN addition, at the end of the day its you the reader I think would prefer to be able to build the same environment that we are referencing when writing the books and doing the sessions.

This is my first post on hopefully making this easier as I know there are plenty of folks having problems with  Installing PowerPivot with SharePoint because I answer questions in the forums. Specifically the PowerPivot Installation and Configuration with SharePoint 2013. One of the many things I think is cool about the SQL 2012 SP1 Release is that PowerPivot Doesn’t have to be installed on any of your SharePoint Servers in your farm. Unless you want to schedule refreshes, have the PowerPivot gallery, or work with Power View and Reporting Services in SharePoint mode.

So I have attached below a copy of a SQL Server 2012 Configuration File PowerPivot.Configurations.ini that will Install anywhere in your environment in its own POWERPIVOT Instance.

There are a couple changes that you will need to make for your environment and on depending how hands on you want to be with the installation.. You can choose to use the file as it is now in Simplified UI mode which is much faster and less tedious than waiting for all of the tests and entering the information by hand, I don’t know about you but whenever I have that many choices to click on I am bound to make a mistake.

However, you can also run it in silent mode by entering your Product Key, Uncommenting the PID parameter.

Then Comment out UIMODE and change either parameter QUITE or QUITESIMPLE value to True

The last change you will need to make unless your installing in the Contoso.com AD Domain is to Change the Service Account Username and Password  on Line 93

Then add or remove any additional Administrators on Line 130.

I have included a link to the file on SkyDrive  so you can download today and check it out.

https://skydrive.live.com/embed?cid=C501EBEB9378C4A3&resid=C501EBEB9378C4A3%2172790&authkey=APGlChs7doCPn5Y 

One last thing the syntax  to start the setup is really easy, if you mount the SQL 2012 SP1 ISO as D: then Run as an Administrator to open a DOS prompt and Change drives to D: Then enter the following.

Setup /CONFIGURATION=D:\PowerPivot.ConfigurationFile.ini

Note: You will still need to run the PowerPivot for SharePoint 2013 Configuration tool to configure the PowerPivot Service Application…

Cheers, and Happy New Year………..

 

-Ivan