sqlsathistory

Nr: 109

Back to Main list

SQLSaturday #109 - Silicon Valley 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Dean Richards	Track 4 - Business Intelligence	Advanced Performance Tuning Tips with Ignite8
00:00:00	Dean Richards	Track 2 - Database Administration	Best Practices for Monitoring SQL Server on VMware
00:00:00	Denise McInerney	Track 1 - 2012 Launch!	Women in Technology Panel
00:00:00	Grant Babb	Track 6 - Bonus Track	Pro-I : open source security monitoring on SQL2008
00:00:00	Joy Mundy	Track 4 - Business Intelligence	Dimensional Modeling
00:00:00	Lara Rubbelke	Track 1 - 2012 Launch!	SQL Server 2012 and the World of Big Data
00:00:00	Lara Rubbelke	Track 5 - Cloud / Azure	Cloud Computing with Windows and SQL Azure
00:00:00	Mark Ginnebaugh	Track 6 - Bonus Track	Accelerate SQL data and applications over the WAN
00:00:00	Mitch Crane	Track 6 - Bonus Track	Virtualizing SQL Server w/out Sacrificing Performa
00:00:00	Denny Cherry	Track 2 - Database Administration	Storage for the DBA
00:00:00	Phil Hummel	Track 3 - Development	TPC Benchmarks and SQL Server
00:00:00	Peter Myers	Track 1 - 2012 Launch!	PowerPivot and Power View in SQL Server 2012
00:00:00	Rushabh Mehta	Track 3 - Development	SSIS 2012 Management Considerations and Best Pract
00:00:00	Ross Mistry	Track 6 - Bonus Track	SQL Server 2012 Keynote
00:00:00	Ross Mistry	Track 5 - Cloud / Azure	Optimize SQL Server for Private Cloud
00:00:00	Michael Rys	Track 1 - 2012 Launch!	FileTable and Semantic Search in SQL Server 2012
00:00:00	Michael Rys	Track 1 - 2012 Launch!	SQL Server Appliances - DB Consolidation, DW BI
00:00:00	Michael Rys	Track 2 - Database Administration	SQL and NoSQL in the context of SQL Server
00:00:00	Adwait Ullal	Track 5 - Cloud / Azure	So you want to move your data to the cloud?
00:00:00	Allan Hirt	Track 1 - 2012 Launch!	A Preview of High Availability in SQL Server 2012
00:00:00	Angel Abundez	Track 6 - Bonus Track	Reporting Services with SharePoint Mobile Device
00:00:00	Dan Bulos	Track 4 - Business Intelligence	A Cube Dude Goes Tabular - Notes from the field
00:00:00	Carlos Bossy	Track 6 - Bonus Track	Using Columnstore Indexes in SQL Server 2012
00:00:00	Clayton Peddy	Track 5 - Cloud / Azure	Introduction to Azure Storage
00:00:00	Denise McInerney	Track 3 - Development	“BEGIN…COMMIT” is Not Enough
00:00:00	Grant Fritchey	Track 3 - Development	Top Tips for Writing Better T-SQL Queries
00:00:00	Jerry Brenner	Track 3 - Development	DMVs - Understand an Application's Database Usage
00:00:00	Kevin Kline	Track 2 - Database Administration	SQL Server Internals Architecture
00:00:00	Mark Gschwind	Track 4 - Business Intelligence	SQL Server 2012 Master Data Services
00:00:00	Neil Mackenzie	Track 5 - Cloud / Azure	SQL Azure Federations
00:00:00	Mark Tabladillo	Track 6 - Bonus Track	Enterprise Data Mining with SQL Server
00:00:00	Wendy Pastrick	Track 2 - Database Administration	Transactional Replication 101
00:00:00	William Brown	Track 4 - Business Intelligence	SQL Server 2012 Business Intelligence and SharePoi
00:00:00	Allan Mitchell	Track 4 - Business Intelligence	Data Quality Services in SQL Server 2012

SessionID: 13047

Advanced Performance Tuning Tips with Ignite8

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 4 - Business Intelligence

Speaker: Dean Richards

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.

SessionID: 13048

Best Practices for Monitoring SQL Server on VMware

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 2 - Database Administration

Speaker: Dean Richards

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.

SessionID: 13090

Women in Technology Panel

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 1 - 2012 Launch!

Speaker: Denise McInerney

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 SQL Saturday attendees are welcome.

SessionID: 14720

Pro-I : open source security monitoring on SQL2008

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Grant Babb

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.

SessionID: 17542

Dimensional Modeling

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 4 - Business Intelligence

Speaker: Joy Mundy

Title: Dimensional Modeling

Abstract:

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

SessionID: 18951

SQL Server 2012 and the World of Big Data

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 1 - 2012 Launch!

Speaker: Lara Rubbelke

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.

SessionID: 18952

Cloud Computing with Windows and SQL Azure

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 5 - Cloud / Azure

Speaker: Lara Rubbelke

Title: Cloud Computing with Windows and SQL Azure

Abstract:

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

SessionID: 19587

Accelerate SQL data and applications over the WAN

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Mark Ginnebaugh

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.

SessionID: 19965

Virtualizing SQL Server w/out Sacrificing Performa

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Mitch Crane

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.

SessionID: 21052

Storage for the DBA

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 2 - Database Administration

Speaker: Denny Cherry

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.

SessionID: 22114

TPC Benchmarks and SQL Server

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 3 - Development

Speaker: Phil Hummel

Title: TPC Benchmarks and SQL Server

Abstract:

Phil Hummel will cover TPC Benchmarks and SQL Server

SessionID: 22204

PowerPivot and Power View in SQL Server 2012

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 1 - 2012 Launch!

Speaker: Peter Myers

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.

SessionID: 23109

SSIS 2012 Management Considerations and Best Pract

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 3 - Development

Speaker: Rushabh Mehta

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.

SessionID: 23471

SQL Server 2012 Keynote

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Ross Mistry

Title: SQL Server 2012 Keynote

Abstract:

SQL Server 2012 Keynote

SessionID: 23472

Optimize SQL Server for Private Cloud

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 5 - Cloud / Azure

Speaker: Ross Mistry

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.

SessionID: 26018

FileTable and Semantic Search in SQL Server 2012

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 1 - 2012 Launch!

Speaker: Michael Rys

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.

SessionID: 26019

SQL Server Appliances - DB Consolidation, DW BI

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 1 - 2012 Launch!

Speaker: Michael Rys

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.

SessionID: 26020

SQL and NoSQL in the context of SQL Server

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 2 - Database Administration

Speaker: Michael Rys

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

SessionID: 28499

So you want to move your data to the cloud?

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 5 - Cloud / Azure

Speaker: Adwait Ullal

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

SessionID: 28621

A Preview of High Availability in SQL Server 2012

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 1 - 2012 Launch!

Speaker: Allan Hirt

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.

SessionID: 28737

Reporting Services with SharePoint Mobile Device

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Angel Abundez

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.

SessionID: 29357

A Cube Dude Goes Tabular - Notes from the field

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 4 - Business Intelligence

Speaker: Dan Bulos

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

Abstract:

Notes from the field

SessionID: 29423

Using Columnstore Indexes in SQL Server 2012

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Carlos Bossy

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.

SessionID: 29556

Introduction to Azure Storage

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 5 - Cloud / Azure

Speaker: Clayton Peddy

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.

SessionID: 29894

“BEGIN…COMMIT” is Not Enough

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 3 - Development

Speaker: Denise McInerney

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.

SessionID: 30278

Top Tips for Writing Better T-SQL Queries

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 3 - Development

Speaker: Grant Fritchey

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.

SessionID: 30569

DMVs - Understand an Application's Database Usage

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 3 - Development

Speaker: Jerry Brenner

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.

SessionID: 31318

SQL Server Internals Architecture

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 2 - Database Administration

Speaker: Kevin Kline

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.

SessionID: 31721

SQL Server 2012 Master Data Services

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 4 - Business Intelligence

Speaker: Mark Gschwind

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

SessionID: 32067

SQL Azure Federations

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 5 - Cloud / Azure

Speaker: Neil Mackenzie

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.

SessionID: 33086

Enterprise Data Mining with SQL Server

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 6 - Bonus Track

Speaker: Mark Tabladillo

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.

SessionID: 33886

Transactional Replication 101

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 2 - Database Administration

Speaker: Wendy Pastrick

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.

SessionID: 34490

SQL Server 2012 Business Intelligence and SharePoi

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 4 - Business Intelligence

Speaker: William Brown

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.

SessionID: 9307

Data Quality Services in SQL Server 2012

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: Track 4 - Business Intelligence

Speaker: Allan Mitchell

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.

This site is open source. Improve this page.