sqlsathistory

Nr: 383

Back to Main list

SQLSaturday #383 - Rochester 2015

Start Time (24h) Speaker Track Title
00:00:00 William E Pearson III Track 2 Possible Musics: SSAS Multidimensional vs Tabular
08:30:00 Colleen Morrow Track 5 So you want to be a Database Administrator...
08:30:00 Janis Griffin Track 6 Query Tuning - Get it Right the First Time
08:30:00 Steve Hood Track 4 Fixing Page Life Expectancy
08:30:00 Warner Chaves Track 3 The Use Cases for In-Memory OLTP
08:30:00 Adam Belebczuk Track 7 Availability Groups 101: An Introduction
08:30:00 Andy Levy Track 2 Easing Into Scripting with Windows PowerShell
09:45:00 Chris Bell Track 1 The Spy Who Loathed Me - An Intro to SQL Security
09:45:00 Colleen Morrow Track 5 Enterprise-level auditing on a Standard Edition budget
09:45:00 Janis Griffin Track 6 Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
09:45:00 Mike Hays Track 4 Advanced Troubleshooting Your SQL Connections
09:45:00 Thomas Grohser Track 2 SQL Server Storage Engine under the hood
09:45:00 Warner Chaves Track 3 Level Up: Understanding Azure's SQL Database Service Tiers
09:45:00 Adam Belebczuk Track 7 XML Without Xanax: How to Handle XML in SQL Server
11:00:00 Chris Bell Track 3 Hacking Exposé - Using SSL to Protect SQL Connections
11:00:00 Edwin M Sarmiento Track 6 SQL Server and Networking High Availability/Disaster Recovery Best Practices
11:00:00 Kevin Feasel Track 5 APPLY Yourself
11:00:00 George Walters Track 1 SQL Server 2014 New Features
11:00:00 John Miner Track 4 Software as a service
11:00:00 Markus Ehrenmueller-Jensen Track 2 The BI Power Hour
11:00:00 Thomas Grohser Track 2 Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools
11:00:00 William E Pearson III Track 7 Getting Started with MDX
13:30:00 Edwin M Sarmiento Track 6 Troubleshoot SQL Server Performance Issues using Wait Statistics
13:30:00 Edward Pollack Track 7 (a Few of) My Favorite DMVs
13:30:00 Kevin Feasel Track 5 Much Ado About Hadoop
13:30:00 George Walters Track 2 SQL Server AlwaysOn Availability Groups
13:30:00 John Miner Track 1 Basic Database Design
13:30:00 Markus Ehrenmueller-Jensen Track 2 Boosting DWH-Performance with SQL Server 2014
13:30:00 Brian Benzel Track 4 The Quest for the Golden Record: MDM Best Practices
14:45:00 Chris Schmidt Track 4 Rethink Your ETL with BIML
14:45:00 David Klee Track 6 Right-Sizing Your SQL Server Virtual Machine
14:45:00 David Maxwell Track 3 The usual SUSPECTs: When good databases go bad.
14:45:00 James Serra Track 7 What exactly is big data and why should I care?
14:45:00 Kendal Van Dyke Track 5 Transactional Replication: Architecture, Setup, and Monitoring
14:45:00 Kathi Kellenberger Track 2 Introduction to Window Functions
14:45:00 Matt Nelson Track 1 Getting started with SSIS
16:00:00 David Klee Track 6 The Many Paths of Consulting
16:00:00 David Maxwell Track 3 DBA 911 - Database Corruption
16:00:00 Edward Pollack Track 1 Query Optimization Crash Course
16:00:00 James Serra Track 7 How does Microsoft solve Big Data?
16:00:00 Kendal Van Dyke Track 5 Transactional Replication: Tuning and Troubleshooting
16:00:00 Kathi Kellenberger Track 2 T-SQL Window Function Performance
16:00:00 Matt Nelson Track 4 Building dynamic SSIS packages for more flexibility

SessionID: 35927

Possible Musics: SSAS Multidimensional vs Tabular

Back to calendar

Event Date: 16-05-2015 - Session time: 00:00:00 - Track: Track 2

Speaker: William E Pearson III

Title: Possible Musics: SSAS Multidimensional vs Tabular

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with SSAS 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SQL Server MVP and SSAS Maestro Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing examples to illustrate approaches for given scenarios.

SessionID: 11784

So you want to be a Database Administrator...

Back to calendar

Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 5

Speaker: Colleen Morrow

Title: So you want to be a Database Administrator...

Abstract:

In 2014, CareerBliss.com and Forbes Magazine ranked Database Administrator as the #1 happiest job. But what exactly does a DBA do? How does someone become a DBA? And why are they so darned happy? In this session we'll explore the different types of DBA, their roles and responsibilities, and the career path for database professionals. Whether you're just starting your career and trying to find your footing, or you're a seasoned veteran wondering where to go from here, this session will show you the possibilities.

SessionID: 15736

Query Tuning - Get it Right the First Time

Back to calendar

Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 6

Speaker: Janis Griffin

Title: Query Tuning - Get it Right the First Time

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 25728

Fixing Page Life Expectancy

Back to calendar

Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 4

Speaker: Steve Hood

Title: Fixing Page Life Expectancy

Abstract:

Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.

SessionID: 27648

The Use Cases for In-Memory OLTP

Back to calendar

Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 3

Speaker: Warner Chaves

Title: The Use Cases for In-Memory OLTP

Abstract:

In this session, we will do a short introduction to the In-Memory OLTP feature before diving straight into the use cases where the new lockless/latchless concurrency control and native compilation really shines. Demos will cover PAGELATCH contention, use of In-Memory for ETL and In-Memory tables as 'shock absorbers' for high throughput environments. For each case we will do a comparison of "Classic" vrs In-Memory, what gains can the audience expect and what patterns will yield the biggest benefits.

SessionID: 9009

Availability Groups 101: An Introduction

Back to calendar

Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 7

Speaker: Adam Belebczuk

Title: Availability Groups 101: An Introduction

Abstract:

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.

SessionID: 9560

Easing Into Scripting with Windows PowerShell

Back to calendar

Event Date: 16-05-2015 - Session time: 08:30:00 - Track: Track 2

Speaker: Andy Levy

Title: Easing Into Scripting with Windows PowerShell

Abstract:

You've been hearing about Windows PowerShell, but you're wondering if it's something you should be working with. Or maybe you’re just looking for a way to make those boring, repetetive chores take care of themselves. In this introductory session, we'll talk about what PowerShell is, how to use it, and where it’s going. Whether you're a junior DBA or seasoned veteran, you'll find ways that PowerShell can make your life easier.

SessionID: 11288

The Spy Who Loathed Me - An Intro to SQL Security

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 1

Speaker: Chris Bell

Title: The Spy Who Loathed Me - An Intro to SQL Security

Abstract:

You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.

SessionID: 11783

Enterprise-level auditing on a Standard Edition budget

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 5

Speaker: Colleen Morrow

Title: Enterprise-level auditing on a Standard Edition budget

Abstract:

In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases. Unfortunately, that's an Enterprise Edition feature. What about those of us running Standard Edition? In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, extended events, and even SQL Audit.

SessionID: 15735

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 6

Speaker: Janis Griffin

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract:

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

SessionID: 20663

Advanced Troubleshooting Your SQL Connections

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 4

Speaker: Mike Hays

Title: Advanced Troubleshooting Your SQL Connections

Abstract:

Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect. It becomes more challenging when we find nothing is wrong with the way SQL Server is running. In this session we review common mistakes to the configuration of network settings. We’ll also show how to troubleshoot the SQL Server Browser. We’ll cover how to test for firewall issues. Finally we’ll discuss why SQL Server is blamed for dropping its connections.

SessionID: 26129

SQL Server Storage Engine under the hood

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 2

Speaker: Thomas Grohser

Title: SQL Server Storage Engine under the hood

Abstract:

How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.   Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.

SessionID: 27647

Level Up: Understanding Azure's SQL Database Service Tiers

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 3

Speaker: Warner Chaves

Title: Level Up: Understanding Azure's SQL Database Service Tiers

Abstract:

As part of Microsoft's aggressive cloud strategy, the SQL Database as a service has been getting new releases and new features at a rapid pace.

The biggest change so far has been the introduction of three service tiers: Basic, Standard and Premium.

Gone is the pay for database size system and it has been replaced by a system where we also pay for the performance characteristics and recovery features of our database.

Come learn the differences between the tiers, measuring performance and how to optimize the use of your cloud SQL power.

SessionID: 9010

XML Without Xanax: How to Handle XML in SQL Server

Back to calendar

Event Date: 16-05-2015 - Session time: 09:45:00 - Track: Track 7

Speaker: Adam Belebczuk

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract:

Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.

SessionID: 11286

Hacking Exposé - Using SSL to Protect SQL Connections

Back to calendar

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

Speaker: Chris Bell

Title: Hacking Exposé - Using SSL to Protect SQL Connections

Abstract:

Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?

You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries? Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would. *Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.

SessionID: 13745

SQL Server and Networking High Availability/Disaster Recovery Best Practices

Back to calendar

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

Speaker: Edwin M Sarmiento

Title: SQL Server and Networking High Availability/Disaster Recovery Best Practices

Abstract:

Do you think you can handle Failover Clustering and Availability Groups? Think again. Your job description as a SQL Server DBA has just changed. In this demo-centric session, you’ll see how networking aspects such as Active Directory and DNS play very important roles when implementing a SQL Server high availability and disaster recovery (HA/DR) solution. You will want to be confident enough to have a conversation with your Domain Administrator to make sure your SQL Server databases meet their recovery objectives and service level agreements.

SessionID: 14202

APPLY Yourself

Back to calendar

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

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 14545

SQL Server 2014 New Features

Back to calendar

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

Speaker: George Walters

Title: SQL Server 2014 New Features

Abstract:

SQL Server 2014 will have a number of new features to help with specific situations in OLTP and OLAP queries. In-Memory tables and queries, SSD Buffer Pool, Columnstore Indexing, and AlwaysOn Improvements will be covered

SessionID: 16999

Software as a service

Back to calendar

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

Speaker: John Miner

Title: Software as a service

Abstract:

Abstract:

Are you tired of installing, configuring and patching Microsoft SQL Server? Microsoft Azure SQL database maybe a way to move some of your infrastructure to the cloud. Depending upon your companies philosophy, it might be great for development, testing, and possibly production environments.

The exciting thing about this service is that new features will be released on this platform first before trickling down to the on-premise editions.

Coverage:

1 - The Azure Portal 2 - Identifying your database server 3 - Adding IP Rules for clients 4 - Capturing a connection string 5 - Using SSMS and/or SQLCMD for development 6 - Creating a database from TSQL 7 - Executing CRUD statements 8 - Migrating old database using wizard 9 - What SQL Azure database still lacks.

SessionID: 19692

The BI Power Hour

Back to calendar

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

Speaker: Markus Ehrenmueller-Jensen

Title: The BI Power Hour

Abstract:

Imagine a world in that end-user can collect data from your data warehouse, from operational databases, flat files, excel files and even external data sources like a web page or a data market. Imagine that those users can cleanse the data by themselves, manage calculations, and refresh the data through a tool they are already familiar with. Imagine that they also can build nice and crisp interactive reports (tables, charts maps) by just a few mouse clicks or by natural language.

SessionID: 26128

Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools

Back to calendar

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

Speaker: Thomas Grohser

Title: Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools

Abstract:

Join Thomas in an almost Powerpoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate it into multiple database projects with a few mouse clicks.

