sqlsathistory

Nr: 714

Back to Main list

SQLSaturday #714 - Philadelphia 2018

Start Time (24h) Speaker Track Title
09:00:00 Eugene Meidinger PreCon (Friday) Power BI Implementation: A Guide to the Other 90%
09:00:00 Grant Fritchey PreCon (Friday) SQL Server Tools for Query Tuning
09:00:00 Alex Grinberg PreCon (Friday) XML and JSON deep dive
08:30:00 Kathi Kellenberger Application Database Development T-SQL Window Function Performance
08:30:00 Zhen Zhang Cloud Application Development Deployment Deploy AlwaysOn on Google Cloud in Real Life
08:30:00 Greg Baldini Technical Vendor Session Simple Modeling Solutions to Complex Measure Problems
08:40:00 Ravi Kumar BI Platform Architecture, Development Administration Power BI Security
08:40:00 Ned Bellavance Enterprise Database Administration Deployment Deploying SQL Server using Desired State Configuration
08:40:00 John Miner Application Database Development Effective Data Warehouse Storage Patterns
08:40:00 Beverly Prohaska Professional Development Innovation or Extinction: Reimagining the Role of IT
08:50:00 Sepand Gojgini Cloud Application Development Deployment Data Landscape on Azure
08:50:00 Tim Gorman Information Delivery Reducing The Surface Area Of Risk in Data Security
08:50:00 Rick Wargo Analytics and Visualization Healthcare Analytics using Machine Learning Services with Python in SQL Server 2017
10:00:00 David Patrick Analytics and Visualization Microsoft and Big Data - An Overview of the Power Tools and more!
10:00:00 Greg Baldini BI Information Delivery DAX More Than Measures: An Introduction to DAX as a Query Language
10:00:00 Alex Grinberg Advanced Analysis Techniques XML and JSON, does the DBA need it
10:10:00 Chris Bell Strategy and Architecture Statistics and Cardinality – How they work together
10:10:00 Greg Moore Professional Development So you want to Present: Tips and Tricks of the trade
10:10:00 Linda Zhang Cloud Application Development Deployment Azure SQL Data Warehouse - Migrate on-premises to cloud: How to and Best Practice
10:10:00 Joe Wehr Professional Development Entrepreneurship - Are you ready to make it on your own?
10:20:00 Tracey Kroll Analytics and Visualization SQL Server 2017 and Python… Perfect Together
10:20:00 Michael Wells Technical Vendor Session #GetModern With Dell EMC
11:30:00 James Serra Strategy and Architecture Big data architectures and the data lake
11:30:00 Jennifer Brocato Strategy and Architecture HA/DR Solutions Using Distributed Availability Groups
11:30:00 Jerod Johnson Technical Vendor Session REST Easy - Instant APIs for Your Database
11:40:00 Ray Kim Professional Development I lost my job! Now what?!? A survival guide for the unemployed
11:40:00 Walter Shields Professional Development Remember what it’s like to be a Beginner?
11:40:00 Ivan Carter Professional Development 7 Steps to Starting Your Own Business
11:50:00 Tracy Boggiano Enterprise Database Administration Deployment Collecting Performance Metrics
11:50:00 Grant Fritchey Application Database Development Extending DevOps to SQL Server
11:50:00 Clay Jackson Technical Vendor Session Move Your SQLServer Database to the cloud
14:10:00 Brian Carrig Enterprise Database Administration Deployment Controlling Competing Workloads with SQL Server Resource Governor
14:10:00 Chris Bell Enterprise Database Administration Deployment 5 Minute No Sweat SQL Security Audits
14:10:00 Kevin Goff BI Platform Architecture, Development Administration Implementing Data Warehouse Patterns with the Microsoft Data Plat
14:15:00 Kathi Kellenberger BI Platform Architecture, Development Administration Azure Machine Learning 101
14:15:00 Marsha Pierce Enterprise Database Administration Deployment Mom Rules for Managing Enterprise Database Environments
14:15:00 Nick Chobotar BI Information Delivery Power Query ETL: Let’s talk about data integration with Power Query
14:15:00 Sebastian Meine Professional Development The Phenomenal IT Consultant - A Blueprint to Getting New Clients, Charging More, and Working Less
14:20:00 Vince Napoli BI Information Delivery Data Governance and Master Data Management
14:20:00 Michael Traudt Technical Vendor Session Protecting SQL Server on Linux!
14:20:00 Sarah Hutchins Professional Development How to Ace Your Job Interview
15:30:00 Dan Clark BI Information Delivery Power Query Deep Dive
15:30:00 Brian Carrig Enterprise Database Administration Deployment Successfully Running SQL Server in AWS
15:30:00 Ned Otter Enterprise Database Administration Deployment Table Partitioning 101
15:35:00 Stephen Mokszycki Enterprise Database Administration Deployment DevOps Database administration.
15:35:00 James Serra Cloud Application Development Deployment Choosing technologies for a big data solution in the cloud
15:35:00 Tracy Boggiano Enterprise Database Administration Deployment Tips on Managing Lots of SQL Servers
15:35:00 Taiob Ali Enterprise Database Administration Deployment New features in Management Studio and Showplan -- Performance Troubleshooting made easier!
15:40:00 Zachary Fanelle BI Information Delivery Self Service Business Intelligence: Model for High Efficiency
15:40:00 Bobbi-Jo Brighton, CST, LCI Professional Development Women’s Mental Toughness in the Tech Industry
15:40:00 Louis Diaz-Delgado Technical Vendor Session SQL Automation – In the Cloud, On-Premise, and Hybrid

