Nr: 628
SQLSaturday #628 - Baton Rouge 2017
SessionID: 64851
Power BI: From the Desktop to the Enterprise
Event Date: 29-07-2017 - Session time: 08:00:00 - Track: Business Intelligence
Speaker: Patrick LeBlanc
Title: Power BI: From the Desktop to the Enterprise
Abstract:
Registration link:
https://www.eventbrite.com/e/power-bi-from-the-desktop-to-the-enterprise-all-day-w-microsoft-experts-tickets-34709769856
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly, blog posts are flying across twitter. How can you keep up? In this full day session I will explain and demonstrate how to implement a full enterprise Power BI solution. This will include preparing your organizations network for Power BI, deciding if you need to build an SSAS Semantic Model or will the Power BI desktop work as an alternative. In addition, there will be a few hand-on labs that will help each attendee get started working with both the Power BI Desktop and the Power BI Service. Bring your laptop, grab a cup of coffee and get ready to learn. See the high-level agenda below:
Preparing Your Organization for Power BI,
To Data Warehouse or Not,
Introduction to the Power BI Desktop,
Introduction to the Power BI Service,
Con
SessionID: 61176
Women in Technology: Identifying and Understanding Gender Bias Inequality
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: Professional Development
Speaker: Rie Irish
Title: Women in Technology: Identifying and Understanding Gender Bias Inequality
Abstract:
Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women job responsibilities. We'll learn how to identify gender bias when we see it. We'll discuss why it's important, how it affects our work, decision making, hiring, etc. We'll discuss strategies for how both men and women can combat this at work in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.
SessionID: 63441
Hostile Takeover
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: SQL Server Administration
Speaker: Robert Bishop
Title: Hostile Takeover
Abstract:
SessionID: 63994
Branding Yourself for a Dream Job
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: Professional Development
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 64513
T-SQL's Hidden Support Feature
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: SQL Server Development
Speaker: Jennifer McCown
Title: T-SQL's Hidden Support Feature
Abstract:
#160;
In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond.#160; These methods help prevent errors and reduce troubleshooting.
SessionID: 64729
PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: PowerShell
Speaker: Mike Robbins
Title: PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell
Abstract:
SessionID: 65094
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: Mobile App Dev
Speaker: David Silver
Abstract:
SessionID: 65377
Introduction to Azure Analysis Services
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: Business Intelligence
Speaker: Patrick LeBlanc
Title: Introduction to Azure Analysis Services
Abstract:
You have been wanting to using SQL Server Analysis Services, but just don't have the physical resources on-premises to set one up. Analysis Services has typically shipped with SQL Server on premises, but now it has been implemented as a fully managed service in Azure. Join this session to learn how to create a and deploy a model, load and refresh data using Azure functions, secure the model, view the model and a little about pricing.
SessionID: 65495
What's new with Power BI
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: Business Intelligence
Speaker: Adam Saxton
Title: What's new with Power BI
Abstract:
A lot of changes have come to Power BI. Do you understand how Premium fits in? What is an app workspace and why would you use it? And, what the heck is a capacity? We will take a look at Premium, Apps and App Workspaces along with the changes to embedding. We will also see how Power BI Report Server fits into the picture.
SessionID: 66310
Managing SSRS Reports using PowerShell and SSRS Web Services
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: PowerShell
Speaker: Russel Loski
Title: Managing SSRS Reports using PowerShell and SSRS Web Services
Abstract:
When you have to do something more than once, you should script it! That’s true for SQL Server maintenance tasks. It’s also important for Business Intelligence projects as well. Microsoft has provided web services to manage your reporting service and to download reports in various forms. In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks: uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh. I addition, I demonstrate how to download a report top PDF using PowerShell. You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts.
SessionID: 66343
Should your spreadsheet be a database?
Event Date: 29-07-2017 - Session time: 09:15:00 - Track: SQL Server Beginner
Speaker: Jonathan Jefferson
Title: Should your spreadsheet be a database?
Abstract:
This session will discuss the pros and cons of Excel spreadsheets for data storage, basic database design, and tips for importing an existing Excel spreadsheet into SQL Server.
SessionID: 61352
Careers in IT - Baton Rouge 2017
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Career
Speaker: Michael Viron
Title: Careers in IT - Baton Rouge 2017
Abstract:
Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session. This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.
SessionID: 61505
Dynamic SQL: Tables, Pivots
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: SQL Server Development
Speaker: Steven Tidwell
Title: Dynamic SQL: Tables, Pivots
Abstract:
SessionID: 61668
Giving Feedback: How to Effectively Communicate to your Employees
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Giving Feedback: How to Effectively Communicate to your Employees
Abstract:
SessionID: 61721
In-Memory Indexes: Part 2 -- The rest of the story!
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Windows Server/Virtualization
Speaker: Mike Byrd
Title: In-Memory Indexes: Part 2 -- The rest of the story!
Abstract:
This session is a continuation of my in-memory table presentation (Part 1) given at 8 SQL Saturdays in 2016 only now concentrating on in-memory indexes. This session will do an in-depth dive into hash, range, and columnstore indexes in the in-memory environment. It will be about 30% presentation and 70% demos with emphasis on when and how to apply in-memory indexes for stated environments/scenarios.
After this session you will
- Understand the three in-memory index types, how to create, and when to apply them for selected scenarios
- Be able to identify performance gains over equivalent disk back tables/indexes
- Comprehend the new data monitoring needed for in-memory tables/indexes
SessionID: 63710
Getting Started with .NET Core
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: .NET Dev
Speaker: Brandon Cornett
Title: Getting Started with .NET Core
Abstract:
Heard of .NET Core, but not taken the time to look in to it? Started looking at it, but been discouraged by the seemingly endless stream of breaking changes to the architecture? Played around with it, but want to know what the framework code you're typing is actually doing? This talk aims to answer some of your questions about .NET Core, what it is, how it's structured, middleware, and the differences between it and the .NET Framework. We'll also have a brief introduction to ASP.NET Core.
SessionID: 64854
Power BI: Customer Stories from the Frontline
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Business Intelligence
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: 64869
React Native - So real you can taste it
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Mobile App Dev
Speaker: Justin Obney
Title: React Native - So real you can taste it
Abstract:
With React Native, you don't build a “mobile web app”, an “HTML5 app”, or a “hybrid app”. You build a real mobile app that's indistinguishable from an app built using Objective-C or Java. React Native uses the same fundamental UI building blocks as regular iOS and Android apps. You just put those building blocks together using JavaScript and React.
SessionID: 64994
Monster VM's (Database Virtualization)
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: SQL Server Administration
Speaker: Michael Corey
Title: Monster VM's (Database Virtualization)
Abstract:
SessionID: 65106
Python in SQL Server 2017
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Business Intelligence
Speaker: Chris Hyde
Title: Python in SQL Server 2017
Abstract:
SQL Server 2017 is right around the corner, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple 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 Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
SessionID: 65811
What’s new for SQL Server Analysis Services?
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: Business Intelligence
Speaker: Thomas LeBlanc
Title: What’s new for SQL Server Analysis Services?
Abstract:
When an Analysis Service database gets created in an enterprise, and users start to report against, it is very hard not to continue to expand the model. Comfort is obtained when a new release of Analysis Services comes along adding functionality to replace the hooks created to satisfy user requirements. With 2016 and 2017, we are seeing the move to update Tabular Models with improved performance and better security. The Multidimensional Cube additions are mainly with new Data Sources and better T-SQL generated to access source databases like Oracle and Teradata.
SessionID: 66281
Event Date: 29-07-2017 - Session time: 10:30:00 - Track: PowerShell
Speaker: Rohn Edwards
Abstract:
SessionID: 61080
Polybase, Didn't that go out with the 70's?
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: SQL Server Development
Speaker: Stan Geiger
Title: Polybase, Didn't that go out with the 70's?
Abstract:
SessionID: 63960
Improving Your Management Skills
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: Professional Development
Speaker: David Reid
Title: Improving Your Management Skills
Abstract:
SessionID: 63993
Bringing DevOps to the Database
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: SQL Server Development
Speaker: Steve Jones
Title: Bringing DevOps to the Database
Abstract:
DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
SessionID: 63997
Gimgen - Going Deep With Javascript Generators
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: Mobile App Dev
Speaker: George Mauer
Title: Gimgen - Going Deep With Javascript Generators
Abstract:
Javascript generators are a fascinating addition to the language. In this session we will go deep into how they work, how they're useful, and culminate with a discussion of how they are used in the gimgen library to create a novel reactive programming library.
SessionID: 64225
Programming in Power Query: An Introduction to M
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: Business Intelligence
Speaker: Andy Parkerson
Title: Programming in Power Query: An Introduction to M
Abstract:
We then look at what to do when the information you get is incomplete and contradictory. Cleaning up data and handling errors and missing data will be our focus in an example of combining multiple data sources into a single data set. We consider this crucial step in the ETL cycle.
Our examination will conclude with a discussion of best practices, centering on coding style and deciding on when to solve a problem with M versus when to rely on DAX.
SessionID: 64319
Taking Time for You
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: Professional Development
Speaker: Karlyn LeBlanc
Title: Taking Time for You
Abstract:
As a working professional, one spends an enormous amount of time creating, maintaining and updating your work skills. The rat race of everyday life, work, work and more work have many people "caught up". The focus becomes, all too often how fast can I move up the corporate ladder? I need to make more money. How can I create a better brand? On top of all of that, one has to make sure to spend time with their family. So…when is there time for YOU? Join me in an interactive session where I will provide various tools and techniques to assist you with improving your quality of life. Ultimately helping you to create a better you.
SessionID: 64463
Pester the Tester: PowerShell Bugs Beware!
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: PowerShell
Speaker: Robert Cain
Title: Pester the Tester: PowerShell Bugs Beware!
Abstract:
So you've been developing PowerShell for a while, or perhaps you're taking over maintenance of an existing set of scripts. It would be great to get extra confidence in your scripts through testing, but how? You're in luck, there's a new module in town, Pester!
Pester is a friendly testing framework designed for testing your PowerShells scripts and modules. In this session you'll be introduced to Pester. You'll see how to use Pester to uncover bugs, as well as using it for test driven development. Make your own PowerShell more robust through the use of Pester. Kill those PowerShell bugs, dead!
SessionID: 64620
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: Business Intelligence
Speaker: Jamey Johnston
Abstract:
Come to this session to get an introduction to the R language including:
- installing and Configuring R and RStudio
- RStudio Overview and Debugging
- how to Access and Manipulate Data
- install and Manage Packages
- create and Use Variables
- control Flows
- functions
- basic Graphing and Statistical Analysis.
We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
SessionID: 64852
Introduction to the Power BI Desktop
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: PowerBI
Speaker: Patrick LeBlanc
Title: Introduction to the Power BI Desktop
Abstract:
Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
SessionID: 65382
Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: SQL Server Administration
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: 68484
How to talk to your Storage Admin
Event Date: 29-07-2017 - Session time: 12:15:00 - Track: SQL Server Administration
Speaker: Marsha Pierce
Title: How to talk to your Storage Admin
Abstract:
SessionID: 61114
SQL Server Statistics – What Are The Chances?
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: SQL Server Administration
Speaker: Lori Edwards
Title: SQL Server Statistics – What Are The Chances?
Abstract:
For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014 2016. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.
SessionID: 61174
How to Build Your Disaster Recovery Plan
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: SQL Server Administration
Speaker: Rie Irish
Title: How to Build Your Disaster Recovery Plan
Abstract:
SessionID: 62623
Navigating an Internship: Tips for beginning a career as a software developer.
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: Career
Speaker: Jay Tulk
Title: Navigating an Internship: Tips for beginning a career as a software developer.
Abstract:
An internship is the first step of a long journey in your career. This session focuses on professionalism, best practices, productivity tips, and how to maximize the benefit that an internship provides both in and out of a new workplace.
SessionID: 64621
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Jamey Johnston
Abstract:
The session will work through a real data science example from Import, Tidy, Transform, Visualize, Model and finally Communicate your results. No prior statistics knowledge is needed just a basic understanding of R.
In this session, we will use Microsoft R Server, R Tools for Visual Studio and Power BI to work through a Data Science problem.
SessionID: 64866
Parallel Programming, an Introduction
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: .NET Dev
Speaker: Matthew Puneky
Title: Parallel Programming, an Introduction
Abstract:
While this is a beginner presentation, it is recommend that you have a firm grasp of coding basics.
The language specific examples will be given in C#.
SessionID: 64968
Trends in the Cloud
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: IT Executive
Speaker: Michael Corey
Title: Trends in the Cloud
Abstract:
After 11 years of existence, the cloud industry would have you believe it is a mature, stable industry that is safe and secure to take your business to. Yet, the secret the insiders in the know is caveat emptor: Let the buyer beware. This presentation covers the state of the cloud today, lessons learned from the early adopters, the new role of cloud keeper, and what to know in advance to create a successful cloud deployment. It ends with a checklist you can use ensure you choose a cloud provider that can meet your needs.
SessionID: 65140
Twilight TimeZone: Handling Time in Your App Architecture
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: .NET Dev
Speaker: William Assaf
Title: Twilight TimeZone: Handling Time in Your App Architecture
Abstract:
SessionID: 65203
Exploring the All-New SSRS 2016
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Tim Mitchell
Title: Exploring the All-New SSRS 2016
Abstract:
For years, SQL Server Reporting Services chugged along with very few updates. Although it remained a reliable and popular reporting tool, the feature set largely remained unchanged for a decade. With the release of SQL Server 2016, everything changed. Microsoft delivered a brand new SSRS. This session will review and demonstrate the new features of SQL Server Reporting Services 2016. You'll walk through the essential changes in SSRS, from the new report manager to the new visualizations. You'll also discuss the SSRS ecosystem and how it fits together with PowerBI and other Microsoft reporting/analytics platforms.
SessionID: 65384
Beginning Automation with Powershell
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: PowerShell
Speaker: Amy Herold
Title: Beginning Automation with Powershell
Abstract:
SessionID: 65494
Using a gateway to leverage on-premises data in Power BI
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Adam Saxton
Title: Using a gateway to leverage on-premises data in Power BI
Abstract:
SessionID: 65553
Set Me Up: How to Think in Sets
Event Date: 29-07-2017 - Session time: 13:30:00 - Track: SQL Server Development
Speaker: Brian Hansen
Title: Set Me Up: How to Think in Sets
Abstract:
SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.
We will look at T-SQL features that can break set-based processing -- generally meaning poor performance -- and gather empirical evidence to support that assertion. We'll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.
SessionID: 61093
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: SQL Server Administration
Speaker: Stacy Gray
Abstract:
SessionID: 61177
Let Her Finish: Supporting Women's Voices from meetings to the board room
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: Professional Development
Speaker: Rie Irish
Title: Let Her Finish: Supporting Women's Voices from meetings to the board room
Abstract:
This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.
SessionID: 61646
App to Azure in 60 Minutes
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: .NET Dev
Speaker: Sven Aelterman
Title: App to Azure in 60 Minutes
Abstract:
Have you been thinking about moving your custom web app to Azure? You'll need to consider several aspects, and this session focuses on some of the technical ones. An existing demo application developed in ASP.NET MVC with a SQL Server backend will be moved over to run in Azure App Service and Azure SQL DB. Along the way, you'll see how to navigate the Azure Portal, consider benefits of Visual Studio Team Services, and have opportunities to see how an app can take advantage of additional Azure services.
SessionID: 61670
Mastering your Resume Interview: Tips to Get Hired
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Mastering your Resume Interview: Tips to Get Hired
Abstract:
Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.
SessionID: 63198
Async or Parallel? No they aren't the same thing!
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: .NET Dev
Speaker: Andie Saizan
Title: Async or Parallel? No they aren't the same thing!
Abstract:
I have frequently seen developers confuse async and parallel programming, not understanding that the purpose of each are quite different. Well designed modern .NET development is full of the async/await model, async/await is built on the Task model, but also async is not parallel. So understanding these concepts is key to long term success in building apps in .NET that are both responsive and most efficient.
SessionID: 64495
From problem to Power BI: A journey in data visualization
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: PowerBI
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: 64732
Automate Operational Readiness and Validation Testing of SQL Server with PowerShell and Pester
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: PowerShell
Speaker: Mike Robbins
Title: Automate Operational Readiness and Validation Testing of SQL Server with PowerShell and Pester
Abstract:
How do you know whether or not all of the SQL Servers in your environment are configured based on your organizations standards? How do you know whether or not they are all operating properly when maintenance is performed on the systems in your environment? During this session, Microsoft MVP Mike F Robbins will discuss and demonstrate how to use PowerShell and Pester to automate operational readiness and operational validation testing of your SQL Servers and the systems in your environment that depend on them. Prior experience with PowerShell is recommended.
SessionID: 65500
Data Modeling for the Modern Enterprise
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: Ryan Casey
Title: Data Modeling for the Modern Enterprise
Abstract:
Explore data modeling and process modeling.
Show Business Benefits and Value of Data Modeling
Data Modeling Approaches and Engineering
What does Acceptable Data Look Like
Entities, Attributes, Measures, and Keys
Relationships and Relationship Types
Normal Form Modeling
Star and Snow Flake Schema
Hybrid Schema
Slowly Changing Dimensions
Many to Many Relationships
Lookup Tables
Enterprise Data Model
Conceptual Data Model
Logical Data Model
Physical Data Model
Dimensional Model
Business Process Model
Trans Relational Model
SessionID: 65551
Get Your Optimizer to Give up All Its Secrets
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: SQL Server Administration
Speaker: Brian Hansen
Title: Get Your Optimizer to Give up All Its Secrets
Abstract:
SessionID: 66308
Querying Semistructured Data in Azure Data Lake with USQL
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: Russel Loski
Title: Querying Semistructured Data in Azure Data Lake with USQL
Abstract:
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
SessionID: 66320
Weird stuff I saw ... while supporting a Java team
Event Date: 29-07-2017 - Session time: 14:45:00 - Track: SQL Server Development
Speaker: Rick Lowe
Title: Weird stuff I saw ... while supporting a Java team
Abstract:
After spending more than a decade completely devoted to the Microsoft stack, I did some time supporting a Java team. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. But it is a different stack, different culture, and different group of folks giving bad advice to developers ... just enough different to keep life interesting. Come hear about my misadventures with server side cursors, output parameters, integrated authentication, and NOCOUNT settings.