Nr: 395
SQLSaturday #395 - Baltimore - BI Edition 2015
SessionID: 23995
Using Common Table Expressions (CTE)
Event Date: 09-05-2015 - Session time: 08:30:00 - Track: DEV
Speaker: Ben Galluzzo
Title: Using Common Table Expressions (CTE)
Abstract:
Common Table Expressions (CTE) are a temporary result set used within an SQL statement, such as SELECT, INSERT, UPDATE, or DELETE, that can be used in place of a subquery and can help simplify more complex queries such as when joining to the same result set multiple times.
We'll begin with an overview of how a Common Table Expression is constructed. Then we'll build some queries using derived tables, and as the queries we build get more unwieldy, demonstrate how the query can be simplified by the use of a CTE.
SessionID: 35604
Intro to Power BI
Event Date: 09-05-2015 - Session time: 08:30:00 - Track: BI 1
Speaker: Azhagappan Arunachalam
Title: Intro to Power BI
Abstract:
SessionID: 35718
Modeling For Tableau
Event Date: 09-05-2015 - Session time: 08:30:00 - Track: BI 2
Speaker: Jennifer Kenney
Title: Modeling For Tableau
Abstract:
SessionID: 35916
Event Date: 09-05-2015 - Session time: 08:30:00 - Track: BI 3
Speaker: Tim Mitchell
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
SessionID: 35972
Execution Plans 101
Event Date: 09-05-2015 - Session time: 08:30:00 - Track: DBA
Speaker: Eugene Meidinger
Title: Execution Plans 101
Abstract:
Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, 5 common troublemakers, and where to learn more. If an execution plan looks like hieroglyphics, this course is for you!
SessionID: 36291
Automating Your SSIS Design Pattern for Faster Development
Event Date: 09-05-2015 - Session time: 08:30:00 - Track: BI 3
Speaker: Samuel Vanga
Title: Automating Your SSIS Design Pattern for Faster Development
Abstract:
Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages.
BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.
SessionID: 17816
Automated SQL Server installation and configuration using PowerShell
Event Date: 09-05-2015 - Session time: 09:50:00 - Track: DBA
Speaker: Jamie Wick
Title: Automated SQL Server installation and configuration using PowerShell
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
SessionID: 27594
Introduction to APS
Event Date: 09-05-2015 - Session time: 09:50:00 - Track: BI 2
Speaker: Warren Sifre
Title: Introduction to APS
Abstract:
We will have a conversation of what is APS and specifically how it differs from the normal SQL Server instances we work with daily. By the end of this talk, you will have a very good understanding of the differences between the APS' MPP architecture compared to SMP SQL Server. We will cover the topic of Polybase and what Hadoop Components are supported by Polybase.
SessionID: 35917
Introduction to Biml
Event Date: 09-05-2015 - Session time: 09:50:00 - Track: BI 3
Speaker: Tim Mitchell
Title: Introduction to Biml
Abstract:
In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
SessionID: 35918
A "101" Overview of Microsoft Power BI for Office 365
Event Date: 09-05-2015 - Session time: 09:50:00 - Track: BI 1
Speaker: Timothy McAliley
Title: A "101" Overview of Microsoft Power BI for Office 365
Abstract:
SessionID: 35971
Getting in Sync With The Developer Next To You
Event Date: 09-05-2015 - Session time: 09:50:00 - Track: DEV
Speaker: Brad McKuhen
Title: Getting in Sync With The Developer Next To You
Abstract:
SessionID: 36287
SQL Clinic Part 1
Event Date: 09-05-2015 - Session time: 09:50:00 - Track: PRO
Speaker: Harsh Deep Singh
Title: SQL Clinic Part 1
Abstract:
SQL Clinic is an open board discussion lead by couple of Microsoft field engineers.
If you have any SQL related problem or question, you can go there and ask and get an answer for free.
If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
SessionID: 16681
Analysis Services: Multidimensional vs Tabular
Event Date: 09-05-2015 - Session time: 11:10:00 - Track: BI 1
Speaker: Jessica Moss
Title: Analysis Services: Multidimensional vs Tabular
Abstract:
The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
SessionID: 22438
Normalize because you need it
Event Date: 09-05-2015 - Session time: 11:10:00 - Track: DEV
Speaker: Raj More
Title: Normalize because you need it
Abstract:
When you design a Transactional System, learn to make decisions on what to normalize based on business rules, not just on the basis of the 1NF through 6NF (nothing wrong with the rules, but I do encourage that you understand your data as well as the rules).
For example, do you need to which of the two addresses and order was shipped to? Which credit card out of the three that you have on file was used on the 106th order for this customer?
My talk is based on breaking out a different table because you need to keep track of the data - when, as a part of your design or maintenance, it dawns on you that this particular piece of data is relevant to the present, and to past events, and needs to be kept track of.
I back my suggestions with experience from designing Transactional Database Systems with 600+ tables used to keep track of multiple threads of information, passing relevant information on to efficient reporting structures.
SessionID: 35742
Optimizing your data warehouse for OLAP Processing
Event Date: 09-05-2015 - Session time: 11:10:00 - Track: DBA
Speaker: Konstantin Melamud
Title: Optimizing your data warehouse for OLAP Processing
Abstract:
SessionID: 35820
ETL Design - Staging
Event Date: 09-05-2015 - Session time: 11:10:00 - Track: BI 3
Speaker: Philip Noakes
Title: ETL Design - Staging
Abstract:
SessionID: 36136
3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Event Date: 09-05-2015 - Session time: 11:10:00 - Track: BI 2
Speaker: David Patrick
Title: 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Abstract:
Need to report on some data from SharePoint? We'll look at three different techniques to pull data from a SharePoint Server. We'll start with SSIS and the SharePoint List Source and Destinations. Next, we'll use Excel to connect to various SharePoint lists (both online and on premise), and finally we'll use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, we'll have three different ways to get data from SharePoint.
SessionID: 36288
SQL Clinic Part 2
Event Date: 09-05-2015 - Session time: 11:10:00 - Track: PRO
Speaker: Harsh Deep Singh
Title: SQL Clinic Part 2
Abstract:
SQL Clinic is an open board discussion lead by couple of Microsoft field engineers.
If you have any SQL related problem or question, you can go there and ask and get an answer for free.
If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
SessionID: 36289
SQL Clinic Part 3
Event Date: 09-05-2015 - Session time: 12:55:00 - Track: PRO
Speaker: Harsh Deep Singh
Title: SQL Clinic Part 3
Abstract:
SQL Clinic is an open board discussion lead by couple of Microsoft field engineers.
If you have any SQL related problem or question, you can go there and ask and get an answer for free.
If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
SessionID: 36346
MDM with Profisee. Usage, Value and First Steps
Event Date: 09-05-2015 - Session time: 12:55:00 - Track: Reserved
Title: MDM with Profisee. Usage, Value and First Steps
Abstract:
Overview of MDM, Profisee, value of our solution, how organizations are using MDM, and how you can get started with an MDM project
SessionID: 36347
Micron Presenting
Event Date: 09-05-2015 - Session time: 12:55:00 - Track: Reserved
Title: Micron Presenting
Abstract:
SessionID: 36348
Microsoft Presenting
Event Date: 09-05-2015 - Session time: 12:55:00 - Track: Reserved
Title: Microsoft Presenting
Abstract:
SessionID: 36349
Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Event Date: 09-05-2015 - Session time: 12:55:00 - Track: Reserved
Title: Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract:
Eric Simpson, Cisco
Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.
SessionID: 11297
Hacking Expos#233; - Using SSL to Protect SQL Connections
Event Date: 09-05-2015 - Session time: 14:00:00 - Track: DBA
Speaker: Chris Bell
Title: Hacking Expos#233; - Using SSL to Protect SQL Connections
Abstract:
Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
SessionID: 11721
Creating solid Power Pivot data models
Event Date: 09-05-2015 - Session time: 14:00:00 - Track: BI 1
Speaker: Dan Clark
Title: Creating solid Power Pivot data models
Abstract:
At the core of every successful data analysis project is a robust data model. In this session, Dan will take you through the process of creating a solid data model in Power Pivot. You will learn how to import data from various sources, combine these in a scalable data model. In addition, you will discover how you can set various properties in the Power Pivot model to enhance the user experience when they create interactive visualisations of the data in Power View.
SessionID: 18879
Event Date: 09-05-2015 - Session time: 14:00:00 - Track: BI 2
Speaker: Ravi Kumar
Abstract:
SessionID: 21809
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 09-05-2015 - Session time: 14:00:00 - Track: BI 3
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 35603
SQL Server Internals Party: Storage, Memory and the Query Life-cycle
Event Date: 09-05-2015 - Session time: 14:00:00 - Track: DEV
Speaker: Ayman El-Ghazali
Title: SQL Server Internals Party: Storage, Memory and the Query Life-cycle
Abstract:
Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB BI Developers and System Administrators. Party hats not included, rated G for Geeks.
SessionID: 35978
Lights, Camera, Action: Introduction to Creating and Delivering Presentations
Event Date: 09-05-2015 - Session time: 14:00:00 - Track: PRO
Speaker: Jessica Moss
Title: Lights, Camera, Action: Introduction to Creating and Delivering Presentations
Abstract:
Sharing your technical knowledge can be a gift for both you and others. But how would you share your knowledge through a presentation? There are so many things to consider: what topic to discuss, where should you present, and should you really imagine the audience naked. This presentation covers these topics, along with much more. Before long, you too can share the gift of presenting!
SessionID: 23994
MongoDB for SQL Developers and Accessing MongoDB with SSIS
Event Date: 09-05-2015 - Session time: 15:20:00 - Track: BI 3
Speaker: Ben Galluzzo
Title: MongoDB for SQL Developers and Accessing MongoDB with SSIS
Abstract:
Just because NoSQL is taking off doesn't mean that SQL developers are left behind. We'll begin with an overview of what MongoDB and NoSQL is and how it relates to our existing world of SQL. Then, we'll go over some of terminology in MongoDB and how these terms map to the SQL world. Lastly, we'll demonstrate how we can work with MongoDB from SSIS.
SessionID: 27768
Windowing Functions in SQL Server 2012
Event Date: 09-05-2015 - Session time: 15:20:00 - Track: DEV
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 35624
The Quest for the Golden Record: MDM Best Practices
Event Date: 09-05-2015 - Session time: 15:20:00 - Track: BI 1
Speaker: Brian Benzel
Title: The Quest for the Golden Record: MDM Best Practices
Abstract:
In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.
SessionID: 35812
Securing Multi-Database Reports
Event Date: 09-05-2015 - Session time: 15:20:00 - Track: DBA
Speaker: Sebastian Meine
Title: Securing Multi-Database Reports
Abstract:
It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable.
In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
SessionID: 35970
Tips and Tricks for Managing SharePoint Databases
Event Date: 09-05-2015 - Session time: 15:20:00 - Track: BI 2
Speaker: Alara Rogers
Title: Tips and Tricks for Managing SharePoint Databases
Abstract:
SharePoint, the 800-pound gorilla that has probably eaten a great deal of space on your SQL Server, has certain consistent idiosyncrasies that can make trouble for a DBA. This session will go over some of the problems SharePoint frequently causes, or that you may encounter in managing databases for it.
SessionID: 35977
Dealing With Difficult People
Event Date: 09-05-2015 - Session time: 15:20:00 - Track: PRO
Speaker: Gigi Bell
Title: Dealing With Difficult People
Abstract:
John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.