sqlsathistory

Nr: 389

SQLSaturday #389 - Huntington Beach 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Jonathan Shaulis	Track 5	Introduction to Wait Types and Response Time Analysis
00:00:00	Deji Akomolafe	Track 6	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
08:30:00	Brandon Leach	Track 5	Treating Tables Like Legos, Partitioning Basics
08:30:00	Kevin Kline	Track 1	Top 10 Admininistrator Mistakes on SQL Server
08:30:00	Yong Ji	Track 8	How to Automate SSIS and SQL Agent Job Deployments
08:30:00	Lynn Langit	Track 3	Using Premium Data for Analysts
08:30:00	Robert Hatton	Track 7	Thinking in SQL
08:30:00	Steve Jones	Track 2	Get Testing with tSQLt
08:30:00	Tim Hidalgo	Track 6	The Ritual of Restoration
08:30:00	Alan Faulkner	Track 4	SSAS Design and Performance Best Practices
09:45:00	Diana Dee	Track 8	Merge Replication 101
09:45:00	Ted Stathakis	Track 7	Getting Started with Reporting Services
09:45:00	Jason Horner	Track 2	PowerShell for the Reluctant DBA / Developer
09:45:00	Denny Cherry	Track 1	Table Indexing for the .NET Developer
09:45:00	Mike Tutor	Other	Tools in Your Toolbox You’re Not using! Why Not?
09:45:00	Paul Turley	Track 6	Visualization Choices: What, When, and How?
09:45:00	Steve Hughes	Track 4	Building a Modern Data Warehouse and Analytics Solution in Azure
09:45:00	Kerry Tyler	Track 5	45 Minutes to Your First SSAS Tabular Model
09:45:00	Argenis Fernandez	Track 3	Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!
11:00:00	Benjamin Nevarez	Track 5	Query Processing in In-Memory OLTP (Hekaton)
11:00:00	Ginger Grant	Track 4	Predicting the future with Machine Learning
11:00:00	Joseph D'Antoni	Track 2	You Wouldn't Let HR Manage Your DBs...
11:00:00	Julie Koesmarno	Track 3	10 Handy Tips On SQL Server Dates
11:00:00	Mickey Stuewe	Track 6	Changing Your Habits to Improve the Performance of Your T-SQL
11:00:00	Rushabh Mehta	Track 7	SSIS 2012 Management Considerations and Best Practices
11:00:00	Simon Cho	Track 8	Transaction
11:00:00	Stacia Varga	Track 1	Multidimensional vs Tabular - May the Best Model Win
12:30:00	Andrew Karcher	Other	[Sponsor] - SQL Server Monitoring with Spotlight for SQL Server Enterprise
12:30:00	Andrew Karcher	Other	[Sponsor] The Red Gate Database Lifecycle Management Story w/ Ste
12:30:00	Andrew Karcher	Other	[Sponsor] Light Up Your SQL Investments with Pyramid Analytics w/
13:30:00	David Sumlin	Track 6	Turbo Charged SQL Development With SQL#
13:30:00	Kevin Kline	Track 1	Convince Me – Persuasion Techniques That Get Things Done
13:30:00	Konstantin Melamud	Track 8	Turbo Boost Performance: In Memory Tables index optimizations
13:30:00	Mike Tutor	Track 5	Simple things you can do to make the Query Optimizer more efficient!
13:30:00	Steve Jones	Track 2	Continuous Integration for Databases
13:30:00	Steve Wake	Track 3	Date Dimension: Past Future in One Script
13:30:00	Kevin Boles	Track 4	Common TSQL Mistakes
13:30:00	David McCarter	Track 7	Rock Your Technical Interview (Part 1)
14:45:00	Julie Koesmarno	Track 3	Interactive Actionable Data Visualisation With Power View
14:45:00	Karen Lopez	Track 2	$#*! Your Database Says About Me
14:45:00	Denny Cherry	Track 1	Database Administration for the non-DBA
14:45:00	Reeves Smith	Track 8	Increase your SSIS productivity with Biml
14:45:00	Stacia Varga	Other	(Way Too Much) Fun with Reporting Services
14:45:00	Kevin Boles	Track 4	SQL Server Defaults SUCK!!
14:45:00	Anoop Sunke	Track 6	Overview Hadoop for Windows (HDP2.2)
14:45:00	David McCarter	Track 7	Rock Your Technical Interview (Part 2)
16:00:00	Benjamin Nevarez	Track 4	Understanding Parameter Sniffing
16:00:00	Demian Quinonez	Track 8	SSIS Design Patterns
16:00:00	Ginger Grant	Track 3	Top 10 SSIS Tuning Tricks
16:00:00	Harry Chandra	Track 5	Poor Man's AlwaysOn - Readable Secondary w/ Automatic Failover Capabilites on SQL 2008 R2
16:00:00	Joseph D'Antoni	Other	Building Perfect SQL Servers, Every Time
16:00:00	Paul Turley	Track 7	Power BI Hands-On Micro-Workshop
16:00:00	Randy Knight	Track 1	Locks, Blocks, and Deadlocks Oh My!
16:00:00	Steve Wake	Other	Near Real-Time Data Warehouse Updates with CDC SSIS
16:00:00	Andrew Nakamura	Track 6	Azure 101 - Where Do I Start?
16:00:00	Argenis Fernandez	Track 2	(Near) Zero-Downtime Upgrades!

