Platinum Sponsor

Sessions Title

Filter Sessions:
400
Dev

We can think about a process memory dump as a photograph of the process memory at a given point in time – usually when something very wrong has happened. They can be used to perform post-mortem debugging to get the exact details on the nature of the problem and avoid them in the future. They are really important, but often overlooked, so this session will try to shed a little bit of light on crash dump analysis and postmortem debugging.

A brief introduction to WinDbg and adplus.vbs, as well as general postmortem debugging,  will lead to a series of examples where we will be able to determine the root cause of some SQL Server crashes (such as data corruption on a DBCC CHECKDB process) and SQL Server stability problems (such as the typical 17883 errors).

A discussion on how to debug common, but tricky, development problems will follow, with examples of debugging .NET applications failing to dispose the connections to the database properly, as well as other kind of database-related problems.

This session will be valuable both for DBAs who want to understand why their SQL Server instance - or cluster resource, etc - is crashing unexpectedly as well as for developers, who will add a new tool and skill set to improve their troubleshooting skills.

300
DBA
Wait Stats are the best kept secret in SQL performance tuning. This deep dive into wait stats will bring you up to speed on everything that you need to know about wait stats in SQL 2005/8.

Starting with the SQL execution model intternals we will cover all the common wait types, how they work, interpreting them, and how you can use them for performance tuning. We will also be covering key improvements in SQL 2008 and a few of the popular tools used by SQL consultants to analyse them.
300
BI
MDX Studio provides unique visualization of MDX expressions and allows the user to interact with different stages of MDX execution. We all also be looking at behaviour or formula engine and storage engine in context of various queries and how MDX studio helps to peep under the hood and understand what is going wrong with the query.It is built by Mosha Pasumansky, who is inventor of MDX and one of the Architects of Microsoft Analysis Services.
200
DBA

Learn to love SCOM!

Out of the box the SCOM Management Pack for SQL Server is not popular with DBA's.  This demo based session will take you through the process of how you can extend SCOM to properly monitor and analyse SQL performance, ultimately providing performance management dashboards for your CIO.

Like it or hate it - SCOM is the enterprise operational monitoring tool of choice for many organisations, so learn to embrace it and unlock the wealth of performance data captured.

400
DBA
In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms!
Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD.
I don’t have a quad core laptop yet, so I will do the best with my dual core!
300
DBA

Successful Logging for real Timber entails meticulous planning, acute selection, proper process and flawless execution which are all important to produce best returns. Transaction Log files in SQL Server are an extremely important component requiring careful planning for the correct sizing, careful implementation and acute management to keep the cogwheels of SQL server well oiled and chugging away to extract the best performance out of the system.


This session is filled with demos of real world samples starting with analysing the core structure of Transaction Log files and the role it plays in the different working scenarios. We will delve further into the role of Transaction Log file in planning on how to correctly size them, engineer manageable VLF's, choosing the correct recovery model and the intricacies of transaction log file usages with respect to checkpoint, snapshots, replication, crash recovery, database  backups, database mirroring and change data capture. We will deep dive into recovering from lost log files, a peculiar case of runaway tempdb log file and resolution, troubleshooting autogrowing log files. So bring out your chainsaws, sharpen your blades and get ready to start Logging the right way!

300
BI
Buiding highly performant data flows takes more than just dragging a few boxes onto the design surface and wiring them up. In this session I'll talk about SSIS's buffer architecture, synchronous and asynchronous transformations, performance tuning knobs and the OVAL technique for identifying bottlenecks.
300
Kat

In this session I'm covering the End-To-End track of how to detect, diagnose, and resolve performance problems in SQL Server (not a difficult job). Be aware that it may take few month to know about tools that can be used to monitor the performance, but it may take years of on-the-job experience to learn how 'best' to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.

The talk details and demonstrates native tools and techniques that can make your long days shorter and make difficult troubleshooting activities much faster and easier. This is not only for a DBA, every SQL Server user needs to know how to keep their database platform in pristine condition, and you'll need these skills to do it.



300
Dev
I run into a lot of performance problems in day to day work.
For a number of these problems I have some proven solutions "on the shelf".

Do you use UDF's ?
Do you have a search page on your site with multiple non mandatory options ?

