sqlsathistory

Nr: 379

SQLSaturday #379 - South Florida 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Jeffrey Garbus	DBA track	Indexing for performance
00:00:00	Jeffrey Garbus	DBA track	How to be a GREAT DBA
00:00:00	Kathi Kellenberger	DBA track	PRECON - SQL Server High Availability
00:00:00	Devin Knight	BI track	Building Solutions for Power BI QA
00:00:00	Maximo Trinidad	Azure	Powershell Working with Windows Azure SQL Database Server
00:00:00	Michael Antonovich	BI track	Once Upon a DateTime
00:00:00	Kenneth Urena	DBA track	Indexing strategies and good physical designs for performance tuning
09:15:00	Jorge Novo	BI track	Dynamic SSIS Frameworks for complex file Structures
09:15:00	Jeffrey Garbus	DEV track	Bad, less Bad, not Bad; rewriting bad SQL Code
09:15:00	Kathi Kellenberger	DEV track	Writing Better T-SQL Queries with Window Functions
09:15:00	Devin Knight	BI track	Creating an End to End Power View Reporting Solution
09:15:00	Joe Homnick	SQL Security	SQL Server and Windows 10: Data Security and Compliance
09:15:00	Richie Rump	DEV track	The Quest to Find Bad Data With Data Profiling
09:15:00	Richie Rump	BI track	Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers
09:15:00	Pam Shaw	BI track	Taking the Scary out of Monster Reports
09:15:00	Adriano da Silva	Azure	An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.
09:15:00	Alex Roque	DEV track	SQL Design and Retrieval for Analysts and Testers using SQL Server 2014
09:15:00	David Crook	Azure	SQL Azure + Azure Machine Learning to predict Home Values - HOL
10:45:00	Dustin Ryan	BI track	Reporting on Your Cube with SSRS
10:45:00	Herve Roggero	Big Data	NO-SQL For the DBA
10:45:00	Jeffrey Garbus	DBA track	Indexing for Join Optimization
10:45:00	James McAuliffe	DBA track	Changing Data Is Easy, Managing Data Change is Hard!
10:45:00	Kenneth Urena	DBA track	Partitioning and Partial Databases for HA for VLDB
10:45:00	Jason Carter	DBA track	Encryption 101: A look at SQL Encryption Options
10:45:00	Paco Gonzalez	Azure	Tone Analysis with HDInsight and Azure Machine Learning
10:45:00	Eric Soto	DBA track	Easier schema migrations, data migrations more w/ Redgate tools
10:45:00	Perry Patterson	BI track	But I Want it in Excel...
10:45:00	Luis Figueroa	BI track	R intro for the SQL Server Pro
10:45:00	David Cobb	DBA track	What's new in SQL 2016?
12:30:00	Russ Reinbold	Lunch Session	SELECT * FROM CorpDB1 WHERE (value_data lt;gt; 0)
12:30:00	Mark Scott	Lunch Session	Learn about Governed Data Discovery with Pyramid Analytics
12:30:00	Brett Johnson	Lunch Session	SQL Server and Microsoft Business Solutions - Tegile
13:30:00	Jorge Besada	DBA track	PowerShell and Python - The Clash - Part Deux
13:30:00	Jen Underwood	BI track	Introducing the Reimagined Power BI Platform
13:30:00	Devin Knight	BI track	Getting Started with Power Query
13:30:00	Michael Antonovich	BI track	Calculated Columns, Measures, and KPIs, Oh My!
13:30:00	Mitchell Pearson	BI track	Process SSAS Cubes with SSIS
13:30:00	Wes Springob	BI track	Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
13:30:00	Kenneth Urena	DBA track	Configuring AlwaysON availability groups with Readable Secundaries
13:30:00	Jason Virtue	Azure	Azure Data Services – Real-time Analytics
13:30:00	Adriano da Silva	Azure	Introduction to Hive with Microsoft Azure HDInsight
13:30:00	Kendal Van Dyke	DBA track	Mastering Plan Guides: Tell The Query Optimizer You're The Boss
13:30:00	Kendal Van Dyke	DEV track	Do You Have A Case Of Mistaken IDENTITY?
15:00:00	Jorge Novo	BI track	Reusable ssis development using Parent - Child methodology
15:00:00	Maximo Trinidad	DEV track	PowerShell with Visual Studio SQL Data Tools
15:00:00	Jason Carter	DEV track	SSMS: The Untold Secrets
15:00:00	Andy Warren	Professional Development	Turbocharge Your Career With a Learning Plan
15:00:00	Paco Gonzalez	Azure	Big Data Mining with SSAS, Azure Machine Learning Mahout
15:00:00	Pam Shaw	BI track	Tips and Tricks for Dynamic SSRS Reports
15:00:00	Kendal Van Dyke	DBA track	Transactional Replication: Architecture, Setup, and Monitoring
15:00:00	Pankaj Satyaketu	DBA track	SQL Server solutions in Azure
16:30:00	Dustin Ryan	BI track	Welcome to SSAS Tabular Models
16:30:00	Kathi Kellenberger	DEV track	T-SQL Window Function Performance
16:30:00	Michael Corey	DBA track	Database Virtualization and Drinking out of the Fire Hose
16:30:00	miguel Cebollero	BI track	SQL Server 2014 In-Memory Programming
16:30:00	Kenneth Urena	DBA track	SQL Server 2014 In-Memory from evey angle
16:30:00	Sam Abraham	DBA track	An Entity Framework Crash Course for the Busy DBA.
16:30:00	Richie Rump	DEV track	We Don't Need Roads: A Look Into SQL Server Indexes
16:30:00	David Cobb	DBA track	Rolling Database Snapshots
16:30:00	Gareth Swanepoel	DBA track	SQL Server 2014 for the DBA