SessionID: 17328

Introduction to Wait Types and Response Time Analysis

Back to calendar

Event Date: 11-04-2015 - Session time: 00:00:00 - Track: Track 5

Speaker: Jonathan Shaulis

Title: Introduction to Wait Types and Response Time Analysis

Abstract:

SessionID: 24757

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 11-04-2015 - Session time: 00:00:00 - Track: Track 6

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First" is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring it!

SessionID: 10704

Treating Tables Like Legos, Partitioning Basics

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 5

Speaker: Brandon Leach

Title: Treating Tables Like Legos, Partitioning Basics

Abstract:

Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we'll look at the concepts surrounding partitioning and how we can apply them. We'll reinforce what we cover with some cool demo's showing some really neat tricks.

SessionID: 18239

Top 10 Admininistrator Mistakes on SQL Server

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 1

Speaker: Kevin Kline

Title: Top 10 Admininistrator Mistakes on SQL Server

Abstract:

SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

SessionID: 18868

How to Automate SSIS and SQL Agent Job Deployments

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 8

Speaker: Yong Ji

Title: How to Automate SSIS and SQL Agent Job Deployments

Abstract:

Are you trying to implement Continuous Integration for your DB?

This session will equip you with the basics and tools needed to approach automating SSIS and SQL Agent Job deployments.

There are many blog postings and articles about this but it is not easy to find good working examples of this automation. In this session, I will go over the basics of this automation and discuss the necessary components and possible options that you can use, including a working example of SSIS and SQL Agent Job deployment.

SessionID: 19328

Using Premium Data for Analysts

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 3

Speaker: Lynn Langit

Title: Using Premium Data for Analysts

Abstract:

Did you know that you can verify business names, addresses and credit status from within Excel? Big Data also means premium data, but what is it and how do you use it? Come to this session to learn via demonstrations, what types of premium data are out there, how to get the right data easily (usually from inside of Excel) and how to estimate costs accurately. We'll look at Dun Bradstreet, Melissa Data, Strike Iron and more.

SessionID: 23168

Thinking in SQL

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 7

Speaker: Robert Hatton

Title: Thinking in SQL

Abstract:

SessionID: 24548

Get Testing with tSQLt

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 2

Speaker: Steve Jones

Title: Get Testing with tSQLt

Abstract:

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.

SessionID: 26573

The Ritual of Restoration

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 6

Speaker: Tim Hidalgo

Title: The Ritual of Restoration

Abstract:

Through out your journeys as a DBA one thing is inevitable. One day a database will fall in battle and it will be up to you to resurrect it. So do you know the different rituals of restoration that can save your company's data, and possibly your job? In this session we will discuss; disasters, backups and demo the various ways you can restore a database for production use.

SessionID: 9064

SSAS Design and Performance Best Practices

Back to calendar

