SQLSaturday #109 - Silicon Valley 2012

Event Date: 03/03/2012 00:00:00

Event Location:

  • Microsoft Technology Center
  • 1065 La Avenida
  • Mountain View, California

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: Best Practices for Monitoring SQL Server on VMware

Abstract: SQL Server on VMware??? Most of our customers have virtualized their application tier, but now are either virtualizing databases or planning to do so soon. Some companies have tried to virtualize databases on VMware already but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools using standard Perfmon counters, you are getting misleading information. Understand which metrics are important and how to get the data.

Speaker(s):

  • Dean Richards

Track and Room: Track 2 - Database Administration - N/A


Title: PowerPivot and Power View in SQL Server 2012

Abstract: This presentation introduces what’s new in PowerPivot for Excel and explores Power View.

PowerPivot, first released with SQL Server 2008 R2, is an add-in for Excel 2010 that empowers business users to create their own tabular data models. In this presentation, you will learn how the add-in has been enhanced to include an upgraded designer experience and new modeling features.

Power View is an interactive data exploration, visualization, and presentation tool that delivers an intuitive ad-hoc reporting experience for business users. The reporting must be based on a tabular model. Ordinarily, the tabular model will need to be optimized for Power View, and the basics on how to achieve this will be covered in this presentation.

Speaker(s):

  • Peter Myers

Track and Room: Track 1 - 2012 Launch! - N/A


Title: FileTable and Semantic Search in SQL Server 2012

Abstract: Managing and Gaining Insight in Unstructured Data with SQL Server 2012: FileTable and Semantic Search

Learn how SQL Server 2012 is reshaping FILESTREAM functionality to enable non-transactional access to Win32 Applications and while at the same time allowing you to manipulate it equally well through SQL relational algebra with a new exciting feature called ‘FileTable’. Coupled together with another exciting new feature ‘Statistical Semantic Search’ that allows you to extract statistically relevant phrases as potential tag recommendations, or find potentially similar content based upon these phrases, SQL Server 2012 now provides unique advances in how unstructured data can be managed and mined using database technologies.

Speaker(s):

  • Michael Rys

Track and Room: Track 1 - 2012 Launch! - N/A


Title: DMVs - Understand an Application’s Database Usage

Abstract: The DMVs contain a wealth of information about how your application uses the database. This talk will describe how to build a tool to mine the DMVs to get a good picture of how your application uses the database, leveraging your understanding of your application and/or it’s data model. By building a tool in a programming language, instead of relying on scripts, you can use set operations to minimize the number of queries executed against the database and then correlate information from a variety of DMVs and system tables. For example, you can execute a single query to get the execution statistics, text and showplan xml for the top N queries and then use XPath on the client to query the showplan xml and extract a wealth of information.

Speaker(s):

  • Jerry Brenner

Track and Room: Track 3 - Development - N/A


Title: SQL Server Internals Architecture

Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - …and much more.

Speaker(s):

  • Kevin Kline

Track and Room: Track 2 - Database Administration - N/A


Title: Pro-I : open source security monitoring on SQL2008

Abstract: Since 2009, a team at Intel Corporation has been developing and enhancing an end-to-end solution for insider threat detection. Today, this solution includes enterprise-scale solution components for real-time event collection and processing, advanced analytics and big data visualization, all of them integrated to protect companies against IP theft, IT Sabotage, Espionage, and Fraud. This solution is being released as software under a GPL-type license, at no charge, to help address this risk worldwide. This introduces the Pro-I solution for the SQL Server platform, including an overview of the architecture and design, and a features demo.

Speaker(s):

  • Grant Babb

Track and Room: Track 6 - Bonus Track - N/A


Title: Introduction to Azure Storage

Abstract: Microsoft Azure offers several storage options that complement SQL Azure and SQL Server. This talk will introduce the storage options available and provide practical usage scenarios on how to best utilize and take advantage of this powerful Azure feature.

Speaker(s):

  • Clayton Peddy

Track and Room: Track 5 - Cloud / Azure - N/A


Title: Optimize SQL Server for Private Cloud

Abstract: Learn how SQL Server fits into your customer’s strategy for virtualization and private cloud. In part 1 we cover the key drivers and technologies for SQL Server in private cloud, SQL Server features that are most relevant for virtualization and private cloud deployment. We also discuss new features in SQL Server 2012 which help your customers leverage their investment in SQL Server and private cloud.

Speaker(s):

  • Ross Mistry

Track and Room: Track 5 - Cloud / Azure - N/A


