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.
A fun session showing some amazing things you can do with Power BI
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.
In this session we will look in detail into some of the features for the Power BI designer and take it for a spin and investigating some of the new capabilities it has to offer for different relationships and new DAX formulas.
This session introduces SQL Server 2012 and 2014 text mining capabilities.
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 SSAS MDX Deep Dive session covering the implementation of a business requirement to identify rogue behaviour over time and within SCD organisation groups.
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
The session starts with a brief overview of the operator and it
Everyone wants a dream job that they enjoy going to each week. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself in today's competitive world.
Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on non-existing products
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
This presentation will focus on techniques and practices for using memory optimized tables in SQL Server to build “warm” data stores from a variety of application data sources (logs,traces, performance statistics)
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?
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
Come and hear about some of our most interesting SQL Server support cases from the last 12 months
This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites
In this session you'll learn how to analyze execution plans efficiently, how to track the real bottleneck quickly, and how to avoid some common mistakes that will save you a lot of time and frustration…
Continuous Integration for Reporting Services
You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.
Multi Site Tier 1 HA solution: 5 parts (1 Windows Cluster, 2 lots of cluster storage, 3 SQL FCI’s & 4 AG’s)
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Being able to reason over your data and accelerate your insights is essential in this cloud first mobile first world. This session visits key technologies, PowerBI, AzureML and IoT to help you start driving your data culture.
This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Join us to go beneath the UI, to learn how to unlock the full power of the underlying query engine and the formula language, and to truly conquer your data and data-shaping needs.
Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
In this session, you’ll learn about SQL Server stored procedures: what they are, when and why you'd use them, and how you would develop a solution with one. We’ll walk through examples to explore the process of solution building in SQL Server.
The Power BI Preview service offers developers a rich API service for anyone to interact with Power BI programmatically and create applications for Power BI. In this session we will introduce you to the Power BI developer story
One of the most important aspects of maintaining uptime with both availability groups and clustered instances of SQL Server is dealing with quorum. This session will cover multiple versions of Windows on how to approach, configure, and manage quorum.
This session will look at providing cost effective DR capability with Azure.
Today’s BI systems are often perceived as mission critical, but their value depends on the quality of data they contain. Learn to use SQL Server Master Data Services and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
EventStore is an event streaming database specialising in delivering CQRS, but capable of being a general repository for notifications. Get the skinny on how it works, the architecture and where you might use it.
The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective.
(1) Overview of the publish options
(2) How to control the layout
(3) Tips & Trick from real world examples
Extended Events are replacing the old SQL Trace & Profiler, and there are many good reasons for that. In this session I want to demonstrate to you some of the best features and possibilities of this Tracing Framework.
What's your data visualization vegetables, and what's your candy? This session will look at data visualization theory and practice.
Many triggers are inefficient and violate best practices, but it doesn't have to be this way.
Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
According to The New York Times, data scientists may spend as much as 80% of their time on “data janitor work.” Attend this session and discover five ways you can become the data hero in your organisation.
This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.
tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.
Come to this session if you want to find out about Microsoft's Document storage option in the cloud. You will leave understanding what it is, why it exists and how to get started.
Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure