Nr: 501
SQLSaturday #501 - Dublin 2016
SessionID: 42721
IoT - Comparing Azure with AWS
Event Date: 18-06-2016 - Session time: 08:00:00 - Track: Cloud SQL2016
Speaker: Allan Mitchell
Title: IoT - Comparing Azure with AWS
Abstract:
The Internet of Things is one of the hottest topics in our industry right now. Being able to collect, process and deliver events from devices/sensors in close to real-time, scaling on-demand offers incredible value-add to businesses.
This session will look at two competing cloud technologies Azure and AWS. How do you build an IoT infrastructure in both offerings. What are the differences? are there any?
Demo heavy this session will show you some of the components on offer to help you reach your IoT needs and make an informed choice as to what you need and about what you should be thinking.
SessionID: 42756
Effective Index Partitioning, Compression Strategy
Event Date: 18-06-2016 - Session time: 08:00:00 - Track: Dev
Speaker: Neil Hambly
Title: Effective Index Partitioning, Compression Strategy
Abstract:
When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
SessionID: 45167
Managing Very Large Databases with SQL Server
Event Date: 18-06-2016 - Session time: 08:00:00 - Track: DBA
Speaker: Brian Carrig
Title: Managing Very Large Databases with SQL Server
Abstract:
If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you!
In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, backups and restores.
SessionID: 45684
How far can MS SQL Server Master Data Services 2016 take your business?
Event Date: 18-06-2016 - Session time: 08:00:00 - Track: Cloud SQL2016
Speaker: Dan Galavan
Title: How far can MS SQL Server Master Data Services 2016 take your business?
Abstract:
The challenges facing a successful Microsoft SQL Server Master Data Services implementation are vast. A key part of ensuring that success is being aware of out of the box MDS functionality, the benefits of Master Data Services in the context of Master Data Management, and the perilous pitfalls you may face. In this session you will learn how to
use MDS 2016 to support the Master Data lifecycle,
ensure Data Quality,
and succeed with Data Stewarding.
All this will be covered using a mix of presentation and demonstrations illustrating how your business can benefit from Master Data Services 2016.
SessionID: 48841
SQL Server Integration Services (SSIS) in SQL Server 2016
Event Date: 18-06-2016 - Session time: 08:00:00 - Track: BI And Analytics
Speaker: Matt Masson
Title: SQL Server Integration Services (SSIS) in SQL Server 2016
Abstract:
The 2016 release has a number of new extensions for creating Hybrid, Cloud, and Big Data processing flows, productivity improvements within the SQL Server Data Tools (SSDT) designer, and various improvements to the SSIS Catalog for server based package execution. Whether you are a new or existing SSIS customer, you won’t want to miss this session
SessionID: 51064
SQL Azure – DTUs and Delta (with on-prem)
Event Date: 18-06-2016 - Session time: 08:00:00 - Track: Cloud SQL2016
Speaker: Vikas Sahni
Title: SQL Azure – DTUs and Delta (with on-prem)
Abstract:
SQL Azure has been around for over five years, and is now ready for enterprise production workloads. This session will address the two issues that Architects, DBAs and Developers want to know more about as they move production workloads to the Cloud.
One topic is the mystery around DTUs (Database Transaction Units), the units that are used to indicate the relative performance levels of different tiers of SQL Azure. The first part of this session will explain the concept of DTUs and how to choose which one as the starting point.
The other topic is the difference in features between SQL Azure and SQL Server. Because of the fundamental multi-tenant nature of SQL Azure, there will always be differences between the two. Over the years, these differences are being continuously reduced, and this session will explain the current delta.
SessionID: 42750
The What, Why and How of Unit Testing SQL Server
Event Date: 18-06-2016 - Session time: 09:15:00 - Track: Dev
Speaker: Annette Allen
Title: The What, Why and How of Unit Testing SQL Server
Abstract:
SessionID: 44812
Introducing Azure SQL Data Warehouse
Event Date: 18-06-2016 - Session time: 09:15:00 - Track: Cloud SQL2016
Speaker: James Rowland-Jones
Title: Introducing Azure SQL Data Warehouse
Abstract:
This session will introduce you to one of the most exciting Azure data services - SQL Data Warehouse! SQLDW is a distributed database engine that delivers high scale to your data warehouse projects. Understand how it works in this 60 minute session.
Topics covered include:
- Key Concepts
- Scaling Storage
- Scaling Compute
- Data Loading
SessionID: 45108
Availability Group Maintenance Operations
Event Date: 18-06-2016 - Session time: 09:15:00 - Track: DBA
Speaker: John Martin
Title: Availability Group Maintenance Operations
Abstract:
AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.
SessionID: 45141
A Day in the Life of the Data Scientist
Event Date: 18-06-2016 - Session time: 09:15:00 - Track: BI And Analytics
Speaker: Buck Woody
Title: A Day in the Life of the Data Scientist
Abstract:
Just what is "Data Science", and what does a Data Scientist do? Is it really all that different than a Business Intelligence Designer, or other data professional? Join Buck Woody, from the Microsoft Machine Learning and Data Science team to learn the role, knowledge and skills involved with Data Science, and how a typical day progresses for the Data Scientist.
SessionID: 43054
Super Scaling Clustered Index Inserts
Event Date: 18-06-2016 - Session time: 11:45:00 - Track: DBA
Speaker: Christopher Adkin
Title: Super Scaling Clustered Index Inserts
Abstract:
SessionID: 44760
Data Driven Organisation: Machine Learning as part of an organisation's DNA
Event Date: 18-06-2016 - Session time: 11:45:00 - Track: BI And Analytics
Speaker: Jen Stirrup
Title: Data Driven Organisation: Machine Learning as part of an organisation's DNA
Abstract:
The session explores how organisations are using machine learning techniques to deliver agile analytics as they become a data-driven organisation's DNA.
How it is possible to imprint data-driven analytical thinking into the culture of the organization? Is Machine Learning viable for everyone? Analytics platforms have always been tools built for statisticians and data scientists. However, these tools are increasingly being directed at business analysts, and Gartner's rankings on its well-known "completeness of vision" and "ability to execute" axes now rest as much on "ease of use" as they do on offering advanced analytical algorithms.
Machine learning focuses the emphasis on the insights and value that data brings, and it is now accessible to organisations.
This session will help you to:
- understand how to craft an ML strategy
- provision the right business analytical capabilities
- move towards actionable results
- identify common pitfalls
SessionID: 44899
Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos
Event Date: 18-06-2016 - Session time: 11:45:00 - Track: Dev
Speaker: Jennifer McCown
Title: Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos
Abstract:
SessionID: 45850
Polybase in SQL Server – Big Data Queried with T-SQL
Event Date: 18-06-2016 - Session time: 11:45:00 - Track: Cloud SQL2016
Speaker: Hubert Kobierzewski
Title: Polybase in SQL Server – Big Data Queried with T-SQL
Abstract:
SessionID: 48843
SQL Lightning Talks
Event Date: 18-06-2016 - Session time: 11:45:00 - Track: Other
Speaker: SqlSat Dublin
Title: SQL Lightning Talks
Abstract:
4 Speakers delivering short sessions for the coveted "Best Lightning Talk" Trophy . Come along and vote for the best speaker for 2016.
- Andre Melancia: Be The Prized Bull With Microsoft Certification (MCP).
- Jens Vestergaard: Custom Assemblies in SSAS.
- Andrew Pruski: Introduction to partitioning
- Ben Watt: Three Ingredients in Power BI
SessionID: 52432
Event Date: 18-06-2016 - Session time: 13:00:00 - Track: DBA
Speaker: Tom Austin
Abstract:
In this session, you’ll see how to use them for impact analysis, team coding standards, sharing changes with your colleagues, unit testing your databases, and generating test data and documentation automatically.
By the time you leave, you’ll have seen dozens of ways you and your team can get more done with less hard work.
SessionID: 52434
BI Office from Pyramid Analytics Delivering Better Decision for Everyone
Event Date: 18-06-2016 - Session time: 13:00:00 - Track: BI And Analytics
Speaker: Nick Barth
Title: BI Office from Pyramid Analytics Delivering Better Decision for Everyone
Abstract:
To become a data-driven organization, business leaders need more than overhyped productivity tools and analytic engines to make decisions. They need a thoughtfully designed platform that empowers everyone to make data an integral part of their day-to-day processes and decisions. They need an end-to-end solution that can bring together disparate data in a governed environment that allows users to easily model, discover, communicate, and distribute information.
For years now Business Intelligence products have forced organisations to make a choice between Governance and Scalability on the one hand or Agility and Self-Service on the other. As a result, many Enterprises possess a patchwork quilt of Reporting, Dashboarding and Analysis tools creating multiple interpretations of the same underlying data.
SessionID: 42707
Session Details not available
Event Date: 18-06-2016 - Session time: 14:00:00 - Track: Cloud SQL2016
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 42796
Making PowerShell useful for your team
Event Date: 18-06-2016 - Session time: 14:00:00 - Track: Dev
Speaker: Rob Sewell
Title: Making PowerShell useful for your team
Abstract:
Come on a journey from The bloke that wrote some scripts to a professional solution for a whole IT team. A session for Powershell beginners and those wishing to improve how their team use PowerShell Each organization requires specific tasks that can be accomplished using PowerShell. I will show you how you can achieve this by demonstrating An easy way to learn the syntax How to explore objects with Powershell and turn your one off scripts into shareable functions How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
A fast-paced session with ideas and discussion points for you to take back to work
SessionID: 48845
The Expert Panel
Event Date: 18-06-2016 - Session time: 14:00:00 - Track: Other
Speaker: SqlSat Dublin
Title: The Expert Panel
Abstract:
Come along and discuss whats moving and shaking in the Data World with out Expert Panel.
- Buck Woody – the ML host
- Mark Souza – The AzureCAT legend
- JRJ - The scale out genius
- Matt Masson – The Integration guy
- Sean McCown – The Master DBA dude
Submit your questions live on twitter via #AskTheExperts or #SqlSatDublin
SessionID: 49375
Azure Machine Learning: From Design to Integration
Event Date: 18-06-2016 - Session time: 14:00:00 - Track: BI And Analytics
Speaker: Peter Myers
Title: Azure Machine Learning: From Design to Integration
Abstract:
Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.
In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.
This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
SessionID: 50892
Power BI Mobile - Answering Your Business Questions
Event Date: 18-06-2016 - Session time: 14:00:00 - Track: BI And Analytics
Speaker: Romi Koifman
Title: Power BI Mobile - Answering Your Business Questions
Abstract:
SessionID: 44222
WTF with SQL
Event Date: 18-06-2016 - Session time: 15:15:00 - Track: Dev
Speaker: Kennie Pontoppidan
Title: WTF with SQL
Abstract:
SQL is based on the relational algebra, right? Relational algebra is based on set theory, right? So we would expect SQL to kind-of respect common sense from set theory. Like A union A has the same number of elements as A. Well, this is not always the case with SQL.
Come and have fun when we explore scenarios of simple SQL statements, where I guarantee you moments of inner WTF.
SessionID: 44423
Revolutionary R integration in SQL Server 2016
Event Date: 18-06-2016 - Session time: 15:15:00 - Track: Cloud SQL2016
Speaker: Marcin Szeliga
Title: Revolutionary R integration in SQL Server 2016
Abstract:
• R can greatly simplify collection of different data.
• Data manipulation and preparation can also be way easier with R.
• You can use R to quickly explore and visualize data.
• Last but not least, R brings the whole power of modern data mining techniques to SQL Server.
As if this was not enough, you can use familiar user interface and SQL Server Enterprise R Services to work with large datasets and multi-threaded, multi-core, multi-process computations. So, even if you don’t know R at all, come and see how natural this language is for everybody who already think in rows and columns.
SessionID: 48842
The Most Important IT Person in the Room: Why Data Experts Own th
Event Date: 18-06-2016 - Session time: 15:15:00 - Track: Other
Speaker: Kevin Kline
Title: The Most Important IT Person in the Room: Why Data Experts Own th
Abstract:
SessionID: 51117
Beyond storing vast amounts of data: Data Lake Analytics
Event Date: 18-06-2016 - Session time: 15:15:00 - Track: BI And Analytics
Speaker: Miguel de Luna Gomez
Title: Beyond storing vast amounts of data: Data Lake Analytics
Abstract:
This year, many corporations are adopting a different strategy to deal with data based on the new principle of “store now, use later.”
This means that massive amounts of data are being stored in Data Lakes, but the processing of that data remains a major challenge. Let#180;s take a deep dive into Data Lake Analytics to process data from Terabytes to Exabytes.
SessionID: 52400
SQL Server BI – 2016 and Beyond
Event Date: 18-06-2016 - Session time: 15:15:00 - Track: BI And Analytics
Speaker: Matt Masson
Title: SQL Server BI – 2016 and Beyond
Abstract:
SQL Server 2016 has added many great new features to Reporting Services and Analysis Services, but we have even more amazing things to come!
In this session we’ll provide of overview of what’s been delivered in SQL 2016, and share our vision of what is coming in the feature – particularly around the relationship between Power BI, Excel, and SQL Server BI.