Title: Using Columnstore Indexes in SQL Server 2012

Abstract: Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the processing time of common data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos will also discuss the scenarios for which columnstore indexes should be implemented to provide powerful but flexible BI solutions.

Speaker(s):

  • Carlos Bossy

Track and Room: Track 6 - Bonus Track - N/A


Title: SSIS 2012 Management Considerations and Best Pract

Abstract: SQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages.

Speaker(s):

  • Rushabh Mehta

Track and Room: Track 3 - Development - N/A


Title: Virtualizing SQL Server w/out Sacrificing Performa

Abstract: Everyone has heard the benefits of virtualization touted: nimble infrastructures, on-demand provisioning, and savings in cap-ex and op-ex due to service consolidation. Most organizations have deployed some form of virtual infrastructure, in most cases resembling what folks would call a private cloud. Administrators are trying to get as much bang for their buck as they can out of their virtual infrastructures, and as a first step, many have migrated less demanding, non-critical, or less critical services into their private cloud. Getting to the next step often involves migrating more demanding, more critical services.

Speaker(s):

  • Mitch Crane

Track and Room: Track 6 - Bonus Track - N/A


Title: Reporting Services with SharePoint Mobile Device

Abstract: Today’s executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let’s help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let’s discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We’ll look at iPad and Windows Phone, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices.

Speaker(s):

  • Angel Abundez

Track and Room: Track 6 - Bonus Track - N/A


Title: Top Tips for Writing Better T-SQL Queries

Abstract: T-SQL provides many different ways to accomplish the same task, and as you might expect, some ways are better than others. In this session, you will learn specific techniques, that if followed, will make you a better T-SQL developer. The session is jam-packed with practical examples and is designed for administrators and developers who want to bring their T-SQL skills to the next level. In fact, you will be able to immediately implement these tips in your current projects once you get back to your office.

Speaker(s):

  • Grant Fritchey

Track and Room: Track 3 - Development - N/A


Title: SQL Server Appliances - DB Consolidation, DW BI

Abstract: The SQL Server Appliance Engineering has developed and delivered a family of appliances tuned and balanced for SQL Server workloads. See how our engineering and partnership with HW vendors has created a springboard for engaging customers on our platform. We will discuss the portfolio and roadmap, as well as drill into the engineering details behing the appliances. You will learn how we tuned, balanced, and validated these solutions - which are available for your customers now. Hold on tight, we’ll be covering a lot of ground in depth in this session.

Speaker(s):

  • Michael Rys

Track and Room: Track 1 - 2012 Launch! - N/A


Title: Accelerate SQL data and applications over the WAN

Abstract: The main culprit affecting MS-SQL performance over a WAN is latency. Latency cannot be addressed by adding bandwidth. A different solution is needed. Riverbed Steelhead appliances address latency issues with MS-SQL by pipelining the delivery of data between the client and the SQL server, giving up to a 10x improvement in performance.

Speaker(s):

  • Mark Ginnebaugh

Track and Room: Track 6 - Bonus Track - N/A


Title: Dimensional Modeling

Abstract: Joy Mundy, of Kimball Group, will cover dimensional modeling using SQL Server 2012.

Speaker(s):

  • Joy Mundy

Track and Room: Track 4 - Business Intelligence - N/A


Title: “BEGIN…COMMIT” is Not Enough

Abstract: Understanding Transactions Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance.

Speaker(s):

  • Denise McInerney

Track and Room: Track 3 - Development - N/A


Title: Data Quality Services in SQL Server 2012

Abstract: Data Quality Services-Making Data Suitable for Business

There are lots of DQ issues we are going to talk about some of the common issues and later on see how we handle them. The biggest issue that customer come to us with is data which is incorrect. What does it mean incorrect? Allan will help us understand this, and show us how to gain confidence in the data by employing Data Quality Services from Microsoft.

Speaker(s):

  • Allan Mitchell

Track and Room: Track 4 - Business Intelligence - N/A


Title: A Cube Dude Goes Tabular - Notes from the field

Abstract: Notes from the field

Speaker(s):

  • Dan Bulos

Track and Room: Track 4 - Business Intelligence - N/A


Title: SQL Server 2012 Keynote

Abstract: SQL Server 2012 Keynote

Speaker(s):

  • Ross Mistry

Track and Room: Track 6 - Bonus Track - N/A


Title: Transactional Replication 101

Abstract: Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.

We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

Speaker(s):

  • Wendy Pastrick

Track and Room: Track 2 - Database Administration - N/A


