Platinum Sponsor
Conference
Clear
Content Type
Search
Clear
Tags

Sessions & Content

Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
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…
In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.
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.
In this session we will discuss how using flash with intelligent caching can allow an economical mix of flash and HDDs to be used to provide huge performance gains
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 is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
This session will give you insight into both of the current tracing technologies in SQL Server. Old SQL Trace has served us well but new times call for new technology. The new Extended Events are a new lightweight tracing mechanism built into SQLOS.
ioN Data Accelerator software transforms industry-leading open server platforms into powerful shared acceleration devices for multiple applications or clusters. Come learn how and why.
Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of SuperMicro's 2U Twin featuring Fusion ioMemory and achieve higher levels of availability with SIOS
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.
This session will demonstrate scripts to gather server inventory data and SQL Server and operating system performance data with PowerShell and provide reports to stay on top of your servers.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
SQL Sentry will present their revolutionary new software which provides enhanced visibility and manageability for advanced AlwaysOn topologies.
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature.
In this lunchtime session, Attunity will highlight real customer implementations of Attunity Replicate and the Microsoft BI technology stack that enabled them to achieve competitive advantage.
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one, discover all these important changes
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
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.
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!
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.
This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.
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.
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.
An in-depth dive into physical table structures
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.
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?
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
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.
This session will do a brief overview of Analysis Services 2012 performance topics, and drill into some common methods for investigating performance issues. The talk will be adjusted based on the audience interests.
Join X-IO to learn how customers like Redknee and Temenos are combining SQL Server 2012 with X-IO intelligent storage to generate higher performance at significantly less cost. Learn why storage is on the verge of a revolution.
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We'll also take a look into the ups and downs of each
Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism.
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
In this deep(!) dive session. I will walk you through the internal storage format of MDF files. I'll cover how SQL Server stores its own internal metadata, how it knows where to find your data, and how to read it once found.
The Column Store Index is an exciting new technology in SQL Server 2012. Using column stores, you can unlock new levels of performance for data warehouses – often gaining an order of magnitude speedup on queries.
This talk will describe how the new ColumnStore index technology in SQL Server 2012 makes queries go faster. Covering details of the storage and execution model, how this model interacts with modern CPUs to deliver significant performance benefits.
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
The addition of spatial data to SQL Server 2008 is one of the most important in terms of integration in line-of-business applications. This talk will discuss the new features and performance enhancements in SQL Server 2012.
This session will present you with a fascinating behind-the-scenes deep-dive view of the new column store index feature. How do column store indexes work? How are they built? And how can they yield such enormous performance boosts to some workloads?
The fill-factor index option has a huge impact on the performance of your DB. By using a different approach for specific use cases this session will give you the tools to find the most optimal fill-factor for your tables.
System Center Advisor assesses your servers’ configuration and helps you proactively avoid downtime, performance degradation, and data loss. It only takes 5 minutes to setup and is accessible wherever you have a web browser.
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
This session reviews the purpose of NUMA, how it changes the internal behaviours of Windows and SQL Server 2012 and NUMA related performance monitoring.
Based on healthcheck reviews of hundreds of SQL Servers across dozens of customers, I'll talk you through the 10 most commonly made mistakes by action or inaction and what you can do to make sure your SQL Servers get a clean bill of health.
For the most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most critical component in a SQL Server installation and is used by your applications and also internally by SQL Server.
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
Do you have data warehouse queries that run too long? In this session we’ll address how columnstore indexes speed up queries, best practices for creating and using columnstore indexes, and how to diagnose and treat potential issues.
  1 to 50 of 141 first 1 2 3 last  Show 10 25 50 100 sessions per page