|
|
|
Reza Madani
|
SSRS Tips and Tricks
Abstract:
The intent of this presentation is to share lots of practical tips and tricks of Reporting Services with you so that you not only shorten your development time but also get a good grasp of SSRS capabilities. Configuration tips, Tablix tricks, templating reports, understanding subscriptions are among tips covered.
Bio:
Reza is a principal architect with HarborObjects, a Microsoft partner in Newport Beach, CA. He has more years of experience than he cares to admit. His focus is on business intelligence solutions using SQL Server 2008 along with WPF and Silverlight application development. He is a MCITP in Sql Server BI08 and DBD08 as well as MCTS in WPF.
|
|
|
Four Phases of Report Authoring for Executives and Upper Management
Presentation Abstract:
Most textbooks on report authoring only cover 1.5 of these 4 phases. In this presentation, I will walk you through some real-life experience situations while developing in SQL Server Reporting Services (SSRS), with emphasis on the other 2.5 phases which are missing from the textbooks.
Bio:
Ben Aminnia is a database architect with over 20 years of experience in developing database systems as well as managing a team of SQL Server developers and DBAs. He's also the president of Los Angeles SQL Server Professionals Group www.sql.la and a board member of Los Angeles .NET Developers Group www.ladotnet.org.
|
Orange County SQL Server Professionals User Group
Thursday, October 7, 2010
6:30PM, New Horizons, Anaheim
Topic: Top 10 Query Optimizer Topics for Better Query Performance
Presenter: Benjamin Nevarez
http://sqloc.com/
SQL Azure Development
Speaker: Lynn Langit, Microsoft Developer Evangelist
 |
Abstract: In this demo-filled session, Lynn will explain the differences between Windows Azure storage and SQL Azure. She wil demonstrate working with SQL Azure storage in your application and discuss the option to connect a non-cloud hosted front end and/or a cloud-hosted front end to a SQL Azure back end solution. Lynn will also talk about migration strategies and best practices. In her talk, you wil also learn recommended business scenarios for cloud-based storage. Finally, she will cover in detail features of SQL Server RDMS which are and are not supported in SQL Azure.
About the Presenter: Lynn Langit is a Developer Evangelist for Microsoft in Southern California. She has worked with SQL Server for 10 years and has published two technical books on SQL Server (both on Business Intelligence). In her spare time, Lynn works on creating courseware to get kids started in coding. She also personally volunteers on the largest electronic medical records project implemented in sub-saharan Africa – SmartCare. For more information check out her blog at: https://blogs.msdn.com/b/socaldevgal
|
SQL Server Reporting Services - What's new in SQL 2008 R2
Presented by: Andrew Karcher
| |
With the upcoming release of SQL Server 2008 R2, there are a bunch of new features for SQL Reporting Services. We will explore some of those new features such as Paging Enhancements, Shared DataSets, Report Parts, ATOM Feeds and many more. If you want to see what is coming, this is the place. |
|
Contact Information:
Jen Underwood, MCITP, MCDBA, MCSD.net
http://www.jenunderwood.com
http://www.linkedin.com/in/jenunderwood
|
1) Business Intelligence with SharePoint 2010 and PowerPivot:
This presentation covers SharePoint 2010 Business Intelligence related technologies including the Chart Web Part, Business Intelligence Center, PerformancePoint, Reporting Services, Report Builder, PowerPivot and Business Connectivity Services.
2) Building Excel and Reporting Services Reports using Analysis Services Cubes:
This presentation walks through building reports in Excel 2007 and Reporting Services 2008 that query data from Analysis Services Cubes. It will also cover basic MDX query language.
BIO:
Jen has over 14 years of experience in business intelligence, data warehousing, reporting, analytics and enterprise architecture specializing in the Microsoft platform. She is deeply technical yet highly adept in all phases of project life cycles from strategic roadmaps to extensive "hands-on" development. Career highlights include projects for Bloomberg, the Department of Defense and Fortune 500 companies. She most recently was invited to participate in the Microsoft TAP programs for the upcoming Microsoft SQL Server 2008 R2, Gemini "PowerPivot" and SharePoint 2010 product releases and is providing input into future Microsoft business intelligence product development. She has presented at various PASS events and at user group meetings in Georgia, Florida and California.
|
|
Coming to Southern California for the First Time
|
An Evening with Fusion-io
| Solid-state technologies are changing the way that MS SQL Server users think about running their databases. Database administrators are discovering that the TCO savings associated with radical performance enhancements, reliability improvements and reduced energy and real estate costs of solid-state technologies are leading to changes in the way their datacenters look and how their MS SQL Servers perform. |
Special Event: Orange County SQL Server Professionals User Group
Topic: SQL Server Integration Services Control Flows and Data Flows
Presenter: Bret Stateham
|
|
Presenter Bio:
Bret has over 20 years of experience in the IT field, over a decade of experience as a trainer. He has been working with Microsoft platforms since the early '90s.
Bret's focus is on SQL Server solutions and is an expert in .Net development as well as SharePoint implementation, configuration and administration.
Bret is a published author, and a frequent speaker at regional Code Camps and user group meetings.
Session Summary:
In this session we will cover the specifics of SQL Server Integration Services Control Flows and Data Flows.
Control flow is where SSIS developers manage the sequencing of tasks within an SSIS package. Control Flow concepts covered in this session include tasks, precedence constraints, containers, variables and more. Understanding the core concepts of control flow is the foundation of creating effective SSIS Packages.
In this session we will also focus on a specific SSIS task: The "Data Flow" task. The data flow is the most commonly used tool to move data in an SSIS package. It is in the data flow that you specify the data sources, transformations, and destinations for your data movement process. Data Flow concepts covered in this session include Connection Managers, Data Sources, Data Destinations, Transformations, Error Output, and more.
|
Please visit http://sqloc.com/ for further details.
Windows Server 2008 and SQL Server 2008 Failover Clustering
Presented by: Allan Hirt
Please click here to view a PDF copy of Allan's presentation.
|
|
Forget a good portion of everything you know about deploying failover clustering ? Windows Server 2008 changes the game. Come to see how the changes and improvements affect clustered SQL Server deployments. Things also change a great deal with SQL Server 2008, especially around the setup, upgrade, and patching processes (among other things). This session will talk about what you need to know to have successful deployments of SQL Server failover clustering on Windows Server 2008. Live demos will be shown where possible.
Bio:
Allan Hirt has been using SQL Server in various guises since 1992 since interning at Sybase in college. Except for the OS/2 version of Microsoft SQL Server, Allan has worked with all versions on Windows since 4.21a. He has also worked with other RDBMS systems over the years including Oracle, Sybase, and Informix, and can relate to non-SQL Server DBAs. He is currently based in the Boston, MA, area and for the past ten years, has traveled all over the world to work with clients as well as deliver training Before forming his own consulting company Megahirtz in 2007, he most recently worked for both Microsoft and Avanade. Over the years, he has authored or contributed to publications about SQL Server for Microsoft, SQL Server Magazine, and others including whitepapers, webcasts, training courses, and books. He is a frequent speaker at conferences like TechEd and SQL PASS and a Clustering MVP. His most recent book, Pro SQL Server 2008 Failover Clustering, was published by Apress in July, 2009, and Allan?s most recent whitepaper on consolidation was published by Microsoft in October, 2009. His blog and contact information can be found at: http://www.sqlha.com
|
|
|
|
|