He will also share Tips and Tricks for using Visual Studio more effective.

SessionID: 35926

Getting Started with MDX

Back to calendar

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

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

SessionID: 13746

Troubleshoot SQL Server Performance Issues using Wait Statistics

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 6

Speaker: Edwin M Sarmiento

Title: Troubleshoot SQL Server Performance Issues using Wait Statistics

Abstract:

Have you ever scratched your head trying to figure out what is causing performance issues in your SQL Server databases? In this session, we will look at uncovering your SQL Server’s performance issues by learning about wait statistics. We will look at SQL Server wait statistics and how we can troubleshoot performance problems using this methodology – from finding the root cause to resolving the issues.

SessionID: 13861

(a Few of) My Favorite DMVs

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 7

Speaker: Edward Pollack

Title: (a Few of) My Favorite DMVs

Abstract:

Dynamic Management Views are a beautiful gift from Microsoft. With them you can gather immense amounts of information about your SQL environment, optimize performance issues, and solve problems you didn't even know you had!

We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.

SessionID: 14203

Much Ado About Hadoop

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 5

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

SessionID: 14547

SQL Server AlwaysOn Availability Groups

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 2

Speaker: George Walters

Title: SQL Server AlwaysOn Availability Groups

Abstract:

Need HA and DR? Tired of Mirroring or Log Shipping restrictions? Reporting queries slowing down your production system? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.

SessionID: 17014

Basic Database Design

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 1

Speaker: John Miner

Title: Basic Database Design

Abstract:

Abstract:

 You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice. 
 This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up. 


 Topics are focused on data storage structures, security, and integrity. 
 After this presentation, will be ready to meet that clients need.

Coverage: 1 - Files File Groups 2 - Logins Users 3 - Security using schemas 4 - Database roles for access. 5 - Table design via SSMS or TSQL. 6 - Default, Check, and NULL constraints 7 - Handling table relationships (PK vs FK). 8 - To index or not to index? 9 - Testing database integrity using DML.

SessionID: 19690

Boosting DWH-Performance with SQL Server 2014

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 2

Speaker: Markus Ehrenmueller-Jensen

Title: Boosting DWH-Performance with SQL Server 2014

Abstract:

SQL Server 2014 is all about in-memory. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: columnar storage, in-memory tables and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.

SessionID: 35625

The Quest for the Golden Record: MDM Best Practices

Back to calendar

Event Date: 16-05-2015 - Session time: 13:30:00 - Track: Track 4

Speaker: Brian Benzel

Title: The Quest for the Golden Record: MDM Best Practices

Abstract:

In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.

SessionID: 11681

Rethink Your ETL with BIML

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 4

Speaker: Chris Schmidt

Title: Rethink Your ETL with BIML

Abstract:

It's estimated that 70% of data warehousing development is in ETL (extract, transformation, and load) between the different source systems, your data warehouse, and/or your data mart. Recently a new tool has entered the marked that promised to revolutionize the way we think about ETL processes. Gone are the days where we need to manually code every component, every event handler, and painstakingly ensure that every package adheres to corporate standards. In this session, Chris will introduce you to the world of BIML and how it can change your world. We'll show you how to quickly create a template in BIML that will make sure all of your packages adhere to corporate standards, and then use metadata to quickly generate dozens of packages to populate your dimensions and facts. Stop spending weeks developing SSIS packages that can be built in hours! You won't want to miss this session!

SessionID: 12603

Right-Sizing Your SQL Server Virtual Machine

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 6

Speaker: David Klee

Title: Right-Sizing Your SQL Server Virtual Machine

Abstract:

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

SessionID: 13334

The usual SUSPECTs: When good databases go bad.

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 3

Speaker: David Maxwell

Title: The usual SUSPECTs: When good databases go bad.

Abstract:

You just restarted SQL Server, but some of your databases aren't coming online. Maybe

