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.
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.
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.
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 and Solutions
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 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
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.
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 warehousing features in SQL 2008
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.
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.
Using Excel as a Data Mining client is a very good move. Very visual and very easy to use.
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
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
In this presentation, I will introduce the Madison architecture and provide a roadmap with major milestones for this product
An introduction to SQL Server Master Data Services
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.
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.
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.
F# supports functional programming, object-oriented programming, and imperative programming. It is new langauge out of MS-Research and very closely resembles oCaml.
WHat's new in Reporting Services
Learn all about Optimistic Concurrency and how it works under the hood in this one hour session.
We all have tried and tested methods of doing things, but may be this new dog will help you do those old tricks?
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.