SessionID: 73290

Power BI Implementation: A Guide to the Other 90%

Back to calendar

Event Date: 21-04-2018 - Session time: 09:00:00 - Track: PreCon (Friday)

Speaker: Eugene Meidinger

Title: Power BI Implementation: A Guide to the Other 90%

Abstract:

When learning about Power BI, the part you learn first is all the powerful visuals. But like an iceberg, that's just the 10% everyone sees. If you are asking yourself "what's next?", this training will teach your the other 90%.

In the first half of the day, we will focus on data manipulation. Often times, the hardest part of making a report is shaping the data. We will cover applied database theory, data cleansing with PowerQuery and data modelling with DAX. We'll show you what each tool is good at and when to use it. We'll also cover some internals so you understand at a deeper level how these tools really work.

The second half of the day is all about deployment and administration. Do you have a data governance plan in place? We'll show how to access your on-premises data with data gateways. We'll cover options for securing and protecting your data, including row-level security and auditing. Finally, we'll go over the ways you can share and distribute these reports.

SessionID: 74498

SQL Server Tools for Query Tuning

Back to calendar

Event Date: 21-04-2018 - Session time: 09:00:00 - Track: PreCon (Friday)

Speaker: Grant Fritchey

Title: SQL Server Tools for Query Tuning

Abstract:

Query tuning within SQL Server can be a tough skill to master. The new tooling released with SQL Server 2016 and 2017 changes how you identify poorly performing queries, troubleshoot their behavior, and tune the queries, all a little easier. This workshop teaches new techniques for tuning queries using all the new tools introduced in SQL Server 2016 and 2017. You'll be able to put this knowledge to work immediately, not only in your 2016 or better instances but also in your Azure SQL Database databases. You will be tuning your queries faster and more accurately using the new tools available.

SessionID: 74499

XML and JSON deep dive

Back to calendar

Event Date: 21-04-2018 - Session time: 09:00:00 - Track: PreCon (Friday)

Speaker: Alex Grinberg

Title: XML and JSON deep dive

Abstract:

In the modern world of information technology, keeping data stored and manipulated reliably

and efficiently is one of the top priorities. Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it is still growing by providing more functionalities to store and manipulate data reliably. eXtensible Markup Language (XML) is one of the technologies that SQL Server implements not only for data manipulation but also for internal usage, such as Execution Plans, Extended Events, DDL trigger Eventdata() function, and behind-the- scenes construction for SQL Server Business Intelligence Tools (SSIS, SSRS, SSAS). XML skills often appear in SQL Server DBA job requirements because the ability to work with XML allow the DBA to be faster and more efficient when solving different types of problems.

