Sessions & Content

Search
Content Type
Conference
Tags
A whistlestop tour of SSIS add-ins Jamie Thomson
There are a number of 3rd party add-ins available that may aid your SQL Server Integration Services (SSIS) development. In this session I will demonstrate some of them.
Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study Satya Jayanty
Achieving application uptime of 99.99% is not an impossible task, can be accomplished if you apply right procedures at right time!
An introduction to Master Data Services Ian Marritt
Master Data Services is a new product due for release with SQL Server 2008 R2. This presentation will explain why you may want to use it and what it will help you achieve and some of the challenges you may face.
Building cubes from ODS or Operational Systems Vincent Rainardi
A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.
Cache-warming strategies for Analysis Services 2008 Chris Webb
Learn how the Analysis Services cache works, and how you can pre-load it with data to ensure optimal query performance.
Common Integration Services Problems Allan Mitchell
Common Integration Services Problems and Solutions
Creating High Performance Spatial Databases Alastair Aitchison
So you heard about the new spatial functionality in SQL Server 2008, rushed back to your database and added geography and geometry columns to all your tables, eager to create the next Google Earth-beating application. You then click the Execute button and wait. And wait. And wait some more. (You get the idea). Spatial data is a rather unique beast, and designing efficient spatial queries requires specific techniques when compared to other, more traditional types of data. In this session, we look at how the SQL Server database engine satisfies spatial queries, the theory behind spatial indexes, demonstrate the effects of altering the bounding box, use the spatial system DMVs and stored procedures to your spatial database
Data & Backup Compression in SQL Server 2008 Andre Kamman
The new compression features built into the Enterprise Edition of SQL Server 2008 should use less disk space and, perhaps even more important, speed up your system because of reduced disk IO. In this session we will : Take a look behind the scenes to see how it works. Investigate what commands / tools we can use to set it up and maintain it. Look into some examples of my own day to day experience that I collected so far. I aim to give an overview of both data compression and backup compression AND some Lessons Learned.
Data Visualisation with Bing Maps for Enterprise Matt Feltham
Has the way you present your data become a bit bland? This session will take you through how combining your location based data on a map using Bing Maps for Enterprise(previously Virtual Earth) can add an interactive edge to the visualisation of your data.
Data Warehouse on a Fast Track forwards Anthony Howcroft
Explore the Fast Track Data Warehouse appliances from HP & Microsoft with case studies, implementation thoughts, and roadmap.
Data warehousing features in SQL 2008 James Rowland-Jones
Data warehousing features in SQL 2008
Designing for simplification Rob Farley
Allowing the query optimiser do its job of simplification is an important feature if any database design. In this session, Rob takes us through ways that a database design can leverage features of the query optimiser such as redundant joins and end up with a system the provides a much simpler querying environment.
Designing I/O systems for SQL Server Thomas Kejser
In this session we will take a deeper look at how SQL Server uses I/O and how you can design the I/O system to meet the requirements of your applications.
Excel - An Excellent Data Mining Tool Allan Mitchell
Using Excel as a Data Mining client is a very good move. Very visual and very easy to use.
Getting Dimensional with Data Chris Testa-O'Neill
This session will introduce you to the core components required to set up and create a cube in SQL Server Analysis services. consideration is given to SQL Server 2005 and SQL Server 2008 to be considered for Friday
I need my reports..........Yesterday! Chris Testa-O'Neill
Due to feedback from previous SQLBits conferences, this session will focus on the management of the reports and report server once the reports have been created to be considered for Friday
Introducing Project Madison Thomas Kejser
In this presentation, I will introduce the Madison architecture and provide a roadmap with major milestones for this product
Introducing SQL Server Master Data Services Donald Farmer
An introduction to SQL Server Master Data Services
Introduction of MS StreamInsight Rob Farley
StreamInsight is Microsoft's technology for Stream Data Processing and Complex Event Processing (CEP). In this session you will get an overview of what CEP is, what problems it tries to solve and how StreamInsight tries to do it.
Introduction to the Microsoft BI Technology Stack Dr John Tunnicliffe
John will introduce you to Analysis Services 2008, demonstrate browsing cubes with Excel 2007, deploying dashboards in SharePoint built using Excel Services and demonstrate how PerformancePoint Services can add the glitz to your BI project.
Let’s make SQL fly - a technical session for developers and administrators who believe in magic! R Meyyappan
In this session we will analyze and resolve a real world SQL Server Performance issue. We will first identify a customer’s query performance issue and understand the reason for the non optimal performance of their application. After understanding the limitations it will of course be natural to invent and perform non TCO increasing magic to make SQL Server really fly. We will also provide few words of caution for those who might abuse the newly acquired magical powers. This deep dive, no fancy power point show is equally designed for developers and administrators. If you are one of those who would rather perform the magic on your own laptop than just observe it being demonstrated, send me an email so I can send you the demo scripts to prepare yourself for the adventure.
Lets go more functional - F# WHAT , WHY and BI Ashwani Roy
F# supports functional programming, object-oriented programming, and imperative programming. It is new langauge out of MS-Research and very closely resembles oCaml.
Microsoft SQL Server 2008 R2: What’s New in Reporting Services Donald Farmer
WHat's new in Reporting Services
Optimistic Concurrency Internals James Rowland-Jones
Learn all about Optimistic Concurrency and how it works under the hood in this one hour session.
Powershell - old tricks for a new dog? Martin Bell
We all have tried and tested methods of doing things, but may be this new dog will help you do those old tricks?
The video is not available to view online.
Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework Martin Cairney
Wouldn't you rather spend your day learning all the funky new features in SQL Server 2008 than running all your daily checks over your instances? SQL Server 2008 introduced Policy Based Management which allows a fine-grained level of configuration and control of the instance's properties. The Enterprise Policy Management Framework takes this and extends it out to allow you to manage SQL 2000 and 2005 instances through policies as well.
Real World SQL Server High Availability Thomas Pullen
The advantages, disadvantages, pitfalls and benefits of the various High Availability options in SQL Server.
The video is not available to view online.
Report Builder 3 Andrew Fryer
What can it do for me?
Self Service Business Intelligence- Project Gemini Bob Duffy
Microsoft Project Gemini brings data modelling and Business Intelligence in the hands of the end user - good or bad. This session demonstrates how to build and deploy an end to end business intelligence solution with project Gemini.
Server consolidation with SQL Server Justin Langford
Planning and design considerations for running a SQL Server consolidation project.
SQL 2008 Development Features Simon Sabin
SQL 2008 Development Features
SQL Injection Attacks (and how to prevent them) Colin Angus Mackay
In this talk Colin Mackay will show you what a SQL Injection Attack is, what they look like, how they work and most importantly how to defend against them.
SQL Server 2008 - Unstructured Data Storage Solutions and Best practices Satya Jayanty
Storage of large volumes of unstructured data - build a strategy by following best practices.
SQL Server optimization stuff you won’t find on Google (yet) Andre Kamman
Henk van der Valk from the Unisys performance lab will be my special guest for this session. He has a test system that we all would like to have at home. The ES7000 has 96 Cores and half a Terabyte of RAM yes RAM (!). We will look at various ways to push SQL Server workloads by methodically detecting and resolving bottlenecks.Together we will show you how you can apply this approach on mid-sized and even smaller systems. (We’ll even try some of them on a laptop, and of course we will remote connect into the big machine ) In this session you will: Learn how to measure what the next bottle-neck is,using perfmon and waitstats. Hear about optimization tips that will get the most out of your hardware to speed up your processsing.
SQL, NoSQL, SomeSQL - A look at non-relational databases Simon Munro
Some people are attempting to unseat the dominance of teh SQL RDBMS. What are the NoSql databases? Are they a threat? Do they actually work? What do they look like? This session contains some answers and offers a context for where non relational databases fit into the picture.
SQLDataSources, LINQDataSources and EntityDatasources in Database Design Andrew Couch
In this talk we will contrast and compare developing WebForm applications using Visual Studio 2008 with different types of datasources. We will be looking at design issues relating to concurrency control and updateability when using key Visual Studio controls such as the FormView and ListView controls. So if you don’t know where to start in choosing between SQL, LINQ and Entity datasources then you will by the end of this talk. We will also take a look at techniques for the seamless integration of ASP.net security with SQL Server Login security for web applications using LINQ.
SSIS in SQL Server 2008 Allan Mitchell
A look at some of the things that make using SSIS in SQL Server 2008 a very good choice for your ETL requirements
Strapped for cache? - Troubleshooting memory problems in SQL Server 2008 Christian Bolton
Learn the terminology, architecture, features and best practices that can help you understand, troubleshoot and avoid memory problems in SQL Server 2008.
The R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core Andrew Fryer
In this session we will cover 3 new enhancements to the Database Engine. Application and Multi-Server Management introduces new capabilities for managing, monitoring and exploiting your SQL Server Infrastructure through the new SQL Server Control Point and enhancements to SSMS and Policy Based Management and Data-tier application packages. SQL Connection Plans allow you to logically refer to an application in connection strings rather than servers making migration of database applications across your SQL Server infrastructure much easier. Unicode compression in R2 enhances the native data compression capabilities introduced in SQL 2008 for Unicode data using SCSU (Simple Compression Scheme for Unicode Data)
T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig Brent Ozar
Making your T-SQL fast isn't really all that different from building and driving race cars. Learn lessons from racing icons that you can apply right away in your databases.
Using Perfmon and Profiler Brent Ozar
Got a slow application or server, and not sure where to start? Brent will explain how to use the two most popular free tools and how to read their results.
Virtualising SQL Server Justin Langford
This session provides details on approaching a SQL Server virtualisation project.
Vital Statistics Christian Bolton
In this session I will be exploring the role that statistics play in query optimization covering how and when they are created, what they look like, how they are updated, and what scenarios will benefit from you creating them yourself.
What's new in R2 for the DBA Jasper Smith
In this session we will cover 3 new enhancements to the Database Engine. Application and Multi-Server Management introduces new capabilities for managing, monitoring and exploiting your SQL Server Infrastructure through the new SQL Server Control Point and enhancements to SSMS and Policy Based Management and Data-tier application packages. SQL Connection Plans allow you to logically refer to an application in connection strings rather than servers making migration of database applications across your SQL Server infrastructure much easier. Unicode compression in R2 enhances the native data compression capabilities introduced in SQL 2008 for Unicode data using SCSU (Simple Compression Scheme for Unicode Data)
The video is not available to view online.
When a query plan goes wrong Simon Sabin
This session looks at some of the common scenarios when query plans can go wrong leading to your performnce suddenly hitting the wall. We will talk through what happens, why it happens and ways in which you can avoid it happening.
<<1>>