Event Date: 11-04-2015 - Session time: 08:30:00 - Track: Track 4

Speaker: Alan Faulkner

Title: SSAS Design and Performance Best Practices

Abstract:

A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

SessionID: 13421

Merge Replication 101

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 8

Speaker: Diana Dee

Title: Merge Replication 101

Abstract:

Merge replication – Some people hate it and some people love it.

Merge replication can be used to provide an autonomous (writable) copy of a database.  It is easy to set up and is very failure-resilient.  It can be used as a database high-availability method.
I will explain why I am a lover of merge replication.  I will demonstrate merge replication set up, explain conflict resolution, and tell stories from my experience to illustrate its resilience.

SessionID: 14266

Getting Started with Reporting Services

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 7

Speaker: Ted Stathakis

Title: Getting Started with Reporting Services

Abstract:

Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a dataset through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.

SessionID: 15878

PowerShell for the Reluctant DBA / Developer

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 2

Speaker: Jason Horner

Title: PowerShell for the Reluctant DBA / Developer

Abstract:

This presentation will provide a brief overview of how to get started with powershell and will be demo intensive.

Demo topics will include common challenges that database professional's face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices.

SessionID: 21079

Table Indexing for the .NET Developer

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 1

Speaker: Denny Cherry

Title: Table Indexing for the .NET Developer

Abstract:

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best.

SessionID: 21171

Tools in Your Toolbox You’re Not using! Why Not?

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Other

Speaker: Mike Tutor

Title: Tools in Your Toolbox You’re Not using! Why Not?

Abstract:

Policy Based Management (PBM) and Central Management Server (CMS) are tools you already have if you have at least one SQL 2008 instance. These powerful but often overlooked tools are simple to use, and together they give you a central point from which to manage all your SQL instances. You can even manage your SQL 2000 and 2005 servers as well. This live demo session will show you how easy it is to use these 'hidden gems' that have been lying about in your SSMS toolbox. Real world solutions for real world problems in just minutes.

SessionID: 21876

Visualization Choices: What, When, and How?

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 6

Speaker: Paul Turley

Title: Visualization Choices: What, When, and How?

Abstract:

When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models.

SessionID: 25763

Building a Modern Data Warehouse and Analytics Solution in Azure

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 4

Speaker: Steve Hughes

Title: Building a Modern Data Warehouse and Analytics Solution in Azure

Abstract:

For years, data warehouses have required a significant investment in hardware and software. We frequently planned for the three year lifecycle. As virtual machines started to handle the load, we gained additional flexibility. In this session, we will look at the various services in Azure and how they can be leveraged to handle various workloads and capabilities. By blending IaaS, PaaS, and even SaaS in the Microsoft Cloud, we can build highly flexible and scalable solutions to meet our needs large and small. We will look at some designs and their strengths and weaknesses including cost, maintenance, scalability, and elasticity.

SessionID: 9089

45 Minutes to Your First SSAS Tabular Model

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 5

Speaker: Kerry Tyler

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract:

Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven't had a chance to dive in and figure out how to develop one yourself? Now is the time!

SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.

SessionID: 9784

Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!

Back to calendar

Event Date: 11-04-2015 - Session time: 09:45:00 - Track: Track 3

Speaker: Argenis Fernandez

Title: Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!

Abstract:

Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail! We will look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. We will also discuss options for environments on which the code cannot be modified.

SessionID: 10362

Query Processing in In-Memory OLTP (Hekaton)

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 5

Speaker: Benjamin Nevarez

Title: Query Processing in In-Memory OLTP (Hekaton)

Abstract:

In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

SessionID: 14673

Predicting the future with Machine Learning

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 4

Speaker: Ginger Grant

Title: Predicting the future with Machine Learning

Abstract:

Machine Learning is Microsoft’s big entry in to the predictive analytics arena. . In this introductory session we will discuss the growing new field of predictive analytics and how Machine Learning is used to predict future results. Instead of staring into crystal balls, Machine Learning provides the ability to experiment to determine which algorithm or R code best analyzes the data to determine if past performance is indicative of the future or use scoring to find a more appropriate model.