Title: SQL Server 2012 Master Data Services

Abstract: What is Master Data Why Master Data is important Overview of SQL 2012 MDS – Capabilities – Underlying Architecture Where Master Data fits into a start-schema Demo i) creating a model, ii) using the new Excel interface, iii) creating 2 types of hierarchies, iv) exposing MDS data to the DW, v) using business rules to enforce data quality

Case Study

Tips on successfully implementing MDS

QA

Speaker(s):

  • Mark Gschwind

Track and Room: Track 4 - Business Intelligence - N/A


Title: Storage for the DBA

Abstract: One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups.

Speaker(s):

  • Denny Cherry

Track and Room: Track 2 - Database Administration - N/A


Title: SQL Server 2012 and the World of Big Data

Abstract: Drill into Microsoft’s Big Data solution and learn how to derive the most value from all your data, including previously untapped unstructured data. Microsoft’s Big Data solution offers breakthrough insights by enabling customers to combine the richness of relational data from databases with unstructured data from Hadoop.

Speaker(s):

  • Lara Rubbelke

Track and Room: Track 1 - 2012 Launch! - N/A


Title: SQL Server 2012 Business Intelligence and SharePoi

Abstract: William will provide an overview of the Microsoft BI Stack, including deployment of BI solutions on SharePoint.

Speaker(s):

  • William Brown

Track and Room: Track 4 - Business Intelligence - N/A


Title: SQL Azure Federations

Abstract: SQL Azure Federations is a new feature providing horizontal scale out to a SQL Azure database. Using SQL Azure Federations, database solutions are able to gain the performance and data-capacity benefits of data sharding while benefitting from the managed platform-as-a-service environment provided by SQL Azure. This presentation describes how to implement a solution using SQL Azure Federations as well as the motivation for and benefits from doing so.

Speaker(s):

  • Neil Mackenzie

Track and Room: Track 5 - Cloud / Azure - N/A


Title: Enterprise Data Mining with SQL Server

Abstract: This presentation describes SQL Server Data Mining (SSDM) for SQL Server Professionals. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft’s Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.

Speaker(s):

  • Mark Tabladillo

Track and Room: Track 6 - Bonus Track - N/A


Title: Cloud Computing with Windows and SQL Azure

Abstract: Kui will speak on Cloud Computing with Windows and SQL Azure in the Enterprise.

Speaker(s):

  • Lara Rubbelke

Track and Room: Track 5 - Cloud / Azure - N/A


Title: SQL and NoSQL in the context of SQL Server

Abstract: SQL and NoSQL: The world of ‘new’ agile data processing paradigms in the context of SQL Server

NoSQL, web-scale databases: These keywords have been increasingly popular and are often used as an anti-thesis to traditional SQL Server databases. In this presentation ,we will go behind these buzzwords and explore what they mean, what benefits they may bring, what type of scenarios can profit from

Speaker(s):

  • Michael Rys

Track and Room: Track 2 - Database Administration - N/A


Title: TPC Benchmarks and SQL Server

Abstract: Phil Hummel will cover TPC Benchmarks and SQL Server

Speaker(s):

  • Phil Hummel

Track and Room: Track 3 - Development - N/A


Title: A Preview of High Availability in SQL Server 2012

Abstract: One of the major focuses of the new major version of SQL Server, SQL Server 2012, is mission critical. There are quite a few changes in this upcoming release, including the new AlwaysOn availability groups feature and some changes to failover clustering. This session will give you a preview of what is coming (including some demo) and talk about how you can start thinking about and preparing for SQL Server 2012 even if it will be awhile before you use it in production.

Speaker(s):

  • Allan Hirt

Track and Room: Track 1 - 2012 Launch! - N/A


Title: Women in Technology Panel

Abstract: Join Meredith Ryan Smith, Wendy Pastrick, Jen Stirrup, and Nikila Srinivasan for a dynamic discussion on women in technology. All SQLSaturday attendees are welcome.

Speaker(s):

  • Denise McInerney

Track and Room: Track 1 - 2012 Launch! - N/A


Title: So you want to move your data to the cloud?

Abstract: What are the options, barriers and issues to move your data to the cloud

Speaker(s):

  • Adwait Ullal

Track and Room: Track 5 - Cloud / Azure - N/A


Title: Advanced Performance Tuning Tips with Ignite8

Abstract: Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response time analysis. The speaker, Senior DBA, Dean Richards, will use real-life case studies to demonstrate the techniques. Much of what you’ll learn falls beyond what other tools can do so this is a “must see” for all DBAs and Developers.

