Event Location:
PCATT at Honolulu Community College
874 Dillingham Blvd
Honolulu, Hawaii
Abstract:
Tightly integrated with SQL Server, SharePoint 2010 offers greater BI capabilities through the new PerformancePoint Service, enhanced functionality in Excel Services. This integration of the most-used collaboration and productivity portal with BI products makes SharePoint the most powerful platform for building your BI solutions.In this session, we'll use the BI tools in SharePoint 2010 including using Chart Web Part to graph lists, Excel Services to expose data via REST API, and PerformancePoint to create an interactive scorecard and dashboard. You will learn not only how to take full advantage of these tools to successfully develop your BI solutions, but also why and how BI can work for your business.
Speaker(s): Wen He,
Abstract:
Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…
Speaker(s): Troy Ketsdever,
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s): Janis Griffin,
Abstract:
See how easy it is to interact with Microsoft Dynamics GP using the eConnect SQL stored procedures which encapsulate business logic. Examples of how to call eConnect stored procedures for sending vendors, customers, inventory items, and related transactions into Microsoft Dynamics GP financial systems.
Speaker(s): David Eichner,
Abstract:
Interacting with SharePoint has been a challenge due to the fact that getting data into and out of SharePoint is still not very straight-forward. There are a few different ways to extract or load SharePoint data including SharePoint APIs, Web Services, and Client Object Model. What is the best way to get data out of or into a SharePoint list? This session will demonstrate the techniques to simplify access to the SharePoint Lists and to get data into and out of SharePoint lists easily by using SSIS. You will learn how to combine Web Services, CAML and ETL tools to create a high performance data integration solution.
Speaker(s): Wen He,
Abstract:
SQL Server Analysis Services (SSAS) began life as OLAP Services in SQL Server 7, over a decade ago. Since then there have been major architectural enhancements and SSAS now plays a central role in Micorosoft's Business Intelligence (BI) platform. This session will describe major SSAS functionality, with demos to illustrate key features. We'll also examine the new SSAS features in SQL Server 2008 R2.
Speaker(s): Deepak Puri,
Abstract:
We will take a look at how the focus and characteristics of BI have changed over the last 25 years up to the present. We will also discuss the recent history of Microsoft's focus on BI, and will take an in-depth look another approach to SQL Server-based BI provided by Strategy Companion Corporation. You will see why companies such as Citigroup, L'Oreal, Honeywell, DataQuick, and many others have embraced Analyzer, Strategy Companion's award-winning, zero-footprint front-end to Analysis Services for their BI applications. You'll see why SQL Server magazine called Analyzer "the best solution to complete the Microsoft BI platform" and how you can quickly implement cost-effective, self-service BI for your non-technical business users.
Speaker(s): Bob Abernethy,
Abstract:
Scrum and XP have found a strong following in the development community. But most non-development groups (such as Web Administrators, Production Support, Security, Testing, and Users/Stake Holders) inside the enterprise are not only far from agile, that are not trying to move to be more agile. I start with a refresher on Scrum, and then use real experiences from large enterprise development projects to teach you how to effectively work with non-agile teams. Instead of trying to "convert" them, I discuss strategies to adapt to their needs while remaining agile in the development realm.
Speaker(s): Philip Japikse,
Abstract:
More and more companies are virtualizing with VMWare, and SQL Server databases are moving in that direction as well. This presentation will demonstrate how Confio Ignite for VM can assist DBAs with performance - not only at the database layer but at the VM and host layers. Armed with this birds eye view, DBAs can finally have some say about the environment their databases live in.
Speaker(s): Janis Griffin,
Abstract:
WPF has now been out for a bit, and we've all seen the spinning cube playing a different video on each side. How does that help you, the line of business developer? I dive into what’s important to developers, including Layout, Event and Commands, and a deep dive into Binding, Templates, and Converters.
Speaker(s): Philip Japikse,
Abstract:
So you aren't writing any code without having tests in place…well, except for those tricky things like web services, database calls, and that section of code that no one wants to touch since it's a pile of spaghetti. I start with a big ball of mud and refactor that using dependency injection, fakes, stubs, and mocks. I will show you how to use Mocks and Stubs to isolate the system under test and write cleaner, more effective tests.
Speaker(s): Philip Japikse,
Abstract:
It's nice when, as database developers, we have a clean slate to work with. Most of the time, however, we inherit and must support existing designs and implementations. To add to the challenge, more often than not documentation of the database doesn't exist or is out-of-date with respect to the production system. In this session, we'll look at some tools, techniques, and scripts that will accelerate your understanding of that beast you're now in charge of supporting and extending, with a focus on identifying and correcting design and implementation anomalies.
Speaker(s): Troy Ketsdever,
Abstract:
Many changes were introduced in ASP.NET MVC 3, including the addition of the Razor view engine and better support for dependency injection. I will demonstrate how to take advantage of ASP.NET MVC 3 by showing you how to build the software behind NerdDinner.com and extend that to e-commerce with an AppStore.
Speaker(s): Chris Eargle,
Abstract:
The sheer number of features in Visual Studio can be overwhelming to the novice. Even seasoned .NET developers constantly discover new techniques from their colleagues. Despite this, there are some features missing from Visual Studio which are covered by Telerik’s JustCode. This session covers features of Visual Studio and JustCode that make you more productive as a developer. It covers items of interest from novice to advanced developers. Why waste your time modifying dozens of files due to one refactoring? Code like a Ninja!
Speaker(s): Chris Eargle,
Abstract:
Making Business Intelligence pervasive throughout an organization has proven to be the “Holy Grail” for many companies – recognized as of immense value but also difficult to attain. In this session we will take a look at the definition, benefits, obstacles, and requirements of Pervasive BI, as well as techniques and technologies which have made SQL Server-based Pervasive BI a “Mission Possible” for many organizations. We will then take a look at a case study of a large internal corporate deployment of Pervasive BI built on SQL Server Analysis Services.
Speaker(s): Bob Abernethy,
Abstract:
Test Driven Development is more than just writing tests first. It requires a different thought process. I will show you that thought process, and how to become a more effective developer, write less code, reduce zero defects, deliver your code faster, and make it to happy hour!
Speaker(s): Philip Japikse,
Abstract:
In my years developing C# applications, I have seen techniques both good and bad. I will demonstrate those that are good, rant against those that are bad, and reveal those unknown to many. Whether a novice or a seasoned coder, you will find something useful, or perhaps even wicked, that you can do with C# and the .NET Framework.
Speaker(s): Chris Eargle,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://www.42and5.com
Troy Ketsdever is a data architect with over 15 years of commercial software development experience, and has maintained a love/hate relationship with SQL Server since version 4.2. In addition to his "day job", Troy enjoys writing articles and presenting at user groups on a variety of database design and implementation topics. His main objective and vision is “making the right information available to the right people at the right time”.
Contact: http://www.kodefuguru.com
Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja!
Bob Abernethy is SVP amp; GM of Strategy Companion Corporation. A veteran of Oracle Corporation and Siebel Systems, Bob has over twenty-five years of IT and software industry experience. Bob received his Bachelor of Science degree from Cornell University in New York and his Master of Management Information Systems degree from West Coast University in Los Angeles.
Contact: http://sharepointhawaii.com/wenhe
Wen is a Senior Solution Architect for eWorld. He has 20 years of eclectic IT experience and his focus for the last 14 is architecting and developing Microsoft-based web and database solutions. He has implemented over 40 SharePoint and BI projects. Wen writes for SharePoint Magazine and has contributed to a 5-day SharePoint Development courseware on MOSS and SharePoint 2010 respectively. He has a BS in Computer Science and master’s degree in Business Administration (MBA) along with a number of Microsoft certifications. He is the founder of the Hawaii SharePoint User Group and has spoken at the SharePoint User Group Hawaii .NET Users Group.
Contact: http://www.skimedic.com/blog
Phil Japikse has been working with .Net since the first betas, and developing software for over 20 years. Phil is a Microsoft MVP and also holds MCSD, MCDBA, CSM, and CSP certifications. Phil is an international speaker and a passionate member of the community, speaking at events all around the world as well as serving as the Lead Director for the Cincinnati .Net User’s Group. Phil is the Patterns and Practices Evangelist for Telerik. You can follow Phil on twitter via www.twitter.com/skimedic.
Contact: http://sharepointhawaii.com/wenhe
Wen is a Senior Solution Architect for eWorld. He has 20 years of eclectic IT experience and his focus for the last 14 is architecting and developing Microsoft-based web and database solutions. He has implemented over 40 SharePoint and BI projects. Wen writes for SharePoint Magazine and has contributed to a 5-day SharePoint Development courseware on MOSS and SharePoint 2010 respectively. He has a BS in Computer Science and master’s degree in Business Administration (MBA) along with a number of Microsoft certifications. He is the founder of the Hawaii SharePoint User Group and has spoken at the SharePoint User Group Hawaii .NET Users Group.
Contact: http://www.skimedic.com/blog
Phil Japikse has been working with .Net since the first betas, and developing software for over 20 years. Phil is a Microsoft MVP and also holds MCSD, MCDBA, CSM, and CSP certifications. Phil is an international speaker and a passionate member of the community, speaking at events all around the world as well as serving as the Lead Director for the Cincinnati .Net User’s Group. Phil is the Patterns and Practices Evangelist for Telerik. You can follow Phil on twitter via www.twitter.com/skimedic.
LinkedIn: http://www.linkedin.com/in/icansoftware
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Contact: http://www.skimedic.com/blog
Phil Japikse has been working with .Net since the first betas, and developing software for over 20 years. Phil is a Microsoft MVP and also holds MCSD, MCDBA, CSM, and CSP certifications. Phil is an international speaker and a passionate member of the community, speaking at events all around the world as well as serving as the Lead Director for the Cincinnati .Net User’s Group. Phil is the Patterns and Practices Evangelist for Telerik. You can follow Phil on twitter via www.twitter.com/skimedic.
Contact: http://www.skimedic.com/blog
Phil Japikse has been working with .Net since the first betas, and developing software for over 20 years. Phil is a Microsoft MVP and also holds MCSD, MCDBA, CSM, and CSP certifications. Phil is an international speaker and a passionate member of the community, speaking at events all around the world as well as serving as the Lead Director for the Cincinnati .Net User’s Group. Phil is the Patterns and Practices Evangelist for Telerik. You can follow Phil on twitter via www.twitter.com/skimedic.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Contact: http://www.kodefuguru.com
Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja!
Contact: http://www.42and5.com
Troy Ketsdever is a data architect with over 15 years of commercial software development experience, and has maintained a love/hate relationship with SQL Server since version 4.2. In addition to his "day job", Troy enjoys writing articles and presenting at user groups on a variety of database design and implementation topics. His main objective and vision is “making the right information available to the right people at the right time”.
Bob Abernethy is SVP amp; GM of Strategy Companion Corporation. A veteran of Oracle Corporation and Siebel Systems, Bob has over twenty-five years of IT and software industry experience. Bob received his Bachelor of Science degree from Cornell University in New York and his Master of Management Information Systems degree from West Coast University in Los Angeles.
Deepak is a SQL Server MVP and a Business Intelligence Consultant who has been working with SQL Server Analysis Services since 2000. He's an active contributor to the MSDN Analysis Services Forum and a regular presenter at Ohio North SQL Server User Group meetings.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Contact: http://www.kodefuguru.com
Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja!
The following is a list of sponsors that helped fund the event.