Sessions & Content

Search
Content Type
Conference
Tags
An introduction to the wonderful world of OData Wesley Backelant
Join me as I guide you through the architecture and capabilities of the OData protocol. Data has been locked inside applications for too long, allow me to show you how to implement OData and open up the data silos inside your company today!
Data loading at warp speeds Ami Levin
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
Database Design: Size Does Matter! Thomas LaRock
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.
DAX Query Engine Internals Alberto Ferrari
In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.
DAXMD: SSAS Multidimensional meets DAX and Power View Chris Webb
This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.
Estimation, Statistics and “Oh My!” Dave Ballantyne
At the heart of SQL Server is the cost based optimizer. This is driven by estimates and they in turn are driven by statistics. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong.
Excel 2013 - Whats new beside PowerPivot and Power View? Stephan Stoltze
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
Geospatial Data Types in SQL Server 2012 Leonard Lobel
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
Gone Clustering in 60 Minutes Edwin Sarmiento
This session teaches the fundamentals and principles behind how Windows Failover Clustering works and how SQL Server leverages on the technology, allowing you to build highly available database infrastructures.
Incremental processing of SSAS Multidimensional databases Dr John Tunnicliffe
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Inside xVelocity InMemory Engine (VertiPaq) Alberto Ferrari
A deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq.
The video is not available to view online.
Kerberos for SQL Server and SharePoint the easy way Dmytro Andriychenko
I would like to present easy to follow principles of Kerberos configuration with handy tips and templates to get this right the first time for your particular environment.
Lean and Mean: Running SQL Server on Windows Server Core Argenis Fernandez
Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management, along with lots of tips and tricks.
Monitoring and Performance Tuning for AlwaysOn SentryOne
SQL Sentry will present their revolutionary new software which provides enhanced visibility and manageability for advanced AlwaysOn topologies.
Searching Binary Data in SQL Server 2012 Steve Jones
A look at binary data in SQL Server and full-text searching of the content of binary files.
SSIS 2012 logging and monitoring Peter ter Braake
In this session we will learn about the SSISDB catalog views. We will use this info plus our own info to build a monitoring solution for SSIS using SSRS.
Tame Your Unruly Data...With Constraints! Rob Volk
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
The video is not available to view online.
The Developer Side of Master Data Services Sascha Lorenz
The Master Data Services offers an easy to use toolset to work with Master Data. In this session we will explore the hidden power of MDS to integrate this service in our solutions. Take your MDS Project on a higher level.
The Posh DBA: Troubleshooting SQL Server with PowerShell Laerte Junior
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
Top Ten Crucial Dev Skills to Make Your DBA Happy Kevin Kline
Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration
Transact SQL Performance Tips Milos Radivojevic
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.
Troubleshooting the most difficult SQL Server problems Klaus Aschenbrenner
Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session!
T-SQL : Bad Habits & Best Practices Aaron Bertrand
This session will cover a collection of minor bad habits that can occasionally lead to major problems, and a set of best practices that you should always have in mind.
Windows Azure SQL Database Troubleshooting Bob Ward
While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.
<<1>>