Speaker(s):

  • Dean Richards

Track and Room: Track 4 - Business Intelligence - N/A


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Dean Richards

LinkedIn: Dean Richards

Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.

Kevin Kline

Contact: http://KevinEKline.com

Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.

Mitch Crane

Contact: http://www.fusionio.com

Mitch Crane has over 10 years experience developing software for enterprise environments, including kernel level programs to run embedded real-time digital printing presses, file systems (WAFL), and storage devices (Fusion-io). More recently Mitch has been working around the office of the CTO at Fusion-io as an evangelist, and technologist around Fusion’s ioMemory in virtual environments.

Angel Abundez

Contact: http://rdpstreamline.com/category/rdp-streamline-blog/

Principal BI consultant of RDP Streamline Solutions delivering BI solutions with SQL Server, SharePoint, and ASP.NET throughout Northern California. Prior to consulting, I worked 10 years as a Project Engineer doing design, manufacturing, and quality for defense and industrial controls companies. After fixing some PM reports, I quickly found my passion in BI and was promoted to BI Architect and DBA. As a consultant, I enjoy networking with other BI devs and learning about new company processes.

Peter Myers

Peter has 14 years of solid experience working in OLTP database design and Business Intelligence with SQL Server and SharePoint. In April 2012, Peter was awarded Microsoft MVP (Most Valuable Professional) for a sixth time. Peter enjoys sharing his enthusiasm for Microsoft technologies by presenting at SQL Server user group meetings and technical events, including TechEd in North America, Europe and Australia.

Mark Tabladillo

Contact: http://www.marktab.net

Mark Tabladillo (MVP, SAS Expert) has been an information technology professional since 1998, and has a primary career consulting with companies across the United States and around the world. Mark’s business mission is to empower and inspire executives, architects and developers with insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark shares his thoughts on his professional blog at http://marktab.net

Ross Mistry

Contact: http://www.rossmistry.com

Ross Mistry is a Principal Enterprise Architect at Microsoft, best-selling author and community champion. Ross designs SQL Server solutions for Microsoft’s largest customers and specializes in high availability, private cloud, and appliances. His recent books include Introducing SQL Server 2012 and 2008 R2 (Microsoft Press), Windows Server 2008 R2 Unleashed (SAMS) and SQL Server 2008 Management and Administration (SAMS).

Phil Hummel

Contact: https://community.emc.com/community/connect/everything_microsoft

Phil joined Microsoft in 2001 joining a new team based in Silicon Valley with a mission to help start-ups see the value of the .NET and SQL Server application development platform. He was in the fourth class of SQL professionals to complete the Microsoft Certified Masters certification. After spending 2010 working as a Business Intelligence consultant focused on SQL Analysis Services and SharePoint, Phil was offered a job on a small team of Microsoft Presales Specialists at EMC focusing on SQL

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Dean Richards

LinkedIn: Dean Richards

Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.

Joy Mundy

Joy Mundy has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy began her career as a business analyst in banking and finance. Her first DW/BI project was as an employee of Stanford University, building an enterprise-wide Decision Support System (as DW/BI systems were called in those days). Joy left Stanford to co-found InfoDynamics LLC, a data warehouse consulting firm (doing business as the Kimball Group), then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse. Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. She returned to consulting and Kimball Group in 2004. Joy graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

Lara Rubbelke

Twitter: - @sqlgal

Lara Rubbelke brings her passion for architecting, implementing, and improving Azure data solutions to the community as a Principle Software Development Engineer for Microsoft. Many know Lara from her work on the DDP Framework, EPM Framework, and Separation of Duties Framework. Her expertise involves Big Data, analytics, OLTP and DW systems. Lara frequently delivers technical presentations at conferences and events including Build, PASS Summit, SQLBits, and webcasts on Channel 9 and MSDN.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

Ross Mistry

Contact: http://www.rossmistry.com

Ross Mistry is a Principal Enterprise Architect at Microsoft, best-selling author and community champion. Ross designs SQL Server solutions for Microsoft’s largest customers and specializes in high availability, private cloud, and appliances. His recent books include Introducing SQL Server 2012 and 2008 R2 (Microsoft Press), Windows Server 2008 R2 Unleashed (SAMS) and SQL Server 2008 Management and Administration (SAMS).

Lara Rubbelke

Twitter: - @sqlgal