SessionID: 16349

Indexing for performance

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: DBA track

Speaker: Jeffrey Garbus

Title: Indexing for performance

Abstract:

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 16352

How to be a GREAT DBA

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: DBA track

Speaker: Jeffrey Garbus

Title: How to be a GREAT DBA

Abstract:

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

SessionID: 18450

PRECON - SQL Server High Availability

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: DBA track

Speaker: Kathi Kellenberger

Title: PRECON - SQL Server High Availability

Abstract:

You have many options when it comes to high availability and disaster recovery. Attend this session to learn the benefits of two of the most popular HA features, Clustering and Availability Groups. Learn how to plan, implement, and manage these technologies.

SessionID: 18660

Building Solutions for Power BI QA

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: BI track

Speaker: Devin Knight

Title: Building Solutions for Power BI QA

Abstract:

QA is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of QA from the Power BI site.

SessionID: 19921

Powershell Working with Windows Azure SQL Database Server

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: Azure

Speaker: Maximo Trinidad

Title: Powershell Working with Windows Azure SQL Database Server

Abstract:

SessionID: 20497

Once Upon a DateTime

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: BI track

Speaker: Michael Antonovich

Title: Once Upon a DateTime

Abstract:

Creating calculated measures and columns in DAX is an essential part of any Tabular or PowerPivot model. Since most data represents events that occur over time, a time dimension is critical in those models to reveal data trends. However, perhaps even more important than just using time as a dimension is using DAX time functions to calculate aggregate measures grouped on discrete time periods such as months, quarters, and years, period to date aggregates, and the analysis of parallel periods to compare the past to the present. For most financial analysis of data, the ability to look at data grouped by different time periods is essential in making good business decisions. Come to our monthly meeting to learn how to use the DAX date functions to successfully analyze data over time.

SessionID: 27205

Indexing strategies and good physical designs for performance tuning

Back to calendar

Event Date: 13-06-2015 - Session time: 00:00:00 - Track: DBA track

Speaker: Kenneth Urena

Title: Indexing strategies and good physical designs for performance tuning

Abstract:

Multiple index strategies to help improve database performance, Part of the topics covered in this session are:

Noncluster Coverage
Page Split
Heaps
Filtered Indexes
Clustered Indexes

SessionID: 13991

Dynamic SSIS Frameworks for complex file Structures

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: BI track

Speaker: Jorge Novo

Title: Dynamic SSIS Frameworks for complex file Structures

Abstract:

On this session we are going to deal with real work situations such as the loading and transformation of fixed width files in EBCDIC. Conversion of comp-2 and comp-3 fields using custom ssis components and the creation of metadata to dynamic generate ssis at run time

SessionID: 16351

Bad, less Bad, not Bad; rewriting bad SQL Code

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: DEV track

Speaker: Jeffrey Garbus

Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract:

This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code "bad"

SessionID: 18451

Writing Better T-SQL Queries with Window Functions

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: DEV track

Speaker: Kathi Kellenberger

Title: Writing Better T-SQL Queries with 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 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: 18661

Creating an End to End Power View Reporting Solution

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: BI track

Speaker: Devin Knight

Title: Creating an End to End Power View Reporting Solution

Abstract:

Power View has the capability of creating eye-popping visualizations within SharePoint and Excel 2013. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. Before you can begin building these incredible reports you must have your data properly prepared. This session will give you a beginning to end view of what is needed to create Power View reports from organizing a Power Pivot source to preparing the actual Power View report.

SessionID: 30893

SQL Server and Windows 10: Data Security and Compliance

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: SQL Security

Speaker: Joe Homnick

Title: SQL Server and Windows 10: Data Security and Compliance

Abstract:

Join Joe as he leverages his 30 years as a CPA and Information Systems Architect to show how SQL Server 2014 delivers the most secure database among leading database vendors. SQL Server solutions provide everything you need to adhere to security and compliance policies—out of the box. This includes the most up to date encryption technologies built on Trustworthy Computing initiatives. Versions 2014, 2016 and Azure will be investigated along with the soon to be released Windows 10 as the most secure client for SQL Server.

SessionID: 35728

The Quest to Find Bad Data With Data Profiling

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: DEV track

Speaker: Richie Rump

Title: The Quest to Find Bad Data With Data Profiling

Abstract:

The legendary adventurer is on the quest of a lifetime. He's found a database that holds the locations of the world's greatest relics, but there's a problem. No, it's not snakes. The database was written using an ancient format and it may hold incorrect data. Our data archaeologist must find a way move the correct data into SQL Server or risk losing our most important treasures, forever. Luckily, he has an powerful tool, data profiling.

#160; Data profiling is a way that you can identify bad data, measure inaccurate data, and know for sure that your queries are right. There are many different ways our adventurer can use data profiling. This session will show you what data profiling is and how it can help lead you to fortune and glory.

SessionID: 35730

Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: BI track

Speaker: Richie Rump

Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Abstract:

Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework.

Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.

SessionID: 36283

Taking the Scary out of Monster Reports

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: BI track

Speaker: Pam Shaw

Title: Taking the Scary out of Monster Reports

Abstract:

So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.

SessionID: 36754

An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: Azure

Speaker: Adriano da Silva

Title: An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.

Abstract:

This presentation provides a high level overview of basic Big Data and Hadoop fundamentals and concepts. It is an ideal opportunity for those considering or learning Hadoop to see Big Data in Action with examples using Microsoft Azure HDInsight, which is a 100% Apache Hadoop-based service in the cloud provided by Microsoft. We will also cover Big Data exploration and data visualization demonstrations using Microsoft products; such as PowerQuery for Excel.

SessionID: 36851

SQL Design and Retrieval for Analysts and Testers using SQL Server 2014

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: DEV track

Speaker: Alex Roque

Title: SQL Design and Retrieval for Analysts and Testers using SQL Server 2014

Abstract:

This session will provide an introductory overview of the relational model for Business Analyst and Quality Assurance Analysts and other IT specialists who would like to become proficient. We will be using SQL Server 2014 and a sample database to understand how to create, design, query and modify data using SQL.

The session will cover:

Understanding the fundamentals of a relational database
Review of SQL Server and its components
An In-depth dive into Transact SQL -The Principles of database design.

Come have some fun and learn how to work with SQL Server and it's relational data.

SessionID: 38059

SQL Azure + Azure Machine Learning to predict Home Values - HOL

Back to calendar

Event Date: 13-06-2015 - Session time: 09:15:00 - Track: Azure

Speaker: David Crook

Title: SQL Azure + Azure Machine Learning to predict Home Values - HOL

Abstract:

During this hands on lab we will connect an Azure Machine Learning experiment to a SQL Azure instance, import the data, train two machine learning models, compare the two and publish a production model as a web service. There will also be an overview of how the data was obtained.

The data is data from Zillow using F# and Azure Cloud Services, we will be predicting the value of homes based on the data collected.

SessionID: 13504

Reporting on Your Cube with SSRS

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: BI track

Speaker: Dustin Ryan

Title: Reporting on Your Cube with SSRS

Abstract:

In this session Dustin will give you an introduction to reporting on a cube with SQL Server Reporting Services (SSRS). You’ll learn about some of the advantages of using your cube as a source for your SSRS reports, how to build reports based on your cube with minimal knowledge of MDX, as well as a few tricks you can use to increase the usability of your reports.

SessionID: 15025

NO-SQL For the DBA

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: Big Data

Speaker: Herve Roggero

Title: NO-SQL For the DBA

Abstract:

In this session I will make a high level introduction of NO-SQL databases from the viewpoint of a Database Administrator. We will review some of the key benefits and challenges of the no-sql database concepts and understand how DBAs will become more involved in the day to day operations of such databases. While no-sql databases are designed for developers, important operations will fall in the hands of DBAs over time. We will look primarily at the Azure Table no-sql data store, and quickly tour other storage engines to understand how they differ such as DocumentDB, CoucheBase and more.

SessionID: 16350

Indexing for Join Optimization

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: DBA track

Speaker: Jeffrey Garbus

Title: Indexing for Join Optimization

Abstract:

Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.

SessionID: 16996

Changing Data Is Easy, Managing Data Change is Hard!

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: DBA track

Speaker: James McAuliffe

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract:

Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

SessionID: 27207

Partitioning and Partial Databases for HA for VLDB

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: DBA track

Speaker: Kenneth Urena

Title: Partitioning and Partial Databases for HA for VLDB

Abstract:

How partitioning + Partial databases on SQL server enterprise can help me to increase my HA environment.

SessionID: 35989

Encryption 101: A look at SQL Encryption Options

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: DBA track

Speaker: Jason Carter

Title: Encryption 101: A look at SQL Encryption Options

Abstract:

Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.

SessionID: 36236

Tone Analysis with HDInsight and Azure Machine Learning

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: Azure

Speaker: Paco Gonzalez

Title: Tone Analysis with HDInsight and Azure Machine Learning

Abstract:

SessionID: 36501

Easier schema migrations, data migrations more w/ Redgate tools

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: DBA track

Speaker: Eric Soto

Title: Easier schema migrations, data migrations more w/ Redgate tools

Abstract:

Managing data models and data for existing applications can be cumbersome and fraught with pitfalls. Many developers and DBAs rely on "change" scripts they produce manually whenever they need to deploy changes or updates. Though this might work well for small and infrequent changes, it's much harder to pull off with large teams, complex applications or applications that change all the time. In the world of software, we rely on source control and code-differencing tools. However, these tools are much less common when it comes to database schemas and data in databases. Enter RedGate tools: SQL Compare, SQL Data Compare and others. These tools allow the DBA to quickly "compare" databases (even data) and quickly generate "change scripts" that can be used to roll out changes and/or audit databases. In this session, we explore these tools and how I've integrated them in my workflow when supporting business applications. [Note I do not work for Redgate and this is not a vendor session.]

SessionID: 36761

But I Want it in Excel...

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: BI track

Speaker: Perry Patterson

Title: But I Want it in Excel...

Abstract:

As IT professionals we can create reports from SQL using Business Objects, Crystal Reports or other popular tools. How many times have we created something fantastic only to hear the CEO or CFO say "That's great... but I want it in Excel". Ugh!

Don't do the export-import thing! Learn some basic techniques to interact directly with SQL to create beautiful Pivot Tables and Graphs, right from Excel. You can even ensure the CxO will always have fresh data and eliminate sync issues with your other reports.

SessionID: 37177

R intro for the SQL Server Pro

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: BI track

Speaker: Luis Figueroa

Title: R intro for the SQL Server Pro

Abstract:

So you’ve heard all the buzz about R and you are ready to start the learning journey but where do you start? in this session, Luis will discuss some industry trends and provide an overview of what R is, how to acquire, manipulate and plot simple data sets, how you can leverage your existing data skills and a number of learning resources that will help you succeed in your jouRney.

SessionID: 37860

What's new in SQL 2016?

Back to calendar

Event Date: 13-06-2015 - Session time: 10:45:00 - Track: DBA track

Speaker: David Cobb

Title: What's new in SQL 2016?

Abstract:

Will cover the main new features (with as many demos as practical) including:

*ColumnStore improvements *In-Memory OLTP Improvements *Live Query Statistics *Query Store *Temporal Tables *Always Encrypted *Stretch Database *Row Level Security *Dynamic Data Masking

SessionID: 37998

SELECT * FROM CorpDB1 WHERE (value_data lt;gt; 0)

Back to calendar

Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Lunch Session

Speaker: Russ Reinbold

Title: SELECT * FROM CorpDB1 WHERE (value_data lt;gt; 0)

Abstract:

Data has value...BUT, what is the value of your data? Explore the value of data in varied Enterprise situations. Will demonstrate tool for single table restore without the need to restore entire DB, and tool for query within table/DB without any dependency on SQL.

DOOR PRIZE - We'll draw for 2TB Passport drive from session attendees.

Attendees will get free copy of Single Table Restore software and have opportunity to provide input into future product.

SessionID: 38024

Learn about Governed Data Discovery with Pyramid Analytics

Back to calendar

Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Lunch Session

Speaker: Mark Scott

Title: Learn about Governed Data Discovery with Pyramid Analytics

Abstract:

Mark will show you how you can Supercharge your Microsoft BI with Pyramid Analytics “BI Office”. See how BI Office gives you the “freedom to” Scale, Maximize, Visualize, and Mobilize your business users with the new Version 5.

Attendees will learn about "Governed Data Discovery" and what that really means. Additionally - attendees will see how to build a SQL Server TABULAR MODEL on the fly - using our Mashup technology! We will then take that tabular model, build some reports, and share with users!

SessionID: 38046

SQL Server and Microsoft Business Solutions - Tegile

Back to calendar

Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Lunch Session

Speaker: Brett Johnson

Title: SQL Server and Microsoft Business Solutions - Tegile

Abstract:

Tegile Intelligent Flash Storage Arrays simplify the storage and management of SQL Server Business Intelligence and OLTP information. Whether you need a hybrid or an all-flash storage array, Tegile offers a comprehensive portfolio of flash storage solutions that deliver sustained performance, resilience and economics to fit most budgets and requirements. Compromise nothing when it comes to storing, accessing and protecting your business critical information.

SessionID: 16037

PowerShell and Python - The Clash - Part Deux

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: DBA track

Speaker: Jorge Besada

Title: PowerShell and Python - The Clash - Part Deux

Abstract:

Comparison of one application done with both technologies

SessionID: 16576

Introducing the Reimagined Power BI Platform

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: BI track

Speaker: Jen Underwood

Title: Introducing the Reimagined Power BI Platform

Abstract:

You have seen glimpses of the new Power BI offering at WPC and PASS in 2014. Microsoft has totally reimagined the Power BI platform, user experience, added developer APIs, custom apps, hybrid direct connectivity to on-premise data sources without data copying and other top secret enhancements that we can dive into by the time of this session. Join me to explore all these great changes for both BI professionals and Power BI users.

SessionID: 18659

Getting Started with Power Query

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: BI track

Speaker: Devin Knight

Title: Getting Started with Power Query

Abstract:

Power Query is a free add-in for Excel 2010 and up that provide users an easy way to discover, combine and refine data all within the familiar Excel interface. With Power Query you can now combine and transform data from a variety of unusual data sources all within Excel, which would have previously required a complex ETL job. Join Devin and learn how you can use Power Query to take your Self-Service BI solutions to the next level.

SessionID: 20498

Calculated Columns, Measures, and KPIs, Oh My!

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: BI track

Speaker: Michael Antonovich

Title: Calculated Columns, Measures, and KPIs, Oh My!

Abstract:

To do serious work in a Power Pivot table or even a SQL Analytics Cube, you must know the difference between calculated columns, measures, and KPIs, how to define them, use them, and display them. This session will take you step by step through the creation of each of these components of a typical pivot table or cube showing you how to define the necessary expressions and then how they are displayed in tables and charts that transform mere data into meaningful managerial information. To keep examples simple enough for all attendees to go back and try on their own, Excel Power Pivot Tables will be used, but the same techniques apply almost without change to SSAS cubes.

SessionID: 21012

Process SSAS Cubes with SSIS

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: BI track

Speaker: Mitchell Pearson

Title: Process SSAS Cubes with SSIS

Abstract:

So you have used SSIS for years to do all your ETL and loading of your data warehouse, but did you know you could also handle all your cube processing inside of SSIS? In this session Mitchell will introduce you to four little know tasks in SSIS that will help to automate the processing of your cube.

SessionID: 24811

Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: BI track

Speaker: Wes Springob

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract:

As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

SessionID: 27208

Configuring AlwaysON availability groups with Readable Secundaries

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: DBA track

Speaker: Kenneth Urena

Title: Configuring AlwaysON availability groups with Readable Secundaries

Abstract:

In this session we are going to see how to configure always on Availability groups with readable secondaries and the necessaries changes to make in the application side.

SessionID: 27467

Azure Data Services – Real-time Analytics

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Azure

Speaker: Jason Virtue

Title: Azure Data Services – Real-time Analytics

Abstract:

SessionID: 36755

Introduction to Hive with Microsoft Azure HDInsight

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Azure

Speaker: Adriano da Silva

Title: Introduction to Hive with Microsoft Azure HDInsight

Abstract:

This presentation introduces functional and technical professionals to the purpose, need and use of Apache Hive and HiveQL. The audience is exposed to the Apache Hive data warehouse software and the Hive QL Language which is a SQL-like language used in the management, query, summarization and analysis of large datasets residing in distributed storage; such as the Azure Blob Storage and Hadoop Distributed File System. The presentation includes principles, concepts and architecture of Hive; in addition to the syntax and use the HiveQL language illustrated in practical examples showing the use of HiveQL as it interfaces with data residing in an Azure Blob Storage.

SessionID: 36854

Mastering Plan Guides: Tell The Query Optimizer You're The Boss

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: DBA track

Speaker: Kendal Van Dyke

Title: Mastering Plan Guides: Tell The Query Optimizer You're The Boss

Abstract:

It's Monday morning and everyone is complaining that the database is slow. You see the problem - even though indexes aren't fragmented and statistics are up to date the query optimizer is choosing a bad plan. Users want it fixed (now!) and you know a way to get things working again but you're not allowed to change code because...it's production. What's a good DBA going to do? Show the query optimizer that you're the boss with plan guides! In this session you'll learn what plan guide are, how they work, and when to (and not to) use them to make under-performing queries behave.

SessionID: 36855

Do You Have A Case Of Mistaken IDENTITY?

Back to calendar

Event Date: 13-06-2015 - Session time: 13:30:00 - Track: DEV track

Speaker: Kendal Van Dyke

Title: Do You Have A Case Of Mistaken IDENTITY?

Abstract:

When creating a table most people use an identity value as the primary key without a second thought. We also take for granted than returning the identity value when a row is inserted "just works"...but it's not as straightforward as it seems - you might have a case of mistaken identity! In this session we'll look at several ways to return identity values, compare identity values with sequences, demonstrate how you can end up with unexpected identity values, and learn how to make sure you've got the right ones every time.