SessionID: 16228

You Wouldn't Let HR Manage Your DBs...

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 2

Speaker: Joseph D'Antoni

Title: You Wouldn't Let HR Manage Your DBs...

Abstract:

So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel. Presented with Karen Lopez.

SessionID: 16918

10 Handy Tips On SQL Server Dates

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 3

Speaker: Julie Koesmarno

Title: 10 Handy Tips On SQL Server Dates

Abstract:

Are you working with an application supporting different time zones and international date formats? How does your choice of storing date / time values differ if you are using Windows Azure SQL Database instead of on-prem SQL Server database? Did you know that SQL Server Database Engine, Integration Services (SSIS) and Analysis Services (SSAS) all have slightly different date / time data types? How can you bullet proof your system for the ever growing data in your organization with much more date and time data to come?

With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE!

SessionID: 20404

Changing Your Habits to Improve the Performance of Your T-SQL

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 6

Speaker: Mickey Stuewe

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract:

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

SessionID: 23126

SSIS 2012 Management Considerations and Best Practices

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 7

Speaker: Rushabh Mehta

Title: SSIS 2012 Management Considerations and Best Practices

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: 24441

Transaction

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 8

Speaker: Simon Cho

Title: Transaction

Abstract:

More likely Transaction logging level inside of LDF file other than just simple rollback and commit transaction.

Transaction related issues in real world. Look at inside of Transaction details. And check what's the best solution for each case. A little bit of minimal logging information.

SessionID: 24729

Multidimensional vs Tabular - May the Best Model Win

Back to calendar

Event Date: 11-04-2015 - Session time: 11:00:00 - Track: Track 1

Speaker: Stacia Varga

Title: Multidimensional vs Tabular - May the Best Model Win

Abstract:

Are multidimensional models dead on arrival? Are tabular models the future of analysis? Come to this session to learn the similarities and differences between these two approaches to analytical modeling first introduced in SQL Server 2012 Analysis Services. We'll explore the pros and cons of each type of model and review how to select the appropriate model to your analytical requirements.

SessionID: 36008

Back to calendar

Event Date: 11-04-2015 - Session time: 12:30:00 - Track: Other

Speaker: Andrew Karcher

Abstract:

Learn about the easiest way to monitor your SQL Server and Windows environment including data collection, historical and real time diagnostics, alarming, notifications, reporting and more.

Speaker: David Swanson

David Swanson is a graduate of the University of Arizona. He has worked in the software industry for 15 years. He has been a developer, a DBA, worked in support, product management and is currently a Database Systems Consult for Dell Software. He assists in product proof of concepts and production implementations with organizations ranging in size from very small to some of the biggest companies in the United States. He lives in the greater Boston area.

SessionID: 36043

Back to calendar

Event Date: 11-04-2015 - Session time: 12:30:00 - Track: Other

Speaker: Andrew Karcher

Abstract:

We all want a strong and steady engineering process for our database development that allows us to deploy our code in a consistent and safe manner. Come see an overview of how a complex database lifecycle process can work to ensure changes made in development environments are always tested and reviewed, before being deployed in an automated fashion. Learn to Ship Safe, and Ship Often.

SessionID: 36044

Back to calendar

Event Date: 11-04-2015 - Session time: 12:30:00 - Track: Other

Speaker: Andrew Karcher

Abstract:

Overview of Pyramid Analytics and Demonstration on our BI Office

SessionID: 12810

Turbo Charged SQL Development With SQL#

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 6

Speaker: David Sumlin

Title: Turbo Charged SQL Development With SQL#

Abstract:

Turbo charge your SQL Server development with the amazing SQL# CLR library. We will do a quick overview of the SQL# library and then jump into examining a few real world implementations of some of the functions and procedures. Some examples will include string manipulation, file handling, as well as some RegEx usage. There are over 245 procedures and functions, user defined aggregates, and user defined types ... and counting. Come explore some of the interesting problems that SQL# can solve. If you'd like to download and view the CLR library ahead of the presentation, you can get most of the CLR features for free at www.sqlsharp.com.

SessionID: 18241

Convince Me – Persuasion Techniques That Get Things Done

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 1

Speaker: Kevin Kline

Title: Convince Me – Persuasion Techniques That Get Things Done

Abstract:

This was the top scoring professional development session from the PASS Summit 2013.

Ever wanted to convince the boss try something new, but didn't know where to start? Ever tried to lead your peers only to fail to achieve your goals? This session teaches you the eight techniques of influencing IT professionals, so that you can innovate and achieve change in your organization.

Learn about the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority.
Learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them.
Discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.

SessionID: 18558

Turbo Boost Performance: In Memory Tables index optimizations

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 8

Speaker: Konstantin Melamud

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract:

With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

SessionID: 21170

Simple things you can do to make the Query Optimizer more efficient!

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 5

Speaker: Mike Tutor

Title: Simple things you can do to make the Query Optimizer more efficient!

Abstract:

On occasion as DBAs we have need to disable the foreign keys and constraints on one or more tables. Guess what, SQL Server no longer trusts those constraints when you re-enable them. What does that mean? In this discussion, we’ll talk about what the impact is to your queries when you have non-trusted constraints, how to find the non-trusted constraints, and how to soothe SQL Servers mistrusting heart so that it will trust your constraints again! How about your foreign keys? Are you using implicit conversions? Are your stats 'stale'? All of these things effect how the query optimizer works and can negatively affect you query performance.

SessionID: 24550

Continuous Integration for Databases

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 2

Speaker: Steve Jones

Title: Continuous Integration for Databases

Abstract:

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

SessionID: 25724

Date Dimension: Past Future in One Script

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 3

Speaker: Steve Wake

Title: Date Dimension: Past Future in One Script

Abstract:

All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or create it in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!

SessionID: 26426

Common TSQL Mistakes

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 4

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over SEVENTY times now and it is always very highly rated!

SessionID: 35932

Rock Your Technical Interview (Part 1)

Back to calendar

Event Date: 11-04-2015 - Session time: 13:30:00 - Track: Track 7

Speaker: David McCarter

Title: Rock Your Technical Interview (Part 1)

Abstract:

SessionID: 16919

Interactive Actionable Data Visualisation With Power View

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 3

Speaker: Julie Koesmarno

Title: Interactive Actionable Data Visualisation With Power View

Abstract:

Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go.

This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.

SessionID: 17911

$#*! Your Database Says About Me

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 2

Speaker: Karen Lopez

Title: $#*! Your Database Says About Me

Abstract:

Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions-- using real-life evidence of her own data in your systems.

SessionID: 21080

Database Administration for the non-DBA

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 1

Speaker: Denny Cherry

Title: Database Administration for the non-DBA

Abstract:

So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

SessionID: 22802

Increase your SSIS productivity with Biml

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 8

Speaker: Reeves Smith

Title: Increase your SSIS productivity with Biml

Abstract:

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.

SessionID: 24731

(Way Too Much) Fun with Reporting Services

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Other

Speaker: Stacia Varga

Title: (Way Too Much) Fun with Reporting Services

Abstract:

Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?

SessionID: 26427

SQL Server Defaults SUCK!!

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 4

Speaker: Kevin Boles

Title: SQL Server Defaults SUCK!!

Abstract:

If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

SessionID: 34604

Overview Hadoop for Windows (HDP2.2)

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 6

Speaker: Anoop Sunke

Title: Overview Hadoop for Windows (HDP2.2)

Abstract:

As the defacto platform for Big Data Apache Hadoop has matured to occupy a central place in the next generation data architecture. Hadoop does not replace existing technologies rather complements them by adding and enhancing what is possible in the enterprise. In this talk we will dive into the details of Hadoop on Windows exploring each of the components and their functions within an Enterprise Hadoop distribution. He will also discuss some of the common use cases, applications and data types that are being enabled with this new capability.

Audience Key Learning: Key components of Hadoop on Windows and their functions within an Enterprise Hadoop distribution. Use cases, applications and data types that are being enabled with Hadoop.

SessionID: 35933

Rock Your Technical Interview (Part 2)

Back to calendar

