sqlsathistory

Nr: 588

Back to Main list

SQLSaturday #588 - New York City 2017

Start Time (24h)	Speaker	Track	Title
09:15:00	Karlyn LeBlanc	Professional Development	Whip Away Stress at Home Work to Create a Better You
09:15:00	Patrick LeBlanc	Analytics and Visualization	Power BI: Customer Stories from the Frontline
09:15:00	Chris Seferlis	BI Platform Architecture, Development Administration	Digging Deeper: BI Methodologies and Best Practices
09:15:00	Thomas Grohser	BI Platform Architecture, Development Administration	Advanced Security: Protecting Data from the DBA
09:15:00	Drew Furgiuele	Enterprise Database Administration Deployment	SQL Server Transactional Replication: A Deep Dive
09:15:00	David Dye	BI Platform Architecture, Development Administration	Advanced SSIS Techniques
09:15:00	Aaron Nelson	Enterprise Database Administration Deployment	Do Awesome Things with PowerShell in 5 minutes or Less
09:15:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
09:15:00	Ned Otter	Enterprise Database Administration Deployment	Real world SQL 2016 In-Memory OLTP
09:15:00	Paul Rizza	BI Platform Architecture, Development Administration	New Features in SSIS 2016
09:15:00	Erik Svensen	BI Information Delivery	Power Query - Don't be afraid of the advanced editor
09:15:00	Allan Hirt	Enterprise Database Administration Deployment	A Closer Look at Distributed Availability Groups
09:15:00	David Klee	Enterprise Database Administration Deployment	SQL Server Administration on Linux
10:35:00	Stephen Mokszycki	Enterprise Database Administration Deployment	Outsourcing database administration to your users.
10:35:00	Slava Murygin	Enterprise Database Administration Deployment	Connection to SQL Server. Problems. Troubleshooting. Solutions.
10:35:00	Ryan Wade	Analytics and Visualization	R-ternatives in Power BI
10:35:00	Jean Joseph	Enterprise Database Administration Deployment	HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES
10:35:00	Andy Leonard	BI Platform Architecture, Development Administration	Using Biml as an SSIS Design Patterns Engine
10:35:00	Wylie Blanchard	BI Platform Architecture, Development Administration	SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI
10:35:00	Janis Griffin	Enterprise Database Administration Deployment	Welcome To the 2016 Query Store!
10:35:00	Timothy McAliley	Cloud Application Development Deployment	Azure Analysis Services - An introduction
10:35:00	Tim Gorman	Enterprise Database Administration Deployment	Accelerating DevOps and TDM Using Data Virtualization
10:35:00	David Klee	Strategy and Architecture	SQL Server Infrastructure – Cloud and On-Prem Options
10:35:00	Robert Pearl	Enterprise Database Administration Deployment	SQL Licensing True-up
10:35:00	Bob Ward	Enterprise Database Administration Deployment	Inside SQL Server In-Memory OLTP
10:35:00	Thomas Grohser	Professional Development	Why candidates fail the job interview in the first minute
12:00:00	David Bermingham	Enterprise Database Administration Deployment	SANLess clustering for physical, virtual and cloud environments
12:00:00	Charles Chiambalero	Strategy and Architecture	No inside, No outside, No box. DellEMC software defined storage s
13:05:00	Steve Simon	BI Information Delivery	SQL Server 2016: A dive into Data Quality Services
13:05:00	Kevin Feasel	Analytics and Visualization	R For the SQL Server Developer
13:05:00	James Serra	Application Database Development	Relational databases vs Non-relational databases
13:05:00	Derik Hammer	Application Database Development	Query Tuning without Production Data
13:05:00	Denis McDowell	Application Database Development	Stop Ignoring the SQL Server Resource Governor
13:05:00	Bob Ward	Enterprise Database Administration Deployment	SQL Server 2016: It Just Runs Faster
13:05:00	Jonathan Stewart	Analytics and Visualization	From problem to Power BI: A journey in data visualization
13:05:00	Amy Herold	Enterprise Database Administration Deployment	Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
13:05:00	Fabiano Amorim	Application Database Development	Writing T-SQL code like a boss
13:05:00	William Wolf	Application Database Development	Stop Doing That! 5 Common T-SQL Anti-Patterns
13:05:00	Adan Ortiz-Cordova	Advanced Analysis Techniques	Creating Your First Azure Machine Learning Model
13:05:00	Sebastian Meine	Professional Development	The Phenomenal IT Consultant
14:25:00	Greg Moore	Enterprise Database Administration Deployment	Tips that have saved my bacon
14:25:00	Edward Pollack	Application Database Development	Finding Islands, Gaps, and Clusters in Complex Data
14:25:00	Luan Moreno Medeiros Maciel	BI Platform Architecture, Development Administration	Azure SQL Database Vs. Amazon RDS
14:25:00	Alex Grinberg	Application Database Development	SQL Server XML 101
14:25:00	John Miner	Application Database Development	Effective Data Warehouse Storage Patterns
14:25:00	Isabelle Van Campenhoudt	Enterprise Database Administration Deployment	SharePoint 2016 Unbreakable with SQL Server Always On Availability Groups
14:25:00	Grant Fritchey	Strategy and Architecture	Extending DevOps To SQL Server
14:25:00	Chris Bell	Application Database Development	Would You Just Load Already?! Maximizing Your SSIS Data Load
14:25:00	Justin Dearing	Application Database Development	An Introduction to Always Encrypted
14:25:00	Chris Hyde	Analytics and Visualization	SQL Server R Services in SQL 2016
14:25:00	Hilary Cotter	Enterprise Database Administration Deployment	Monitoring SQL Server using Extended Events
14:25:00	Lisa Margerum	Professional Development	Network your Way to Success!
14:25:00	David Bermingham	Enterprise Database Administration Deployment	SQL Server High Availability in Azure IaaS
15:45:00	Steve Simon	BI Information Delivery	SQL Server Reporting Services 2016 on Steroids!!
15:45:00	Matt Gordon	Enterprise Database Administration Deployment	Top 5 Tips to Keep Always On Always Humming and Users Happy
15:45:00	Adam Saxton	BI Platform Architecture, Development Administration	Using a gateway to leverage on-premises data in Power BI
15:45:00	James Serra	BI Platform Architecture, Development Administration	Choosing the right technologies for a big data solution
15:45:00	Azhagappan Arunachalam	Cloud Application Development Deployment	Understanding U-SQL
15:45:00	Luan Moreno Medeiros Maciel	BI Platform Architecture, Development Administration	DBaaS on Azure - SQL Database Best Practices
15:45:00	Andy Mallon	Application Database Development	Demystifying Data Compression
15:45:00	Juan Soto	Professional Development	Wish you could live the glamorous consulting life?
15:45:00	Mike Lawell	Application Database Development	Execution Plans for Mere Mortals
15:45:00	Jake Switzer	Information Delivery	Azure Data Catalog 101
15:45:00	Joseph D'Antoni	Cloud Application Development Deployment	Building Secure Applications in Azure SQL Database
15:45:00	Mark Broadbent	Enterprise Database Administration Deployment	Lockless in Seattle: Using In-Memory OLTP Transaction Processing
15:45:00	Melody Zacharias	BI Platform Architecture, Development Administration	Introduction to Microsoft Analytics – Turning Data into Intelligent Action