Lara Rubbelke brings her passion for architecting, implementing, and improving Azure data solutions to the community as a Principle Software Development Engineer for Microsoft. Many know Lara from her work on the DDP Framework, EPM Framework, and Separation of Duties Framework. Her expertise involves Big Data, analytics, OLTP and DW systems. Lara frequently delivers technical presentations at conferences and events including Build, PASS Summit, SQLBits, and webcasts on Channel 9 and MSDN.

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

I am the CEO of DesignMind, a San Francisco-based consulting firm providing data-related services to enterprises and hyper-growth companies. We consult and develop across the entire data life cycle, including Database Applications, Mobile and web Apps, Data Warehousing and Business Intelligence, Big Data, and Data Science.

I am a Microsoft Regional Director and have been a Data Platform MVP since 2011. I lead three PASS Chapters. I served on the PASS Board of Directors in 2011, and am the main organizer for SQLSaturday Silicon Valley.

Denise McInerney

Twitter: - @denisemc06

LinkedIn: Denise McInerney

Contact: http://weblogs.sqlteam.com/denisem/default.aspx

Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.

William Brown

William Brown has been working in the Business Intelligence field since 1991 and currently is a Microsoft Technical Solution Professional specializing in Business Intelligence. Before joining Microsoft, he worked for fifteen years at Symmetry, a BI consulting company, and Oracle where he developed their first Business Intelligence systems for global sales reporting and financial planning.

Jerry Brenner

Jerry Brenner is Lead Performance Engineer at Guidewire, spending a lot of time developing tools that mine the DMVs and system tables, to enable quick debugging of performance issues. He spent the first half of his career working on query optimizers and implementing SQL functionality. He was technical lead for the rewriting of subquery processing in Sybase, so that Peoplesoft could release on Sybase and an original member of the query processing team at Cloudscape, the first relational database written in Java. (Cloudscape is now the Derby open source project and the basis of JavaDB.)

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Michael Rys

Contact: http://www.microsoft.com

Michael Rys is principal program manager in the SQL Server RDBMS team.

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.

Grant Babb

Contact: http://www.intel.com

Grant Babb is a technical lead/program manager at Intel Corporation working in Information Security. He is an MCT and an expert in Business Intelligence solutions. His work and research in the security field has focused on Insider Threat Detection in recent years, and has been a keynote presenter at conferences on this subject. He is committed to bringing business intelligence to Information Security and is the project owner of Pro-I, an open source release of an advanced security solution.

Adwait Ullal

Contact: http://dotnetjobs.posterous.com

Adwait Ullal is seasoned technologist and worked with most Microsoft products. Adwait recently conduct a Windows/SQL Azure evaluation for a financial services company.

Michael Rys

Contact: http://www.microsoft.com

Michael Rys is principal program manager in the SQL Server RDBMS team.

Mark Gschwind

Mark Gschwind is VP of Business Intelligence at DesignMind, a Microsoft Gold consulting partner based in San Francisco. He has been a BI Consultant since 1995, implementing Data Warehousing, OLAP, Reporting and Data Mining solutions to over 46 clients. He is an MCP and is certified in Oracle Essbase. He has presented MDS to other SQLSaturday events, as well as local PASS chapters. He has been using MDS since 2008 and has also used DQS on numerous client engagements.

Clayton Peddy

Clayton C. Peddy is the Director of Architecture at Terrace Software, a Microsoft Gold Partner and member of the Microsoft Azure Circle. He is a certified Microsoft Azure Developer, is a co-leader of the San Francisco .Net User Group and serves on the board of the Bay Area Association of Database Developers, and the California State University, Chico Computer Science Advisory Committee.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Neil Mackenzie

Contact: http://convective.wordpress.com/

Neil Mackenzie works for Satory Global, where he has helped many companies migrate onto Windows Azure. He has been using Windows Azure since its public preview in 2008. Neil wrote the Microsoft Windows Azure Development Cookbook and also blogs about Windows Azure.

Denise McInerney

Twitter: - @denisemc06

LinkedIn: Denise McInerney

Contact: http://weblogs.sqlteam.com/denisem/default.aspx

Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.

Dan Bulos

Twitter: - @DanBulos

Dan Bulos is president and founder of Symmetry Corporation, a leading BI consulting firm and Microsoft Gold Certified Partner. He has over 25 years of experience consulting with Fortune 500 companies on using analytical systems and has provided strategic consulting on new product features and directions to leading software vendors. A featured speaker at BI and data warehouse conferences in the US and Europe, Dan is a recognized authority on multidimensional database technology.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Michael Rys

Contact: http://www.microsoft.com

Michael Rys is principal program manager in the SQL Server RDBMS team.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page