SessionID: 72064

T-SQL Window Function Performance

Back to calendar

Event Date: 21-04-2018 - Session time: 08:30:00 - Track: Application Database Development

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

Deploy AlwaysOn on Google Cloud in Real Life

Back to calendar

Event Date: 21-04-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Zhen Zhang

Title: Deploy AlwaysOn on Google Cloud in Real Life

Abstract:

We will discuss all details of deploying SQL Server 2016 AlwasyOn on Google Cloud in real life. There are already white paper and google official document on creating AlwaysOn. However those are not ready for real production environment. I will show you all missing parts to deploy in real life on GCP

SessionID: 80609

Simple Modeling Solutions to Complex Measure Problems

Back to calendar

Event Date: 21-04-2018 - Session time: 08:30:00 - Track: Technical Vendor Session

Speaker: Greg Baldini

Title: Simple Modeling Solutions to Complex Measure Problems

Abstract:

With examples of real problems and (attempted) solutions, this presentation will examine dimensional modeling techniques which simplify and speed up measure evaluation. A fast-paced and language/tool-agnostic look at some common and uncommon reporting scenarios, including:

All manner of date calculations and comparisons Slowly changing dimensions Events in progress Conditional evaluation of measures

By the end of this talk, you should have a stronger understanding of the right questions to ask that will make your BI solution simpler for end users and more performant at run-time.

SessionID: 73235

Power BI Security

Back to calendar

Event Date: 21-04-2018 - Session time: 08:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ravi Kumar

Title: Power BI Security

Abstract:

How secure is Power BI and how do I apply user security? Come to this session to learn two things:

  1. How secure Power BI really is in the cloud? We will go over what architecture Power BI uses to secure the data.

  2. How does user security work Power BI? We will cover "who can see what" from a user point of view.

SessionID: 73340

Deploying SQL Server using Desired State Configuration

Back to calendar

Event Date: 21-04-2018 - Session time: 08:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Ned Bellavance

Title: Deploying SQL Server using Desired State Configuration

Abstract:

Automation and configuration management are essential tools in the belt of all IT practitioners. In this session you'll learn about Microsoft's Desired State Configuration tool, and how you can leverage it to automagically deploy SQL Server in a consistent and repeatable way. You'll also see how DSC can be used to make changes or correct the dreaded configuration drift.

There will be demos! No death by PowerPoint.

SessionID: 73615

Effective Data Warehouse Storage Patterns

Back to calendar

Event Date: 21-04-2018 - Session time: 08:40: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: 80429

Innovation or Extinction: Reimagining the Role of IT

Back to calendar

Event Date: 21-04-2018 - Session time: 08:40:00 - Track: Professional Development

Speaker: Beverly Prohaska

Title: Innovation or Extinction: Reimagining the Role of IT

Abstract:

While nearly every organization believes that they want to capture “innovation” as the silver bullet to survivability and growth, very few have learned the best practices to create an “innovative culture”, and even fewer execute those plans well. Beverly Prohaska, Consultant and former CIO, presents a model for understanding and initiating a culture that can actually innovate at differing levels. This discussion will include key definitions, do’s and don’ts, as well as best practices, examples, and observations on Innovation across several large companies.

SessionID: 70777

Data Landscape on Azure

Back to calendar

Event Date: 21-04-2018 - Session time: 08:50:00 - Track: Cloud Application Development Deployment

Speaker: Sepand Gojgini

Title: Data Landscape on Azure

Abstract:

There are many Data Platform offerings available on Azure and new ones are introduced regularly and evolved. In this session we will cover various offering and what scenarios are most suitable for. We will also discuss whether it makes sense to make use of this services or roll your own on-premise or hybrid solutions

SessionID: 70961

Reducing The Surface Area Of Risk in Data Security

Back to calendar

Event Date: 21-04-2018 - Session time: 08:50:00 - Track: Information Delivery

Speaker: Tim Gorman

Title: Reducing The Surface Area Of Risk in Data Security

Abstract:

When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.

Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.

SessionID: 73936

Healthcare Analytics using Machine Learning Services with Python in SQL Server 2017

Back to calendar

Event Date: 21-04-2018 - Session time: 08:50:00 - Track: Analytics and Visualization

Speaker: Rick Wargo

Title: Healthcare Analytics using Machine Learning Services with Python in SQL Server 2017

Abstract:

Take advantage of Python-based analytics in SQL Server 2017. This session will cover setting up Python Machine Learning in SQL Server 2017 and exploring data models through analytics using publicly available healthcare claims data. You won't need to know Python to get value from this session, but an understanding of programming will be very helpful.

SessionID: 70771

Microsoft and Big Data - An Overview of the Power Tools and more!

Back to calendar

Event Date: 21-04-2018 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: David Patrick

Title: Microsoft and Big Data - An Overview of the Power Tools and more!

Abstract:

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.

SessionID: 72642

DAX More Than Measures: An Introduction to DAX as a Query Language

Back to calendar

Event Date: 21-04-2018 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Greg Baldini

Title: DAX More Than Measures: An Introduction to DAX as a Query Language

Abstract:

DAX is the native formula language for Power BI and SSAS Tabular. At least, that's how most of us have experienced it.

DAX is actually a query language, with rich semantics to represent all manner of analytical queries. Join us for a deep dive into using DAX to its full potential to answer complex queries using Tabular's in-memory model for lightning speed.

SessionID: 73303

XML and JSON, does the DBA need it

Back to calendar

Event Date: 21-04-2018 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Alex Grinberg

Title: XML and JSON, does the DBA need it

Abstract:

This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server - JSON integration. During the session, the audience will be provided with plenty of code examples. As a bonus, a lucky winner will receive my most recent book, "XML and JSON Recipes for SQL Server".

SessionID: 72281

Statistics and Cardinality – How they work together

Back to calendar

Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Strategy and Architecture

Speaker: Chris Bell

Title: Statistics and Cardinality – How they work together

Abstract:

Are your statistics up to date?

Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact a simple upgrade of your SQL Server to 2014 and the new cardinality estimator can have.

SessionID: 72551

So you want to Present: Tips and Tricks of the trade

Back to calendar

Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Professional Development

Speaker: Greg Moore

Title: So you want to Present: Tips and Tricks of the trade

Abstract:

So you've decided to take the leap into presenting. Maybe it's at your local user group, maybe it's at SQL Saturday.

This talk will guide you through the process of selecting a topic, preparing for it and actually giving it.

We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place.

What are some good guidelines to follow and when can, or even should, you break them.

This will be partly interactive so come with questions and be prepared to be asked some.

SessionID: 73640

Azure SQL Data Warehouse - Migrate on-premises to cloud: How to and Best Practice

Back to calendar

Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Cloud Application Development Deployment

Speaker: Linda Zhang

Title: Azure SQL Data Warehouse - Migrate on-premises to cloud: How to and Best Practice

Abstract:

Azure SQL Data Warehouse - Migrate on-premises to cloud: How to and Best Practice

We will discuss what is Azure SQL DW and ways to build it and migrate to it. Azure SQL DW is a SQL-based, fully managed, petabyte-scale cloud data warehouse, that is highly elastic and enables you to set up in minutes and scale capacity in seconds.

SessionID: 73949

Entrepreneurship - Are you ready to make it on your own?

Back to calendar

Event Date: 21-04-2018 - Session time: 10:10:00 - Track: Professional Development

Speaker: Joe Wehr

Title: Entrepreneurship - Are you ready to make it on your own?

Abstract:

There's no doubt about it, being an entrepreneur can be very rewarding. However, it is far from easy. So, before you embark on that journey, you have to ask yourself if this is the right thing for you to do. But, how do you know?

Attend this inspiring session by Prof Joe Wehr of the MCCC and discover the good and the bad of becoming an entrepreneur.

This includes the things everyone needs to know, like

And the less obvious, including

If you have been thinking about “it” but aren't sure if you're ready, you need to attend this session. You might be surprised what you learn about yourself.

SessionID: 73897

SQL Server 2017 and Python… Perfect Together

Back to calendar

Event Date: 21-04-2018 - Session time: 10:20:00 - Track: Analytics and Visualization

Speaker: Tracey Kroll

Title: SQL Server 2017 and Python… Perfect Together

Abstract:

This session explores how the basics of Python, how it is integrated within SQL Server, and demonstrates some code in the context of a potential use case.

SessionID: 80503

#GetModern With Dell EMC

Back to calendar

Event Date: 21-04-2018 - Session time: 10:20:00 - Track: Technical Vendor Session

Speaker: Michael Wells

Title: #GetModern With Dell EMC

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/Dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 70915

Big data architectures and the data lake

Back to calendar

Event Date: 21-04-2018 - Session time: 11:30:00 - Track: Strategy and Architecture

Speaker: James Serra

Title: Big data architectures and the data lake

Abstract:

With so many new technologies it can get confusing on the best approach to building a big data architecture. The data lake is a great new concept, usually built in Hadoop, but what exactly is it and how does it fit in? In this presentation I’ll discuss the four most common patterns in big data production implementations, the top-down vs bottoms-up approach to analytics, and how you can use a data lake and a RDBMS data warehouse together. We will go into detail on the characteristics of a data lake and its benefits, and how you still need to perform the same data governance tasks in a data lake as you do in a data warehouse. Come to this presentation to make sure your data lake does not turn into a data swamp!

SessionID: 73821

HA/DR Solutions Using Distributed Availability Groups

Back to calendar

Event Date: 21-04-2018 - Session time: 11:30:00 - Track: Strategy and Architecture

Speaker: Jennifer Brocato

Title: HA/DR Solutions Using Distributed Availability Groups

Abstract:

No need to be afraid of availability groups. No more multi-subnet clusters. Use DAG to implement cross cluster replication. Learn how to expand your replication using the distributed availability groups using virtual and physical servers. Configure solutions to provide high availability and disaster recovery to any degree.

SessionID: 78747

REST Easy - Instant APIs for Your Database

Back to calendar

Event Date: 21-04-2018 - Session time: 11:30:00 - Track: Technical Vendor Session

Speaker: Jerod Johnson

Title: REST Easy - Instant APIs for Your Database

Abstract:

SQL Server provides database technology built with industry-leading performance, top-notch security and compliance, mission-critical availability, and a consistent experience across platforms and devices.

API-driven data consumption platforms and services highlight the need for RESTful access to SQL server data. The existing options for REST access to SQL Server data or using web development frameworks to convert relational data to JSON objects soak up time, resources, and energy on software development and maintenance that enterprises could be using to drive business.

With the CData API Server, users can rapidly create RESTful APIs for SQL Server data using a point-and-click interface. API Server includes everything needed to create, run, manage, and secure APIs for your SQL Server data. In this talk, we will walk through creating an OData API for SQL Server data and demonstrate connectivity using modern web development frameworks.

SessionID: 70762

I lost my job! Now what?!? A survival guide for the unemployed

Back to calendar

Event Date: 21-04-2018 - Session time: 11:40:00 - Track: Professional Development

Speaker: Ray Kim

Title: I lost my job! Now what?!? A survival guide for the unemployed

Abstract:

You've just been told by HR that you are no longer a part of their organization. You've been kicked to the curb. You are now living in the no-man's land called unemployment.

Unemployment is a scary situation. You're dealing with emotions and uncertainty. You don't know if you'll be out of work for days, weeks, or months.

Fortunately, unemployment is survivable. In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times. We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time. Hopefully, you'll land on your feet once again before long!

SessionID: 80291

Remember what it’s like to be a Beginner?

Back to calendar

Event Date: 21-04-2018 - Session time: 11:40:00 - Track: Professional Development

Speaker: Walter Shields

Title: Remember what it’s like to be a Beginner?

Abstract:

As an educator, I have seen such a wide demographic of people being attracted to databases and SQL. Wanting to understand how it all works and eager to learn this technology. From students majoring in computer science, business, and marketing to working professionals like developers, business analyst, marketing analyst and business managers.

This is the new crop of beginners I see every day that are attracted to you and what you do as a professional in database technology!

The thing is, as attractive as we are; to someone who wishes to enter this field; the actual steps they must take to become part of this profession can seem daunting.

In this session, I will walk us down memory lane back to the place we all started, as a beginner. I will raise your awareness of just how influential you already are and how you can use that influence to help those starting on their journey to understanding databases and SQL.

SessionID: 80773

7 Steps to Starting Your Own Business

Back to calendar

Event Date: 21-04-2018 - Session time: 11:40:00 - Track: Professional Development

Speaker: Ivan Carter

Title: 7 Steps to Starting Your Own Business

Abstract:

TBD

SessionID: 72662

Collecting Performance Metrics

Back to calendar

Event Date: 21-04-2018 - Session time: 11:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Collecting Performance Metrics

Abstract:

Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or whether or not a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? The answer is baseline metrics.

Only if you have baseline performance information can you answer these questions and form a plan to address the issues at hand. In this session, we will be discussing several open source tools you can combine into an inexpensive baselining system you can use to troubleshoot issues and answer important questions.

Attendees in this session will learn how to collect important metric data, what data to collect, and how to interpret that data and develop a plan of action to address any issues.

SessionID: 74497

Extending DevOps to SQL Server

Back to calendar

Event Date: 21-04-2018 - Session time: 11:50:00 - Track: Application Database Development

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

Move Your SQLServer Database to the cloud

Back to calendar

Event Date: 21-04-2018 - Session time: 11:50:00 - Track: Technical Vendor Session

Speaker: Clay Jackson

Title: Move Your SQLServer Database to the cloud

Abstract:

Clear the clouds on (pun intended)

What’s “The Cloud”? Why Should I Move to The Cloud? When Should I Move to The Cloud? What Should I Move to The Cloud? How Do I Move to The Cloud?

SessionID: 72202

Controlling Competing Workloads with SQL Server Resource Governor

Back to calendar

Event Date: 21-04-2018 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Carrig

Title: Controlling Competing Workloads with SQL Server Resource Governor

Abstract:

With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.

SessionID: 72280

5 Minute No Sweat SQL Security Audits

Back to calendar

Event Date: 21-04-2018 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: 5 Minute No Sweat SQL Security Audits

Abstract:

Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need.

In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.

SessionID: 74501

Implementing Data Warehouse Patterns with the Microsoft Data Plat

Back to calendar

Event Date: 21-04-2018 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Goff

Title: Implementing Data Warehouse Patterns with the Microsoft Data Plat

Abstract:

You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, ETL patterns, and more

SessionID: 72062

Azure Machine Learning 101

Back to calendar

Event Date: 21-04-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kathi Kellenberger

Title: Azure Machine Learning 101

Abstract:

You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.

SessionID: 72875

Mom Rules for Managing Enterprise Database Environments

Back to calendar

Event Date: 21-04-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: Mom Rules for Managing Enterprise Database Environments

Abstract:

Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.

SessionID: 73944

Power Query ETL: Let’s talk about data integration with Power Query

Back to calendar

Event Date: 21-04-2018 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Nick Chobotar

Title: Power Query ETL: Let’s talk about data integration with Power Query

Abstract:

Power Query is developing fast and gaining exponential popularity. Integration into SSAS is a strong statement from Microsoft that Power Query graduated from self-service BI to production. This session will focus on advanced topics in data connectivity and data transformation within Power BI environment.

Some key topics include:

SessionID: 73960

The Phenomenal IT Consultant - A Blueprint to Getting New Clients, Charging More, and Working Less

Back to calendar

Event Date: 21-04-2018 - Session time: 14:15:00 - Track: Professional Development

Speaker: Sebastian Meine

Title: The Phenomenal IT Consultant - A Blueprint to Getting New Clients, Charging More, and Working Less

Abstract:

Whether you are just starting out or have been in business as an IT consultant for a while, if you wonder how to get more clients, you are not alone. You are probably spending many hours chasing after opportunities, but somehow, you just can’t get enough to say yes.

Now, imagine having potential clients call you instead. Imagine getting enough inquiries to be able to pick and chose (while increasing your prices working less). Discover how in this unique session where Sebastian Meine, Ph.D. will introduce a simple way to attract new clients to your business: The NICER Client Attraction Method™.

SessionID: 73989

Data Governance and Master Data Management

Back to calendar

Event Date: 21-04-2018 - Session time: 14:20:00 - Track: BI Information Delivery

Speaker: Vince Napoli

Title: Data Governance and Master Data Management

Abstract:

With system implementation and data sourcing being more widely distributed than ever, from on premise to cloud and cloud services to self-service BI, challenges to manage your enterprise data has only grown exponentially harder. We will review options and scenarios for implementing Master Data Management (MDM), and discuss how a Data Governance framework to support the entire process becomes very critical to the success of your business. We will look at design patterns available to support your MDM effort, tools, such as SQL Server Master Data Services, and the setup of the organization oversight as an integral part of the overall picture.

SessionID: 78067

Protecting SQL Server on Linux!

Back to calendar

Event Date: 21-04-2018 - Session time: 14:20:00 - Track: Technical Vendor Session

Speaker: Michael Traudt

Title: Protecting SQL Server on Linux!

Abstract:

Are you curious about SQL Server on Linux? Join the session to learn all about the next generation of SQL Server on the Linux Operating System. Learn about deployment, configuration, storage, scale and more. Options for High Availability can seem boundless. Learn how to select the best option for you and how SANless clustering makes it simple.

SessionID: 80293

How to Ace Your Job Interview

Back to calendar

Event Date: 21-04-2018 - Session time: 14:20:00 - Track: Professional Development

Speaker: Sarah Hutchins

Title: How to Ace Your Job Interview

Abstract:

Aside from your technical abilities, the impression you make on the interview will be the reason you do or do not get a job offer. In this session, Sarah Hutchins, a successful national IT recruiter will highlight her top tips for phone, video conference, and onsite interviews. In addition, she will provide industry information about salary negotiation that employers don’t want you to know, to help you leverage the best possible offer. The session will include information about preparation, dress, and presentation. It will also incorporate role-playing the most common interview questions, and all attendees will be provided an interview prep guide with typical behavioral questions.

SessionID: 72121

Power Query Deep Dive

Back to calendar

Event Date: 21-04-2018 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Dan Clark

Title: Power Query Deep Dive

Abstract:

Power Query is a great tool for extracting, transforming, and loading data. It has an intuitive interface that allows you to create queries without having to worry about writing code. Under the covers Power Query is creating the M code that gets executed. In this session we will pull back the covers to reveal and understand the M code that is being created. This will give you greater insight into how to debug your queries. In addition, we will look at creating advance queries that go beyond what is available using the Power Query user interface.

SessionID: 72205

Successfully Running SQL Server in AWS

Back to calendar

Event Date: 21-04-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Carrig

Title: Successfully Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider, with many companies successfully running SQL server on AWS infrastructure, but trying to make sense of the available options can be daunting. In this session, we will explore the options available for running SQL server in AWS, either as a managed service or using dedicated EC2 instances. We will document the different storage options, High Availability strategies, as well as important security and maintenance caveats. We will also cover various licensing approaches available when running SQL server in AWS.

SessionID: 73827

Table Partitioning 101

Back to calendar

Event Date: 21-04-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ned Otter

Title: Table Partitioning 101

Abstract:

As of SQL 2016/SP1, Table Partitioning is available in all editions of SQL Server!

In this entry-level session, we'll discuss the advantages and disadvantages of deploying this often misunderstood feature. Is it designed to improve performance, or to ease administration?

Only one way to find out!

SessionID: 70781

DevOps Database administration.

Back to calendar

Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Stephen Mokszycki

Title: DevOps Database administration.

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

Choosing technologies for a big data solution in the cloud

Back to calendar

Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Cloud Application Development Deployment