SessionID: 54868

Whip Away Stress at Home Work to Create a Better You

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Whip Away Stress at Home Work to Create a Better You

Abstract:

If you are a working professional there is a chance that stress has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

SessionID: 54969

Power BI: Customer Stories from the Frontline

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Patrick LeBlanc

Title: Power BI: Customer Stories from the Frontline

Abstract:

As the popularity of Power BI continues to grow, so does the number of emails and customer calls about issues that they face. Some are easy to solve, and some require a level of research and testing to solve. Join us in this session to learn from some of the top customer issues and trends that we have faced. Explore the problem, and then dive into how we fixed it!

SessionID: 56250

Digging Deeper: BI Methodologies and Best Practices

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Seferlis

Title: Digging Deeper: BI Methodologies and Best Practices

Abstract:

In this session attendees will learn how to make decisions around which technologies to use when delivering BI solutions including some exciting new BI features in SQL 2016. We will explore the starting point of the project with data sources, step through the ETL decision making process and on to picking the medium for best delivery of content, while learning some best practices along the way.

SessionID: 56278

Advanced Security: Protecting Data from the DBA

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Thomas Grohser

Title: Advanced Security: Protecting Data from the DBA

Abstract:

More and more regulated and audited industries have the problem that the DBA's that manage SQL Server can access all the data. While application level encryption can solve the problem for special data like SSN sometimes encryption is not an option (keyword 3rd party application).

This session shows how to manage SQL Server without being a member of the sysadmin server role and how to audit SQL Server in cases where the DBA has to troubleshoot a problem as sysadmin.

SessionID: 56315

SQL Server Transactional Replication: A Deep Dive

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server Transactional Replication: A Deep Dive

Abstract:

Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!

SessionID: 56536

Advanced SSIS Techniques

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Dye

Title: Advanced SSIS Techniques

Abstract:

As an ETL developer using SQL Server Integration Services have you ever wondered how to:

1. Import all .csv files from a folder
2. Replace dynamic SQL using variables in SSIS
3. How to configure the data flow buffer
4. Create custom logging solutions
5. Use a script component as a data flow transformation This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
   Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components. Upon completion of this workshop attendees will be able to:
