Sessions & Content

Tags
Search
Conference
7 Databases in 70 Minutes
Learn about 7 SQL and NoSQL databases: how they work, when to use them, and how they form a modern data architecture
AD 2015. 2AM A Disaster just Began
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?
Agnostic, Hybrid Big Data Integration using PDW and PolyBase
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.
Alarm for Data Governance! Self-Service BI is coming
This session will show you what is possible in the Power BI Offering of Microsoft in relation to Data Governance
All about Indexes
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
All About Indexing
Indexes are the best instrument for query optimization. But what kind of indexes and on what columns? The key to answering those questions is understanding how indexes are stored and used by SQL Server. And that is exactly what this session is about.
Amazing Things You Can Do With Power BI
A fun session showing some amazing things you can do with Power BI
An End-to-End Troubleshooting Checklist for SQL Server
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.
An Introduction To Column Store Indexes and Batch Mode
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.
An introduction to the Power BI Designer
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.
Analysing Text with SQL Server 2014
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Analytics Master Class-exploiting exotic patterns in data
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).
Analyze data streams with Azure stream analytics
Azure stream analytics is a new Azure service for analyzing streaming data.
Automating Your Database Deployments
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 from the ground up
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.
Azure Networks and VMs for the DB Guy
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
Behaviour Analysis MDX
A SSAS MDX Deep Dive session covering the implementation of a business requirement to identify rogue behaviour over time and within SCD organisation groups.
Best Practices for multi-environment database development
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
BI DBA Performance Tuning
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
Boost your T-SQL with the APPLY Operator
The session starts with a brief overview of the operator and it
Branding Yourself for a Dream Job
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.
Budgeting with Power Pivot
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
Build your own Monitoring Environment with Powershell
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
Building a meta-driven near realtime ETL solution with BIML
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.
Building A Reporting Solution Using Power Query
See how to use Power Query to build a detail-level reporting solution
Building an Operational Data Store using SQL Server in Azure
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)
Building Big - In The Cloud
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.
Building scalable analytical solutions on Azure
Come to this session to see how to build a scalable analytical solution on Microsoft Azure with Elastic Search and Kibana.
Bulk load and minimal logged inserts
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?
Challenge Me! Capturing SQL Server Data with PowerShell
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.
Cloud Migration: The anatomy of a whole datacentre migration
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
Clustering SQL Server: What Does It Mean In 2015?
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.
Coeo Managed Support-More interesting support cases!
Come and hear about some of our most interesting SQL Server support cases from the last 12 months
Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit
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
Common Pitfalls When Analyzing Execution Plans
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…
Common TSQL Mistakes
A review of many TSQL mistakes I see over and over at clients! This is a 100%-demo session, with the bad AND good code presented. I GUARANTEE that you will find things here that help you be MUCH better at interacting with SQL Server!!
Continuous Integration for Reporting Services
Continuous Integration for Reporting Services
Cool Story, Bro: The DBAreactions Guide to SQL Server 2014
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.
Create SQL FCIs with AGs cross site with no SAN rep???
Multi Site Tier 1 HA solution: 5 parts (1 Windows Cluster, 2 lots of cluster storage, 3 SQL FCI’s & 4 AG’s)
Daily problems with indexing and its-possible-solution
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Data Culture
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.
Database Design: Size DOES Matter
Great database performance starts with great database design.
Daves SQL Fun Time Hour (Plus a bit)
In this session we'll take a look at a wide variety of topics, from useful and little known TSQL coding constructs to best case indexing advice and a whole lot more.
Deadlocking for Mere Mortals
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.
Deep dive into Delayed Durability
In this session you will see what is delayed durability, how it is achieved and how to make the best use case out of it. You will understand how to use it and a demo which explains the effects of using delayed durability with SSDs.
Deep Dive into Power Query Formula Language
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.
Deep into Isolation Levels
Isolation levels are one of the most complex subjects inside SQL Server and at the same time - one of the most important one. In this session we will take a look at all of them and see how they work behind the scenes.
Delivering Agile Analytics with Azure Machine Learning
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.
Deploying SQL Server with Microsoft Azure Virtual Machine
Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how
Designing a database to best support multidimensional OLAP
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
<<1234>>