Nr: 574
SQLSaturday #574 - Washington DC 2016
SessionID: 53371
Automated SQL Server installation and configuration using PowerShell
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Jamie Wick
Title: Automated SQL Server installation and configuration using PowerShell
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
SessionID: 53449
Location Location Location Preparing and Presenting Geographic Data
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: BI Information Delivery
Speaker: David Dye
Title: Location Location Location Preparing and Presenting Geographic Data
Abstract:
This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data. We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions. Real life examples and solutions will provided to give better context to each step in the process.
After the data structure has been created we will focus on how to best “clean” and validate the geographic data. We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types.
Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports. This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as:
Events that occurred at a specific address, zip code, and even block range and events within a mile radius.
SessionID: 53753
The Many Paths of Consulting
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Professional Development
Speaker: David Klee
Title: The Many Paths of Consulting
Abstract:
People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.
This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.
SessionID: 53797
A Discussion on Azure SQL Database Security Features for the Cloud Objectionist
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Timothy McAliley
Title: A Discussion on Azure SQL Database Security Features for the Cloud Objectionist
Abstract:
This session is for the those who have security objections related to moving to the cloud or are interested in the security features of the of the Azure SQL Database, a relational database Platform as a Service offering in Microsoft Azure. There certainly are Azure SQL Database features which have parity with SQL Server engine features (Always Encrypted, TDE, RLS, etc.). But this session will take a look at security features focused on the Azure SQL Database; server firewall settings, Auditing Threat detection, Alert Rules, Role-based Access Control and configuring Azure AD Authentication. If time permits, we will step through Dynamic Data Making via the Azure portal. Hopefully the main take away will be a warm and fuzzy (and more secure) feeling about planning for cloud workloads.
SessionID: 54784
PowerBI Internals
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: BI Information Delivery
Speaker: Eugene Meidinger
Title: PowerBI Internals
Abstract:
SessionID: 54901
Demystifying Data Compression
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Andy Mallon
Title: Demystifying Data Compression
Abstract:
High-end storage is expensive, and SQL Server data compression can make your database smaller. So compress all the tables!
No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
SessionID: 55151
Don't Let History Be a Mystery! Temporal Data in SQL Server 2016
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Intermediate Dev
Speaker: Adam Machanic
Title: Don't Let History Be a Mystery! Temporal Data in SQL Server 2016
Abstract:
It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.
SessionID: 55169
Why Should I Care About ... Partitioned Views?
Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Lowe
Title: Why Should I Care About ... Partitioned Views?
Abstract:
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away.
SessionID: 53345
Using Excel Web Services to Create Dashboards in SharePoint
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Analytics and Visualization
Speaker: David Patrick
Title: Using Excel Web Services to Create Dashboards in SharePoint
Abstract:
In this session, we'll do a deep dive into Excel Web Services, a feature of SharePoint, that allows us to use Excel to create custom dashboards. Dashboards are pages served up by SharePoint and we'll look at how to create these pages, add Excel Web Services web parts to these pages, and arrange these web parts and "connect" these parts to communicate with each other, to create interactive, updating dashboards for our users.
SessionID: 53424
R For the SQL Server Developer
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Analytics and Visualization
Speaker: Kevin Feasel
Title: R For the SQL Server Developer
Abstract:
R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.
SessionID: 53784
Enhancing your career: Building your personal brand
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Professional Development
Speaker: James Serra
Title: Enhancing your career: Building your personal brand
Abstract:
In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP. Along the way I saw my yearly income triple. Is it because I know some secret? Is it because I am a genius? No! It is just about laying out your career path, setting goals, and doing the work. It's about building your personal brand and stepping out of your comfort zone. It's about overcoming your fear of taking risks. If you can do those things, you will be rewarded. I will discuss how you too can go from unknown to well-known. I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting. Your first step to enhancing your career will be to attend this session!
SessionID: 54020
Getting to 99.99% Uptime Delivering Operational Excellence
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Professional Development
Speaker: George Govantes
Title: Getting to 99.99% Uptime Delivering Operational Excellence
Abstract:
How does one take advice from the top leadership experts and translate into action? As one's responsibilities grow many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some will argue this is out of my scope of responsibilities why should I care about the building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.
SessionID: 54148
Top 10 Dos and Don’ts for Clustered SQL Server Implementations
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Allan Hirt
Title: Top 10 Dos and Don’ts for Clustered SQL Server Implementations
Abstract:
Whether you are a new DBA or a seasoned veteran, clustered implementations of SQL Server can still vex many in one way or another. Physical, virtual, and cloud-based architectures all have different subtle complexities when it comes to deploying either clustered instances of SQL Server (FCIs) or availability groups (AGs) regardless if you are using an older version or SQL Server 2016. Storage, networking, Active Directory, quorum, the overall underlying Windows Server failover cluster, and more are topics that come up quite often. This session will cut to the chase and concentrate nearly 20 years of experience down into the most relevant aspects of planning, deployment, and administration of clustered implementations that every DBA should know. The ten dos and don’ts presented could not only mean the difference between success and failure, but whether your systems are up or down.
SessionID: 54314
SQL Server on Windows Core. Installation and Configuration.
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Intermediate DBA
Speaker: Slava Murygin
Title: SQL Server on Windows Core. Installation and Configuration.
Abstract:
Would you consider building your next SQL Server in Windows Core Environment?
Do you have enough knowledge?
In this session we will go step by step through an installation, remote configuration and administration of SQL Server using PowerShell scripts.
SessionID: 55138
Troubleshooting Blocking for Beginners
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Intro DBA
Speaker: Kendra Little
Title: Troubleshooting Blocking for Beginners
Abstract:
SessionID: 55156
Understanding SQL Server 2016 Always Encrypted
Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Ed Leighton-Dick
Title: Understanding SQL Server 2016 Always Encrypted
Abstract:
SessionID: 53447
Creating Dynamic Packages
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
Speaker: David Dye
Title: Creating Dynamic Packages
Abstract:
In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to:
- Iterate through all files in a folder and import their content into SQL
- Dynamically create and name table based on a data source
- Dynamically create a T-SQL statement at runtime based on run time conditions
This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment.
Each attendee will leave with the knowledge and toolset necessary to:
Use expressions within SSIS packages
Use variables to dynamically create SQL statements
Configure custom dynamic logging
Use package configurations and parameters and environments to make packages more portable at execution
- Replace dynamic SQL using expressions in SSIS
SessionID: 53943
The Art of War with Bad Code
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Intermediate DBA
Speaker: Andrew Kelly
Title: The Art of War with Bad Code
Abstract:
SessionID: 54689
Introduction to SQL Server Reporting Services 2016
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: BI Information Delivery
Speaker: Jessica Moss
Title: Introduction to SQL Server Reporting Services 2016
Abstract:
Reports, dashboards, and indicators are an essential part of your job as a report analyst. SQL Server Reporting Services (SSRS) 2016 gives you the ability to create these items to share with coworkers and management. This session will walk you through how to design, develop, deploy, and maintain reports within your environment. As a bonus, we will cover mobile reports, introduced in SSRS 2016!
SessionID: 54829
I’m It – Survival Techniques for the Lone DBA
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Professional Development
Speaker: Monica Rathbun
Title: I’m It – Survival Techniques for the Lone DBA
Abstract:
Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
SessionID: 54909
Blue Collar SQL Tricks - Make Standard Edition Work for you.
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Application Database Development
Speaker: William Wolf
Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.
Abstract:
You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.
In this session, we will review some of the limitations that Standard has. Then review items such as basic normalization and High Availability options available to Standard. You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.
Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!
SessionID: 54956
WIT: Identifying, Understanding and Combating Gender Bias
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Professional Development
Speaker: Rie Irish
Title: WIT: Identifying, Understanding and Combating Gender Bias
Abstract:
Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women and job responsibilities. We'll learn about the origins of some of these biases and how to identify gender bias when we see it. We'll discuss some strategies for how both men and women can combat this at work and in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.
SessionID: 55002
SQL Server Databaseology: A Deep Dive Into Database Internals
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Speaker: John Morehouse
Title: SQL Server Databaseology: A Deep Dive Into Database Internals
Abstract:
Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.
SessionID: 55167
Why should I care about ... the plan cache?
Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Lowe
Title: Why should I care about ... the plan cache?
Abstract:
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
SessionID: 53551
CONVERT_IMPLICIT is a hidden danger
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Intermediate DBA
Speaker: Alex Grinberg
Title: CONVERT_IMPLICIT is a hidden danger
Abstract:
Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.
SessionID: 53669
PolyBase: I now pronounce you SQL and Hadoop
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Other
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#39;re about to be blown away! This is a match made in Data Heaven. You#39;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: 54299
Imposter Syndrome: Are You Faking It Will they Find Out?
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Professional Development
Speaker: Mindy Curnutt
Title: Imposter Syndrome: Are You Faking It Will they Find Out?
Abstract:
Have you ever thought to yourself “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!
SessionID: 54519
SQL and VMware - more than just virtualization demos
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Niran Even-Chen
Title: SQL and VMware - more than just virtualization demos
Abstract:
SessionID: 54568
SQL Server 2016: Temporal Tables and Dynamic Data Masking
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Wayne Sheffield
Title: SQL Server 2016: Temporal Tables and Dynamic Data Masking
Abstract:
SQL Server 2016 introduces many new features and enhancements. This session will look into two of those: Temporal Tables and Dynamic Data Masking. Temporal Tables simplifies the task of building a history table to track all data changes so that you can see how the data looked at a specific point in time, while Dynamic Data Masking is used to obfuscate data from users (for example, show just the last 4 characters of your SSN). This session is >90% demos!
SessionID: 54598
Rewriting Your Checklist for SQL 2016
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Mike Hillwig
Title: Rewriting Your Checklist for SQL 2016
Abstract:
How big should the page file be for Windows Server 2016? How many data files should SQL Server 2016's TempDB contain? What trace flags should we use by default now?
These are questions you addressed long ago in your setup checklist. You've spent a lot of time with that checklist, and you're sure it's perfect. Or is it? When was the last time you visited that checklist? Does it make sense for SQL 2014? What about SQL 2016? Change is hard, and DBAs need to constantly challenge yesterday's best practices to ensure they meet today's business needs.
Join veteran DBA Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.
SessionID: 54688
Introduction to SQL Server Integration Services 2016
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jessica Moss
Title: Introduction to SQL Server Integration Services 2016
Abstract:
SQL Server Integration Services (SSIS) provides database administrators, business intelligence developers, and application programmers the ability to quickly and easily move and transform data. Whether your data in on-premises or in the cloud, within SQL Server or stored in text files, clean or dirty, SSIS can help you extract, transform, and load (ETL) the information. Join this session to learn more about SSIS, specifically how to develop, deploy, and maintain SSIS packages.
SessionID: 55161
Unit-Testing in SQL Server - An Introduction
Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Application Database Development
Speaker: Sebastian Meine
Title: Unit-Testing in SQL Server - An Introduction
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.
In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.
You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
SessionID: 53533
Security 101
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Application Database Development
Speaker: Thomas Grohser
Title: Security 101
Abstract:
Integrating security into your database design. Learn how to use roles, schemas and encryption to secure the data. A very demo rich session that will introduce you to security on the database level. We start with understanding GRANT, REVOKE and DENY while working our way through the object hierarchy till we end up at the column level when we have a lock at encryption. This session will also cover new SQL 2016 security features and how to use them correctly.
SessionID: 53942
Query Store – What is it all about?
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Intermediate DBA
Speaker: Andrew Kelly
Title: Query Store – What is it all about?
Abstract:
SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.
SessionID: 53994
Introducing Azure Machine Learning
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Intermediate BI
Speaker: Mark Hudson
Title: Introducing Azure Machine Learning
Abstract:
SessionID: 54298
Fun with SQL Server Spatial Data
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Application Database Development
Speaker: Mindy Curnutt
Title: Fun with SQL Server Spatial Data
Abstract:
SessionID: 54658
Introduction to PostgreSQL
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Application Database Development
Speaker: Stephen Frost
Title: Introduction to PostgreSQL
Abstract:
PostgreSQL is a powerful, open source object-relational database system with decades of continuous active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows, is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).
This talk will provide an introduction to PostgreSQL by one of the project's committers, including the overall architecture, major features, data types, and capabilities.
SessionID: 54959
Hi, my name is Powershell, let's be friends! An Intro to PoSH
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment
Speaker: Amy Herold
Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH
Abstract:
Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
SessionID: 55162
The Phenomenal IT Consultant
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Professional Development
Speaker: Sebastian Meine
Title: The Phenomenal IT Consultant
Abstract:
Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.
In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part.
This session is for you…
- if you are struggling to find enough new clients,
- if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
- if you feel like you are treading water when it comes to marketing.
Join this session and get started on your way to becoming a Phenomenal IT Consultant.
SessionID: 55170
Extending the SSIS Framework to be region aware
Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Intermediate BI
Speaker: Brad McKuhen
Title: Extending the SSIS Framework to be region aware
Abstract:
In this demo-heavy session, we will extend the EntDNA SSIS Framework Community Edition to become region aware, tackling the problem of running groups of packages around the world on multiple servers, and get the results back to the calling server, all using a centralized, coordinated schedule.