you see a database marked SUSPECT, or RECOVERY PENDING. What do you do? In this session we'll cover the various states that a database can be in, how they get into those states, and learn the proper techniques to bring your data safely back online.

SessionID: 15621

What exactly is big data and why should I care?

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 7

Speaker: James Serra

Title: What exactly is big data and why should I care?

Abstract:

You may understand what a data warehouse is, but what is big data? And why should I care about it? How will it help me? I’ll talk about the things to look at to understand if you have big data, and cover those buzz words you may have heard but don’t know what they mean (data scientist, Hadoop, Internet of Things, data lake, modern data warehouse). I’ll also give examples of how big data is making companies make better business decisions.

SessionID: 18081

Transactional Replication: Architecture, Setup, and Monitoring

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 5

Speaker: Kendal Van Dyke

Title: Transactional Replication: Architecture, Setup, and Monitoring

Abstract:

At some point in every DBA's career they'll be probably be asked to work with transactional replication. While it may seem scary at first, it's not that complicated once you understand how all the parts and pieces work together. In this session we'll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly.

Session Goals: • Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles. • Learn how to configure a working replication topology • Learn how to how to monitor transactional replication performance

SessionID: 18448

Introduction to Window Functions

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 2

Speaker: Kathi Kellenberger

Title: Introduction to Window Functions

Abstract:

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to 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: 19846

Getting started with SSIS

Back to calendar

Event Date: 16-05-2015 - Session time: 14:45:00 - Track: Track 1

Speaker: Matt Nelson

Title: Getting started with SSIS

Abstract:

Integration services is a powerful tool for visualizing and handling most of your SQL Server ETL needs. But Business Intelligence Development Studio (BIDS) can be a confusing tool the first time that you start the application. There's a LOT going on, and for the first time developer, it's not very clear how to get started. This session will help get you on your feet developing SSIS packages. We will look at some common scenarios and live demo creating your first SSIS packages to copy data from one server to another, extract data to a flat file, and learn how to solve some common errors. Feel free to bring your questions on getting started with BIDS.

SessionID: 12604

The Many Paths of Consulting

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 6

Speaker: David Klee

Title: The Many Paths of Consulting

Abstract:

People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.

This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.

SessionID: 13333

DBA 911 - Database Corruption

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 3

Speaker: David Maxwell

Title: DBA 911 - Database Corruption

Abstract:

SessionID: 13864

Query Optimization Crash Course

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 1

Speaker: Edward Pollack

Title: Query Optimization Crash Course

Abstract:

Do you have users complaining that applications are running "too slow"? Do your DB traces look like a short story written by monkeys at typewriters?

This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!

SessionID: 15620

How does Microsoft solve Big Data?

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 7

Speaker: James Serra

Title: How does Microsoft solve Big Data?

Abstract:

So you got a handle on what Big Data is and how you can use it to find business value in your data. Now you need an understanding of the Microsoft products that can be used to create a Big Data solution. Microsoft has many pieces of the puzzle and in this presentation I will show how they fit together. How does Microsoft enhance and add value to Big Data? From collecting data, transforming it, storing it, to visualizing it, I will show you Microsoft’s solutions for every step of the way.

SessionID: 18082

Transactional Replication: Tuning and Troubleshooting

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 5

Speaker: Kendal Van Dyke

Title: Transactional Replication: Tuning and Troubleshooting

Abstract:

At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.

Session Goals: • Learn how to baseline performance metrics by gleaning information from the distribution database • Show how to tune replication agent performance with agent profiles • Demonstrate advanced troubleshooting techniques to apply when problems occur

SessionID: 18449

T-SQL Window Function Performance

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 2

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

SessionID: 19847

Building dynamic SSIS packages for more flexibility

Back to calendar

Event Date: 16-05-2015 - Session time: 16:00:00 - Track: Track 4

Speaker: Matt Nelson

Title: Building dynamic SSIS packages for more flexibility

Abstract:

After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today's date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.