Sessions & Content

Tags
Content Type
Search
Conference
“SQL Attack…ed” - SQL Server under attack: SQL Injection
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
Error handling in T-SQL stored procedures
A Look at 3 Big Data Tools
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
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
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
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
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
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!
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
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
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
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.
Branding Yourself for a Dream Job
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
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
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
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
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
A deep dive into batch mode scalability with column store index and SQL 2014.
Continuous Delivery for Data Warehouses and Marts
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
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.
Data Security - In a Post Snowden World
Everyone knew how to keep data safe and secure, right up until Edward Snowden revealed this error. Learn how to keep the data secure, by identifying and quantifying the risks. Take away practical tips and advice to apply immediately.
Database Design Contentious Issues
Let's debate database design issues: NULLs, surrogate keys, datatypes, RI and more
DAX Patterns
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Deep-Dive to Analysis Services Security
This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.
Demonstrating PDW integration with Hadoop & Polybase
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.
Designing quality SQL Server 2014 solutions
This session shows how you can use SQL Server 2014’s features to meet your solution’s non-functional requirements and ensure operational success.
Dive into the Query Optimizer-Undocumented Insight
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
Do's and don'ts of database corruption
In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
Effective Index Partitioning, Compression Strategy
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression
ETL Patterns with Clustered Columnstore Indexes
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
Extending your datacentre to the cloud with SQL Server 2014
Microsoft is moving to the cloud and SQL Server 2014 is the first release with features designed specifically to extend your datacentre into the cloud. In this session we'll look at these features with end-to-end demos, discussions and scenarios so you can understand what the future could look like in your own SQL Server environment.
Fasten your seat belt and look at the Data Steward
In this session we will discuss Data Governance around Power BI and on-prem platforms. How to avoid dataset-hell. What are the best practices for sharing queries? Who is the famous Data Steward ?
From user groups to #sqlhelp-the SQL community explained
Run by folks heavily involved in the SQL community, this session explores what opportunities are out there for networking, learning and collaborating. Covering local, national, global, & digital communities, we'll put you in the know.
Getting Started Reading Execution Plans
Learn where to start reading execution plans and how to interpret them in order to understand how to tune poorly performing queries.
Hadoop: Big Data or Big Deal?
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
How the SQL Server Engine Thinks
How does SQL Server build results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be SQL Server. This session is for people who are comfortable writing queries, but not with indexes, statistics, and sargability.
How to Pick SQL Server Hardware
You don't buy a lot of servers, but you're about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions including SQL Edition, sockets, and RAM.
How to write professional Powershell scripts
It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.
Inside Ola Hallengrens Maintenance Solution
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
Integration Services (SSIS) for the DBA
In this session, you will learn what SSIS is, what components it consists of, and how to use the SSIS catalog to track the execution of packages and how to troubleshoot packages.
Interesting support cases from the Coeo Managed Support Team
Come and hear about some of the most interesting problem scenarios and solutions that the Coeo managed support team have been working on this year.
Intro to R
R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about.
Introducing XLCubed: More Microsoft BI power with less tools
Learn how XLCubed unlocks the value of Multi-dimensional and Tabular SSAS and SQL for power users in Excel; providing pixel perfect delivery of reporting, dashboards for both Web and Mobile and with or without SharePoint.
Introduction to BI Office
Attend this session to learn more about Governed Data discovery, get an overview of BI Office and find out why so many Microsoft customers are investing in this innovative BI Platform.
Is your data big enough for a PDW?
You have tuned your SQL server to it's limits, you have maxed the RAM on your server, and still your data warehouse is too slow. Is a Parallel Data Warehouse the next step?
I've Got A SQL Database, Now What?
So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you.
Latches, Spinlocks, and Lock Free Data Structures
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
Learn about SQL Server Buffer Pool Extension, flash storage
Learn more about use cases and limitations for buffer pool extension. We will also cover the performance gains it can bring to your environment.
Making the ODS the Centre of Your Data Strategy
Big Data has triggered the need for organisations to build real-time Operational Data Store (ODS) layers to feed the ‘Data Lake’ on Hadoop. Attend this lunchtime session to learn why a real-time ODS should be at the heart of your data architecture
MDX 101
In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.
<<12>>