Nr: 285
SQLSaturday #285 - Atlanta 2014
SessionID: 10687
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 10 DBA Radar Detectors
Speaker: Brandon Leach
Abstract:
In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation.
SessionID: 10849
SQL 2012 Table Compression
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 03 Admin Highway
Speaker: Jason Brimhall
Title: SQL 2012 Table Compression
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
SessionID: 11105
BIML--Step by Step
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 01 BI Roadshow
Speaker: Julie Smith
Title: BIML--Step by Step
Abstract:
BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, which enables exponentially faster development of SSIS packages.
SessionID: 11106
Power Power Query Query With Julie Smith and Rob Volk.
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 02 BI HorsePower
Speaker: Julie Smith
Title: Power Power Query Query With Julie Smith and Rob Volk.
Abstract:
Excel-erate All The Data!
Power Query finishes the Microsoft Self Service (read: inside Excel) BI Stack by providing Extract-Transform-Load capabilities Come and watch Julie and Rob demonstrate this fun and useful new tool.
SessionID: 11194
Judge, Jury, and Executioner--A First Look At Execution Plans
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 07 High Performance
Speaker: Carlos L Chacon
Title: Judge, Jury, and Executioner--A First Look At Execution Plans
Abstract:
When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the 'Hairy' Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/
SessionID: 11261
The Spy Who Loathed Me - An Intro to SQL Security
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 03 Admin Highway
Speaker: Chris Bell
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract:
You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
SessionID: 11571
Best Interview Ever
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 06 Pro Racing
Speaker: Chris Skorlinski
Title: Best Interview Ever
Abstract:
Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. I'll cover key strategies you can use to make your face-2-face interview the best ever increasing chances for a new job and new adventure. Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He'll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.
SessionID: 12397
High Availability with Windows Server 2012 R2 and SQL Server 2014
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 05 Availability Horsepower
Speaker: David Bermingham
Title: High Availability with Windows Server 2012 R2 and SQL Server 2014
Abstract:
This lecture (20% slides, 80% demonstrations) takes a close look at the new features of Windows Server 2012 R2 clustering and how it affects your SQL Server availability. In addition, the new availability features of SQL Server 2014 will be reviewed. This session is geared for those new to Windows Server clustering and SQL Server AlwaysOn but will also be beneficial to those with experience looking to learn about the new high availability features in both Windows Server 2012 R2 and SQL Server 2014.
SessionID: 12502
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 03 Admin Highway
Speaker: David Klee
Abstract:
SessionID: 13032
Implementing Auditing in SQL Server 2012
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 03 Admin Highway
Speaker: David Dye
Title: Implementing Auditing in SQL Server 2012
Abstract:
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
SessionID: 13033
Column Level Encryption
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 03 Admin Highway
Speaker: David Dye
Title: Column Level Encryption
Abstract:
This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption.
SessionID: 13348
GIS Data and Solving the Shortest Path
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 09 Spaghetti Junction
Speaker: Dan Holmes
Title: GIS Data and Solving the Shortest Path
Abstract:
GIS data is used everywhere for many reasons. We are all used to digitally navigating maps on our computer or device. How can we use Sql Server and a network (map) to solve some of those same problems without leaving the server’s process? Then, once you have solved a network for one business case, what other problems can you solve with the same algorithm but in a different business domain and using a different network?
SessionID: 13472
Database Design Fundamentals
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 06 Pro Racing
Speaker: Louis Davidson
Title: Database Design Fundamentals
Abstract:
SessionID: 13689
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 07 High Performance
Speaker: Ed Watson
Abstract:
SessionID: 13899
SQL Server 2012 Always On - The Good, the Bad and the Ugly
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 05 Availability Horsepower
Speaker: Eric Peterson
Title: SQL Server 2012 Always On - The Good, the Bad and the Ugly
Abstract:
Our SQL Server 2012 Always On system with 12 months in production and an 8TB data, you can learn from our experiances, the Good (yes, there are some really cool features), the Bad (not really bad, but features you need to know about) and the Ugly (outagess, causes and resolutions). The session will cover the new SQL Server 2012 Always on functionality and provide hands on examples to features along with a review of how we used SQL Server Always on in a VLDB environment.
SessionID: 14782
Statistics and Query Optimization
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 07 High Performance
Speaker: Grant Fritchey
Title: Statistics and Query Optimization
Abstract:
There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.
SessionID: 15726
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 07 High Performance
Speaker: Janis Griffin
Abstract:
SessionID: 15793
Maintenance and Backups: Intro to Ola Hallengren
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 03 Admin Highway
Speaker: Jason Carter
Title: Maintenance and Backups: Intro to Ola Hallengren
Abstract:
This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
SessionID: 15908
DataViz You Thought You Couldn't Do with SSRS
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 02 BI HorsePower
Speaker: Jason Thomas
Title: DataViz You Thought You Couldn't Do with SSRS
Abstract:
SessionID: 16092
Automating Execution Plan Analysis
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 07 High Performance
Speaker: Joe Chang
Title: Automating Execution Plan Analysis
Abstract:
SessionID: 16334
Bad, less Bad, not Bad; rewriting bad SQL Code
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 04 Code Paths
Speaker: Jeffrey Garbus
Title: Bad, less Bad, not Bad; rewriting bad SQL Code
Abstract:
This session porvodes case studied in rewritign bad SQL, with a lot of discussion on what makes sql code "bad"
SessionID: 17317
T-SQL: Beyond the Basics
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 04 Code Paths
Speaker: Jon Boulineau
Title: T-SQL: Beyond the Basics
Abstract:
SessionID: 17424
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 04 Code Paths
Speaker: Richie Rump
Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers
Abstract:
Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework.
Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.
SessionID: 17786
Data Visualization Using Excel
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 02 BI HorsePower
Speaker: Justin Stephens
Title: Data Visualization Using Excel
Abstract:
SessionID: 17849
What’s Simple About SIMPLE Recovery?
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 10 DBA Radar Detectors
Speaker: Kalen Delaney
Title: What’s Simple About SIMPLE Recovery?
Abstract:
There is a common misconception that SIMPLE Recovery means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in SIMPLE Recovery, but some (not all) operations are minimally logged. In this presentation, I'll tell you what minimal logging means in conjunction with each of the three different recovery models. In addition, I’ll describe the benefits and dangers of the SIMPLE Recovery Model.
SessionID: 18037
Using recursive Common Table Expressions (CTE)
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 04 Code Paths
Speaker: Ken Colson
Title: Using recursive Common Table Expressions (CTE)
Abstract:
In this session we will look at real world experiences using recursive CTEs. Starting with the basics of putting together CTEs, adding recursion, using more complex queries and then using the queries to calculate n-level of financial balances. Additionally we will look at going from parent-child and child-parent
SessionID: 18430
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 09 Spaghetti Junction
Speaker: Kathi Kellenberger
Abstract:
SessionID: 18941
Fundamentals of MDX
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 08 BI Traffic Analysis
Speaker: Lance England
Title: Fundamentals of MDX
Abstract:
Cubes and Excel go together like peanut butter and jelly. However, some questions cannot be answered by browsing a cube. Multidimensional Expressions, or MDX, unlock the full potential of your multidimensional data. Learning MDX requires a clear understanding of some fundamental concepts. Change your mental model, and advance past the MDX learning curve.
SessionID: 20244
Independent Contracting 101
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 06 Pro Racing
Speaker: Michael French
Title: Independent Contracting 101
Abstract:
WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology.
SessionID: 20414
Database Development Comes out of the Dark Ages
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 04 Code Paths
Speaker: miguel Cebollero
Title: Database Development Comes out of the Dark Ages
Abstract:
SessionID: 21028
SQL Server's In Memory Database Objects
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 09 Spaghetti Junction
Speaker: Denny Cherry
Title: SQL Server's In Memory Database Objects
Abstract:
SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
SessionID: 21411
Merging Excel files from SharePoint for Analysis in Tableau with the BI Stack
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 08 BI Traffic Analysis
Speaker: Nelson Davis
Title: Merging Excel files from SharePoint for Analysis in Tableau with the BI Stack
Abstract:
Leveraging the Microsoft BI stack to grab multiple Excel files from SharePoint folders, merge them together, and ultimately bring them into Tableau Desktop for additional analysis. The solution will help with the common problem when different regions of a company are submitting different versions of the same Excel document/report which need to be combined and analyzed as a whole. Rather than downloading and manually merging dozens of documents, this solution will detail the automated process for making this happen.
SessionID: 21860
BI Expert Panel - Part 1
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 01 BI Roadshow
Speaker: Paul Turley
Title: BI Expert Panel - Part 1
Abstract:
Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions. Join Rushabh Mehta, Mark Tabladillo and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world. Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, design your solution.
SessionID: 21861
BI Expert Panel - Part 2
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 01 BI Roadshow
Speaker: Paul Turley
Title: BI Expert Panel - Part 2
Abstract:
In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Mark Tabladillo and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
SessionID: 22194
Introduction to Power BI
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 02 BI HorsePower
Speaker: Patrick LeBlanc
Title: Introduction to Power BI
Abstract:
SessionID: 22360
Tips Tricks for dynamic SSRS Reports
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 01 BI Roadshow
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
SessionID: 22743
Microsoft Azure SQL Database
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 09 Spaghetti Junction
Speaker: Ryan Duclos
Title: Microsoft Azure SQL Database
Abstract:
***It is assumed that you have familiarity with SQL Server.
SessionID: 22941
ETL Architecture Chekup: Avoiding Costly Mistakes
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 11 Express Toll Lane ETL
Speaker: Rafael Salas
Title: ETL Architecture Chekup: Avoiding Costly Mistakes
Abstract:
In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.
SessionID: 23245
READY FOR PROD
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 10 DBA Radar Detectors
Speaker: Robert Verell
Title: READY FOR PROD
Abstract:
As a DBA, my personal least favorite part of the development lifecycle is pushing changes to production. It means adding something unknown (no matter how well tested) to an environment that is considered stable and reliable. Plus there are other things that myself (and I'm sure developers as well) would rather be doing.
In READY FOR PROD (caps for emphasis), we will explore how I believe pushing T-SQL script, SSRS reports, and SSIS packages to production should go, and I encourage those in the audience to participate so we can get an idea of how other environments push code as easily or painfully as possible.
SessionID: 23257
Ask The Experts!
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Ask The Experts!
Speaker: Rob Volk
Title: Ask The Experts!
Abstract:
Ask The Experts is an open clinic/lounge area, where you can ask questions of our participating Experts and get answers to your most vexing problems. The clinic will be open throughout the day, and we will be awarding prizes for your toughest questions, so bring 'em on!
SessionID: 23258
Lightning Talks!
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 06 Pro Racing
Speaker: Rob Volk
Title: Lightning Talks!
Abstract:
System.Xml.XmlElement
SessionID: 23259
Quiz Bowl! - Room 223
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: Ask The Experts!
Speaker: Rob Volk
Title: Quiz Bowl! - Room 223
Abstract:
Think you know SQL Server? Test your knowledge with (and against) our Experts! Quiz Bowl will consist of several 2 person teams, one attendee and one Expert. Teams will compete for a very nice prize. Please visit our Ask The Experts clinic before lunch and ask a challenging question! You can receive one of a limited number of tickets to participate in Quiz Bowl. Please note that Quiz Bowl is being held in Room 223 during the lunch break. Additional prizes may be awarded at the end of the day for ticket holders who were not selected to compete.
SessionID: 23390
Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL Servers
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 01 BI Roadshow
Speaker: Rodney Landrum
Title: Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL Servers
Abstract:
SessionID: 23736
SQL 2012 AlwaysOn Quickstart
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 05 Availability Horsepower
Speaker: Ryan Adams
Title: SQL 2012 AlwaysOn Quickstart
Abstract:
In this presentation I'll explain what the new SQL 2012 AlwaysOn high availability
and disaster recovery solution is all about. I'll talk about the different levels
of protection it provides through Windows Clustering, SQL Clustering, and Availability
Groups. We'll discuss how these three things come together to protect your databases.
We'll finish with a dive into availability group configuration and the new
capabilities it gives us.
SessionID: 24050
Create and Load a Staging Environment from Scratch in an Hour with Biml
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 11 Express Toll Lane ETL
Speaker: Scott Currie
Title: Create and Load a Staging Environment from Scratch in an Hour with Biml
Abstract:
Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie (the creator of Biml) will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.
SessionID: 24328
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 04 Code Paths
Speaker: Sergey Barskiy
Abstract:
This session will concentrate on features of SSDT as it pertains to creating and updating data structure while incorporating your databases into source control management as well as full application lifecycle management. Discussion will include structure management, seeded data management and deployment. Build integration features will also be part of the talk.
Learning objectives
- Core features of SSDT
- Source control and artifacts creation
- Refactoring and build integration
SessionID: 24937
Administering Managing the Power BI Environment
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 02 BI HorsePower
Speaker: Melissa Coates
Title: Administering Managing the Power BI Environment
Abstract:
Power BI for Office 365 is Microsoft's new self-service BI offering. Just because it emphasizes self-service doesn't mean a system administrator isn't an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.
SessionID: 25704
SSIS 2012: More Than Just a Pretty UI
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 11 Express Toll Lane ETL
Speaker: Steve Wake
Title: SSIS 2012: More Than Just a Pretty UI
Abstract:
SessionID: 25840
Managing a Technical Team: Lessons Learned
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 06 Pro Racing
Speaker: Stuart Ainsworth
Title: Managing a Technical Team: Lessons Learned
Abstract:
SessionID: 25917
Windows Server 2012 R2 High Availability for SQL Server
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 05 Availability Horsepower
Speaker: Sven Aelterman
Title: Windows Server 2012 R2 High Availability for SQL Server
Abstract:
With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? What's needed for geo-clustering? Come learn from a Windows Server admin and (accidental) DBA who's been building SQL Server clusters since 2000 (the year and the version!). We'll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it's pretty cool!).
SessionID: 26006
45 min to build your first SSRS report
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 01 BI Roadshow
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
SessionID: 26394
SQL Server 2014 New Features
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 09 Spaghetti Junction
Speaker: Kevin Boles
Title: SQL Server 2014 New Features
Abstract:
There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.
SessionID: 26620
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 11 Express Toll Lane ETL
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: 26674
It is TEMPDB, Why Should You Care?
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 10 DBA Radar Detectors
Speaker: Tim Radney
Title: It is TEMPDB, Why Should You Care?
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 26940
Predictive Analytics for the Data Scientist and BI Pro
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 08 BI Traffic Analysis
Speaker: Teo Lachev
Title: Predictive Analytics for the Data Scientist and BI Pro
Abstract:
The time for predictive analytics to go mainstream has finally come! Business users and BI Pros can use the Microsoft SQL Server and Microsoft Office to unleash predictive analytics and unlock hidden patterns. Join this session to learn how a data scientist can use the Excel Data Mining add-ins to perform predictive analytics with Excel data. I'll provide also the necessary fundamentals for understanding and implementing organizational predictive models with Analysis Services.
SessionID: 27157
AlwaysOn Availability Groups Troubleshooting and Common Issues
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 05 Availability Horsepower
Speaker: Thomas Stringer
Title: AlwaysOn Availability Groups Troubleshooting and Common Issues
Abstract:
SessionID: 27191
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 07 High Performance
Speaker: Kenneth Urena
Abstract:
- Noncluster Coverage
- Page Split
- Heaps
- Filtered Indexes
- Clustered Indexes
SessionID: 27349
DAX 101
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 08 BI Traffic Analysis
Speaker: Damu Venkatesan
Title: DAX 101
Abstract:
In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
SessionID: 27728
Crazy Things That Developers Do
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 10 DBA Radar Detectors
Speaker: Wayne Sheffield
Title: Crazy Things That Developers Do
Abstract:
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
SessionID: 27814
Navigating the Options for Data Redundancy
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 05 Availability Horsepower
Speaker: Wendy Pastrick
Title: Navigating the Options for Data Redundancy
Abstract:
SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
SessionID: 28175
The 20-Minute Tabular Model
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 02 BI HorsePower
Speaker: Bill Anton
Title: The 20-Minute Tabular Model
Abstract:
SessionID: 9082
Manageable SSAS Deployment Strategies
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 08 BI Traffic Analysis
Speaker: Kerry Tyler
Title: Manageable SSAS Deployment Strategies
Abstract:
If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, we will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
SessionID: 9727
Everything You Ever Knew About SSIS Is Null and Void
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 11 Express Toll Lane ETL
Speaker: Robert Cain
Title: Everything You Ever Knew About SSIS Is Null and Void
Abstract:
Along with the catalog came many new improvements, such as package and project parameters. No longer do you have to mess around with ugly configuration files, or the mess of passing data between packages. Also included are new reports which you can use to examine your packages as they run, or see the status of past runs.
In this session we'll look at how the new project based deployment model simplifies your SSIS coding. We'll also take a dive into the catalog, uncovering the wealth of information it can provide.
SessionID: 9755
Peace of Mind: Making DBCC CHECKDB Go Faster
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 10 DBA Radar Detectors
Speaker: Argenis Fernandez
Title: Peace of Mind: Making DBCC CHECKDB Go Faster
Abstract:
SessionID: 9757
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 09 Spaghetti Junction
Speaker: Argenis Fernandez
Abstract:
SessionID: 9989
Automate Your ETL Infrastructure with SSIS and PowerShell
Event Date: 03-05-2014 - Session time: 00:00:00 - Track: 11 Express Toll Lane ETL
Speaker: Allen White
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.