Speaker: James Serra

Title: Choosing technologies for a big data solution in the cloud

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 and tools should use? That is what this presentation will help you answer. First we will level-set what big data is and other definitions, cover questions to ask to help decide which technologies to use, go over the new technologies to choose from, and then compare the pros and cons of the technologies. Finally we will show you common big data architecture solutions and help you to answer questions such as: Where do I store the data? Should I use a data lake? Do I still need a cube? Do I need the power of MPP? Should I build a "logical data warehouse"? And we'll close with showing 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: 71192

Tips on Managing Lots of SQL Servers

Back to calendar

Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Tips on Managing Lots of SQL Servers

Abstract:

When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers to manage or a hundred? How do you know they are setup correctly? How do you maintain the databases on each server? How do you take care of patching? How do you know when your server is on fire?

In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.

SessionID: 73161

New features in Management Studio and Showplan -- Performance Troubleshooting made easier!

Back to calendar

Event Date: 21-04-2018 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Taiob Ali

Title: New features in Management Studio and Showplan -- Performance Troubleshooting made easier!

Abstract:

SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.  

Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?

In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.

SessionID: 74500

Self Service Business Intelligence: Model for High Efficiency

Back to calendar

Event Date: 21-04-2018 - Session time: 15:40:00 - Track: BI Information Delivery

Speaker: Zachary Fanelle

Title: Self Service Business Intelligence: Model for High Efficiency

Abstract:

The goal of business intelligence is to get the right information to the right people at the right time. Historically, the long-standing model for this process was completely IT owned. Business users had issues with the speed of delivery with this approach, along with the lack of flexibility. The self-service business intelligence model is a methodology that addresses these problems, and gives the end users more freedom with their data.

In this discussion, Zack Fanelle will be covering the intricacies of why the self-service business model drives high levels of efficiency and productivity. This requires a new approach to collaboration with the business and IT. In addition, he will be covering technical examples of what the model would look like in 2018 and how to take advantage of it using modern products.

SessionID: 80013

Women’s Mental Toughness in the Tech Industry

Back to calendar

Event Date: 21-04-2018 - Session time: 15:40:00 - Track: Professional Development

Speaker: Bobbi-Jo Brighton, CST, LCI

Title: Women’s Mental Toughness in the Tech Industry

Abstract:

As a woman in tech, you enjoy the work and you want to contribute, yet chances are there are times you feel like quitting. Let’s face it, it gets tiring to step up every day when you’re always dealing with how to fit in with all the guys, being respected, and getting your voice heard. Add in juggling work and home, along with that nagging voice in your head, “Am I good enough?” – it’s no wonder that educated, highly trained women are leaving tech in droves.

Mental Toughness coach Bobbi-Jo Brighton, CST, LCI, helps us take a critical and insightful look at challenges that women professionals face in building their tech careers and becoming effective, influential leaders. Bobbi-Jo shares her expertise on empowering women through mental toughness to objectively look at workplace dissatisfaction, as well as the vital importance of strengthening your mindset to shift from frustration, doubt, and confusion within yourself to stay in the game and thrive in your life and tech career. (7 mi

SessionID: 80117

SQL Automation – In the Cloud, On-Premise, and Hybrid

Back to calendar

Event Date: 21-04-2018 - Session time: 15:40:00 - Track: Technical Vendor Session

Speaker: Louis Diaz-Delgado

Title: SQL Automation – In the Cloud, On-Premise, and Hybrid

Abstract:

They’re all SQL jobs, but some of your critical jobs run on local SQL Servers, while others run on Azure SQL. Still others execute across both environments. Will you maintain separate SQL Agents or other schedulers to automate these jobs? Or, will you will leverage a centralized solution? JAMS gives you complete control over every aspect of your SQL jobs – their source, their schedule, their history, their status – regardless of environment.

In this working session, we will walk through defining, executing, monitoring, and logging SQL jobs with JAMS. Then, we’ll show you how to leverage one centralized automation solution to manage all your SQL jobs, and combine them into powerful business workflows that span on-premise, cloud, and hybrid instances.