SessionID: 13994

Reusable ssis development using Parent - Child methodology

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: BI track

Speaker: Jorge Novo

Title: Reusable ssis development using Parent - Child methodology

Abstract:

On this session we are going to cover the creation of independent packages and how to create a package controller using package configuration features to create a parent - child work flow. what would be cover: Creation of ssis package controllers, How to used package configuration features Passing parameters from a parent package to a child package

SessionID: 19922

PowerShell with Visual Studio SQL Data Tools

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: DEV track

Speaker: Maximo Trinidad

Title: PowerShell with Visual Studio SQL Data Tools

Abstract:

This session will show the integration and use of PowerShell Tools for Visual Studio with SQL Data tools. Also demostrate how

the use of a PowerShell script in SSIS "Script Task" component as part on a ETL flow. Covering some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell.

SessionID: 35990

SSMS: The Untold Secrets

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: DEV track

Speaker: Jason Carter

Title: SSMS: The Untold Secrets

Abstract:

You spend all day working with SQL Server Management Studio (SSMS) but are you deriving maximum value out of it? In this session we will review some of the more useful functionality of SSMS including Templates, Registered Servers, Regular Expressions and various other settings you didn't know you want.

SessionID: 36052

Turbocharge Your Career With a Learning Plan

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: Professional Development

Speaker: Andy Warren

Title: Turbocharge Your Career With a Learning Plan

Abstract:

What will you learn next quarter and why? How will you learn it? How much time and money will it cost? What is the ROI on learning those skills? Those are the questions that you answer by building a learning plan and, if you do it well, you’ll find yourself steadily pulling away from your peers.

It starts with a learning list, a place to capture skills you think you need to learn. That’s where you score each topic by estimating the effort to learn it in time and money and the value it adds to your career now and later. It’s absolutely an analog process, but it gives you the framework for answering one question: what do I learn next and why?

Once you’ve picked a topic, how do you learn more about it? Do you read blogs, buy books, or attend a class? Or all of the above? How much time makes sense? Join this session and learn how to dig into the topic to answer the questions that lead to a learning plan. After that, it’s just a matter of executing the plan!

SessionID: 36235

Big Data Mining with SSAS, Azure Machine Learning Mahout

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: Azure

Speaker: Paco Gonzalez

Title: Big Data Mining with SSAS, Azure Machine Learning Mahout

Abstract:

Join this session to learn about traditional data mining with the power of Mahout in Hadoop and Azure Machine Learning.

Mahout is a machine learning library, supported in HDinsight. HDInsight is the Microsoft service that brings Apache Hadoop to the cloud, and Mahout is a powerful tool for processing models within HDFS and MapReduce. This session will cover how data mining is implemented in the context of big data and the cloud. This session will cover the full data mining cycle: ETL,building, testing, and training data models to visualization, testing, and real-time querying. You will see how to discover patterns and make predictions, classifications, and recommendations to get all the insights from your structured and non-structured big data.

SessionID: 36284

Tips and Tricks for Dynamic SSRS Reports

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: BI track

Speaker: Pam Shaw

Title: Tips and Tricks for Dynamic SSRS Reports

Abstract:

In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users.

~ This will include defining formats based on the data contents. ~ We will explore how to refine layouts based on the data to be delivered. ~ We will demonstrate how to create a parameter driven data source. ~ We will take a look at how creating templates can give your catalog of reports a more professional look.

All of this together will empower you to have more control over the reports you create.

SessionID: 36852

Transactional Replication: Architecture, Setup, and Monitoring

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: DBA track

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. You'll return to work with the confidence and know-how that you need to set up and manage a transactional replication topology.

SessionID: 37806

SQL Server solutions in Azure

Back to calendar

Event Date: 13-06-2015 - Session time: 15:00:00 - Track: DBA track

Speaker: Pankaj Satyaketu

Title: SQL Server solutions in Azure

Abstract:

In this session we will be looking at the continuum of SQL Server solutions running in Azure, Microsoft's public cloud. We will take a look at running SQL Server on virtual machines in Azure via our Infrastructure as a Service solution and SQL Database our Platform as a Service solution. Come learn the differences between both and also gain some insight into some of the preview feature capabilities of SQL Database.

SessionID: 13505

Welcome to SSAS Tabular Models

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: BI track

Speaker: Dustin Ryan

Title: Welcome to SSAS Tabular Models

Abstract:

Knowing how to build a Tabular model is one thing. Knowing how to build a Tabular model the right way is something completely different. In this session we’ll discuss how to decide if building a Tabular model is the right choice, how to build a Tabular model completely from scratch, best practices you should follow, and things to avoid. If you’re new to Tabular Modeling or wanting to learn best practices, this session is for you!

SessionID: 18452

T-SQL Window Function Performance

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DEV track

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

Database Virtualization and Drinking out of the Fire Hose

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DBA track

Speaker: Michael Corey

Title: Database Virtualization and Drinking out of the Fire Hose

Abstract:

A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.

SessionID: 20421

SQL Server 2014 In-Memory Programming

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: BI track

Speaker: miguel Cebollero

Title: SQL Server 2014 In-Memory Programming

Abstract:

SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.

SessionID: 27206

SQL Server 2014 In-Memory from evey angle

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DBA track

Speaker: Kenneth Urena

Title: SQL Server 2014 In-Memory from evey angle

Abstract:

we are going to start with the basics about how to create tables, Stored procedures and objects in general. also the new features of delay_durability in conjunction with Inmemory OLTP.

From the point of view of the developer , which advantages and disadvantages it has , besides the different constraints presented . From the point of view of the DBA , which advantages and disadvantages it has, besides the changes necessary for the administration. From the point of view of Architect occasions where I can be helpful in improving my performance OLTP

SessionID: 28170

An Entity Framework Crash Course for the Busy DBA.

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DBA track

Speaker: Sam Abraham

Title: An Entity Framework Crash Course for the Busy DBA.

Abstract:

The Entity Framework enables developers to work with data in the form of domain-specific objects and properties, without having to concern themselves with the underlying database tables and columns where this data is stored. With such great power comes great frustration; Namely our Database Administrators' as they trace through and attempt to optimize the Entity Framework auto-generated SQL statements hitting our databases.

This talk aims to empower the DBA with an understanding of the architecture behind the Entity Framework and the most common pitfalls programmers fall for when attempting to rapidly write data access layer code using the Entity Framework and what can be done to overcome them.

SessionID: 35729

We Don't Need Roads: A Look Into SQL Server Indexes

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DEV track

Speaker: Richie Rump

Title: We Don't Need Roads: A Look Into SQL Server Indexes

Abstract:

Have you ever ran a SQL against SQL Server and it was so slow that you wondered if the database was from 1955? You could use a Delorean or you can create indexes in your database. This session will introduce you to SQL Server indexes. Indexes are a powerful tool to improve the performance of our queries. We'll discuss how indexes are structured and why they speed up queries, how INSERT, UPDATE, and DELETE queries are affected by indexes and how to identify if an index is necessary. Then, we'll take a look at an Entity Framework application and see how EF reacts to our fresh new indexes. If you want to make bad query performance a thing of the past this session is for you.

SessionID: 36496

Rolling Database Snapshots

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DBA track

Speaker: David Cobb

Title: Rolling Database Snapshots

Abstract:

You want a recent version of your database to move reporting workload off production, using SQL 2005-2008R2 Enterprise but not yet using SQL 2012/2014? Consider rolling database snapshots. This approach works with or without database mirroring, to continuously provide a recent version of your database to support read-only and reporting workloads. This solution will be compared to other alternatives, a working demo presented, with shared source code.

SessionID: 36636

SQL Server 2014 for the DBA

Back to calendar

Event Date: 13-06-2015 - Session time: 16:30:00 - Track: DBA track

Speaker: Gareth Swanepoel

Title: SQL Server 2014 for the DBA

Abstract:

SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements.

The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals.

This site is open source. Improve this page.