Learn about 7 SQL and NoSQL databases: how they work, when to use them, and how they form a modern data architecture
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW?
PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.
This session will show you what is possible in the Power BI Offering of Microsoft in relation to Data Governance
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at guidelines for index creation
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
This session introduces SQL Server 2012 and 2014 text mining capabilities.
There are some little-known but very useful ways of extracting information from data.
This session will cover:
• Monte Carlo simulations
• Nyquist’s Theorem
• Simpson’s paradox
• Benford’s Law
These will rock your world (they certainly rocked mine).
Azure stream analytics is a new Azure service for analyzing streaming data.
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practise your deployments using continuous integration before you ever get near production
Azure Machine Learning is a fully managed cloud service for predictive analytics.
In this 1hour session, we will run through;
ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
A journey from dev to production. This talk covers best practices for developing and deploying Visual Studio Database Projects targeting multiple environments. We will cover using composite projects, pre and post deployment scripts and other optionst
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
The session starts with a brief overview of the operator and it
Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
See how to use Power Query to build a detail-level reporting solution
The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.
When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible?
Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees are encouraged to send challenges to the presenter via email for demonstration purposes.
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
Clustering no longer means just installing a clustered instance of SQL Server (FCI). Availability groups also are clustered. This session will demystify clustering as it relates to SQL Server.
Come and hear about some of our most interesting SQL Server support cases from the last 12 months