6. Import/export multiple sources/destinations
7. Use an execute SQL task with variables to replace dynamic SQL within a package
8. Dynamically handle errors within any part of a package

SessionID: 56940

Do Awesome Things with PowerShell in 5 minutes or Less

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Aaron Nelson

Title: Do Awesome Things with PowerShell in 5 minutes or Less

Abstract:

What if you could import 25 million rows of CSV data in less than 2 minutes? Or regain lost sysadmin access to your SQL Server in 20 seconds? Need to check which of your 200 servers has misconfigured max memory, calculate the proper memory and then set it? No problem, couple of minutes, tops.

PowerShell can do amazing things for database administrators. It can automate your complex, onerous tasks. It can also automate the boring yet vital tasks like testing backups, and it can do it faster than you think. Even better, it is easier to learn than you might expect.

Get Better, Faster, Stronger with PowerShell SQL Server.

SessionID: 57293

Crash Course on Better SQL Development

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 57649

Real world SQL 2016 In-Memory OLTP

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ned Otter

Title: Real world SQL 2016 In-Memory OLTP

Abstract:

What is the optimal way to migrate existing data to In-Memory?

How does Garbage Collection work, what types of memory-optimized objects does it work with, and how can I make sure it's operational? What are the pros/cons of different ways of handling hot/cold data with In-Memory OLTP? What causes ALTER TABLE to be fully logged and serially executed? All of these questions and more are answered as we discuss real-world usage of SQL 2016 In-Memory OLTP.

SessionID: 57769

New Features in SSIS 2016

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paul Rizza

Title: New Features in SSIS 2016

Abstract:

This session will present detailed examples of the newest features added or enhanced in SSIS 2016.

Including but not limited to: True template based package design Incremental package deployment Non-Admin logging access Error Handling by Column name (prior versions only gave that cryptic lineage ID number) SSISDB AlwaysOn Availability Group support and many more...

The session will include a limited number of slides followed but demo examples of each new feature which will also be provided for download so attendees while have access to them for reference after the event.

SessionID: 58166

Power Query - Don't be afraid of the advanced editor

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: BI Information Delivery

Speaker: Erik Svensen

Title: Power Query - Don't be afraid of the advanced editor

Abstract:

There is no reason to be afraid of the advanced editor in Power Query - you can do a lot more in here than the user interface exposes.

I will guide you through different examples of hidden functions and variables you can use in your data extraction and transformations using Power Query, and you will learn how to make your queries dynamic and flexible and even include error handling if something you didnt expect happen actually do.

You will leave the session with a good understanding of how powerful the language of Power Query actually is and how you can use it in your toolbelt.

The learnings can be used both in Power BI Desktop and Excel.

SessionID: 61694

A Closer Look at Distributed Availability Groups

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: A Closer Look at Distributed Availability Groups

Abstract:

SQL Server 2016 introduces a new way of deploying an availability group: Distributed Availability Groups. This new form of an AG allows you to span different underlying Windows Server Cluster topologies which can enable both disaster recovery and migration scenarios. This session will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario, as well as show a demo of one in action.

SessionID: 65052

SQL Server Administration on Linux

Back to calendar

Event Date: 20-05-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: SQL Server Administration on Linux

Abstract:

I bet never in your career you thought SQL Server would run on anything other than Windows. Times are changing, and are you ready? SQL Server on Linux is right around the corner! What is Linux – really? Why run your mission-critical databases on an unfamiliar operating system? This introductory session will help seasoned SQL Server DBA understand the basics of Linux and how it is different from Windows, all the way from basic management to performance monitoring. By the end of this session, you will be able to launch your own Linux-based SQL Server instance and get hands-on with this paradigm shift to see if this new platform is right for your organization.

SessionID: 54851

Outsourcing database administration to your users.

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Stephen Mokszycki

Title: Outsourcing database administration to your users.

Abstract:

How outsource administrative tasks to your end user groups in a safe, secure, and repeatable pattern. Now you no longer have to pause and stop what you are doing to create that new login, and replicate it to your Disaster Recovery. You do not have to stop and perform a backup/restore to refresh the development environment. Empower your end users, let them do this on their own without compromising your security.

There will be a demo!

SessionID: 54862

Connection to SQL Server. Problems. Troubleshooting. Solutions.

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Slava Murygin

Title: Connection to SQL Server. Problems. Troubleshooting. Solutions.

Abstract:

It is very frustrating when users complain about inability to connect to SQL Server while SQL Server functioning as normal as usually.

This session demonstrates multiple different scenarios of SQL Server connectivity issues, describes basic of troubleshooting methods and showing possible fixes using PowerShell scripts.

SessionID: 56224

R-ternatives in Power BI

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: R-ternatives in Power BI

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI.

