Friday 25 June 2010

NDC 2010 Review

NDC2010.jog Like last year, I was fortunate enough to attend the Norwegian Developers Conference or NDC 2010. It was held again in Oslo but this time in Oslo Spektrum in the centre of town . There was 7 different tracks which covered a lot of different development technologies including web development, test driven development, AGILE and SCRUM project methodologies and architectural patterns and practices.

 

The conference organizers managed to raise the bar once again in terms of speakers and content. The speaker line-up contained a whole cross section from the development community. Speakers like Rob Conery, Bob C Martin, Itzik Ben Gan, Michael Feathers and some of the brightest stars in the Norwegian community such as Jonas Follesø, Frederik Kalseth and Mark Nijhof.

I got to Itzik Ben-Gan’s talks on Advanced T-SQL Tips & Tricks and also Pivoting SQL data. Itzik managed to show some exceptional ways to simplify queries and also to think a slight bit differently on how you would perform some common queries.

The overflow solution this year was nick named the “ADD Room” or “Mission Control” by some. It consisted of 7 large screens suspended over section of the arena. You picked up a set of wireless headphones and you could watch the session from the seats below. It worked really well and even better when you discovered the VIP box seats which has some extra leg room and more comfortable seats. A lot of people managed to figure this out by the end.

DSC06584 The Thursday nights entertainment was provided by the Ralph Myerz & Jack Herron Band who rocked the place. Some great percussion and funky rhythms. Hugely enjoyable.

A couple of us also headed over the nearest Irish pub, and by tradition you must bring an Irishman as a form of identification. I got to chat again to Scott Bellware (who has an excellent post on NDC), Tibi Covaci, Rob and many others. It was great to get some interesting takes on speaker styles, presentation techniques and other such stuff.

I quite enjoyed Rob Conery’s talk on WebForms vs MVC on Friday morning which was an interesting talk and there has been much, in some parts very heated debate on twitter and on his blog post about it.

For me, it was more whatever you use there is no need to be militant (one of my personal stances), but to also leave your mind open to other options. Additionally some innovation has stagnated coming out of the main tool provider(s). Maybe I am looking too simply at this and not reading as much into it as much as everyone else but at least that it was I took from it.

Jon Skeet did a great session on what he thought should be in C# 5.0 (which Ben Hall commented “isn’t that just Ruby”) which was followed by a panel discussion by Mads Torgersen, Jon Skeet, Eric Lippert and Neal Gafter on where C# 5.0 is going.

.NET Rocks presenters Carl Franklin and Richard Campbell presented the 64 Bit question where people won some nice prizes. Also Carl did an impromptu session along with myself, Ingo Rammer, Tibi Covaci and Rune Grothaug (who took the video)

The folks at ProgramUtvikling, Rune Grothaug and Anders Norås should be commended with the excellence that was the Norwegian Developer Conference 2010.

Which leaves me with this. The Norwegian Developer Conference should be a prescribed part of your developer education. The conference is progressively raising the bar on how developer conferences should be run. The level of the talks, the quality of the speakers added to the amount of post discussion means that if you miss it, you miss out on a very valuable resource.

Monday 31 May 2010

New Business Intelligence Features in Sharepoint 2010

This is a cross post from the ErgoGroup Blog

Now that the dust has settled after the release of the new 2010 editions of SharePoint and Office and also the new release of SQL Server 2008 R2, we can take a look at the new Business Intelligence features that have been added to these products. Some of the features are brand new while others have been updated.

So lets first look at two of the new features for Business Intelligence that are in SharePoint 2010.

PowerPivot

PowerPivot_Logo PowerPiviot or as its previous project codename “Gemini” is a new feature that allows you to move massive amounts of data around in seconds. Where before pivot tables could end up being very big and cumbersome, PowerPivot is the superhero edition, in that it can manage large volumes of data quickly and easily. In addition you can build new applications with Excel that can published to SharePoint, essentially allowing your Excel wizards to create data driven applications quickly.

 

 DemoScreen

You can take a look at some of the online demonstrations of PowerPivot here

Visio Services

