What’s New in SQL Server 2016
SQL Server 2016 is just around the corner. There are a lot of new features in the box, and improvements to old ones. There’s a lot to learn, and you need to start planning before SQL Server 2016 hits the streets. In this session, Jeremiah Peschka will share a high level overview of what’s next in SQL Server 2016.
Jeremiah (Blog | LinkedIn | Twitter) solves data problems using SQL Server, Riak, Hadoop, and other database tools. He has over a decade of experience with performance tuning and scalability database. Jeremiah is a Microsoft MVP; MCITP for SQL Server 2005 – 2012; develops the .NET Riak client; and is a Cloudera Certified Developer for Apache Hadoop. He’s also a big fan of coffee.
Doing much more with much less: The Case for Data Warehouse Automation
One of the most pervasive problems in BI today is that data warehouses take too long to build and they are too hard to change. According to TDWI, building a data warehouse is among the most labor-intensive and time-consuming activities of BI development. There are so many moving parts—requirements, source data analysis, data quality, source-target mapping, data acquisition, data transformation logic, ETL design, scheduling, error handling—and getting it right the first time isn’t easy. And when you finally do get it right, something changes.
The two areas of data warehouse automation include:
• Data warehouse design automation – uses source system structures, rules and standards to accelerate data warehouse design.
• Data warehouse development automation – uses metadata to generate and synchronize related development tasks – such as table management, index management, processing (ETL, ELT), documentation, deployment and scheduling. Metadata allows related development tasks to be combined to drastically reduce the time to delivery – and is used to enable agile / iterative development.
Join data warehouse automation pioneer WhereScape for this presentation to learn how companies like VW, Nike, Vodafone, Cornell University, Washington State University, Canadian Rail, Lamar, Blue Cross, F5 accelerate warehouse development and change cycles while simultaneously assuring quality and consistency. One of the most important aspects of doing automation right is that it should not get in the way of your developers – it should leverage existing skills, add best practices and generate documentation.
Douglas has worked for WhereScape in the US for the last 4 years, and globally for 12. He has worked in data warehousing on SQL Server since SQL 7. Douglas has given talks at SQL Saturdays, TDWI events and Tech Eds.
Refreshments graciously provided by WhereScape.
Featured Sponsor: serverlogic
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.