Toggle navigation
FAQ
Venue & Travel
Sponsors
Sessions
Training Days
Wednesday
Thursday
Friday
Saturday
Login
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Tags
performance
(32)
Content Type
Slide Deck
17
OtherSample
6
Video
27
Search
Conference
SQLBits X
32
5+ Database Design Blunders and How to Avoid Them
Karen discusses five (plus a few more) database design blunders with tips on how to avoid them. Audience members will also be able to contribute their war stories of design fails, WTHs and D'ohs.
A Deep Dive in SQL Server 2012 Data Warehousing
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
A heap of clusters
An in-depth dive into physical table structures
Architectural Patterns and practices SQL Azure
As a shared database infrastructure in the cloud, SQL Azure provides the opportunity for creating large workloads in a scalable and reliable environment.
Building a BI Portal for Tabular Models
The Microsoft BI stack has a number of tools for data visualization - Excel, Power View, native Reporting Services, and Performance Point. Come see each visualization applied to the new tabular model in Analysis Services.
Compression - Define your Strategy
The Enterprise only feature "Compression" can make a HUGE difference to your storage requirements and we will examine this feature in detail, integrate this into your strategies, finding objects which your should use this one
Load Testing Analysis Services
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
Loading Data Warehouse Dimensions in SSIS
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Maximizing hardware utilization for performance & lower TCO
In this session we will discuss ways to maximize existing hardware utilization to speed up queries. We will analyze cases of performance issue and tune them for better CPU, Storage and Memory utilization resulting in higher performance and lower TCO.
Memory Management for Analysis Services with SQL Sentry
Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.
<<
1
2
3
4
>>