Event Date: 11-04-2015 - Session time: 14:45:00 - Track: Track 7

Speaker: David McCarter

Title: Rock Your Technical Interview (Part 2)

Abstract:

SessionID: 10363

Understanding Parameter Sniffing

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 4

Speaker: Benjamin Nevarez

Title: Understanding Parameter Sniffing

Abstract:

Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

SessionID: 13062

SSIS Design Patterns

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 8

Speaker: Demian Quinonez

Title: SSIS Design Patterns

Abstract:

Business Intelligence is what you get when you take raw data and transform it into the valuable information that organizations use to make strategic decisions. But how do you take data from disparate systems, mold it, and bring it together in one place where you can begin the important work of data analysis?

Learn about some common SSIS (SQL Server Integration Services) design patterns for loading data into a data warehouse.

SessionID: 14672

Top 10 SSIS Tuning Tricks

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 3

Speaker: Ginger Grant

Title: Top 10 SSIS Tuning Tricks

Abstract:

Interested in making SSIS perform faster? Do you wonder what the best practices for writing Packages really are? This session reviews how to create SSIS packages to perform as quickly as possible by revealing the Top 10 things you can do to improve the performance of your packages.

SessionID: 14947

Poor Man's AlwaysOn - Readable Secondary w/ Automatic Failover Capabilites on SQL 2008 R2

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 5

Speaker: Harry Chandra

Title: Poor Man's AlwaysOn - Readable Secondary w/ Automatic Failover Capabilites on SQL 2008 R2

Abstract:

This session will cover the process of creating a readable secondary with automatic failover capabilities. Not everyone can be on SQL 2012 right away or having more than one secondary server for reporting or failover by utilizing Database Mirroring\Log Shipping and Database Snapshot. After this session, you will be able to utilize your reporting/secondary server for more than 1 purpose.

SessionID: 16226

Building Perfect SQL Servers, Every Time

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Other

Speaker: Joseph D'Antoni

Title: Building Perfect SQL Servers, Every Time

Abstract:

One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.

SessionID: 21877

Power BI Hands-On Micro-Workshop

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 7

Speaker: Paul Turley

Title: Power BI Hands-On Micro-Workshop

Abstract:

Bring your laptop and let's build a BI solution using the components of Power BI! You'll need Office 2013 ProPlus (you can install the trial) and the Power Query add-in. I'll provide everything else. This 95% demo and uber-fast hands-on lab session will show you how to cleanse and transform data from multiple sources with Power Query, model data for reporting with Power Pivot and then explore the model and build interactive dashboards with Power View. You'll leave with a working BI solution.

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: 22554

Locks, Blocks, and Deadlocks Oh My!

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 1

Speaker: Randy Knight

Title: Locks, Blocks, and Deadlocks Oh My!

Abstract:

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.

SessionID: 25725

Near Real-Time Data Warehouse Updates with CDC SSIS

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Other

Speaker: Steve Wake

Title: Near Real-Time Data Warehouse Updates with CDC SSIS

Abstract:

If you need to keep a data warehouse up-to-date in near real-time, Change Data Capture (CDC) is a solution! If you are looking for a way to setup auditing of database changes, CDC is a solution! 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 configured. 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 in a way that can be run quickly and keep your data warehouse up-to-date.

SessionID: 9484

Azure 101 - Where Do I Start?

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 6

Speaker: Andrew Nakamura

Title: Azure 101 - Where Do I Start?

Abstract:

Have you wanted to get started with Azure but don't know where to start? Aside from the reasons why to learn Azure, what resources can you use to quickly ramp up your skills for little costs? In this session, you will learn the way to fast track your Azure knowledge. Learn how to either use it as an idea lab to test new features of SQL and other technologies.

SessionID: 9785

(Near) Zero-Downtime Upgrades!

Back to calendar

Event Date: 11-04-2015 - Session time: 16:00:00 - Track: Track 2

Speaker: Argenis Fernandez

Title: (Near) Zero-Downtime Upgrades!

Abstract:

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure? You can actually do this, by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

In this session you will:

Understand how rolling upgrades are better than in place upgrades
Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you.

This site is open source. Improve this page.