Sessions & Content

Tags
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.
An introduction to SQL Server in Containers
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
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
Application acceleration using DataCore software
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.
Benchmarking like a PRO
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.
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?
Building a Performance Monitoring System Using XEvents
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.
Building an End to End IoT Solution Using Pi Sensors & Azure
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
A practical look at the components of Cortana Intelligence Suite.
Career Advice from the SQLBits Industry Veteran Q&A Panel
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
Columnstore Indexes Worst Practices & Limitations
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 ...
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 Science for the SQL Server Professional
This Q&A panel is here to answer your questions and help you make sense of what Data Science means and how you can fit into this discipline. We have mixed the panel up with Data Scientists, and Non Data Scientist working in a Data Science team.
data.table power hour
Learn how to use this fantastic package in R for high-speed, low-code table wrangling.
Database Design Throwdown
Data architects and DBAs have debated database design best practices for decades. Join us for some great debates and laughs.
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 data modeling using Power BI and SSAS
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many and RLS.
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.
Designing for Concurrency
SQL Server normally relies on concurrency models in order to maintain the Isolation in ACID. As systems scale, this method can go from being a benefit to a hindrance, limiting the concurrency for our applications and hurting performance.
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.
Enhancements that will make your SQL Server roar-SP1 Ed.
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
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.
Flash Storage For The SQL Server Professional
The storage industry is at one of the greatest inflection points in its history. Learn the basics of flash storage and how conventional wisdom needs to change and how best to leverage what is fast becoming the main stream storage technology.
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.
Get Near Realtime ETL with Service Broker
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Get the best of both worlds with SQL Server R Services
In this talk, we learn the two ways that SQL R Services can be invoked one from the R IDE via the ScaleR package; and as a stored procedure directly from SQL Server Management Studio.
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
Hacking SQL Server
How easy is it to hack a SQL Server? In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll also cover recommendations on how to avoid these attacks.
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
Introducing the Query Store
The Query Store will change how you tune queries and gather metrics about them in both SQL Server 2016 and Azure SQL Database.
Introduction to Azure Analysis Services
Learn to build Analysis Services models in the cloud
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.
Introduction to SQL Server on Linux
In this session, Program Managers from Microsoft will provide an introduction to SQL Server and how it runs on Linux and container platforms.
<<12>>