Nr: 506
SQLSaturday #506 - Baltimore - BI Edition 2016
SessionID: 46020
SQL Server Internals: The Practical Angle - Part 1
Event Date: 30-04-2016 - Session time: 08:00:00 - Track: DBA
Speaker: Dmitri Korotkevitch
Title: SQL Server Internals: The Practical Angle - Part 1
Abstract:
A deep understanding of SQL Server internals makes it much easier to design and maintain efficient SQL Server solutions. Unfortunately, database professionals who lack this knowledge often make design and implementation decisions that adversely affect their systems.
This pre-conference session helps to address these issues and shows you how SQL Server components work under the hood, work together and communicate with one another, and most importantly, affect your systems. The session is based on the book “Pro SQL Server Internals” (http://www.amazon.com/dp/1430259620), includes numerous demos, and discusses answers to the following questions:
- How does SQL Server store data and use indexes,
(See Part 2 for more details)
SessionID: 46409
Full day precon: Building Better SSIS Packages
Event Date: 30-04-2016 - Session time: 08:00:00 - Track: BI
Speaker: Tim Mitchell
Title: Full day precon: Building Better SSIS Packages
Abstract:
Building packages in SQL Server Integration Services is easy. Building good packages takes a bit more effort.
SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be:
• Reliable
• Resilient
• Reusable
• Maintainable
• Well performing
There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages.
In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices.
SessionID: 46021
SQL Server Internals: The Practical Angle - Part 2
Event Date: 30-04-2016 - Session time: 12:30:00 - Track: DBA
Speaker: Dmitri Korotkevitch
Title: SQL Server Internals: The Practical Angle - Part 2
Abstract:
The session can also help database pros who prefer to understand and fix the root cause of a problem rather than simply applying a bandage. The session is based on the book “Pro SQL Server Internals” (http://www.amazon.com/dp/1430259620), includes numerous demos, and discusses answers to the following questions:
- How does SQL Server store data and use indexes, and how can you efficiently design and maintain them?
- What is the internal implementation of the various database objects, and when should they be used or not be used?
- How do you troubleshoot and fix concurrency issues and design efficient transaction strategies?
- How does SQL Server execute queries, and how are the most common plan-caching-related issues addressed?
- How do you quickly identify and resolve issues and bottlenecks in systems?
SessionID: 43099
Optimizing the SQL Server and Databases for large Fact Tables
Event Date: 30-04-2016 - Session time: 08:30:00 - Track: DBA
Speaker: Thomas Grohser
Title: Optimizing the SQL Server and Databases for large Fact Tables
Abstract:
A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.
We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.
SessionID: 44150
Going beyond SELECT *
Event Date: 30-04-2016 - Session time: 08:30:00 - Track: DEV
Speaker: Eugene Meidinger
Title: Going beyond SELECT *
Abstract:
SessionID: 44734
Advanced SQL Server Analysis Services
Event Date: 30-04-2016 - Session time: 08:30:00 - Track: BI
Speaker: Kevin Goff
Title: Advanced SQL Server Analysis Services
Abstract:
This session will go well beyond creating SSAS cubes with the cube wizard. I'll cover topics such as the pros and cons of ROLAP, XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code, Advanced MDX in SSRS, Partitioning and Aggregations, Data Driven KPIs, and Dimension Attribute Discretization.
SessionID: 45121
Event Date: 30-04-2016 - Session time: 08:30:00 - Track: BI
Speaker: David Patrick
Abstract:
SessionID: 47343
Would You Just Load Already?! Maximizing Your SSIS Data Load
Event Date: 30-04-2016 - Session time: 08:30:00 - Track: BI
Speaker: Chris Bell
Title: Would You Just Load Already?! Maximizing Your SSIS Data Load
Abstract:
In this session you will learn a simple method to load data via SSIS and identify, remove, and record those bad records allowing you to maximize the amount of data loaded while ensuring data integrity.
SessionID: 47790
SSRS Episode 2016 - The Reports Awaken!
Event Date: 30-04-2016 - Session time: 08:30:00 - Track: BI
Speaker: Ayman El-Ghazali
Title: SSRS Episode 2016 - The Reports Awaken!
Abstract:
In an IT Department far, far away...
SSRS in the BI Galaxy has vanished. Due to this absence, other non-sinister reporting tools have risen from the ashes of this Global Industry and will not rest until SSRS 2016, the latest Reporting tool, has been defeated. With the support of brave BI developers like yourself, we will lead the new way of BI reporting in the future. Armed with the latest in Paginated and Mobile Reports, it is time to restore peace and justice in the BI Galaxy that depends on us!
In English, we're going to take a look at the latest edition for SQL Server Reporting Services.
SessionID: 44184
Peanut Butter Chocolate: Integrating Hadoop with SQL Server
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: DEV
Speaker: Kevin Feasel
Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server
Abstract:
SessionID: 44735
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: BI
Speaker: Kevin Goff
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, and more.
SessionID: 45319
Power BI Desktop Fundamentals
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: BI
Speaker: Junaith Haja
Title: Power BI Desktop Fundamentals
Abstract:
SessionID: 45432
Introduction to Biml
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: BI
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: 48835
Disaster Recovery Options with Azure
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: DBA
Speaker: Carlos L Chacon
Title: Disaster Recovery Options with Azure
Abstract:
Recovery in the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recover in Azure.
SessionID: 48858
SQL Auditing - Getting A View Of Yesterday's Activity Today
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: DBA
Speaker: Brad McKuhen
Title: SQL Auditing - Getting A View Of Yesterday's Activity Today
Abstract:
SessionID: 49257
PolyBase: I now pronounce you SQL and Hadoop
Event Date: 30-04-2016 - Session time: 09:50:00 - Track: BI
Speaker: Ayman El-Ghazali
Title: PolyBase: I now pronounce you SQL and Hadoop
Abstract:
If you thought the Royal wedding of 2011 was a big deal, then you're about to be blown away! This is a match made in Data Heaven. You're all invited, no need to RSVP, there is plenty of food for thought in this session. There will be some background talk and a demo for querying and creating data on HDFS (using Azure Blobs). As a special gift to the happy couple, we will also have a special demo with JSON documents. This will be the greatest coming together of 2016! See you there!
SessionID: 43113
Use Biml to Automate SSIS Design Patterns
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: BI
Speaker: Andy Leonard
Title: Use Biml to Automate SSIS Design Patterns
Abstract:
Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.
In this session, you will learn:
- How to rapidly build multiple SSIS packages using Biml
- How to apply different SSIS Design Patterns using Biml
- How to automate SSIS Design Patterns using Biml
SessionID: 44783
Setting up your BI Infrastructure
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: BI
Speaker: Paresh Motiwala
Title: Setting up your BI Infrastructure
Abstract:
We know BI in bits and pieces. But imagine if you had to setup the BI infrastructure from scratch.
What do we need to consider, which players do we consider, what are the components, the HA/DR scenario for the same, what technology to use? These are the questions we will answer along the way.
In this fast paced, information packed session; we will look at:
- Selection of RDBMS
- Selection/Setup of Reporting Infrastructure
- Selection/Setup of ETL Infrastructure
- Forming BI IT Team
- Forming Users Team
- Training
- Security of BI environment
- Managing Copy Data and Copy Data Virtualization
- Data Warehouse
- Utilizing Cloud
- Collaborative Computing
- Deciding what parts of BI to centralize and what to distribute.
- Scope Creep
- Success criteria
- Redundancy
- Maintenance
We will look at the best practices involved in creating a BI infrastructure. Time permitting, we can discuss whether to outsource this project or rise above our DBA job
SessionID: 45515
Top 10 Wait Types Everyone Should Know
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: DBA
Speaker: Janis Griffin
Title: Top 10 Wait Types Everyone Should Know
Abstract:
SessionID: 45605
Getting to know U-SQL
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: BI
Speaker: Azhagappan Arunachalam
Title: Getting to know U-SQL
Abstract:
SessionID: 46044
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: DBA
Speaker: Stan Geiger
Abstract:
SessionID: 46698
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: BI
Speaker: Mark Hudson
Abstract:
Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
SessionID: 48641
Table Vars and Temp Tables – What you NEED to Know!
Event Date: 30-04-2016 - Session time: 11:10:00 - Track: DEV
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables – What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 49895
Event Date: 30-04-2016 - Session time: 12:55:00 - Track: Other
Abstract:
SessionID: 49897
SQL Games
Event Date: 30-04-2016 - Session time: 12:55:00 - Track: Other
Title: SQL Games
Abstract:
SQL fun games for IT Professionals
SessionID: 50024
Event Date: 30-04-2016 - Session time: 12:55:00 - Track: Other
Speaker: Janis Griffin
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
SessionID: 43091
Let's Talk About Your Model: Simple Modeling Solutions to Complex Problems
Event Date: 30-04-2016 - Session time: 14:00:00 - Track: DEV
Speaker: Greg Baldini
Title: Let's Talk About Your Model: Simple Modeling Solutions to Complex Problems
Abstract:
• 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: 45183
Azure Machine Learning – Bringing Advanced Analytics to the Masses
Event Date: 30-04-2016 - Session time: 14:00:00 - Track: BI
Speaker: Dan Clark
Title: Azure Machine Learning – Bringing Advanced Analytics to the Masses
Abstract:
SessionID: 45434
Managing Security in SSIS
Event Date: 30-04-2016 - Session time: 14:00:00 - Track: BI
Speaker: Tim Mitchell
Title: Managing Security in SSIS
Abstract:
In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover:
Properly securing connection passwords in SSIS
Using package protection levels
Restricting access to deployed packages
Using role-based security for SSIS deployment and execution
Using execution proxies
SessionID: 48226
7 steps to better career opportunities
Event Date: 30-04-2016 - Session time: 14:00:00 - Track: Pro
Speaker: Carlos L Chacon
Title: 7 steps to better career opportunities
Abstract:
SessionID: 48400
Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing
Event Date: 30-04-2016 - Session time: 14:00:00 - Track: BI
Speaker: Jeremy Frye
Title: Speed Up Your SSAS Cube's Data Refresh With Dynamic Partition Processing
Abstract:
Are you sometimes plagued with the unfortunate event of your SSAS cube refresh exceeding the scheduled maintenance window? Maybe you simply need to update recent data to reflect a critical change during business hours, but can’t afford several hours of downtime. I have a solution for you! In this session, we will focus on building an ETL framework while leveraging your cube’s logical partition design to dynamically process only the necessary data within your measure group. We will discuss audit logging, cube processing options, partition design and metadata access. These techniques and strategies will provide a faster data refresh process for your warehouse or data mart.
SessionID: 49355
Data Partitioning for Database Architects and Mere Mortals
Event Date: 30-04-2016 - Session time: 14:00:00 - Track: DBA
Speaker: Dmitri Korotkevitch
Title: Data Partitioning for Database Architects and Mere Mortals
Abstract:
SessionID: 44798
Working with SSRS Data-Driven Subscriptions
Event Date: 30-04-2016 - Session time: 15:15:00 - Track: BI
Speaker: Ben Galluzzo
Title: Working with SSRS Data-Driven Subscriptions
Abstract:
SSRS Subscriptions are one of the great things within SSRS to automate delivery of reports. However, one of the more powerful methods of further enhancing this automation is by use of data-driven subscriptions. Data-driven subscriptions allow us to determine at run time what subscribers and other parameters can be used for automating generating these reports.
We'll begin with a quick overview of what the more familiar subscription functionality is and then quickly jump into what data-driven subscriptions provide for us. We'll then demonstrate from beginning to end how to implement data-driven-subscriptions. Lastly, we'll wrap up with any tips and tricks to enhance our process.
SessionID: 45503
Successfully Virtualizing SQL Server on vSphere
Event Date: 30-04-2016 - Session time: 15:15:00 - Track: Pro
Speaker: Deji Akomolafe
Title: Successfully Virtualizing SQL Server on vSphere
Abstract:
Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First" is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring it!
SessionID: 47450
Dealing With Difficult Managers
Event Date: 30-04-2016 - Session time: 15:15:00 - Track: Pro
Speaker: Gigi Bell
Title: Dealing With Difficult Managers
Abstract:
We have all encountered difficult managers that leave us stressed out. They can be micro-managers, bullies, too timid, or even just apathetic. In any case, you are currently stuck with this manager, and you need coping strategies!
Through case studies and open discussion, we will help you determine if you indeed have a difficult manager. We will identify and categorize behavior patterns of managers so that you can determine the best strategies to deal with him or her. In addition, we will also explore the consequences of these actions, and how they can help you to succeed in furthering your career.
SessionID: 49356
Event Date: 30-04-2016 - Session time: 15:15:00 - Track: DEV
Speaker: Dmitri Korotkevitch
Abstract:
This session shows several common mistakes and inefficiencies that can be found in many production systems such as excessive code reuse in the database using the views and multi-statement functions and in the data access code; unnecessary joins and I/O operations in pagination queries; storage of multiple entities in the same tables using XML for entities-specific attributes; usage of the optional parameters in the where clause of the queries; and several others. The session explains the root-cause of performance issues those mistakes introduce and demonstrates how to properly address them in the code and database design.
SessionID: 49892
Security for your BI data
Event Date: 30-04-2016 - Session time: 15:15:00 - Track: BI
Speaker: Thomas Grohser
Title: Security for your BI data
Abstract:
What is Security and how the manage security for your data at rest, during the ETL and reporting process across multiple servers and in HA/DR situations.
Handling permissions on a read only copy (readable mirror or snapshot) or individual permissions on a column are just two examples of topics this session filled with best practices will cover. This session focuses on the protection of the raw data and how to secure it from users, admins and everyone else.