I'll demonstrate the top 5 things I keep running into and what I do to fix that.
This session will be about database design and coding issues, not about raid levels etc.
300
Kat
Increase the "out of the box" performance and throughput of SQL Server. How can you double backup speed?, improve table scans?, load a single flat file as quickly as possible into SQL Server? What benefits does Solid State storage bring? This "free format" session is led by Henk Van der Valk, manager of the Unisys EMEA SQL Server Performance lab. It will give practical, real world advice for improving SQL performance and scalability, revealing details of a new offering from UNISYS; "SQL PowerRack", that combines high performance server technology and Solid State Storage to deliver new levels of performance for the most demanding SQL BI applications.
300
DBA
You can read the Microsoft marketing messages about how wonderful the HA options are in SQL Server. So what are they like in the real world? This session will discuss the theory, and see how it works in practice, related to my experience of Failover Clustering, Database Mirroring, Log Shipping and other "HA" options that exist. The session will also cover business considerations, like how expensive the solutions are, both for hardware purchase and software licensing.
This session is held over from SQLBits 5 when the speaker was ill.
300
Dev
Used properly, normalisation brings huge advantages.  It optimises storage (each piece of data is stored only once), it removes an entire class of update, insert and delete anomalies and it improves data integrity.  What more could we ask for?  Well, performance can be an issue.  Normalised databases often have a reputation for poor performance.  This talk will examine the role of normalisation on performance and focus on effective ways we can denormalise data and yet retain the data integrity that normalisation brings. 
This talk compliments that by Tony Rogerson beautifully and will be given by Mark and Yasmeen Ahmed who works with him at the University of Dundee.
300
Kat
In this session Greg Gonzalez, President and Product Manager for SQL Sentry, will illustrate how the SQL Sentry BI Suite provides unparalleled insight, awareness and control over the true source of performance issues across the entire SQL Server BI Platform. He will high-light some unique and patented features not seen in any other moni-toring product, from an animated real-time and historical Disk Activity view to pinpointing high impact SQL and SSAS queries.
400
Dev
Encapsulating common code in fucntions is one of the first things you learn as a programmer. However with SQL Server functions can be very bad for performance. In this session we will examine scalar functions in both TSQL and in .Net.
You will come away from this session understanding the pitfalls of TSQL functions and how you can make them run 100 times faster.
300
DBA
This session will be useful for anyone responsible for troubleshooting SQL Server performance problems.

The session provides details on when and how to use the PerfStats scripts to co-ordinate SQL Trace and PerfMon data capture and SQL Nexus for trace analysis.  These tools are completely free to use and make analysis of huge trace files trivial.

These tools provide reports and drill-down analysis for performance troubleshooting and are an invaluable tool for rapid problem diagnosis.

Following this session, attendees will be familiar with the PerfStats and SQLNexus troubleshooting tools, knowing where to get the tools, when to use them and how to interpret the results.
300
BI
Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
300
BI
This session will show how Excel PowerPivot could beused as the sole tool for creating Business Intelligence prototypesquickly.  End users would have access to an initial version to have theoption of handling the final product without having to wait for a more advanceddevelopment. This way of working can bring benefits over the traditionalway of creating prototypes for BI and even could be made without the need ofpurchasing a specific hardware. We will be able to use a local machine for itscreation, aside from that, the solution would be very portable--we will justneed to move/copy the file from one machine to another in order to distributeit across different users or even just publishing it in MOSS. At the endof the session we will have connected to different data sources to create anExcel spreadsheet that will reinforce our vision of the user to the new tool,helping you better understand the implementation to be performed and will helpus to validate the requirements and needs of our BI solution.
300
BI

David Elliott and David Prime from Betfair will be presenting.

This session will investigate using Stream Insight, SQL Server and Analysis Services to provide an example framework to monitor cube usage as well as suggest a mechanism for highlighting areas for performance and security enhancements.

200
Dev

This session will help you understand the basic concepts of building SQL Azure applications. After an overview of SQL Azure, we will walk you through details;  such as setting up a SQL Azure account; connecting to SQL Azure; managing logins and security; creating objects; migrating database schemas and moving data. This will be demonstrated by showing how to building a simple application.

300
DBA
This session will cover how and why you should configure tempdb, how to troubleshoot tempdb issues, and how to detect, resolve, and mitigate allocation contention issues by creating multiple data files, optimizing temporary object reuse, and using trace flag 1118.
200
BI
So you've gone to all the trouble of building a cube, and your users are complaining that their queries are still too slow? This session will show you how to tune query performance on Analysis Services 2008, looking at partitioning, designing aggregations and identifying MDX-related bottlenecks.
400
Dev

SQL Server 2008 provides a lot of scaleout technologies. In combination with Service Broker you can build message-based applications that can be scaled out to any required workload and size. In this session you will learn the basics of scaleout technologies available in SQL Server 2008 and in Service Broker. We’ll cover in detail:

*) Scaling out with Service Broker
*) Load Balancing
*) Routing
*) Service Broker message forwarders
*) Broker Configuration Notice Service

400
BI
In almost all data warehouses there is a requirement to quickly get data into SQL Server. In this talk, I will present the different options you have: SSIS vs. T-SQL. We will look at some common design patterns for scalability and take a deeper look at how the Bulk API for SQL Server works.
300
Dev
When systems are under load, it is usually the database that is a bottleneck.  You can unblock the flow of data by taking the database out of the equation, but is this realistic, possible or desirable?  This session starts by calling bull on database ivory towers, exploring the options that database professionals seldom consider but are already becoming mainstream with highly scalable and performant systems.  Some of the newer approaches such as caching, eventual consistency, NoSQL databases and complex event processing are covered and their pros, cons and applications discussed
300
BI

This session discusses the impact of various design/modelling aspects and SQL Server features to the query and loading performance of a SQL Server data warehouse.

  • How various data warehouse design/dimensional modelling aspects like fact table primary key, foreign keys, snowflaking, fact grain, transaction dimension, slowly changing dimension type 2, periodic snapshot, incremental extract, accumulated snapshot and fact normalisation affects the data warehouse query performance and loading performance.
  • How SQL Server specific features affect (can be used to improve) the query and loading performance of a SQL Server data warehouse, for example: partitioning, clustered index, indexed views, filtered indexes, bitmap indexes, change data capture, data compression, merge statement, incremental delete, query/table hints, joins, data types, minimally logged insert, data/log files, filegroups, autogrow, tempdb, recovery model, and scalable shared database.

 

200
DBA
You have landed a new challenge. The customer doesn't know how many SQL Servers they have, has no operational tools, poor performance and needs help getting started. Sound familair?

This session walks through the process of using free tools to help discover SQL Server Instances across an organisation and analyse the health, configuration, compliance and performance of 200 servers within 24 hours.

Tools used are SQLH2 health tracking tools and Microosft MAP toolkit.
200
DBA

Need to build a fancy N.O.C. style dashboard ?

This session demonstrates how to use Powershell to build a fully featured real time performance dashboard for SQL Server.We will be going through the major resource groups to monitor, key thresholds to use and how to build your own performance dashboard in minutes.

Featured technologies are WMI performance counters, Powershell and Poshboard - the free web based IT portal build with Silverlight, and Powershell and recently released on codeplex.

300
BI
Fast Track is a new reference data warehousing architecture provided by Microsoft. More than this it represents a new way of thinking about data warehousing. A Fast Track system is measured by its raw compute power - not by a DBAs ability to tune an index. Fast Track is an appliance-like solution that delivers phenomenal performance from a pre-defined, balanced configuration of CPU, memory and storage using nothing but commodity hardware.

Of particular interest in a Fast Track system is the way in which the storage and SQL Server are configured. To achieve the fantastic throughput without using SSDs requires some careful configuration.  This configuration is designed to make use of Sequential I/O to dramatically improve disk I/O performance.

Interested? If you have a large data warehouse that's seen better days or perhaps you are about to embark on a new warehousing project then you should be!  Fast Track is a great solution with a fantastic value proposition.

In this one hour session we'll aim to get under the skin of Fast Track and get some answers as to how it delivers such great throughput on commodity hardware. In the process we'll aim to answer the following questions:  
  • When might I need Fast Track? 
  • What is Sequential I/O?
  • How does Sequential I/O improve performance?  
  • What do I need to do to get Sequential I/O?  
  • How can I monitor for Sequential I/O ?
  • What may I need to change in my ETL to get the benefit of sequential I/O?

Allan Mitchell will be showing how to build SSIS packages to take advantage of sequential IO performance.

Still reading?  I'll save you a front row seat....
300
BI
Setting proper relationships for the attributes of a dimension is essential from a query performance point of view. It is one of the most important things while dimensional modelling.
Aggregations are pre calculated summaries of cube data that help enable Microsoft SQL Server 2005 Analysis Services (SSAS) to provide rapid query responses. Aggregations are like fact table data grouped and aggregated to a higher level in the Hierarchy. Building the correct aggregations can greatly enhance query performance.
MDX Studio can be used to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships. MDX Studio provides unique visualization representation of MDX expression and allows the user to interact with different stages of MDX execution. It is built by Mosha Pasumansky, who is inventor of MDX and one of the Architects of Microsoft Analysis Services.
300
DBA

With examples we will discuss tips and tricks that will be useful for Developers, DBAs and Consultants.

