Dennis Chung

After receiving much comments from various members: Excel PowerPivot in 2010. We’ll give Project 2010 a short break till the next session as I think the broader topic at hand is Business Intelligence in Microsoft Office and Microsoft SharePoint 2010. And so… for this month, we’ll cover just that in a bumper 2 hour session on BI in 2010. Agenda: 1900h Introduction 1905h Business Intelligence in Microsoft Office Excel 2010 including PowerPivot for Excel 2010. 1945h Break 2000h Business Intelligence in Microsoft Office SharePoint Server 2010 Covering PowerPivot for SharePoint 2010, Excel Services 2010 and Performance Point 2010. It’s going to be a packed session and do pass word around as few sessions integrate as many products into one demo as this… Date: 15th September 2010, Wed Time: 1845h - 2100h Venue: Microsoft Singapore, Level 22CF-12 To register, simple email Tian-AnTan@avantustraining.com. to confirm your attendance and any number of friends tagging along. Tian-An MVP Office System Singapore Office User Group

SharePoint Content Governance Linden Daniels, Microsoft Consulting Services SharePoint is one of the fastest selling products from Microsoft. Yet it still causes IT and users problems with scaling usability, performance and operations. Find out more by understanding the underlying architecture and what remediation can be done. Refreshments will be provided, courtesy of Microsoft Singapore. Please RSVP to ssofian@mvps.org to confirm your attendance Linden is a Principal Consultant working for Microsoft Singapore, focusing in the areas of Knowledge Management, Document Management and Collaboration. Originally working in Document Management, he has moved on to Portal Technologies where he now specialises the Microsoft SharePoint 2010 Products and Technologies. Linden has been working in Microsoft Singapore for 10 years and is a leading expert in SharePoint technologies in the South East Asia region. He has helped many large organisations and companies successfully implement SharePoint products and technologies in Singapore, South East Asia, Australia and Europe, such as McKinsey, Singapore’s and the Australian Tax Offices, Major Oil Companies, Ministry of Education, the Law Courts, International Financial and Banking Institutions, International Chip Companies etc. His 15 years of information technology experience has exposed him to a wide range of development platforms and systems. This enables his to understand the strategic nature of information technology across diverse vertical industries.

<We’re giving away a copy of Windows Home Server to a lucky attendee!> Date: 8th September 2010 (Wednesday) Time: 7.00pm to 9.30pm Venue: 1 Marina Boulevard #22-00,MS Singapore – 22FC12 6.30pm: Registration 7.00pm: Session 1 – Kaspersky Open Space Security 8.15pm: Toilet/Stretching Break 8.30pm: Session 2 – Windows 7 Deployment Tools Update 9.30pm: Home Sweet Home Session 1 – Kapersky Abstract: In this session, Mr. Lim Thou Liang will cover in depth why Kaspersky is leading in the world’s top 4 anti-virus solution space with many renowned security vendors like Juniper, Blue Coat, Sybari, Clearswift etc who use their anti-virus engine. He will also demonstrate on the ease of management, administration and support of Kaspersky Central Admin Kit. Speaker’s Profile: Thou Liang graduated from University of New Castle, Australia with a degree in Bachelor of Engineering (Computer). He has over 20 years of experience in the IT industry, out of which more than 10 years of training experience in system courses, specializing in a complete range of Microsoft BackOffice products. As one of the pioneer MCTs and MCSE in Asia, Thou Liang has been an early starter in Microsoft technology. He is one of the leading IT Trainer/Consultant and has trained numerous IT professionals, both locally and around the S.E Asia region. Thou Liang’s other areas of expertise include NT, Windows 2000/2003/2008, SQL, Visual Basic, various versions of C language, Security, BizTalk Server, Datawarehousing, OLAP, XML and many more. His other exposure includes software development in the arena of C, C++, VB, VB .NET, and C# programming languages Session 2 – Windows 7 Deployment Tools Update Abstract: Join Jay in learning about the new updates made available in helping you deploy Windows 7 in the Enterprise. If you think you already know enough about deployment, think again. We will cover User-Driven Installation (UDI), a deployment framework that combines the flexibility of Lite touch Installation + Control and Automation of Zero Touch Installation. We will also learn how MAP 5.0 can help u do a readiness assessment for Office 2010, software usage tracking for Windows Server, Sharepoint Server, System Center Configuration Manager, Exchange Server and SQL Server. We end off with AppCompat Toolkit 5.6, which now includes Compatibility Testing for 64bit applications, additional detection for Windows 7 deprecated features. Join us, to learn about the updates, ask questions, and make the best use of the tools available to make your life easy. Registration For registration, please email to admin@sgwindowsgroup.org with the following: - SWUG ID - Name - Email Address Note: There won’t be an event confirmation. Just turn up, we don’t turn people away. However, please register if you’re coming.