There are 3 ways you can leverage R in Power BI. You can use it as a data source, you can leverage it in Power Query, or you can use it to create custom visualizations. In this session I present easy to follow examples of those 3 scenarios. I will also provide resources that will enable you to take what you learned to the next level.

SessionID: 57745

HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Jean Joseph

Title: HOW TO TROUBLESHOOT DATABASE PERFORMANCE ISSUES

Abstract:

In this session, I will be talking about performance turning, index design, statistics, query optimizer, parameter sniffing, data types, analyzing and understanding execution plans, wait stats, activity monitor, DMV(s). After this session you should be able to quickly identify the top performance issues of your databases.

SessionID: 57998

Using Biml as an SSIS Design Patterns Engine

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Using Biml as an SSIS Design Patterns Engine

Abstract:

Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

• How to build and execute your first Biml file!
• How to design a single SSIS package using Biml
• How to rapidly build multiple SSIS packages using Biml

SessionID: 58088

SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: BI Platform Architecture, Development Administration

Speaker: Wylie Blanchard

Title: SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI

Abstract:

In this session we'll develop a Tabular Data Model in MS SSAS and review our options for deploying, sharing and visualizing it. Well also discuss how senior leaders will see the business value of SSAS and how end users can utilize it for Self-Service Business Intelligence.

SessionID: 61530

Welcome To the 2016 Query Store!

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Welcome To the 2016 Query Store!

Abstract:

One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type information it holds and how you can use it to analyze performance issues. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 62455

Azure Analysis Services - An introduction

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Cloud Application Development Deployment

Speaker: Timothy McAliley

Title: Azure Analysis Services - An introduction

Abstract:

We will take a look at an introduction and overview of Azure Analysis Services - Microsoft 's cloud-based analytical engine and Platform as a Service (PaaS) offering. We will discuss Azure Analysis Services features and capabilities, use cases, provisioning and deployment, managing and monitoring, tools, and report creation. Although Azure Analysis Service is in Public Preview at the time of this session submission, we will incorporate the latest publicly available information.

SessionID: 62481

Accelerating DevOps and TDM Using Data Virtualization

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Gorman

Title: Accelerating DevOps and TDM Using Data Virtualization

Abstract:

DevOps is the merger of app development, testing, and IT ops. All tasks from coding to testing to operations should be automated so new features and fixes can be continuously quickly.

Test Data Management (TDM) is the optimization of the process of software quality, ensuring that applications properly work according to their specifications.

Constraining both DevOps and TDM is database size. "Storage is cheap" is not merely a lie, but more to the point it takes a lot of time to push terabytes around from place to place, and time itself is expensive and dear.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur, quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.

SessionID: 62600

SQL Server Infrastructure – Cloud and On-Prem Options

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Strategy and Architecture

Speaker: David Klee

Title: SQL Server Infrastructure – Cloud and On-Prem Options

Abstract:

Years ago, DBAs worked side-by-side with the infrastructure teams who managed the equipment their databases ran on. Today, organizations are more siloed than ever, and DBAs have less visibility into this layer than ever before. What is actually under the OS? Why does it matter?

Physical servers, enterprise virtualization, and cloud servers all provide solid platforms for you to run your databases on, but improperly configured and tuned platforms can lead to performance nightmares. Let’s explore the various layers, options, and performance characteristics of the different systems underneath SQL Server so you can improve the performance of your systems.

SessionID: 62614

SQL Licensing True-up

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Pearl

Title: SQL Licensing True-up

Abstract:

Licensing models are constantly changing and ever confusing for folks administering and deploying SQL Servers. CALs, Per processor, per core, VM vs. Physical, Standard vs. Enterprise, Active v Passive. What's considered a license and what is not.

In addition, we will prepare you for the dreaded Microsoft True-up! Offering tips and scripts and methods to create an inventory of your SQL environment and be ready when it happens!

SessionID: 62760

Inside SQL Server In-Memory OLTP

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Inside SQL Server In-Memory OLTP

Abstract:

Based on the successful 500 Level talk at PASS 2016, this session will provide an internals view of how In-Memory OLTP works for SQL Server 2016. Because this session is Advanced, it is intended for those that understand the basic fundamentals of In-Memory OLTP but want to learn how the "Hekaton" engine works behind the scenes to deliver the amazing 30x performance improvements seen for customers moving to In-Memory OLTP. This session will include a look behind the scenes at threads, data and index design, transactions and concurrency, logging, storage, and natively compiled procedures. And since this will be an advanced level session, of course the demonstration of the looking at the Hekaton engine with the debugger is a must.

SessionID: 62804

Why candidates fail the job interview in the first minute

Back to calendar

Event Date: 20-05-2017 - Session time: 10:35:00 - Track: Professional Development

Speaker: Thomas Grohser

Title: Why candidates fail the job interview in the first minute

Abstract:

In the last two decades Thomas always had more open positions than I could fill, not because of lack of applicants, I must have interviewed close to 300 people for DBA, database developer, data architect, data modeling and other data related positions. Come to this highly interactive session to learn why 99% of the candidates failed the simplest questions and disqualified them self.

Thomas will share what he misses in resumes and how to respond to questions better.

SessionID: 64285

SANLess clustering for physical, virtual and cloud environments

Back to calendar

Event Date: 20-05-2017 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SANLess clustering for physical, virtual and cloud environments

Abstract:

Microsoft Clusters and Datacenter MVP, Dave Bermingham, will discuss how to create SANLess clusters in environments where traditional shared storage clusters are impractical or impossible. He will be discussing high performance clusters leveraging SSD and Flash-based PCIe storage for faster SQL application response times - no SAN (or SAN Admin required). He will also touch on methods for providing HA protection and native Windows Failover Clustering in Windows Azure or the Amazon Cloud. -- Topics covered -- High performance storage and accelerating SQL Server without sacrificing availability; AlwaysOn Failover Clustering vs. AlwaysOn Availability Groups; HA and DR strategy for SQL Server in Amazon EC2 and Azure instances; Fast, cost-effective strategies to get HA and DR protection without a SAN.

SessionID: 64308

No inside, No outside, No box. DellEMC software defined storage s

Back to calendar

Event Date: 20-05-2017 - Session time: 12:00:00 - Track: Strategy and Architecture

Speaker: Charles Chiambalero

Title: No inside, No outside, No box. DellEMC software defined storage s

Abstract:

Enjoy lunch while learning about the next evolution of storage technologies!

In the past, islands of servers with local unevenly utilized and difficult to protect resources led to virtualization technologies like storage arrays (i.e. SAN's) to enable larger pooling of resources and advanced strategies in data protection and high availability. While media technologies like SSD's have evolved from the rotational disk of the past, so has the array evolved into software defined storage strategies leveraging commodity hardware and providing almost limitless scale, face melting performance and new targets in availability. Come learn how the storage market leader DellEMC views software defined storage and how it's product ScaleIO can help you evolve.

SessionID: 54853

SQL Server 2016: A dive into Data Quality Services

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: BI Information Delivery

Speaker: Steve Simon

Title: SQL Server 2016: A dive into Data Quality Services

Abstract:

SQL Server 2016: Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.

SessionID: 54921

R For the SQL Server Developer

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 55000

Relational databases vs Non-relational databases

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Application Database Development

Speaker: James Serra

Title: Relational databases vs Non-relational databases

Abstract:

There is a lot of confusion about the place and purpose of the many recent non-relational database solutions (“NoSQL databases”) compared to the relational database solutions that have been around for so many years. In this presentation I will first clarify what exactly these database solutions are, how they compare to Hadoop, and discuss the best use cases for each. I’ll discuss topics involving ACID vs BASE, scaling, data warehousing, polyglot persistence, CAP theorem, and SQL Server 2016 and PolyBase. We will even touch on a new type of database solution called NewSQL. If you are building a new solution it is important to understand all your options so you take the right path to success.

SessionID: 55118

Query Tuning without Production Data

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Application Database Development

Speaker: Derik Hammer

Title: Query Tuning without Production Data

Abstract:

The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an underpowered development machine and a database which is less than 1/10th the size of the production equivalent. This session will cover query tuning techniques which will stop those phone calls and can be exercised on the worse of development environments. I will focus on query execution plan anti-patterns and faking out the optimizer.

SessionID: 57285

Stop Ignoring the SQL Server Resource Governor

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Application Database Development

Speaker: Denis McDowell

Title: Stop Ignoring the SQL Server Resource Governor

Abstract:

SQL Professionals are looking for ways to increase density without increasing resource contention between workloads. The SQL Server Resource Governor is a valuable tool which is often overlooked by Developers and Database Administrators. Resource Governor feature enhancements have made it an indispensable tool for developers and architects. This session will utilize case-studies and demos to illustrate why the Resource Governor should be part of your deployment strategy.

SessionID: 59533

SQL Server 2016: It Just Runs Faster

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: SQL Server 2016: It Just Runs Faster

Abstract:

Based on the popular blog series, join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 “It Just Runs Faster”, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business you won’t want to miss this session.

SessionID: 59793

From problem to Power BI: A journey in data visualization

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: From problem to Power BI: A journey in data visualization

Abstract:

Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

SessionID: 63008

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 63191

Writing T-SQL code like a boss

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Application Database Development

Speaker: Fabiano Amorim

Title: Writing T-SQL code like a boss

Abstract:

SQL is a tricky programming language, if you work with SQL Server in any capacity, as a developer, DBA, or a SQL user, you need to know how to write a good T-SQL code. A poorly written query will bring even the best hardware to its knees, for a truly performing system, there is no substitute for properly written queries that takes advantage of all SQL Server has to offer. Come to this session to learn how re-write a query and see many tips on what to do to make queries execute as fast as possible.

SessionID: 63307

Stop Doing That! 5 Common T-SQL Anti-Patterns

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Application Database Development

Speaker: William Wolf

Title: Stop Doing That! 5 Common T-SQL Anti-Patterns

Abstract:

There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work then you would expect.

In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.

By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rockstar!

SessionID: 63593

Creating Your First Azure Machine Learning Model

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Advanced Analysis Techniques

Speaker: Adan Ortiz-Cordova

Title: Creating Your First Azure Machine Learning Model

Abstract:

Azure Machine Learning is a predictive analytics service that allows you to quickly create and deploy analytic solutions. These solutions can predict future trends based on current and historical data. This allows solutions to get smarter over time. Azure Machine Learning Studio allows you to set up an experiment using drag-and-drop modules preprogrammed with predictive modeling techniques with just a web browser.

This session will provide a fundamental introduction to the Azure Machine Learning cloud service (as well as key machine learning paradigms and concepts). In addition, we will go over setting up a workspace, training a machine learning model, and publishing the model as web service using Machine Learning Studio.

SessionID: 63601

The Phenomenal IT Consultant

Back to calendar

Event Date: 20-05-2017 - Session time: 13:05:00 - Track: Professional Development

Speaker: Sebastian Meine

Title: The Phenomenal IT Consultant

Abstract:

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.

In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…

• if you are struggling to find enough new clients,
• if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
• if you feel like you are treading water when it comes to marketing. Join this session and get started on your way to becoming a Phenomenal IT Consultant.

SessionID: 54867

Tips that have saved my bacon

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Greg Moore

Title: Tips that have saved my bacon

Abstract:

In this session, I propose to share some of the tricks I've used on the operational side of being a DBA.

There's saying, never perform small miracles, people to rely on them, but isn't it useful to have a few in your back-pocket.

Everyone knows log-shipping is great for DR recovery, but what about using it for minor issues, like a delete or update gone bad? Want to move a large table someplace else (like that "oh it'll just be a small audit table, it won't grow large because we'll write the functionality later to keep it small" and they never do? UNC backups... an often overlooked but useful option for making a backup AND getting it off your server. Run a small operation where too many fingers have access to the operational DB and you want to catch them? These are some of the tricks I've picked up over the years and used more than once to perform small miracles and have saved my bacon or the bacon of others

SessionID: 54950

Finding Islands, Gaps, and Clusters in Complex Data

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Application Database Development

Speaker: Edward Pollack

Title: Finding Islands, Gaps, and Clusters in Complex Data

Abstract:

Being able to group data into logical and meaningful sets can be extremely useful. When the data involved is a non-repeating sequence of integers, grouping is not too difficult. Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.

This is a fast-paced session that delves into methods that can be applied to any data. Want to know how many production incidents make up a single common problem? Can we track sales success by the number of consecutive weeks that an agent has exceeded their goal? How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?

Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!

SessionID: 57351

Azure SQL Database Vs. Amazon RDS

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: BI Platform Architecture, Development Administration

Speaker: Luan Moreno Medeiros Maciel

Title: Azure SQL Database Vs. Amazon RDS

Abstract:

They are the largest hosting companies in the world, Amazon AWS and Microsoft Azure, both have our beloved SQL Server running as a PaaS (Platform-as-a-Service).

The term DBaaS (Database-as-a-Service) is a brand new concept that brings the self-managing cloud process to our reality, now administrative tasks and process such as backup, high availability and disaster recovery solutions will be handed to the hosting company.

Flexibility, scalability on-demand, and rapid provisioning are the hottest points to move towards to the PaaS delivery. Ready to change the mindset of your company and concern only with the business value, join with me on this session and open your mind to the new reality.

SessionID: 57472

SQL Server XML 101

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Application Database Development

Speaker: Alex Grinberg

Title: SQL Server XML 101

Abstract:

XML processing become more and more a part of our daily life. Today anyone, DBA or Developer, interferes one way or another with XML-based processes. In the SQL Server XML 101 session I'll go over XML data type from "ground zero" to advanced tricks and tips. Using real life examples I'll show most efficient ways to work with an XML of any complexity and size. I'll cover the problems that you can anticipate to deal with with XML. How to: load the files using T-SQL code, dynamically retrieve and element or attribute, use different XML data types' methods and functions.

SessionID: 57609

Effective Data Warehouse Storage Patterns

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Application Database Development

Speaker: John Miner

Title: Effective Data Warehouse Storage Patterns

Abstract:

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?

This presentation will review the following techniques to fix your woes.

Coverage:

1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?

SessionID: 59481

SharePoint 2016 Unbreakable with SQL Server Always On Availability Groups

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Isabelle Van Campenhoudt

Title: SharePoint 2016 Unbreakable with SQL Server Always On Availability Groups

Abstract:

SQL Server is really the brain of SharePoint; in this session, Serge and Isabelle will give you an overview of what any SharePoint consultant and DBA need to know regarding business continuity in SharePoint 2013 2016. Of course SQL Server plays a major role in this story; the sessions will be animated with real live demos.

Topics covered:

• Concepts of business continuity • SharePoint and Business continuity • Patterns and anti-patterns • SharePoint and SQL Server Always on Availability groups : what works, what doesn’t work (demos) • Role of Azure • Lessons learned from real projects • New features in SQL Server 2016 that can help SharePoint business continuity

Benefits of Attending this Session:

Learn about SharePoint High Availability and Disaster Recovery with SQL Server Always On Availability Groups Learn about SharePoint Business Continuity Learn about SharePoint 2013/2016 unbreakable

SessionID: 59728

Extending DevOps To SQL Server

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Strategy and Architecture

Speaker: Grant Fritchey

Title: Extending DevOps To SQL Server

Abstract:

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.

SessionID: 61480

Would You Just Load Already?! Maximizing Your SSIS Data Load

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Application Database Development

Speaker: Chris Bell

Title: Would You Just Load Already?! Maximizing Your SSIS Data Load

Abstract:

Loading data via SSIS is great! It’s fast too! Until you hit a bad record. Then things aren’t so great. Now you probably have to waste time dumping and reloading all the data, or worst figure out where the bad record is and try a partial load.

In this session you will learn a simple method to load data via SSIS and identify, remove, and record those bad records allowing you to maximize the amount of data loaded while ensuring data integrity.

SessionID: 62486

An Introduction to Always Encrypted

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Application Database Development

Speaker: Justin Dearing

Title: An Introduction to Always Encrypted

Abstract:

This will be an introduction to the new SQL Server 2016 Always Encryption feature. Unlike Transparent Data Encryption Always Encrypted provides encryption in transit as well as encryption at rest. This will be a survey overview of both the operations and development side of Always Encrypted, but will be mainly operations focused. Considerations for porting existing databases to Always Encrypted will also be discussed.

SessionID: 63500

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 63501

Monitoring SQL Server using Extended Events

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Hilary Cotter

Title: Monitoring SQL Server using Extended Events

Abstract:

Extended events is designed to be a replacement to Profiler and delivers expanded monitoring and troubleshooting and offers less performance overhead than profiler. Learn how to log long running/high cpu/high IO queries, determining queries which timeout, and to debug sql server processes.

SessionID: 63602

Network your Way to Success!

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Professional Development

Speaker: Lisa Margerum

Title: Network your Way to Success!

Abstract:

Did you know that most employers -- whether looking for a full time employee, contractor, or consultant – interview people because of their technical skills and experiences, but hire and keep them for their social capital? In times of economic downturn, it’s not the person who is the most competent who stays; it’s the one who’s most competent, likeable, and connected. Socially adept people also get invited to the table more often for big projects and are promoted (or extended) more frequently than purely ‘competent’ individuals.

Whether or not you’ve been in your role for a few months, years, or even decades – or you’re looking for a new job and new opportunities -- strategic networking is the way to make yourself more relevant, more attractive for projects and promotion – or more hirable by potential customers.

Join us for an interactive session to strategize the best actions to increase your social capital and network your way to success!

SessionID: 64076

SQL Server High Availability in Azure IaaS

Back to calendar

Event Date: 20-05-2017 - Session time: 14:25:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SQL Server High Availability in Azure IaaS

Abstract:

Deploying mission critical SQL Server in Azure IaaS requires an in-depth understanding of storage, virtual networks, load balancers, SQL Server AlwaysOn and more. To qualify for Azure’s SLA of 99.95% availability, steps must be taken to mitigate downtime by leveraging Fault Domains and Update Domains in conjunction with traditional HA options.

Azure Resource Manager (ARM) replaces Azure “Classic” as the preferred deployment method in Azure. New features such as Deployment Templates and Resource Groups introduced in ARM make it a powerful tool in managing the entire life-cycle of SQL Server in Azure.

In this session attendees will learn how to leverage ARM to deploy SQL AlwaysOn Availability Groups and Failover Cluster Instances. Template Deployments and manual configurations using the Azure Portal and Azure PowerShell will be demonstrated.

SessionID: 54856

SQL Server Reporting Services 2016 on Steroids!!

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Steve Simon

Title: SQL Server Reporting Services 2016 on Steroids!!

Abstract:

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.

In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

SessionID: 54883

Top 5 Tips to Keep Always On Always Humming and Users Happy

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Top 5 Tips to Keep Always On Always Humming and Users Happy

Abstract:

Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet.

SessionID: 54968

Using a gateway to leverage on-premises data in Power BI

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Adam Saxton

Title: Using a gateway to leverage on-premises data in Power BI

Abstract:

I look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards for Power BI. This will start with Power BI Desktop, and the choices you have for SQL Server and Analysis Services. It will then move to the cloud and look at hosting your files on OneDrive for Business, and what this means for data freshness. We will then look at options for personal use or a more centralized use. It will finish off with looking at some troubleshooting tools available to you when working with data refresh.

SessionID: 54997

Choosing the right technologies for a big data solution

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: James Serra

Title: Choosing the right technologies for a big data solution

Abstract:

Has your company been building data warehouses for years using SQL Server? And are you now tasked with creating or moving your data warehouse to the cloud and modernizing it to support “Big Data”? What technologies/tools should use? That is what this presentation will help you answer. First we will cover what questions to ask concerning data (type, size, frequency), reporting, performance needs, on-prem vs cloud, staff technology skills, OSS requirements, and cost. Then we will show you common big data architecture solutions and help you to answer questions such as: What tool do I use to move data to the cloud? Where do I store the data? Should I use a data lake? Do I still need a cube? What about Hadoop/NoSQL? Do I need the power of MPP? Should I build a "logical data warehouse"? Finally, we’ll show some architectures of real-world customer big data solutions. Come to this session to get started down the path to making the proper technology choices in moving to the cloud.

SessionID: 55028

Understanding U-SQL

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Azhagappan Arunachalam

Title: Understanding U-SQL

Abstract:

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL. In this session, we#39;ll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,). We#39;ll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

SessionID: 57350

DBaaS on Azure - SQL Database Best Practices

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Luan Moreno Medeiros Maciel

Title: DBaaS on Azure - SQL Database Best Practices

Abstract:

The new term called - DBaaS (Database as a Service) is being widely recognised nowadays, this denomination provides a flexible, scalable and on-demand platform that is oriented toward self-service and easy management delivering, principally in terms of provisioning a business own environment. Is not necessary anymore the acquirement of a machine on the Microsoft Cloud [IaaS] to run a SQL Server Database, now you can leave this complexity behind by handing over this responsibility to Microsoft Azure Datacenter.

This new technology is being adopted for a lot of customers around the world and now it’s your time to get into it by learning the best practices configurations and caveats. Immerse yourself in this session and learn how to provide a to your customer the best database solution available on the market, the SQL Database from Microsoft Azure.

SessionID: 57529

Demystifying Data Compression

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

SessionID: 57816

Wish you could live the glamorous consulting life?

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Professional Development

Speaker: Juan Soto

Title: Wish you could live the glamorous consulting life?

Abstract:

We are going to talk about a topic many will not touch at a SQL Saturday: Money. How to make it, how to get customers, how to market. Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).

I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way. In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out. Y

SessionID: 61158

Execution Plans for Mere Mortals

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 61350

Azure Data Catalog 101

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Information Delivery

Speaker: Jake Switzer

Title: Azure Data Catalog 101

Abstract:

Azure Data Catalog is a fully managed cloud service that enables users to discover the data sources they need, and to understand the data sources they find, while helping organizations get more value from their existing investments. Data Catalog provides capabilities that enable any user – from analysts to data scientists to developers – to discover, understand, and consume data sources. Data Catalog includes a crowdsourcing model of metadata and annotations, and allows all users to contribute their knowledge to build a community and culture of data.

This session will provide a 101 introduction to Azure Data Catalog. Included in this session will be creating an Asset in Azure Data Catalog, setting up access control for Assets, amongst the demonstration of features of the product.

SessionID: 62431

Building Secure Applications in Azure SQL Database

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Joseph D'Antoni

Title: Building Secure Applications in Azure SQL Database

Abstract:

Cloud computing requires new security paradigms that are unfamiliar to many application users, database administrators, and programmers. Consequently, some organizations are hesitant to implement a cloud infrastructure for data management due to perceived security risks. However, much of this concern can be alleviated through a better understanding of the security features built into Microsoft Azure and Microsoft Azure SQL Database.

Azure provides extremely robust security protection at the physical, logical, and data layers of its services and applications, making Azure datacenters among the most secure facilities of their kind in the world. Likewise, Azure SQL Database includes multiple layers of security, with role-based logical data protection and auditing to monitor the security of your data.

SessionID: 63620

Lockless in Seattle: Using In-Memory OLTP Transaction Processing

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mark Broadbent

Title: Lockless in Seattle: Using In-Memory OLTP Transaction Processing

Abstract:

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.

SessionID: 63627

Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Back to calendar

Event Date: 20-05-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melody Zacharias

Title: Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Abstract:

Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business. As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients. In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits. We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.

This site is open source. Improve this page.