Nr: 370
SQLSaturday #370 - Phoenix 2015
SessionID: 10164
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS/DBA/Misc
Speaker: Bradley Ball
Abstract:
Data Warehouses and OLTP systems are different! But there are some core concepts that we need to understand for managing and maintaining both. Do you want to know how you can load data faster, just by setting up your database correctly? Are your queries running slow? Want to understand how you can reduce locking and blocking in reporting queries? Do you have a system with views, that reference views, which reference more views? Let's discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!
SessionID: 10281
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA/Prof Dev
Speaker: Ben Miller
Abstract:
Ever wanted to know what happens behind the scenes in SQL Server when automating your maintenance work? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come to learn about the knobs available to tune your SMO automations. PowerShell will be used as the vehicle that leverages SMO. Come see this demo-heavy session, you'll be glad you did.
SessionID: 10378
Understanding Parameter Sniffing
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Benjamin Nevarez
Title: Understanding Parameter Sniffing
Abstract:
SessionID: 10892
Using Extended Events in SQL Server
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Brimhall
Title: Using Extended Events in SQL Server
Abstract:
SessionID: 11170
Standalone to High-Availability Clusters over Lunch—with Time to Spare
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Carl Berglund
Title: Standalone to High-Availability Clusters over Lunch—with Time to Spare
Abstract:
SessionID: 11364
Getting started with Big Data and BI
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Carlos Bossy
Title: Getting started with Big Data and BI
Abstract:
SessionID: 11366
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Carlos Bossy
Abstract:
SessionID: 11529
Ten T-SQL Techniques with Tally Tables
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Chris Hyde
Title: Ten T-SQL Techniques with Tally Tables
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 11725
Database Replication Strategies for Improved Productivity
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA/Prof Dev
Speaker: Clay Jackson
Title: Database Replication Strategies for Improved Productivity
Abstract:
Strategies for Database Replication that can be used to reduce downtime during migrations, distribute database workload and improve database productivity and availability.
SessionID: 12601
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
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: 13678
Extending Your Availability Group for Disaster Recovery
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Ed Leighton-Dick
Title: Extending Your Availability Group for Disaster Recovery
Abstract:
Did you know that SQL Server Availability Groups can be a great solution for disaster recovery? Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup. Extending an availability group to multiple sites for disaster recovery becomes more complicated. A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration. In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.
SessionID: 13679
Protecting Your Data with Encryption
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS/DBA/Misc
Speaker: Ed Leighton-Dick
Title: Protecting Your Data with Encryption
Abstract:
We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.
SessionID: 13898
Make Your DBA Happy: 5 Habits Developers Can Implement Today
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Eric Oszakiewski
Title: Make Your DBA Happy: 5 Habits Developers Can Implement Today
Abstract:
Don't make your DBA groan each time you need to start a project! There are best practices and good habits developers can be using when developing databases that not only make your DBA happy, but keep the application and entire database server healthy. Learn about 5 good habits developers can be using right now to show your database admin you really care, including but not limited to T-SQL query construction and database design.
SessionID: 14670
Predicting the future with Machine Learning
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Ginger Grant
Title: Predicting the future with Machine Learning
Abstract:
Machine Learning is Microsoft’s big entry in to the predictive analytics arena. Instead of staring into crystal balls, Machine Learning analyzes the data to determine if past performance is indicative of the future. In this introductory session we will discuss the growing new field of data predictive analytics and now Machine Learning is used to analyze cloud data.
SessionID: 15508
Guerilla MDM via MDS/SSIS Implementation
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Ira Warren
Title: Guerilla MDM via MDS/SSIS Implementation
Abstract:
I have implemented at several client. In implementing MDS I have extensive experience in creating data quality, data governance and MDM/MDS accelerators I published many articles.
Accelerators can take many forms generally there either software products that accelerate development and/or techniques that embody data aware and code generation capabilities.
In developing the MDS application extracting data, applying data quality, loading MDS entities, and extracting data from MDS, we have applied these techniques, that I have published articles on.
Specifically we've created an
SSIS/MDS application architecture is highly reusable and can easily be used to Quickstart other MDS projects requiring minimal change and leaving the best practices for MDS architecture, as I understand them. The basic principle we applied this to be a data aware (data profiling)and create SSIS code that will self generate loan pr
SessionID: 15737
Introduction to Wait Types and Response Time Analysis
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Janis Griffin
Title: Introduction to Wait Types and Response Time Analysis
Abstract:
SessionID: 15868
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 17159
Enterprise-grade MDM On SQL Server - the Keys to Success
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
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: 17496
Creating Dashboards in SSRS
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Joshua Buttles
Title: Creating Dashboards in SSRS
Abstract:
SessionID: 17508
Introduction to Microsoft Power Query
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Josh Sivey
Title: Introduction to Microsoft Power Query
Abstract:
Microsoft Power Query is an Excel plugin that enhances self-service business intelligence by allowing for discovering, merging, and enriching data from a variety of data sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia. In this session we’ll explore the basics of Power Query including how to use the plugin to source, merge, and enrich data to support self-service analytics.
SessionID: 17532
Data Factory: Data Integration in the Cloud
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Josh Luedeman
Title: Data Factory: Data Integration in the Cloud
Abstract:
SessionID: 17812
Diary of a Wimpy SSIS Developer
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Joseph Barth
Title: Diary of a Wimpy SSIS Developer
Abstract:
5 Glorious chapters that have
1- To lookup or Not to Lookup
2- Stored Procedure or Crazy CTE's
3- Excel's just don't do it!
4- Problems in container Town.
5- Show down at the Error Corral.
Prelude to devine intervention of SSIS supremacy(With the rest of the time, show you examples of cool stuff you can do with SSIS)
SessionID: 17817
Optimize Your SQL Server 2014 Workloads with Cisco UCS
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Gary Serda
Title: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract:
SessionID: 18253
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Cox
Abstract:
Keynote Themes:
- Pay attention to Azure SQL DB because most of the new features will appear there first
- Large projects on SQL 2014
- SQL on premises + Cloud scenarios/use cases
- Demos: Power BI, On-Premises + Cloud
SessionID: 18453
WIT Panel
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Kathi Kellenberger
Title: WIT Panel
Abstract:
SessionID: 18454
Writing Better T-SQL Queries with Window Functions
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Kathi Kellenberger
Title: Writing Better T-SQL Queries with Window Functions
Abstract:
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
SessionID: 18858
SQL Server Backups and Restores A to Z
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Keith Tate
Title: SQL Server Backups and Restores A to Z
Abstract:
Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do? If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options.
The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.
SessionID: 19092
Geospatial Data Types in SQL Server 2012
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Leonard Lobel
Title: Geospatial Data Types in SQL Server 2012
Abstract:
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!
SessionID: 19236
SQL Server Statistics – What Are The Chances?
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Lori Edwards
Title: SQL Server Statistics – What Are The Chances?
Abstract:
For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.
SessionID: 19341
Data wizardry with the next generation of Power BI!
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Matt Smith
Title: Data wizardry with the next generation of Power BI!
Abstract:
This will be an action-packed culmination of entertainment, story telling, jokes, and data wizardry using the next generation of Power BI!
SessionID: 19757
How "quirky" is your update?
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Martin Schoombee
Title: How "quirky" is your update?
Abstract:
Running totals are a lot easier with the SQL Server 2012 T-SQL syntax, but making it perform over large data sets still remain a challenge. This demo-heavy session will explore the good, the bad and the ugly when it comes to calculating running totals.
Our main focus however, will be a method coined by Jeff Moden as the "quirky update". This method produces lightning-fast results when calculating running totals, and sometimes the only option if you're dealing with large volumes and high performance requirements.
SessionID: 20004
TSQL Bullet-Dodging and Spoon-bending
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Michael DeFehr
Title: TSQL Bullet-Dodging and Spoon-bending
Abstract:
Did you think you could dodge bullets with SQL Server? Well, with some of these techniques, you won't have to. Learn some of the newer language elements in SQL server: Recursive CTE's, Composable DML, the MERGE statement, Row numbering and table-valued parameters. This fast-paced session that is almost exclusively demos is sure to leave you with a few ideas to make your TSQL development life easier.
SessionID: 20250
Introduction to Tableau
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Michael Perillo
Title: Introduction to Tableau
Abstract:
In this introductory Step-by-step you'll learn how to visually analyze data with Tableau by connecting to data, creating views and more.
- Introducing the Tableau Desktop application
- Connecting to SQL/OLAP data
- Creating worksheets and dashboards
- Demonstrating query and design best practices
SessionID: 20775
The Ins and Outs of SQL Indexes
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Mindy Curnutt
Title: The Ins and Outs of SQL Indexes
Abstract:
SessionID: 21115
Setting up an Azure Test Lab
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Marie Roqueni
Title: Setting up an Azure Test Lab
Abstract:
Azure is a fun new world, but many developers don't have access to an Azure subscription to start playing with it. In this session, you will learn how to setup an Azure Test environment, find free training resources, and learn tips and tricks to get the most out of the Azure Free Trial.
SessionID: 21167
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Mike Tutor
Abstract:
SessionID: 21594
Application of Hadoop on-demand for BI Integration and ETL Automation Using Azure HDInsight
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Orion Gebremedhin
Title: Application of Hadoop on-demand for BI Integration and ETL Automation Using Azure HDInsight
Abstract:
This session is designed to demonstrate the practical application of the Hyper Scale on-demand approach to Hadoop on Azure HDInsight, to process massive amounts of data on the cloud, for business intelligence applications. A hybrid architecture for ETL Integration will be discussed with practical demonstrations.
SessionID: 21822
Fun with the File System Task
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Paul Graham
Title: Fun with the File System Task
Abstract:
SessionID: 21862
Power BI Hands-On Micro-Workshop
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Paul Turley
Title: Power BI Hands-On Micro-Workshop
Abstract:
Office ProPlus 60 day trial: http://www.microsoft.com/en-us/evalcenter/evaluate-office-professional-plus-2013
Power Query add-in: http://www.microsoft.com/en-us/download/details.aspx?id=39379
SessionID: 21879
In Memory OLTP: One programmer's experience
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Paul Combellick
Title: In Memory OLTP: One programmer's experience
Abstract:
New for SQL Server 2014, In Memory OLTP, aka Hekaton, improves performance of many OLTP operations by maintaining tables in memory in lock latch free data structures and compiling T-SQL stored procedures to native code. This is one programmer’s experience porting an application to SQL Server 2014’s In-Memory OLTP feature to improve application concurrency, performance and scalability. I will discuss lessons learned and what changes are necessary to partially migrate an existing application to exploit SQL Server In Memory OLTP without having to rewrite a large application.
SessionID: 22605
Understanding the SQL Server Transaction Log
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Randy Knight
Title: Understanding the SQL Server Transaction Log
Abstract:
The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.
SessionID: 22793
Dynamically Increase your Data Awareness
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Reeves Smith
Title: Dynamically Increase your Data Awareness
Abstract:
Data Profiling is a vital step that is often overlooked in the development process. Integration Services (SSIS) built-in support for data profiling is limited and takes manual user intervention. Learn a new approach to automate data profiling and increase your data awareness.
In this session we will walk through a framework that dynamically develops a group of packages that can profile data based on the existing metadata within your current environment. By dynamically tracking the metadata within your environment, you can easily maintain your data monitoring solution. This will enable a more thorough view of your ETL environment that will allow you to spot issues faster and create a more scaled infrastructure based on your current performance needs.
SessionID: 22930
Introduction to Microsoft Azure DocumentDB
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Jeff Renz
Title: Introduction to Microsoft Azure DocumentDB
Abstract:
In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.
SessionID: 22981
Powershell - Automating build and deployment in a datawarehouse environment
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Richard Kemp
Title: Powershell - Automating build and deployment in a datawarehouse environment
Abstract:
There are many components which are developed and integrated as part of the large database solution – databases, ETL packages, reports, roles/security, SharePoint presentment, dashboards, etc. But the solution also needs to be managed in the context of a robust ALM, many physical environments with varying configurations, and many developers contending for resources. Automated builds are critical to such a solution. In this session we will examine the techniques used at one company to leverage PowerShell to drive automated processes to build, deploy, and test a solution in their development, testing, and QA environments. We will see live demos of the tools involved.
SessionID: 23093
Event Notification in SQL Server 2012
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Robert Miller
Title: Event Notification in SQL Server 2012
Abstract:
This session will cover an introduction to Event Notification usage in SQL Server 2012.
SessionID: 23367
Virtualizing our Environment
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Rob Mandeville
Title: Virtualizing our Environment
Abstract:
This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I'll discuss the differences between virtual and physical host metrics and issues surrounding them. We'll discuss some virtualization shortcomings and then show a little about Solarwinds' DPA and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.
SessionID: 23703
SQL Server Filesystem
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS/DBA/Misc
Speaker: Roger Wolter
Title: SQL Server Filesystem
Abstract:
• Why is fragmentation bad for performance?
• Why should I allocate more than one file in a filegroup?
• Why should I not rely on autogrow to size my SQL files?
• Why is autoshrink a very bad thing?
• What should my NTFS allocation unit size be set to?
• How many files should tempdb have?
All this and more!
SessionID: 23706
Introduction to Excel pivot tables
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS
Speaker: Ryan McCauley
Title: Introduction to Excel pivot tables
Abstract:
When people have a pile of data on which they need to do some basic analysis, most still turn to Excel as an easy-to-use data analysis tool. While there are many advanced BI tools you can use to help data tell the story, one of the easiest to use is built-in functionality, the Excel pivot table. In this session, we’ll review what a pivot table is, how to put your data together to leverage the power behind it, and do some demonstrations. We’ll also, time permitting, get into some of the more advanced features of pivot tables and show how they can be used to do some pretty advanced data analysis and aggregation.
SessionID: 25710
Change Data Capture (CDC) with SSIS
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS/DBA/Misc
Speaker: Steve Wake
Title: Change Data Capture (CDC) with SSIS
Abstract:
Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
SessionID: 26468
SQL Server 2014 Column Store Index vNEXT
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Boles
Title: SQL Server 2014 Column Store Index vNEXT
Abstract:
SessionID: 26572
Setting the stage...
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Tim Hidalgo
Title: Setting the stage...
Abstract:
Making successful deployments consistently is something your executive team wishes could happen. Sometimes they wish it so hard, that you end up becoming that cowboy that tests everything in production (you know who you are). Procuring equipment and configuring an environment so that you can have some confidence in your solutions, while not destroying customer data, can be a challenge...especially if you have no plan of attack to hand the people that sign the checks.
In this session we will discuss the need for, the design of, and the way to get a staging environment that can boost your deployment success rate, allow developers to fearlessly code creative solutions, and allow you the DBA to get some sleep knowing they aren't testing in production.
SessionID: 26967
The Life Cycle of a Query in 3D
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA/Prof Dev
Speaker: Todd Kleinhans
Title: The Life Cycle of a Query in 3D
Abstract:
Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
SessionID: 27386
The Significance of Choosing the Right Data Types
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: App Dev
Speaker: Vern Rabe
Title: The Significance of Choosing the Right Data Types
Abstract:
In addition, we will cover several data type related functions, and the caveats in their usage. Even advanced T-SQL developers and DBAs will walk away with a useful nugget or two.
SessionID: 34778
Powershell Tips and Tricks for SQL Server Administration
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA/Prof Dev
Speaker: Michael Fal
Title: Powershell Tips and Tricks for SQL Server Administration
Abstract:
SessionID: 34815
Pyramid Ananytics Govern Data Discovery
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Mike Teel
Title: Pyramid Ananytics Govern Data Discovery
Abstract:
The integrated Pyramid office suite offers a number of features that enables users to make the most of the suite's BI capabilities. Designed to smoothly integrate with corporate business flows,
SessionID: 9068
SSAS Multidimensional vs. SSAS Tabular – Which one do I use?
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Alan Faulkner
Title: SSAS Multidimensional vs. SSAS Tabular – Which one do I use?
Abstract:
With the release of SQL Server 2012, we were introduced to two possible options when it came to Analysis Services. This ultimately presented a question…”Which one do I use SSAS multidimensional or SSAS tabular”?
Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014. This session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012/2014.
SessionID: 9141
On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: BIA
Speaker: Adam Jorgensen
Title: On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Abstract:
SessionID: 9417
Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Amy Herold
Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Abstract:
While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
SessionID: 9420
Making the Leap from Developer to DBA
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA/Prof Dev
Speaker: Amy Herold
Title: Making the Leap from Developer to DBA
Abstract:
You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
SessionID: 9450
The Leader in Server-Side Storage Intelligence
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: DBA/Prof Dev
Speaker: Jared Lutgen
Title: The Leader in Server-Side Storage Intelligence
Abstract:
SessionID: 9867
RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works
Event Date: 28-02-2015 - Session time: 00:00:00 - Track: SSIS/DBA/Misc
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.