Another new addition to SharePoint is Visio Services which allows you to share your Visio diagrams across the organization by publishing them to SharePoint. This helps to reduce licensing costs and also administrative overheads by removing the requirement for either Visio or Visio viewer to be installed on the client computer.

Additionally by using data enabled Visio diagrams you can make updatable documents with data coming from a number of data sources. In essence you will never need to manually update the document again before distribution. Multiple diagrams can be combined to give better information to your users.

SQL Server 2008 R2

Now we can take a look at the new Report Builder 3.0 that is included with SQL Server 2008 R2 Reporting Services.

SQL Server Reporting Services has undergone an overhaul in the latest edition of SQL Server 2008 R2. The service front end has been updated with a better interface and now has AJAX support. One small thing that will make life a lot easier for the users is the addition of a cancel button if you run the wrong report by accident.

Report Builder 3.0

The new Report Builder 3.0 now has support for geo spatial data and maps which can improve the visualization of your data dramatically. Maps are a very strong visual tool and by having spatially aware data you can make your reports more interactive and give a sense of scale across distance.

Reports can also be made as ATOM feeds which means they can be consumed by standard RSS readers such as Outlook 2010 and also can be used by PowerPivot as a data source and thus making your data linking much easier and quicker.

Map_Sales

This is only a sneak peak at some of the features that have been released as part of the toolset in Microsoft Business Intelligence stack and I will be giving a presentation on these tools and more at IT Galla 2010 in ErgoGroup Stavanger on June 3rd 2010. You can register for this event here

ITGalla

Monday 24 May 2010

MCITP SQL Server 2008 Database Developer : Exam 70-454

I have just finished the exam 70-454 UPGRADE: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD. This exam is an upgrade for those database developers who have already attained the MCITP Database Developer on SQL Server 2005.

As an upgrade this exam contains elements from both 70-433 and 70-451. Like upgrade exams this allows people who have already got their MCITP to combine two exams into one so that they don’t have to pay for doing both exams. By doing this exam you will get two new certifications, the MCTS SQL Server 2008 Database Development and MCITP SQL Server 2008 Database Developer.

Since I had completed the previous MCITP and I have completed upgrade style exams before, I had an idea of how to go about this exam. I looked at the major changes from SQL 2005 to SQL 2008 and made sure to cover them. Also it should be noted that this exam does not cover the new changes in SQL Server 2008 R2.

Anyways, some information about the exam. The preparation materials for this exam as a whole are fairly limited in that there is no specific book for exam 70-454. However there is book for 70-433 (I didn’t use this) though I did use my own set of posts on 70-433. Additionally there is a sample exam on Measure Up for 70-433 but there is none for 70-451.

Again like my previous post on 70-566 the issue was again how to deal with the Pro part of the exam. I used articles in the MSDN library and the SQL Server Books online as well as a copy of SQL Server 2008 Enterprise Trial to make sure I could run through any of the concepts that are mentioned in the exam matrix for exam 70-451.

And finally the new logos after completing this exam

MCITP logo MCTS Logo

Tuesday 11 May 2010

SharePoint 2010 Beta Exam dates announced

So we are finally getting the information on when the SharePoint 2010 beta exams will be happening. They will be running from May 21 2010 until June 11 2010.

Registration for the exams will open May 17th at 12AM EST

If you have registered your details with the Microsoft Learning Connect site you will have received beta codes for the exams by now. If you haven’t registered yourself, they may be announced later on the MSL Born to Learn blog

Frequently Asked Questions
You can find answers to Frequently Asked Questions about beta exams here:
http://www.microsoft.com/learning/en/us/certification/exam-dev-release.aspx#tab2.

For Microsoft Certified Professional (MCP) help and information, you may log in to the MCP Web site at http://mcp.microsoft.com/ or contact your Regional Service Center: http://www.microsoft.com/learning/en/us/help/assisted-support.aspx.


For updates and information about exams, visit the Born to Learn blog at: http://borntolearn.mslearn.net/.

If you have questions or comments about the Microsoft Learning Subject Matter Experts program, contact mslcd@microsoft.com.