Sessions & Content

Search
Content Type
Conference
Tags
Data Mining and SSIS - makes sense Allan Mitchell
Using a predictive technology inside something that moves your data around really makes sense sometimes although not a lot of people are taking advantage of it. Let me show you how to use the two together
Data Warehouse Data Modelling Vincent Rainardi
Designing dimensional and fact tables using a case study to understand data modelling
The video is not available to view online.
Database Maintenance Optimization Brad McGehee
Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance.
Effective test-driven database development Gojko Adzic
Although test-driven development is now considered common sense in the OO world, it is very rare in database development. This session looks at the reasons behind this and presents solutions and best practices for test-driven database development. Database TDD and testing is analysed from two aspects: unit-testing in the database (stored procedures,views) and integration testing from the object service/web layer down to the database. I also present DbFit, an extension to FIT/FitNesse that makes database TDD easy This session is aimed at database developers, technical architects and Java/.NET developers working on enterprise applications.
Implementing Clustering using SQL Server Thomas Pullen
How to plan, install and configure a clustered SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions Davide Mauri
Come to this session to see how you can create a logging, monitoring and profiling solution for your existing or new SSIS packages overcoming all usual problems that a typical solution brings: increasing package complexity, longer development times and so on. The session will propose a standard, out-of-the-box solution for all of these challenges.
Making the SQL developer one of the family with Visual Studio Team System Richard Fennell
Showing how Visual Studio Team Edition for DB Professionals addresses problematic issues such as schema management, source control, testing, data generation and deployment.
NHibernate - Open Source Object Relational Mapping (ORM) Ben Hall
You maybe have heard about Linq to SQL, you may have heard about the Entity Framework but there is an open source framework getting a lot more attention called NHibernate.
SQL Server’s storage engine Dr András Belokosztolszki
What does it mean that my index is fragmented? Why do I get a warning about index record sizes? How should I store images in SQL Server? Knowing how SQL Server stores data and what options there are to control this can help you to build more efficient applications. In this session we will look at how table and index data is stored on disk. We will look at the various data types available, from bits to filestreams, how indexes can be used to optimize read or write performance, and how row and page compression work.
SSIS by example Peter Doyle
Discover how to build a real world SSIS package. Learn how to set up a package configuration, Manipulate package variables. Process multiple files and capture errors. Learn some workarounds for SSIS limitations (bugs).
Understanding ADO.NET Data Services Mike Taulty
Taking a look at what ADO.NET Data Services does for us in exposing data over a set of RESTful protocols for easy access from any kind of client.
Understanding Graphical Execution Plans Ashwani Roy
Graphical Execution Plans in SSMS is not only the best way to know what is happenning under the hood of SQL engine but also it is the most accessible one.
Universal calculated measures in MDX queries Tomislav Piasevoli
Among many of its functions, MDX language has one special set function - Axis() function. That function allows creation of calculated measures that are context aware and, if wanted, don't need to refer to any dimension or hierarchy in the cube. In other words, such measures are universal or independant, which means they can be used in any MDX query. In this session we will present such measures and explain how they work. We'll also show the way how to design them for various scenarios and discuss their potentials and weaknesses. Previous experience in writing MDX queries is recommended.
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices Satya Jayanty
SQL Server upgrade is no easy job, as DBA must go through upgrade methodology with options and considerations. Take help of freely available Upgrade tools from Microsoft and plan your database upgrade with a coverage of Pre-upgrade tasks, during upgrade and Post upgrade tasks.
What’s New in SQL Server 2008 T-SQL Martin Bell
SQL Server 2008 has plenty of new, improved and updated features including extensions to Transact SQL. In this presentation Martin will talk about and demonstrate some of the new T-SQL features.
The video is not available to view online.
<<1>>