Sessions & Content

Search
Content Type
Conference
Tags
‘Out of the box’ advanced analytics & data warehousing Ian Macdonald
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 Ust Oldfield
Learn the ins and outs of Azure Data Lake in this deep dive
Adaptive QP Enhancements in SQL Server and SQL Azure Conor Cunningham
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 Richard Douglas
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 Gail Shaw
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.
An introduction to SQL Server in Containers Andrew Pruski
Containers are a new and exciting technology but what does it mean for DBAs? This session will give an introduction into SQL Server running in containers and what options are available.
Analysis Services in times of Continuous Integration Gabi Münster
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.
Application acceleration using DataCore software Andy Spencer
Application acceleration using DataCore software
The video is not available to view online.
Azure SQL Database best practices in resiliency design Kun Cheng
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) Simon Whiteley
Azure SQLDW - WHAT, WHERE, WHEN and HOW to use it.
Benchmarking & Testing In-Memory Performance Amit Bansal
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.
Benchmarking like a PRO Gianluca Sartori
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system.
The video is not available to view online.
Better than PowerBI? Best-in-class, on-prem for Microsoft BI Ian Macdonald
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?
Building a Performance Monitoring System Using XEvents Ola Hallengren
In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.
The video is not available to view online.
Building an End to End IoT Solution Using Pi Sensors & Azure Paul Andrew
Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.
Building Blocks of Cortana Intelligence Suite in Azure Melissa Coates
A practical look at the components of Cortana Intelligence Suite.
The video is not available to view online.
Career Advice from the SQLBits Industry Veteran Q&A Panel Chris Testa-O'Neill
Join industry veterans Steve Jones, Kevin Kline, and friends for a wide-ranging Q&A panel discussion covering all topics of career advice for the IT professional. We’ll discuss topics like personal branding, team leadership, trends in hiring, career
The video is not available to view online.
Columnstore Indexes Worst Practices & Limitations Niko Neugebauer
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ...
The video is not available to view online.
Columnstore killed the OLAP Star-Did it really? Niko Neugebauer
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 Dave Lawrence
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
<<12345>>