SG Dot Net September UG Meeting September UG meeting will be held on 2nd September 2010 on this Thursday, at Level 21 Auditorium from 1845hrs – late. Light Refreshments will be served before the session. A Lap around Windows Azure Wely Lau & Mohamed Faizal 1900 hrs – late The Windows Azure platform is a set of high-performance cloud computing services that can be used together or independently and enable developers to leverage existing skills and familiar tools to develop cloud applications. In this session, we’ll provide a developer-focused overview of ...

Getting Started with SQL Azure The excitement of cloud computing really changes people how to develop their application. Talking about application, it is almost impossible to proceed without the database. Microsoft® SQL Azure Database is a cloud-based relational database service built on SQL Server technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. SQL Azure Database helps to ease provisioning and deployment of multiple databases. Developers do not have to install, setup, patch or manage any software. High availability and fault tolerance is built-in and no physical administration is required. Customers can use existing knowledge in T-SQL development and a familiar relational data model for symmetry with existing on-premises databases. SQL Azure Database can help reduce costs by integrating with existing toolsets and providing symmetry with on-premises and cloud databases. Speaker profile: Name : Wely Blog : http://wely-lau.net Prior joining NCS as a Cloud Solutions Architect, he worked as Developer Evangelist for Microsoft Indonesia. In NCS, he drives and realizes the adoption of Cloud Computing, specifically on Windows Azure platform. Creating cloud assessment program, migrating existing application to the cloud, developing new cloud application, and conducting cloud training are all his daily tasks in NCS. His passion in driving Microsoft technologies on both online and offline community activity make him awarded Microsoft MVP in Visual C# category. Date: August 26th, 2010 Time: 7:00PM – 8:30 PM Registration starts at 6:30 PM Venue: NTUC Building 21nd Floor Microsoft Office One Marina Boulevard Please confirm your attendance by sending email to SGSQL@LIVE.COM

Agenda for the Night 7:00 PM to 7:15PM - Registration 7:20 PM to 8:30PM – What’s new in Exchange 2010 SP 1(beta) by Triston 8:30 PM to 8:45PM - Toilet/Stretching Break 8:45PM to 10PM – Exchange 2010 and the new RPC client access service by Achinta Abstract for What’s new in Exchange 2010 SP1(beta): This month we are going to peep into the public release of highly anticipated Exchange SP1(beta). We are going to talk about what are the new features that introduced in this Service Pack and what are advantages of them. Since this is a beta release, we are also going to talk about what are the known issues of this beta release. So join us in this month’s meet up and get to know more about this beta release. **Abstract for Exchange 2010 and the new RPC Client Access Service:**The session will cover in detail Exchange 2010 Client Access Server Arrays. A brief history will be provided on the client access architectures of Exchange 2007 ,2003 and 2000 and what has changed in the new Exchange 2010.What are the supported Outlook clients, Public folder connections and setting static RPC ports for MAPI connections will be conversed. There will be a brief discussion on how to provide true High availability for internal Outlook MAPI clients by combining CAS Array and Windows Network Load Balancing. Registration For registration, please email to tristonwan@gmail.com with the following: ...

InfoPath 2010 and SharePoint 2010 Productivity Riwut Libinuko, MVP SharePoint Server Microsoft InfoPath 2010 provides easier way than ever to design electronic forms. It includes Office Fluent UI which allows us to create powerful, interactive forms without having to write any code. This session will show how to use InfoPath 2010 and SharePoint 2010 to increase your productivity in solution delivery. Formatted mostly as on stage scenario – demos , we are expecting to expose all new functionalities. InfoPath Forms + SharePoint Workflows = Business Applications Hoo Kai Sheng, K2 As an application platform, SharePoint comes with a wide collection of building blocks that enables both business and technical users to create applications to suit varying business needs. We will be exploring forms and worklows in SharePoint - two commonly seen building blocks in a business application and review how can they be combined to establish high performance SharePoint solutions with the minimal effort possible. Refreshments will be provided, courtesy of K2 Singapore. Please RSVP to ssofian@mvps.org to confirm your attendance

My first brush with SQL was in 1996, with SQL 6.5. It was known as the “mickey mouse” database for some reasons i couldn’t understand then (well, i was still a student u know). I had huge respects for DBA (Database Administrators) and earned my first DBA Certification (MCDBA) from Microsoft in 2002. And subsequently upgraded my certifications several rounds. Yes, i’m on my next round of certification updates. This time i’m eyeing on SQL Server 2008 R2. From a simple database server to now, it has grown so much (Felt like my brains are swelling from picking it up). I just wanted to share a very cool set of resources that i picked up on Channel 9. It is a Developers Training Course for SQL Server 2008 R2. Supposedly to be meant for developers, but i felt IT Pros benefits from understanding the information too. (Warning to IT Pros: Might be a bit too developer focused. Good for DBAs to know the capabilities). To make it easy, i’m listing the topics here. But do visit the main page for a collection; ...

Session 1: 7.15pm to 8.30pm Abstract for Exchange 2010 High Availablity for CAS and Hub Transport Server by: Speaker: Shaji Firoz This month we are going to touch on recommended way to deploy CAS / HUB servers with HA in mind to provide various Exchange services like OWA, Outlook Anywhere, Autodiscover, Free Busy, etc. Also Shaji will discuss on the importance of implementing Reverse Proxy technology and the need to place hardware Load balancer in the architect design and certificate requirements for various Exchange services. This will offer load balancing across CAS/Hub Servers to overcome the native Windows Network Load Balance shortfall. He will share with us on how users get to use 2 factor authentication when they access company mail using OWA from Public places. About Shaji Firoz: Shaji Firoz is a Senior Consultant working for IT Outsourcing company in Singapore. Shaji works mostly on Microsoft Technologies - with keen on messaging environment. He leads the development & implementation efforts in Exchange & Active Directory environments. He authors MS Exchange based technical articles in this site and spends time on blogging about Hosted Exchange in msexchange.org blog section. In recognition of his knowledge of Windows & Exchange Servers and his willingness to share the information and help to community, Microsoft recognized him with MVP in Exchange Server. Session 2: 8.45pm to 10pm Abstract for Exchange 2010 High Availability for Mailbox Server (DAG): Speaker: Triston Wan This topic will share with you on how Exchange 2010 High Availability for Mailbox role (DAG) was architected. How this new HA solution will help companies achieve its highest availability with the lower cost. The speaker will discuss how simple it is to implement DR solution as compared to the early versions of Exchange server. You will also learn DAG designs based on different scenarios that Enterprises could consider and why backup is not required with Exchange 2010. We will also deep-dive into DAG solution with more details. About Triston Wan: Wan Ziyang (Triston) is Sr.Consultant with a System Integrator based in Singapore. He is MCSE since year 2005 and MVP in Exchange Server. Triston leads Singapore MessagingTalk User Group activities where folks interested in Microsoft Messaging Technologies gather for learning and networking. He has done several implementation on various versions of Exchange Servers. He is also Redhat Certified Engineer on EL4. Registration For registration, please email to tristonwan@gmail.com.com with the following: ...

 Singapore SharePoint Community Date 08 July 2010 Time 06:45 PM – 9:30PM Location Microsoft Singapore Level 22 CF-12 Scalable SharePoint Infrastructure Management William Tay, Microsoft Singapore Come by and enjoy a highly-interactive session with William as he talks about the latest and neatest trick in the Microsoft Business Intelligence stack called PowerPivot and how it fits into the entire Microsoft Business Intelligence solution – and more importantly, how it democratize Business Intelligence in the enterprise with the Microsoft belief of BI for the Masses. Introduction to Claims Authentication in SharePoint 2010 Chyan Yee Goh, Microsoft Consulting Services When it comes to identity management intensive applications, it’s hard to top SharePoint. Whether you are signing in a portal, accessing a document or using a webpart for reaching out to external web services, your identity is going to be the factor that drives it all. In this session, we will give an overview of how claims based authentication is used in SharePoint 2010 and how this opens up opportunities for authentication scenarios that were not possible before. Refreshments will be provided, courtesy of AvePoint Singapore. Please RSVP to ssofian@mvps.org to confirm your attendance. And reserve your SharePoint 2010 shirt. Whilst stocks last.