Nr: 392
SQLSaturday #392 - Atlanta 2015
SessionID: 14447
Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
Event Date: 16-05-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Gene Webb
Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
Abstract:
What is master data management and why should I care about it?
What does the master data services components of SQL Server do for me?
Overview of all features of MDS
How to build out an MDM subject area
How to use MDS for reference data management
How to use MDS for data quality
How to use MDS with a data warehouse to improve data quality
SessionID: 34780
Getting Started with Database Automation
Event Date: 16-05-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Michael Fal
Title: Getting Started with Database Automation
Abstract:
SessionID: 34781
Powershell and the Art of SQL Server Deployment
Event Date: 16-05-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Michael Fal
Title: Powershell and the Art of SQL Server Deployment
Abstract:
SessionID: 12253
Database: The Motion Picture
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: Reporting Visualization
Speaker: Dave Mattingly
Title: Database: The Motion Picture
Abstract:
Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"
SessionID: 12349
Clustered Columnstore Indexes in SQL Server 2014
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA
Speaker: Dave Fackler
Title: Clustered Columnstore Indexes in SQL Server 2014
Abstract:
SQL Server 2012 introduced columnstore indexing but with one major drawback -- columnstore indexes were not updateable. Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management. SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable! During this session, we'll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled. We'll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally. Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!
SessionID: 13351
Emulating a SELECT Trigger if Such a Thing Existed
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA
Speaker: Dan Holmes
Title: Emulating a SELECT Trigger if Such a Thing Existed
Abstract:
SELECT triggers don't exist but what if they did? What if you could capture the statement, get a parse tree, or the plan and change what happens? What would you be able to do? What problems could you solve? What are the limitations? Let's go outside the box and see what we can see. Join me on this interesting but unorthodox journey into what SQLServer can do. You decide if it should.
SessionID: 13494
Database Design Fundamentals
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DEV
Speaker: Louis Davidson
Title: Database Design Fundamentals
Abstract:
SessionID: 16288
Sliding Window Table Partition Intro
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA
Speaker: Jeff Reinhard
Title: Sliding Window Table Partition Intro
Abstract:
A walk-through of creating a sliding window table partition on an AdventureWorks table.
SessionID: 16840
Closing the SSIS Package Management Story with BIPS
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: PowerShell
Speaker: Jim Christopher
Title: Closing the SSIS Package Management Story with BIPS
Abstract:
BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.
In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.
SessionID: 22985
Why should I care about the plan cache?
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DEV
Speaker: Rick Lowe
Title: Why should I care about the plan cache?
Abstract:
SessionID: 24056
SSIS Unit and Integration Testing with the Open Source BEST project
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: BIML
Speaker: Scott Currie
Title: SSIS Unit and Integration Testing with the Open Source BEST project
Abstract:
Biml Enabled SSIS Test (BEST) [https://github.com/bimlscript/best] is an open source framework that enables users to define unit and integration tests for SSIS packages using your choice of database tables, Excel files, or XML.
In this session, you will learn how to use BEST to author your SSIS tests and how to use free open source tools to report and visualize test results as part of your existing production processes.
Note that while BEST is implemented using Biml, you do not need to learn Biml to use it.
SessionID: 26430
SQL Server Defaults SUCK!!
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: DBA
Speaker: Kevin Boles
Title: SQL Server Defaults SUCK!!
Abstract:
SessionID: 26941
Event Date: 16-05-2015 - Session time: 08:15:00 - Track: BI
Speaker: Teo Lachev
Abstract:
Microsoft has always provided a comprehensive toolset for BI developers but functionality gaps remains. In attempt to fill in some of these gaps, MVPs and community have implemented outstanding tools. Join this session to learn how to increase your developer productivity and improve your BI solutions by using BIDS Helper, DAX Studio, DAX Editor, Query Capture, and OLAP Extensions. This session assumes developer experience in designing and implementing BI solutions with SSAS, SSRS, and SSIS.
SessionID: 10859
Using Extended Events in SQL Server
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA
Speaker: Jason Brimhall
Title: Using Extended Events in SQL Server
Abstract:
SessionID: 12179
Tuning SQL Server for SharePoint
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA
Speaker: Daniel Glenn
Title: Tuning SQL Server for SharePoint
Abstract:
Some of the topics covered will include: the configuration steps and settings needed for SQL Server to properly host SharePoint databases, database size considerations, the SQL permissions your SharePoint administrators REALLY need, and why SharePoint databases have a GUID in their name (and how to avoid them!).
SessionID: 16028
Are users working against you? Manage human factors to achieve BI success
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: BI
Speaker: Javier Guillen
Title: Are users working against you? Manage human factors to achieve BI success
Abstract:
Too often we experience adoption issues that account for partial or complete failures for BI delivery. Are users satisfied with BI assets? Do they continue to build information 'silos'? Are they reluctant to change and utilize governed data sets?
In this presentation, attendees will learn about a perspective that can help increase ROI on BI delivery by actively targeting human factors critical to achieving success.
SessionID: 16336
Indexing for Join Optimization
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DEV
Speaker: Jeffrey Garbus
Title: Indexing for Join Optimization
Abstract:
Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.
SessionID: 21622
Sentiment Analysis with Big Data
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: Big Data Data Science
Speaker: Paco Gonzalez
Title: Sentiment Analysis with Big Data
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 22807
Increase your SSIS productivity with Biml
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: BIML
Speaker: Reeves Smith
Title: Increase your SSIS productivity with Biml
Abstract:
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
SessionID: 24447
Beginners SQL Server Security the Low Hanging Fruit
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA
Speaker: Lindsay Clark
Title: Beginners SQL Server Security the Low Hanging Fruit
Abstract:
Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.
SessionID: 25922
Gentle Introduction to T-SQL Window Functions
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DEV
Speaker: Sven Aelterman
Title: Gentle Introduction to T-SQL Window Functions
Abstract:
Since their infancy in SQL Server 2005 and their growth spurt in SQL Server 2012, T-SQL window functions have provided new ways to solve fairly common end-user query requests. However, their successful use requires thinking a little differently about sets than you're used to. In this session, you will explore the basic concepts of ordering, partitioning and framing. Everything will be demonstrated with easy to follow examples that you will be able to adapt quickly to your query needs.
SessionID: 28345
Version control with GIT for the DBA
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: DBA
Speaker: Justin Dearing
Title: Version control with GIT for the DBA
Abstract:
What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.
In my session. We will cover:
What is version control?
How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN?
How do I setup git for internal use in my company?
How do I host public and private repositories on github.
How do pull requests work?
How do I fork a SVN repo to github?
We will be covering using git from both the command line and Vis
SessionID: 9397
SSIS 2014: Project Deployment Configuration using SSIS Catalog
Event Date: 16-05-2015 - Session time: 09:30:00 - Track: ETL/SSIS
Speaker: Amir Charania
Title: SSIS 2014: Project Deployment Configuration using SSIS Catalog
Abstract:
Are you an ETL Developer that has worked with SSIS 2008 or earlier? If so, you will be excited to learn about some of the new features in SSIS 2012 that make your life a lot easier! In this demo-driven session, we will go through the entire process of building, configuring, deploying, executing and reporting on SSIS packages using the Project Deployment Model. You will see how multiple packages are deployed at one time, how project parameters make configuring your packages a breeze, how environment variables help you move your packages from DEV to UAT to PROD, how project level connection managers help you share connections across packages, and Integration Services Dashboard gives you detailed logging so you can identify the cause of package failure with no extra coding.
By the end of this session, you will be ready to start taking advantage of these new features in your own environment.
SessionID: 20709
PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: PowerShell
Speaker: Mike Robbins
Title: PS C:\gt; Get-Started -With 'PowerShell Desired State Configuration'
Abstract:
SessionID: 22095
Common Coding Mistakes and how to Mitigate them
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DEV
Speaker: William Wolf
Title: Common Coding Mistakes and how to Mitigate them
Abstract:
There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
SessionID: 22259
Choosing the right clustering key
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DEV
Speaker: Phil Pledger
Title: Choosing the right clustering key
Abstract:
SessionID: 23154
Loading a Data Warehouse with SSIS
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: ETL/SSIS
Speaker: Robert Biddle
Title: Loading a Data Warehouse with SSIS
Abstract:
SessionID: 23255
Getting Started With SQL Server Replication
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: Availability Replication
Speaker: Robert Verell
Title: Getting Started With SQL Server Replication
Abstract:
SessionID: 28181
20-Minute Tabular Model
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: BI
Speaker: Bill Anton
Title: 20-Minute Tabular Model
Abstract:
SessionID: 28254
The Absolute Beginner's Guide to BIML
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: BIML
Speaker: Kevin Hazzard
Title: The Absolute Beginner's Guide to BIML
Abstract:
SessionID: 34748
Microsoft Technologies for Data Science
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: Big Data Data Science
Speaker: Mark Tabladillo
Title: Microsoft Technologies for Data Science
Abstract:
Microsoft provides several technologies in and around SQL Server which can be used for casual to serious data science. This presentation provides an authoritative overview of five major options: SQL Server Analysis Services, Excel Add-in for SSAS, Semantic Search, Microsoft Azure Machine Learning, and F#. Also included are tips on working with Python and R. These technologies have been used by the presenter in various companies and industries. Bring your beginner to advanced questions!
SessionID: 34779
Powershell Tips and Tricks for SQL Server Administration
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DBA
Speaker: Michael Fal
Title: Powershell Tips and Tricks for SQL Server Administration
Abstract:
SessionID: 37062
Ask Doc Brown and Einstein!
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: Ask Doc Einstein!
Speaker: Rob Volk
Title: Ask Doc Brown and Einstein!
Abstract:
Do you have a pressing question about SQL Server? Or Time Travel? We have a number of experts that can answer your questions! Stop by Room 205 throughout the day and get your tough SQL Server questions answered by experts in the community! You can also ask about career advice and professional development if you're looking to get into or get better at your SQL Server skills.
SessionID: 9410
Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DBA
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: 9740
Event Date: 16-05-2015 - Session time: 10:45:00 - Track: DEV
Speaker: Robert Cain
Abstract:
As a developer, you are using Visual Studio to manage your C#, VB.Net, and other projects. Why not your database projects as well?
As a DBA, you are using SQL Server Management Studio (SSMS) to develop your database projects. But as an experienced DBA, you can get frustrated quickly with its limitations.
There's a better way! Database Development got completely revamped with the release of SQL Server Data Tools. A FREE download, SQL Server Data Tools, or SSDT for short, allows you to manage the development of databases with a powerful, yet easy to use project interface.
In this session we'll look at the tools included with SSDT such as the all new localdb, database snapshots, and the new way to publish your database. You'll also learn how to reverse engineer existing databases into your project, as well as how to do safe refactoring. See how to streamline your database development with SSDT!
SessionID: 11171
Standalone to High-Availability Clusters over Lunch—with Time to Spare
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Availability Replication
Speaker: Carl Berglund
Title: Standalone to High-Availability Clusters over Lunch—with Time to Spare
Abstract:
SessionID: 14448
Learn How To Build A Golden Record for Any Subject Over Lunch!
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: BI
Speaker: Gene Webb
Title: Learn How To Build A Golden Record for Any Subject Over Lunch!
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to:
• Create a golden record for any subject area in a matter of minutes
Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?
• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?
• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting
• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
SessionID: 36841
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Professional Development
Speaker: Rie Irish
Abstract:
This group 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: 37004
Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch
Speaker: Gary Serda
Title: Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract:
SessionID: 37006
Clusters Your Way: #SANLess clusters for physical, virtual cloud environments
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Availability Replication
Speaker: SIOS Technology
Title: Clusters Your Way: #SANLess clusters for physical, virtual cloud environments
Abstract:
SessionID: 37011
SQL Server and Microsoft Business Solutions - Tegile
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch
Speaker: Brett Johnson
Title: SQL Server and Microsoft Business Solutions - Tegile
Abstract:
will send via email
SessionID: 37063
1.21 Gigawatt Talks!
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Ask Doc Einstein!
Speaker: Rob Volk
Title: 1.21 Gigawatt Talks!
Abstract:
GREAT SCOTT! You never know when or where a bolt of lightning will strike! But we do now! Come to this session and hear some local and SQL Server community speakers give brief, intense flashes of insight to the audience! And if you have a topic you can present in 5 minutes or less, COME PREPARED! You never know when it might be your chance to get up there! If you put your mind to it, you can accomplish anything!
SessionID: 37164
SQL Server Clinic
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch
Speaker: Denny Cherry
Title: SQL Server Clinic
Abstract:
Join a panel of SQL Server MVPs including Denny Cherry Joey D’Antoni for the SQL Server Clinic. The SQL Server Clinic will be a free style question and answer session where you can ask your SQL Server questions to your favorite authors, consultants and SQL Server experts. Grab your lunch, grab a seat and bring your questions about SQL Server, Consulting, etc.
SessionID: 37235
Learn about Governed Data Discovery with Pyramid Analytics
Event Date: 16-05-2015 - Session time: 11:45:00 - Track: Sponsor/Lunch
Speaker: Mark Scott
Title: Learn about Governed Data Discovery with Pyramid Analytics
Abstract:
Mark Rob will show you how you can Supercharge your Microsoft BI with Pyramid Analytics “BI Office”. See how BI Office gives you the “freedom to” Scale, Maximize, Visualize, and Mobilize your business users with the new Version 5. Attendees will see how easy it is to go from Analytics to Dashboards and reports in just 45 minutes. Additionally Mark will show you our mobile dashboard offering on the new iPad Air.
SessionID: 11174
How I Became a BIML Believer
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: BIML
Speaker: Carla Sessions
Title: How I Became a BIML Believer
Abstract:
- How to import data from a flat file, and auto generate tables, views and SSIS packages based on metadata
- Utilizing metadata stored in a database
- Using BIML as a metadata store
- How to use BIML Annotations
- Helpful BimlScript extension methods
- Consolidating code with include files
- Helpful uses of C# Linq within BimlScript
All of the code and techniques in this session can be used with the free BIDS Helper add-in found on CodePlex.com
SessionID: 11222
Making your SSIS Fly Beyond the Sky
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: ETL/SSIS
Speaker: Carlos Rodrigues
Title: Making your SSIS Fly Beyond the Sky
Abstract:
SessionID: 13080
DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Sponsor/Lunch
Speaker: Denis McDowell
Title: DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Abstract:
SessionID: 15911
Memoirs of Building a 150 GB (and growing) SSAS Tabular Model
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: BI
Speaker: Jason Thomas
Title: Memoirs of Building a 150 GB (and growing) SSAS Tabular Model
Abstract:
SessionID: 17324
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV
Speaker: Jon Boulineau
Abstract:
SessionID: 20426
SQL Server 2014 In-Memory Programming
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV
Speaker: miguel Cebollero
Title: SQL Server 2014 In-Memory Programming
Abstract:
SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.
SessionID: 21072
Index Internals
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV
Speaker: Denny Cherry
Title: Index Internals
Abstract:
During this session we will be digging into the internals of SQL Server indexes.
If you came to this session last year, that wasn't this. Since then this session has been totally rewritten, and is mostly demos using a single command, DBCC PAGE! Come check it out, for some insides looks at how SQL Server manages and uses our data for us.
SessionID: 22370
Tips Tricks for dynamic SSRS Reports
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Reporting Visualization
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: 24436
Parameter Sniffing the Good and the Bad
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: DEV
Speaker: Lance Tidwell
Title: Parameter Sniffing the Good and the Bad
Abstract:
SessionID: 27354
Self-Service ETL with Microsoft Power Query
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: ETL/SSIS
Speaker: Damu Venkatesan
Title: Self-Service ETL with Microsoft Power Query
Abstract:
SessionID: 36842
Awesome PowerShell for SQL 2014
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: PowerShell
Speaker: Aaron Nelson
Title: Awesome PowerShell for SQL 2014
Abstract:
Need to import millions of rows from a CSV in under a minute? No problem. Need to copy all the Users, Databases, and Agent Jobs from one server to another? Done. Need to update all of your development databases to have the same schema, but want to skip the update and only spit out a report if data loss might occur? Piece of CAKE!! These are some of the scenarios that we will cover in this session on how to leverage PowerShell with SQL Server 2014.
SessionID: 37174
Independent Contracting 101
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Professional Development
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: 9276
Business Continuity: The Real Reason for HA and DR
Event Date: 16-05-2015 - Session time: 13:15:00 - Track: Availability Replication
Speaker: Allan Hirt
Title: Business Continuity: The Real Reason for HA and DR
Abstract:
These days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.
SessionID: 10303
SQL Server Encryption
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DBA
Speaker: Ben Miller
Title: SQL Server Encryption
Abstract:
What encryption is available in your version of SQL Server? This session will cover how to set up the Encryption Hierarchy and the requirements for the new Backup with Encryption in SQL 2014. We will also cover end to end Transparent Database Encryption (TDE). This session will go over all the steps and caveats that go with this technology. Encryption is here to stay so jump on and let's take it for a ride.
SessionID: 10768
9 secrets to independent consulting success
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Professional Development
Speaker: Brian Moran
Title: 9 secrets to independent consulting success
Abstract:
Are you an independent consultant focused on Microsoft data or aspire to become one? Maybe you have a few partners or are considering joining forces with friends? This session is for you.
My 25 years of consulting experience include 15 years working for myself or with partners. This session explores the top lessons I’ve learned over that time.
This session doesn’t cover marketing or SME topics. We explore top tips related to most everything else you must know to achieve success as an IC including:
• Common reasons IC’s fail.
• Customer satisfaction and happiness.
• Formal and informal partnerships.
• Legal stuff 101.
• Bookkeeping, finance and cash flow.
• Taxes and entity structures.
• Building equity in your business.
• Work life balance.
We often learn the most from our mistakes. 25 years of mistakes has made me an IC expert. Attending this session will shave years from your learning curve.
SessionID: 13702
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DBA
Speaker: Ed Watson
Abstract:
SessionID: 15877
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: BI
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 16223
Becoming a Top DBA--Learning Automation in SQL Server
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DBA
Speaker: Joseph D'Antoni
Title: Becoming a Top DBA--Learning Automation in SQL Server
Abstract:
Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
• Fully Automating SQL Server Installations
• Dynamically Adding Databases to an Availability Group
• Syncing jobs and logins between Availability Group members
• Patching SQL Servers automatically
• Other techniques for process automation
This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
SessionID: 20077
Unit Testing with tSQLt an Open Source Testing Framework for SQL
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DEV
Speaker: Mark Fugel
Title: Unit Testing with tSQLt an Open Source Testing Framework for SQL
Abstract:
This session is for anyone interested int getting started in setting up an environment where you wish to establish unit testing for SQL. It will include how to install, setup, create, run and even come to depend and even enjoy having your unit tests in place to "have your back"! Real examples will used to show how unit tests can be used to test stored procedures and functions. We will discuss how tSQLt can even be used to enforce development standards and even integrated into your automated build and release processes (such as Team City).
SessionID: 22967
Design principles for robust ETL processes
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: ETL/SSIS
Speaker: Rafael Salas
Title: Design principles for robust ETL processes
Abstract:
Is the design of your ETL processes robust? Does your ETL process keep you awake at night?
Data integration is still the most common point of failure of data centric projects and choosing a mature ETL tool, such as SSIS, is not enough. In many cases this is due to improper planning and the use of questionable design principles. During this session we will look at ETL processes from a holistic point of view to identify key areas that are often neglected and that have the potential to affect the system reliability and increase its maintenance cost. We will use SSIS to evaluate key ETL architecture areas - such as re-start ability, monitoring, error handling, among others- and discuss design principles you can use to improve the architecture of your ETL processes going forward. You will find the session valuable regardless of you level of expertise in ETL.
SessionID: 24824
Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Reporting Visualization
Speaker: Wes Springob
Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Abstract:
As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.
SessionID: 24927
Introduction to SQL Server Clustering
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Availability Replication
Speaker: Chad Churchwell
Title: Introduction to SQL Server Clustering
Abstract:
This session will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL. We will cover the required components and walk through how clustering works behind the scenes
SessionID: 25722
Near Real-Time Data Warehouse Updates with CDC SSIS
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: ETL/SSIS
Speaker: Steve Wake
Title: Near Real-Time Data Warehouse Updates with CDC SSIS
Abstract:
SessionID: 25858
Eating The Elephant; A DBA's Guide to Hadoop Big Data
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Big Data Data Science
Speaker: Stuart Ainsworth
Title: Eating The Elephant; A DBA's Guide to Hadoop Big Data
Abstract:
You're a SQL Server DBA working at Contoso and your boss calls you out of your cubicle one day and tells you that the development team is interested in implementing a Hadoop-based solution to your customers. She wants you to help plan for the implementation and ongoing administration. Where do you begin?
This session will cover the foundations of Hadoop and how it fundamentally differs from the relational approach. The goal is to provide a map between your current skill set and "big data.” Although we will talk about basic techniques for querying data, the focus is on basic understanding of how Hadoop works, how to plan for growth, and what you need to do to start maintaining a Hadoop cluster. Additional discussion will cover the complementary nature of Hadoop and SQL Server.
Examples and demos will highlight basic query tools, including transferring data to and from SQL Server.
SessionID: 26726
Getting involved and Getting ahead
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: Professional Development
Speaker: Tim Radney
Title: Getting involved and Getting ahead
Abstract:
SessionID: 27771
Table Vars Temp Tables - What you NEED to Know!
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: DEV
Speaker: Wayne Sheffield
Title: Table Vars 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 represent 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: 9554
Using BIML as an SSIS Design Patterns Engine
Event Date: 16-05-2015 - Session time: 14:30:00 - Track: BIML
Speaker: Andy Leonard
Title: Using BIML as an SSIS Design Patterns Engine
Abstract:
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
SessionID: 11132
Master Data Management with MDS, DQS and SSIS
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: BI
Speaker: Julie Smith
Title: Master Data Management with MDS, DQS and SSIS
Abstract:
SessionID: 13190
Advanced SSIS Techniques
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: ETL/SSIS
Speaker: David Dye
Title: Advanced SSIS Techniques
Abstract:
As an ETL developer using SQL Server Integration Services have you ever wondered how to:
- Import all .csv files from a folder
- Replace dynamic SQL using variables in SSIS
- How to configure the data flow buffer
- Create custom logging solutions
- Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
- Import/export multiple sources/destinations
- Use an execute SQL task with variables to replace dynamic SQL within a package
- Dynamically handle errors within any part of a package
SessionID: 16864
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DEV
Speaker: Jim Wooley
Abstract:
SessionID: 16998
Changing Data Is Easy, Managing Data Change is Hard!
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DEV
Speaker: James McAuliffe
Title: Changing Data Is Easy, Managing Data Change is Hard!
Abstract:
SessionID: 17210
Continuous Delivery for Data Warehouses and Marts
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: BI
Speaker: John Welch
Title: Continuous Delivery for Data Warehouses and Marts
Abstract:
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Most data warehouses are in a constant state of flux. There are new requirements coming in from the business, updates and improvements to be made to existing data and structures, and new initiatives that drive new data requirements. How do you manage the complexity of keeping up with the changes and delivering new features to your business users in a timely manner, while maintaining high quality? Continuous delivery is an approach for managing this. It focuses on automation of many steps in the process, so that time is spent on adding new functionality, rather than repetitive steps. Attend this session and learn how Continuous Delivery can be applied to your data projects.
SessionID: 17214
What's your Character Type?
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DEV
Speaker: John Deardurff
Title: What's your Character Type?
Abstract:
This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.
SessionID: 17268
Only You Can Prevent Database Fires!
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA
Speaker: John Morehouse
Title: Only You Can Prevent Database Fires!
Abstract:
Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!
SessionID: 18246
SQL Server Internals and Architecture
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA
Speaker: Kevin Kline
Title: SQL Server Internals and Architecture
Abstract:
What are the various areas of memory inside of SQL Server?
How are queries handled behind the scenes?
What does SQL Server do with procedural code, like functions, procedures, and triggers?
What happens during checkpoints? Lazywrites?
How are IOs handled with regards to transaction logs and database?
What happens when transaction logs and databases grow or shrinks?
SessionID: 19005
R intro for the SQL Server Pro
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: Reporting Visualization
Speaker: Luis Figueroa
Title: R intro for the SQL Server Pro
Abstract:
So you’ve heard all the buzz about R and you are ready to start the learning journey but where do you start? in this session, Luis will provide a quick overview of what R is, how to acquire, manipulate and plot simple data sets, how you can leverage your existing knowledge of T-SQL and a number of learning sources that will help you succeed in your jouRney.
SessionID: 20606
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA
Speaker: Mike Lawell
Abstract:
This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.
There will be homework!
SessionID: 24941
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: BI
Speaker: Melissa Coates
Abstract:
SessionID: 26727
Understanding SQL Backups and Restores
Event Date: 16-05-2015 - Session time: 15:45:00 - Track: DBA
Speaker: Tim Radney
Title: Understanding SQL Backups and Restores
Abstract: