Sessions & Content

Search
Content Type
Conference
Tags
“SQL Attack…ed” - SQL Server under attack: SQL Injection Andreas Wolter
In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual and automated SQL Injection, including a broadly unknown elevation of privileges attack.
A Comedy of Errors Andrew Whettam
Error handling in T-SQL stored procedures
A Look at 3 Big Data Tools Allan Mitchell
This session will look at SQOOP, PIG and HIVE. Three tools which are essential in your Big Data Toolbox. We'll look at what they do, how they do it and why you would want to use them
A One Hour Data Analysts Toolkit: using R and PowerBI Jennifer Stirrup
In this intensive one hour session, learn how to analyse and visualise your data using the Data Analysts Toolkit - Microsoft Power BI complemented with R
Achieving PCI with SQL Server - Don't be the next Sony Simon Sabin
This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification. We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality
Advanced Modeling with Analysis Services Tabular Alberto Ferrari
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
Advanced Reporting Techniques & Managing Reports Dr. Subramani Paramasivam
What are the techniques to implement linked reports, subscriptions, report history, snapshot options, editing report using browser based Report Builder? Find out in this session.
Azure SQL DB - Running a cloud database service at scale Nigel Ellis
In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies. This presentation will provide an outline of the scenarios and requirements for a database service.
Bad Plan! Sit! Gail Shaw
In this session we'll look at the common causes of bad execution plans and examine options for resolving the problem, short term and long term.
Basket Analysis using BI Office and SSAS Tabular Edition Pyramid Analytics
In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.
BI Tips and Tricks with SQL Server Reporting Services Adam Aspin
Impress the boss and your colleagues by delivering Dashboards, KPIS, maps and Scorecards wrapped in a tablet-ready interface with SSRS
Blend SQL Azure with SQL Server to drive Performance Insight Dell Software
Peter O'Connell will talk about how SpotlightEssentials.com uses SQL Azure to collect and mine over 40TB of SQL Server Performance data across thousands of instances to drive unique insights into SQL Server Performance.
The video is not available to view online.
Branding Yourself for a Dream Job Steve Jones
Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.
Building a BI Performance Monitoring Solution Stacia Varga
Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.
Building Your Myth Busting Lab With Power BI Julie Koesmarno
Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!
Building Your T-SQL Tool Kit: Window Function Fundamentals Christina E. Leo
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Cardinality Estimates in Microsoft SQL Server 2014 Thomas LaRock
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Column Store Index and Batch Mode Scalability Deep Dive Chris Adkin
A deep dive into batch mode scalability with column store index and SQL 2014.
Continuous Delivery for Data Warehouses and Marts John Welch
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Continuous Integration for Databases Steve Jones
Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.
<<12345>>