[/accordion] [accordion title=”Past San Francisco Bay Area Events”]
Dimensional Modeling: The Basics & Beyond
Thursday, June 5, 2014 in San Francisco Join BI Expert Dan Bulos as he covers the fundamentals of DM along with best practices in designing and implementing the data model.
Learn more >
SQL Server Implementation Frameworks From Dev to Production 
Wednesday, June 11 in San Francisco You’ll learn about a best practice framework that alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.
Learn more >
Enable Zero Downtime for Apps in a SQL Server Environment
Tuesday, June 17 in Mountain View Learn about SQL Server upgrade challenges, new architectural approaches that enable the agile data tier, and case studies for eliminating app downtime with no app changes.
Learn more >
Peter Myers: Mastering the CUBE Functions in Excel
Thursday, May 8, 2014 in Mountain View This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model, whether it be a PowerPivot data model, a tabular database or multidimensional cube. You’ll learn and see live demos of the seven CUBE functions that are natively available in Excel since the Office 2007 release. Learn more >
Big Data, Analytics and Normalization with Fabian Pascal 
Wednesday, May 14 in San Francisco Join Fabian Pascal to get his take on Big Data. Fabian is infamous for his fundamental, no-holds-barred, uncompromising take on what the Relational Model is, what it isn’t, and what that means for all professionals who design databases. Learn more >
SQL Server Analysis Services (SSAS) – A Practical Introduction
Tuesday, May 20 in Mountain View Patrick Sheehan of Microsoft will cover platform architecture, data warehousing methodology, and multi-dimensional cube development. By the end of this session, you’ll be able to begin building and deploying cubes in your environment. Learn more >
Platfora: An Analytics Sandbox In A World Of Big Data
Thursday, April 3, 2014 in San Francisco You’ll see how to build data sets and visualizations with the Platfora graphical interface. Speakers: Roberto Arnetoli and Andrew Eichenbaum of DesignMind. Learn more >
Reactive Programming for Databases
Wednesday, April 9 in San Francisco Learn about Reactive Programming and how it solves common problems. Speaker: Val Huber of Expresso Logic Learn more >
Part 3: T-SQL Windows Functions in the Realm of Query Logical Processing
Tuesday, April 15 in Mountain View Speaker: Ami Levin of SolidQ Ami will investigate what T-SQL currently offers for window functions, and also show what’s missing and how it can be useful for solving real-life challenges. You’ll see demos of how to use windows functions to solve practical, logically challenging queries. Learn more >
Saturday, March 15, 2014 at Microsoft in Mountain View
SQL Saturday is a free, one-day learning event about SQL Server, Microsoft Business Intelligence, and Big Data. Learn more and register here You’ll get an inside look at SQL Server 2014. Plus you’ll learn from top experts from California, Redmond, Boston, Denver, New Jersey, Atlanta, and Toronto. Check out the full Event Schedule.
Selected Sessions
Dimensional Modeling: The Basics & Beyond with Dan Bulos Learn more Getting Started with Big Data and BI with Carlos Bossy, BI Consultant Learn more SQL Server’s In Memory Database Objects with Denny Cherry, MCM Learn more Unblock yourself – Optimistic concurrency in Hekaton with Kalen Delaney, SQL Server MVP Learn more
Self-Service BI with Excel and SharePoint
Thursday, February 6, 2014 in San Francisco Speaker: Angel Abundez of DesignMind You’ll learn about PowerPivot for Excel and SharePoint, as well as how to visualize data with Power View. Learn more >
SQL Server on Windows Azure
Wednesday, February 12 in San Francisco Speaker: Azure expert and author Neil Mackenzie You’ll learn how Windows Azure computes, stores and connects, with a particular emphasis on how it impacts your SQL Server deployments. You’ll see how to optimize performance and provide high availability for SQL Server deployed in the virtualized environment provided by Windows Azure. Learn more >
Part 2: T-SQL Windows Functions in the Realm of Query Logical Processing
Thursday, February 18 in Mountain View Speaker: Ami Levin of SolidQ Ami will investigate what T-SQL currently offers for window functions, and also show what’s missing and how it can be useful for solving real-life challenges. You’ll see demos of how to use windows functions to solve practical, logically challenging queries. Learn more >
T-SQL Windows Functions in the Realm of Query Logical Processing
Thursday, January 23 in Mountain View Speaker: Ami Levin of SolidQ Ami will investigate what T-SQL currently offers for window functions, and also show what’s missing and how it can be useful for solving real-life challenges. You’ll see demos of how to use windows functions to solve practical, logically challenging queries.
Big Data is a Big Deal – Running Hadoop In The Cloud
November 19, 2013 at Microsoft Speaker: Bruno Terkaly of Microsoft
Bruno Terkaly of Microsoft’s Azure team will give us a solid understanding of underpinnings and principles of Hadoop, perhaps the most sought after high-paying skill for a developer today. He’ll begin by showing how you build your own single node cluster of Hadoop on the Linux virtual machine (CentOS) for free so you can start learning immediately.
The session will begin with a raw Linux VM and all the necessary components will be downloaded and installed. You can be up and running quickly in the cloud within 30 minutes. This session will contain code and will show no more than a few slides. You’ll learn about writing the low-level map/reduce code in Java, which is really the low-level assembly language of Hadoop code. Then Bruno will introduce more efficient approaches to analyzing big data with Hadoop, running high level queries and analyzing crime information from San Francisco as the example. You’ll create tables, import data, and group crime types!
SANLess Clustering, On the Ground and In the Cloud
November 13, 2013 at Microsoft Speaker: Tony Tomarchio, SIOS Director of Field Engineering
Get the inside scoop on SANLess Clustering and learn how to Increase Your SQL Server Availability Options with SIOS DataKeeper Cluster Edition
Tony will examine SANless SQL Server performance and availability options for installations on the ground and in the cloud. You’ll learn how to accelerate SQL Server and achieve maximum uptime and data protection for mission critical workloads like SQL, SharePoint, Lync, Dynamics—without costly and complex shared storage.
You’ll learn how you can make new, local, SSD and Flash-based PCIe storage highly available and how DataKeeper can be used to bridge the gap and create hybrid availability solutions for SQL Server that span into Amazon’s EC2 cloud services.
SQL Server 2014 xVelocity Enhancement: Updateable Columnstore Indexes
November 7, 2013 at Microsoft Speaker: Pat Sheehan, Data Platform Architect, Microsoft
Pat will offer an overview of the xVelocity engine enhancements for columnar data and review columnstore –v- rowstore. You’ll learn how and when to apply columnstore indexes, and see the radical improvement that columnstore can provide. Pat will demo a Data Warehouse system being optimized using Columnstore Indexing.
Practical Examples of Using Extended Events
October 9, 2013 at Microsoft Speaker: Dean Richards of Confio
Dean will show practical examples of using extended events to collect useful information. Each example will include demos on configuring the event and using the data.
Silicon Valley Code Camp
October 5/6, 2013 at Foothill College
Code Camp is a free, two-day community event.
This year for the first time, there will be Business Intelligence, Big Data, SQL Server, and DBA tracks sponsored by PASS. You can see world class speakers such as Joe Chang, Ami Levin, Mark Tabladillo, Rushabh Mehta, Stacia Misner, and Hugo Kornelis from the Netherlands.
[/accordion] [/accordions]