300
BI
Microsoft SQL Server 2008 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. This session covers the new scalability features of SQL Server Reporting Services 2008, such as on-demand processing and improved memory management. The session will demonstrates how to build a high performance, scalable reporting platform and explains performance tuning techniques to ensure that report performance remains optimal as your platform grows.
300
Kat
This demonstration shows you how to manage database changes using source control within SQL Server Management Studio. Source controlling the database is quick, and lets you track database changes, seeing who made them, when, and why. Source control can work with your continu-ous integration environment so database changes kick off automated tests. This ensures any problems are caught quickly. Once these changes have been tested, deployment to your test or production servers be-comes a simple operation.
400
DBA
This session details a typical DBA's day demonstrating the new improvements of the Management Platform & Performance monitoring made for Microsoft SQL Server 2008.

We will concentrate on how best you can make use of tools (pre-installed) of Microsoft, as they pertain to efficient systems management, multi-server management, performance tracking, and policy implementation. Take advantages of detection and enforcement of security policies & design practices in your database environment  using both graphical and command-line tools. We cover everything from the new Management interface in SQL Server and Management Data Warehouse that also have a practical demonstration of PowerShell integration in SQL Server administration tasks, not to mention about best practices. 
        
400
DBA
So how does SQL Server pick which plan to run?  If you've ever wanted to get a better understanding of how the Query Optimizer works, this is the talk to attend.  Come listen to a member of the Query Processor development team explain how a query goes from SQL to the final plan.  This talk will cover conceptual topics like how query trees are built and how the optimizer stores all of the alternatives it is considering.  Additionally, the talk will examine examples in areas including index matching, parallel query generation, and update processing so that you can apply these concepts to better debug your own queries using the same techniques.
300
Kat
Presented by Quest Software's Iain Kick, Senior Technical Consultant SQL Server. What do you do when the SQL Server Service won't start? Techniques covered to quickly alert to service failure and where to go to iden-tify and fix any issues. This presentation will cover the native Microsoft solutions and Quest's Spotlight on SQL Server Enterprise ‘New way'. Attend this presentation to receive your free Spotlight on SQL Serv-er Enterprise licence, conditions apply.
300
Dev
Bad performance is often systemic of poor queries which are systemic of bad schema design which is systemic of non-relational thinking which is systemic of project time constraints and lack of understanding of Database Design. In this talk/tutorial I'll work my way through Normalisation, we'll look at the Relation Model and how to think in sets - it's very important; throughout I'll be referring to Codd and Date's teachings. Theory aside I'll do all my demonstrations in SQL Server - concurrency, indexing, good T-SQL practices and advice.
300
DBA

Performance troubleshooting is a key aspect of any operational DBA's role and identifying performance bottlenecks quickly enables faster problem resolution. 

PAL helps identify problems quickly by processing large log files and providing a colour-coded report highlighting problem areas.

Here's a summary of the session:

  • Performance troubleshooting
    • Troubleshooting methodology
    • Data capture
  • Using Performance Analysis for Logs (PAL)
    • Analysing PerfMon log files
    • Tuning thresholds
    • Working with theshold templates
  • Post-analysis steps
    • Establish a baseline
    • Next steps for troubleshooting
300
DBA
With the combination of Windows Server 2008 R2 and SQL Server 2008 R2 it has now become possible to run SQL Server on up to 256 Cores. Recently, the SQL CAT team had a customer in the lab to test a banking application at high scale-up. Previously, we had test runs for the same application on 32-cores – but now the time had come to stress the app to 128 Cores.
In this session, I will talk about the lessons we learned from stress testing an OLTP workload at this scale. You will see some interesting bottlenecks and get an idea of what sort of numbers are achievable on a big SQL Server box. Of course, I will also provide you with the guidance on how to get those numbers.
300
BI
Tips from the field on getting the most out of SSIS
200
DBA
New to troubleshooting SQL Server? Not sure where to start? In this session you'll get an introduction on how to review the performance of a SQL Server installation including what thresholds and configurations to look out for and how to delve deeper once you've mastered the basics.
300
Dev
Do you know SQL Server Execution Plans? Yes! - and can you read/analyze them? No... For the beginner it is not very easy to understand and explain execution plans generated by SQL Server for your queries. Therefore this session gives you a good overview and understanding about SQL Server execution plans and how you can read them without reading through complete books. In this session you will see the basic constructs of an execution plan, and how SQL Server uses them to translate your SQL based query to an internal format which is executed by the execution engine of SQL Server. After attending this session you are able to understand and analyze execution plans generated by your queries, and how you can tune them with the adoption of additional indices. Finally you will also see which additional information about your queries an execution plan will expose to you.