Nr: 375
SQLSaturday #375 - Silicon Valley 2015
SessionID: 10380
Query Processing in In-Memory OLTP (Hekaton)
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 4- Development
Speaker: Benjamin Nevarez
Title: Query Processing in In-Memory OLTP (Hekaton)
Abstract:
SessionID: 11104
Getting your message across? A practical guide to using charts graphs!
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 3- Business Intelligence
Speaker: Dan Bulos
Title: Getting your message across? A practical guide to using charts graphs!
Abstract:
There are many books and articles on how to design a dashboard or create a pretty chart. But how do you know which graphical representation is the right one for your data? What kind of chart will answer the right business question? Should you use a line, bar, or pie chart? (Yes, even a pie chart. Stephen Few is not always correct in a business context.) When should you use multiple series on a chart versus using small multiples? What is the best way to show contribution to the whole? Why would you mix a line and bar chart?
This session will take a practical approach not theoretical one. How to give your users and management what they are looking for in a way that balances information content vs. visual impact. A visualization that not only answers the business questions but draws the eye to the most important aspects of the data.
SessionID: 12599
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 2- Cloud Big Data
Speaker: David Klee
Abstract:
Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!
SessionID: 12875
MEANINGLESS, BUT CONSISTENT: DATABASE TRUTH VS. CORRECTNESS
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 6- Bonus Track
Speaker: Fabian Pascal
Title: MEANINGLESS, BUT CONSISTENT: DATABASE TRUTH VS. CORRECTNESS
Abstract:
This is a critical part of data fundamentals, the grasp of which is poor. It is a subject usually neither much covered in education, nor part of job requirements and industry dialogue, yet can defeat the entire purpose of your DBMS expertise.
This presentation fills this gap. It covers the following:
- Meaning, business rules and table interpretations;
- Types of business rule;
- Meaning and database truth;
- Business rules, integrity constraints and database consistency;
- DBMS and user reponsibilities.
SessionID: 14004
Clusters Your Way Discussion Panel — A real-world take on flexibly protecting SQL Server and beyond
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 4- Development
Speaker: SIOS Technology
Title: Clusters Your Way Discussion Panel — A real-world take on flexibly protecting SQL Server and beyond
Abstract:
In this unique lunch session Microsoft SQL Server MVPs Denny Cherry and Joey D’Antoni will discuss their own personal experiences for creating and implementing a cost effective high availability and disaster recovery solutions. They’ll be covering the protection of Tier-1 applications in the cloud, getting the most out of SQL Server Standard Edition, and of course be there to answer your own clustering questions.
SessionID: 14508
What's your Imperative doing in my Declarative?
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 4- Development
Speaker: Geoff Hiten
Title: What's your Imperative doing in my Declarative?
Abstract:
SessionID: 14786
Automating Your Database Deployments
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 5- Database Administration
Speaker: Grant Fritchey
Title: Automating Your Database Deployments
Abstract:
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.
In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
SessionID: 15289
Introduction to Azure DocumentDB
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 2- Cloud Big Data
Speaker: Ike Ellis
Title: Introduction to Azure DocumentDB
Abstract:
SessionID: 15528
Practical Machine Learning with Azure ML and Revolution R
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 1- The Big Stage
Speaker: Jarek Kazmierczak
Title: Practical Machine Learning with Azure ML and Revolution R
Abstract:
Over years, machine learning has emerged as a key pillar of data science. Predictive analytics, data mining, even modern inferential statistics rely heavily on machine learning methods. However; the ever growing hype and in many cases overinflated expectations have led to a rather superficial understanding of the "Whats", Whens, and Hows" of machine learning in mainstream businesses.
The goal of this talk is to deliver a pragmatic view of key ingredients common across any machine learning approach and demonstrate how core machine learning tasks can be facilitated and streamlined using the Microsoft's latest ventures into the world of advanced analytics: Azure Machine Learning and Revolution R.
We will look at machine learning experiment design, data exploration and preparation, feature engineering, feature and model selection, evaluation and interpretation of test results. We will also provide a very brief review of the most successful machine learning models.
SessionID: 16236
Becoming a Top DBA--Learning Automation in SQL Server
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 5- Database Administration
Speaker: Joseph D'Antoni
Title: Becoming a Top DBA--Learning Automation in SQL Server
Abstract:
Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
• Fully Automating SQL Server Installations
• Dynamically Adding Databases to an Availability Group
• Syncing jobs and logins between Availability Group members
• Patching SQL Servers automatically
• Other techniques for process automation
This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
SessionID: 16843
Flash SQL Server— Re-Thinking Best Practices
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 6- Bonus Track
Speaker: J May
Title: Flash SQL Server— Re-Thinking Best Practices
Abstract:
SessionID: 16845
Columnstore Indexes in SQL Server 2014: Flipping the DW /Faster Bit
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 1- The Big Stage
Speaker: Jimmy May
Title: Columnstore Indexes in SQL Server 2014: Flipping the DW /Faster Bit
Abstract:
Columnstore indexes were introduced in SQL Server 2012 have been wholly re-architected optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads are a hybrid technology leveraging the best of off-disk in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, big wins at customer sites inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit why columnstore manifests my motto, “Change the world or go home!”
SessionID: 17161
Enterprise-grade MDM On SQL Server - the Keys to Success
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 3- Business Intelligence
Speaker: John McAllister
Title: Enterprise-grade MDM On SQL Server - the Keys to Success
Abstract:
This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server. Organizational considerations include building buy-in, team capability expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome. Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality.
SessionID: 17162
Accelerate SQL Server Master Data Services with Profisee Maestro
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 3- Business Intelligence
Speaker: John McAllister
Title: Accelerate SQL Server Master Data Services with Profisee Maestro
Abstract:
Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.
SessionID: 20773
The Ins and Outs of SQL Indexes
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 4- Development
Speaker: Mindy Curnutt
Title: The Ins and Outs of SQL Indexes
Abstract:
SessionID: 21085
Storage For the DBA
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 1- The Big Stage
Speaker: Denny Cherry
Title: Storage For the DBA
Abstract:
SessionID: 21624
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 2- Cloud Big Data
Speaker: Patrick Jean
Abstract:
SessionID: 21679
Setting up your BI Infrastructure
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 3- Business Intelligence
Speaker: Paresh Motiwala
Title: Setting up your BI Infrastructure
Abstract:
We know BI in bits and pieces. But imagine if you had to setup the BI infrastructure from scratch.
What do we need to consider, which players do we consider, what are the components, the HA/DR scenario for the same, what technology to use? These are the questions we will attempt to answer along the way.
What are the best practices involved in creating a BI infrastructure. We can discuss whether to outsource this project or rise above our DBA job and do it ourselves.
SessionID: 22018
Introduction to Time Series Forecasting
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 1- The Big Stage
Speaker: Peter Myers
Title: Introduction to Time Series Forecasting
Abstract:
Imagine taking historical sales data and using data science to accurately predict future sales values. This is precisely the objective of time series forecasting – to predict future values based on previously observed values.
This session will introduce time series forecasting, and describe how different Microsoft BI products enable forecasting for various audiences, including the business analysts, IT developer, and even the Information Worker.
Topics will include Analysis Services forecasting by using the Microsoft Time Series algorithm with the Excel add-ins (Table Analysis Tools and the Client Tools), SQL Server Data Tools (SSDT) and script.
SessionID: 22115
Disaster Recovery for SQL Server Applications using Azure Site Recovery
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 6- Bonus Track
Speaker: Phil Hummel
Title: Disaster Recovery for SQL Server Applications using Azure Site Recovery
Abstract:
SessionID: 22290
Streamlining SQL Server Implementations Across Organization
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 6- Bonus Track
Speaker: Prakash Heda
Title: Streamlining SQL Server Implementations Across Organization
Abstract:
SessionID: 22372
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 1- The Big Stage
Speaker: Pat Sheehan
Abstract:
Did you know that the Microsoft Data Platform is more than just SQL Server? Microsoft's new and exciting cloud offerings include the RDBMS we all know and love, but also big data, NoSQL, streaming analytics, and even some platforms you would might not expect....like Oracle, MySQL, Mongo, PostgreSQL, Hbase, Storm, Kafka, and more.
In this session we will cover the breadth of the Microsoft Cloud Data Platform, from IaaS to PaaS, big data to RDBMS; all on Azure.
SessionID: 24858
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 4- Development
Speaker: David Moutray
Abstract:
SessionID: 24953
Lightning talks - SacSQLUG
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 6- Bonus Track
Speaker: Dan Hess
Title: Lightning talks - SacSQLUG
Abstract:
Presenters are board members for the Sacramento SQL Server user group:
Mitch Bottel - president;
Dan Hess - vice president/treasurer;
Dilip Nayak - event coordinator;
Joe Simmons - public relations;
SessionID: 26733
Common SQL Server Mistakes and How to Avoid Them
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 4- Development
Speaker: Tim Radney
Title: Common SQL Server Mistakes and How to Avoid Them
Abstract:
SessionID: 27105
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 5- Database Administration
Speaker: Trent Mera
Abstract:
Spotlight on SQL Server alerts you to problems in your data environment and provides intuitive and rapid diagnostics of the root causes.
Performance Analysis for SQL Server exposes the best tuning opportunities in your database applications by providing a detailed historical view of the workload in your environment, right down to the statement level.
SessionID: 27404
Care and Feeding of Your System Databases
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 5- Database Administration
Speaker: Vicky Harp
Title: Care and Feeding of Your System Databases
Abstract:
Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
SessionID: 27450
Optimize Your SQL Server 2014 Workloads with Cisco UCS
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 1- The Big Stage
Speaker: Vince Hill
Title: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract:
SessionID: 27460
Advanced SSIS Techniques
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 3- Business Intelligence
Speaker: Virginia Mushkatbat
Title: Advanced SSIS Techniques
Abstract:
SSIS is a tool that simplifies ETL and other workflow development, automates DB maintenance, and can be used to automate data lifecycle. It has a lot of faculties that allow to extend its functionality, from built-in expressions mechanisms to scripts to custom components building. However, it takes patience to explore these capabilities - and we want to help developers to cut time necessary to learn the intricacies of the SSIS development.
SessionID: 9491
Big Data Data Science, How to Get Past the Hype and Into a Team
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 2- Cloud Big Data
Speaker: Andrew Eichenbaum
Title: Big Data Data Science, How to Get Past the Hype and Into a Team
Abstract:
Big Data and Data Science are two of the most hyped areas in high tech today. But what do Big Data and Data Science really mean, and how can you move into these hot career paths? In the discussion we will: Discuss the different roles in Big Data and Data Science teams; talk about the qualifications around each of the roles. Andrew will also provide starting points and pointers on how to get started in these fields.
SessionID: 9664
Automating Power BI Creations
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 3- Business Intelligence
Speaker: Angel Abundez
Title: Automating Power BI Creations
Abstract:
SessionID: 9789
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 5- Database Administration
Speaker: Argenis Fernandez
Abstract:
SessionID: 9866
RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works.
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 5- Database Administration
Speaker: Arnie Rowland
Title: RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works.
Abstract:
I'm just going to say it straight out. I'm pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it 'pessimistic', or 'optimistic', or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel 'dirty' as you attempt to 'repeatedly' read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of 'Dirty', 'Repeatable' and 'Phantom' reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.
SessionID: 9957
True tales of “small-shop” web analytics data with SQL and SSAS
Event Date: 28-03-2015 - Session time: 00:00:00 - Track: 2- Cloud Big Data
Speaker: Audrey Carstensen
Title: True tales of “small-shop” web analytics data with SQL and SSAS
Abstract:
It doesn’t take a big company to make big data! Web analytics data can come from many sources and be very unruly, and the web world is full of people who want insights at their fingertips. However, a 40 person company doesn’t have the resources for a large team of technical analysts. This is a case study on maximum insights with a relatively small number of technical people – maybe only one! We’ll walk through taking multiple sources of data (some with millions of rows daily) and converting them into a usable source of insights for the non-technical user.