Sessions & Content

Tags
Content Type
Search
Conference
‘Out of the box’ advanced analytics & data warehousing
Pyramid Analytics BI Office’s Enterprise BI Platform and PrecisionPoint’s data warehousing solution for MS Dynamics ERP systems combine to deliver simplified access to key Business and Financial data.
A Deep Dive Into Data Lakes
Learn the ins and outs of Azure Data Lake in this deep dive
Adaptive QP Enhancements in SQL Server and SQL Azure
The SQL team has been working on next-gen query processing improvements to improve the performance of your queries and to enable new scenarios. This talk will explain these enhancements and how they fit into the overall product roadmap for SQL.
Alerting; Beyond the Basics
We'll look at events that you should be monitoring, how you can use various services & IoT enabled devices to alert you in ways that were never possible. You'll leave with a new outlook of how teams can be notified to fix problems faster than ever.
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 the design considerations for clustered indexes and for nonclustered indexes.
Analysis Services in times of Continuous Integration
Continuous Integration has not yet been fully integrated into our BI standards and methods. Tool support is still somewhat unsatisfactory. Let’s look into requirements for a SSAS solution and on ways to approach your self-made solution.
Azure SQL Database best practices in resiliency design
We’ll share in the session best practices of designing highly available SQL Databases in the context of cross region deployment; how to make your application robust to handle transient connectivity issues.
Azure SQL DataWarehouse: 0-100 (DWUs)
Azure SQLDW - WHAT, WHERE, WHEN and HOW to use it.
Benchmarking & Testing In-Memory Performance
Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. This session gives you the details you need.
Better than PowerBI? Best-in-class, on-prem for Microsoft BI
Industry independent analysts say “Pyramid Analytics is essentially the best-in-class, on-premises offering for Microsoft BI today and tomorrow” What does this mean for you and PowerBI?
Columnstore killed the OLAP Star-Did it really?
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
Creating the single view of a Customer; at volume, without code
Business expects 360 view of Customer but data is difficult to build, challenging to clean and complex to de-duplicate. The challenge is to synchronise this data with systems of record. See how Profisee can solve this problem at volume & without code
data.table power hour
Learn how to use this fantastic package in R for high-speed, low-code table wrangling.
Database Security in SQL Server 2016 and beyond
In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB.
Deep Dive into SSIDB Catalog
A session to understand the available functionality of SSISDB Catalog
Deep dive into the secrets of Temporal Tables
Temporal Tables as a new technology in Microsoft SQL Server makes the implementation and management of data histories so easy. In this session, discover ALL the secrets of System Versioned Temporal Tables.
Digital Transformation using Power BI for your CEO
Make the right career move impressing your CEO and C-Level suite executives! Meet their specific needs with the right metrics and data visualisation. Power BI can help to bring clarity & predictability to the CEO to make strategic decisions.
Exploring Statistics: Where estimated rowcount comes from
A look inside SQL Server distribution statistics
Faster Provisioning with SQL Clone
Find out how the new SQL Clone enables self-service easy automation of database copies, near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.
Gems to help you troubleshoot query performance
In this session we will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance.
Getting CI right for SQL server
Write SQL unit tests with tSQLt and automate them with VSTS.
Getting Your Story Straight with Data Visualizations
Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data.
Graphs Are Everywhere - Graph DB Support in SQL vNext
Learn about graph databases and how they are implemented in SQL Server vNext
HADR for SQL Server on Linux
This session will cover High Availability and Disaster Recovery solutions for SQL Server on Linux. What technology options are available and how to build a highly available database solution on Linux
How to replicate your SAP data to the Microsoft platform using Attunity
The world’s largest enterprises run their critical business operations on SAP. See a demo of how to replicate SAP data to the Microsoft platform, avoiding the challenges of the complex underlying data models and structures.
Impact of weather on English Premier League in Power BI
By using open data and web scraping in Power BI we will examine if weather has an impact on games in the English Premier League. We will look at the advantages and disadvantages of using open data and web page data how Power BI works with it.
Including Your Database in a DevOps CI/CD Process
Many organizations want to build software in a DevOps framework, but struggle to include the database. Come see how Continuous Integration, Testing, and Continuous Deliver can work with a database.
In-database Predictive Analytics with SQL Server vNext
SQL Server vNext R Services and the new MicrosoftML package
Inside statistics-a guessing game
A query was running fast yesterday and today it suffers from performance problems. What will you do? - restart the server (did work) - drop the procedure cache (read in a blog article) - get a coffee and pass in review this session about statistics
Introduction to Deep Learning
What is the future going to look like? When are we going to reach true Artificial Intelligence? Is the Singularity going to happen? There is a lot of talk today about AI and what it means for the human society.
Keep Your Environment Always On with SQL Server 2016
The Microsoft Tiger team will showcase the environments that help you keep your environment Always On
Lifting the lid on SQL Server on Linux
Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He will explore the mechanics to deploy SQL Server on Linux, what is and is not in the current Linux build and share some of quirks, and observations on setup and config.
Machine Learning at Scale with Apache Spark
Richard will show you, from no knowledge of Spark, how to navigate the Spark framework ecosystem and build complex batch and near real time applications that use Spark's machine learning library mllib
Migrating from SQL Server to Azure SQL Database
Come to this session to learn about AzureSQL DB migration approaches, challenges, and solutions from SQLCAT. We will present practical migration guidance and learnings from our engagements with high scale and complex customer migrations
Near real-time IoT Analytics of Pumping Stations in PowerBI
An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI
New T-SQL Capabilities in SQL Server 2016 & v.Next
Discover the ins and outs of some of the newest capabilities of our favorite data language, and walk away with a long list of reasons to consider upgrading to the latest version - or the next version.
Normalization Beyond Third Normal Form
Many people think that normalization stops at Third Normal Form. But there are lots of higher normal forms. And they are not as complex or as irrelevant as often claimed. If you want to design better databases, then come attend this session!
Optimizer Secrets: Debugging using 860x Trace Flags
Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.
Optimizing multi-billion row tables in Tabular
In this session we will show you how Tabular performs when you are querying a model with many billions rows, conduct a complete analysis of the model searching for optimization ideas and implement them on the fly, so to look at the effect of using th
Orchestrating data with Azure Data Factory
See how Azure Data Factory orchestrates the movement of data in Azure, with a case study from a Microsoft partner.
Performance Pitfalls of Code Reuse
Learn how object-oriented T-SQL hurts performance.
Powershell community scripts for DBAs
We will take a look into my favourite Powershell scripts
Query Plans Deep Dive
An in depth look at query plans and the query optimiser
Query Store – What is it all about?
The Query Store functionality in SQL Server 2016 will change the way we look at performance going forward. Come see why.
Real world learnings from SQL Server 2016 Migrations
SQL Server 2016 is a class leading Tier One product but how do you get customers to upgrade and migrate? How can you address the "so what" SQL does everything I need to do now?
Review ColumnStore Index in SQL 2016 and Azure SQL DB
This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database
SQL Server 2016 It Just Runs Faster
Come take a deep dive and behind the scenes look at why SQL Server 2016 "Just Runs Faster" with little or no application changes.
SQL Server Internals and Configuration for R
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.
SQL Server Replication-What, How and Why
SQL Server Replication: What is it? How does it work? Why would you want to use it in your environment?
SQL Server/Azure Engineering Model
The SQL Team delivers value monthly to both cloud and on-premises environments. This is not easy to do. This talk will explain the model, telemetry and security
Statistics, Row Counts, Execution Plans, and Query Tuning
Row counts are the primary factor for choices made by the query optimizer. This session explores how row counts affects query performance.
Top 10 Clustering Dos and Dont's
Clustered instances (FCIs) and availability groups (AGs) can still be the source of pain and confusion for many. Learn from one of the world's experts on clustering SQL Server about some of the most important considerations to clustering success.
Unlock the power of the Pivottable
Pivot tables are very powerfull for analysing data, but a bit difficult to learn. This session will explain all the features to unlock the real power of the PivotTable
Using a gateway to leverage on-premises data in Power BI
I look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards for Power BI. This will start with Power BI Desktop, and the choices you have for SQL Server and Analysis Services.
Whats new in Azure SQL DB and SQL engine
Attend this session to get an overview of the wide array of significant changes and investments with Azure SQL Database, including parity with SQL Server 2016 and Intelligent database capabilities.
Who Am I? Managing Identities in Azure
Learn about identity management in Azure. You will learn about how to manage identity across your cloud environments.
Why Your Datatype Choices Matter
Learn how poor data type choices can cripple SQL Server.
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
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.
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.
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
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 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.
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
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
Designing Stored Procedure Solutions
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.
Developing For PowerBI
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
  1 to 100 of 697 first 1 2 3 4 5 6 7 last  Show 10 25 50 100 sessions per page