![]() Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. In this session, Luis Figueroa (Solutions Engineer Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered! In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP Track and Room: BI Platform Architecture, Dev, Delivery Admin - 3310 Finally, we’ll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations. We will also review the security capabilities in the catalog, and will discuss maintenance operations. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. In this demo-heavy presentation, we will dive into the details of the SSIS catalog. With all this complexity, it is important to understand the inner workings of the SSIS catalog to keep it running smoothly. With integrated package storage, Windows ACL-like security settings, built-in logging, and many other features, the SSIS catalog has become an anchor for many ETL architectures. The SSIS catalog is one of the best-evolved features in the SQL Server Integration Services ecosystem. Track and Room: Analytics Visualization - 1313 so many “R” packages - “R” versions - “R” compilers - WTF … “R” you confused ?Ĥ Better understanding of syntax and results … real-world demo timeĥ How TSQL Developers SQL DBAs can go from Newbie » to » Talented in a short time (with effort) … Useful links to available resources The goal of this session is for attendees to learn / walk away with:ġ A practical understanding of how to install a full working implementation of all Microsoft R components necessary to perform T-SQL “R” codingĢ Heightened interest in adding some R language syntax and R packages to their knowledge base repositoryģ An explanation to help sort through some of the confusing things in “R” life. The TSQL Developer/DBA un-official entry into “R” Coding/Analytics (via TSQL) using RTVS (R Tools for Visual Studio) and SSMS with primary focus and demos around implementing using SQL Server R Services … (In Database) - (i.e., SQL Server Launchpad (MSSQLSERVER) service) Title: So you have installed Microsoft R Services (In-database) … Now what “R” you going to do? Track and Room: Enterprise Database Administration Deployment - 1307 How to change OS and database platforms without losing your mind.Offer virtualized environments for every project- development through production with only a 1/3 or the resources once required.Join Kellyn Pot’Vin-Gorman as she demonstrates why virtualization is key to empowering the database administrator. How to do more with less time, less people and less hardware and last but not least, how to do all of this without having to become an expert in 20 different languages, products and specialties. How to provide a databases as fast as they are needed for new projects, new test cases and new challenges. How to provide all the databases you need without having to constantly ask for more disk space. This session is about how to remove those limits. Title: Introducing the Limitless DBA- Copy Data Management, DBA StyleĮverything in our day to day lives as a DBA is about limits. This is a list of sessions from the event, based on the schedule in the XML files. If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s). All data shown below is from the historical XML public data available.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |