Sessions & Content

Search
Content Type
Conference
Tags
AddIns for SSMS - build your own Hue Holleran
SSMS is a great environment ... and here's how to make it even better: write your own AddIn - here's how!
The video is not available to view online.
Comparing Azure storage and SQL Data Services Simon Munro
Comparison between Azure storage and SQL Data Services
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.
Data Warehousing features in SQL 2008 James Rowland-Jones
SQL Server 2008 has a ton of great features to help you in your data warehousing endeavours. In this session find out what they are and how you can best use them.
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.
Designing Effective Aggregations in Analysis Services 2008 Chris Webb
This session will show you how to build aggregations in Analysis Services 2008 that are useful for the queries you're actually running
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.
End to End Report Creation and Management in SQL Server Reporting Services 2008 Chris Testa-O'Neill
Get off to a flying start with Microsoft Reporting Services 2008, exploring an end to end solution to enables you to facilitate report creation and facilitation!
High Availability in SQL Server 2008 Justin Langford
Database availability is important to every DBA and selecting the right solution to satisfy availability requirements can be a difficult choice. Attendees will be presented with an overview of each technology and complementary technologies enabling them to make better choices of availability solution.
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.
Message in a bottle: Service Broker from 1 to 100 in 75 minutes! Klaus Aschenbrenner
Service Broker provides several new key features for building SOA applications directly with SQL Server 2005.
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.
Performance Optimization with SQL Server 2008 R Meyyappan
Best Practice Guidelines for optimal performance while using the new SQL Server 2008 features: Filtered Index/Statistics, Resource Governor, Row Compression , Page Compression, Server Configuration Option: 'optimize for ad hoc workloads', Plan Freezing, Table-Valued Parameters, Disabling Table Lock Escalation, Transparent Data Encryption and more.
The video is not available to view online.
Performance Tuning your TSQL Simon Sabin
A indepth insight into performance tuning database applications.
Securing and Hardening a SQL Server Implementation - Notes from the Field Ross Mistry
SQL Server is regularly targeted by hackers as it is a repository of sensitive data for organizations. If breached, hackers can gain access to confidential information including, but not limited to credit card numbers, social security numbers, and marketing information. This presentation covers topics pertaining to best practices and tips on how to secure and harden a SQL Server 2008 & 2005 implementation. Some of the security and hardening topics covered include: minimize surface area with policy based management, encryption, advanced auditing, configuring a Windows Server 2008 firewall, applying security templates with Active Directory, and consolidating SQL Server logs.
SQL Server Architecture: The life of a query Christian Bolton
In this session I will be bringing together all the components of SQL Server to illustrate what happens when you issue a query from a client. From the TDS packet, through ODS, the optimizer and the buffer manager to returning the result. I'll walk you through when the transaction log is used, what happens when a checkpoint occurs and what the lazy writer does. I've illustrated the process in a way that's easy to consume and helpful to put SQL Server's architecture into context.
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.
<<12>>