200
DBA
This session isn’t out to teach you how to build indexes, it’s out to give you the tools and techniques to understand how your current indexes are performing. Practical methods to identify and capture index usage and adjust granularity to your working environment.
How to use the dmv’s to your advantage. The session is built around the GrumpyOldDBA’s tuning work with tables of several hundred million rows in an ERP application. All code will be provided.
|
200
DBA
How to use Perfmon, Visual Studio Team Edition, SQL Profiler, DTA, Analysing Trace Output and ClearTrace to identify poor performance areas in your system.
|
200
DBA
Do you want to increase your SQL Server database availability and deliver high performance solution? Do you agree fast failover with minimal data loss has traditionally involved higher hardware cost and greater software complexity? This session highlights effective usage of SQL Server 2005 Database mirroring, that can fail over quickly with no loss of committed data, does not require proprietary hardware, and is easy to set up and manage. Leave the session to deliver high availability and high performance solutions for database redundancy with the help of Database Mirroring concept and other High Availability features in SQL Server 2005.
|
200
DBA
‘Top of the Pops’ might be dead, but Dave will give you his own countdown of his 10 most useful/favorite SQL keywords. No secrets to giveaway here, suffice to say that you will know some of them (but maybe not used this way) and some may be unfamiliar to you. The whole ‘Countdown’ will be demoed and Dave will explain why they make his top 10. This is a session for people who use SQL regularly as Developers, know the standard DML but maybe never had the chance to peek around the corner to see what else was there! Both SQL 2000 and SQL 2005 syntax will feature, so this is stuff you can take away and use today ...
|
300
DBA
Many SQL Server installations have been done with either little or no consideration to securing the installation itself. Although your internal SQL Server data may seem to be secure, the way that your installation itself has been configured may inadvertently allow malicious or simply curious intruders.
This talk will look at some of these gaps - all from real world experience - and show how you can secure your existing SQL Server 2000 installations and also will contrast the improvements made with SQL Server 2005 to make it more secure out of the box.
|
200
Dev
Using T-SQL transactions to manage the behaviour of queries is always a balance between data integrity and client concurrency. In order to build high performance, well behaving data logic layers it is important that we understand this topic. In this session we will look at isolation levels (including the row versioning levels), locking and deadlocking. We’ll also look at the exception handling capabilities in 2005 and how they can be used to manage transactions in stored procedures.
|
200
BI
SQL Server Reporting Services provides a powerful mechanism for generating reports. This session provides an introduction to the many features and capabilities of Reporting services.
Topics covered will include installation, managing reports and security. The session will also show you how to author reports using the Business Intelligence studio. Highlights include using Stored Procedures as data sources, passing parameters into reports and running conditional logic inside reports.
Tips and tricks are included throughout the session to help you on your way.
|
200
DBA
Recently the SQL MVPs put together their list of myths about SQL Server.
If you think you know everything about SQL then come along and see if you're right.
|
200
DBA
If you haven't discovered yet what partitioning can do for you in SQL Server 2005 - then this session is for you. Many resources teach the basics of partitioning - BUT this session gives a view of partitioning from the trenches - ie. how it's been used in the real world to solve very difficult problems.
This session is comprehensible even for those that have not used partitioning yet - as it starts with a 5-minute overview. Partitioning is a simple concept to grasp and this session goes beyond the concepts and shows in-depth how partitioning has been implemented in the real world.
The session uses real case studies of very different and difficult to solve problems and it is shown how partitioning solve these problems in an elegant and simple way and more importantly how to keep a partitioned system performing optimally.
By drawing on real case studies with which the presenter has direct experience the session shows many lessons learned from implementing partitioning that go beyond the basic concepts and show how real world problems were really solved by using partitioning.
|
200
Kat
What has changed for the better and worse.
|
200
BI
How do we handle early arriving facts? If you are an experienced DW developer you would have come across this many times, if you are a novice you are certain to face this challenge in the near future. Each organisation makes decision to handle this scenario as suited to them. I have handled this scenario in one of these 3 categories.
1. Ignore early arriving facts all together? Is that the right way to do it?
2. During load process populate the dimension table with the Natural Key and default values and map surrogate key to the incoming fact record.
3. During fact load map default surrogate key and load those records into the “Rejected” table.
I would be conducting a demo for point 2 and 3.
In depth analysis on what happens to the records in the Rejected table and what do I propose to resolve these records?
What is Business Intelligence Service Centre (BISC) and their involvement is going to mission critical for the success of your BI project?
|
200
DBA
Databases, like applications, evolve. However, unlike applications, databases can be modified directly. This is like modifying an application via a hex editor. In this session Andras will contrast the two most common database development styles: working on a live database directly vs. working with creation SQL scripts. He will show some of his own techniques and chosen tools to display how to avoid some change related problems, to manage database changes and to set up source control for databases.
|
200
BI
Loading Partitions directly Consuming a package in SSRS Using a DM algorithm in the pipeline to see if the new customer meets criteria Fuzzy Grouping for deduplicating
|
300
BI
This session is all about developing for SSIS, writing .Net code to create your own tasks. We cover by way of introduction the different component types you can develop, and the common approach you can use. We will walk through examples of task development highlighting best practice and lessons learned. You will also find out how to create user interfaces and interact with the SSIS design-time environment for a rich user experience. As well as getting real-world insights into developing for SSIS, you will learn the practicalities of installing and managing components.
|
200
Dev
Test driven development is one of the current hot topics in software development, but how far can these principles be applied in the world of SQL? In this session I will look at the principles of TDD and other testing options using both freeware tools and Microsoft’s Visual Studio Datadude.
|
200
Kat
Due to the uncertaintity of whats will be publicly available in October we don't have the specifics of this session.
Areas likely to be covered are Declarative Management Framework, performance collection and analysis, auditing, resource governor.
We will update this session abstract nearer to the conference.
|
200
Kat
Due to the uncertaintity of whats will be publicly available in October we don't have the specifics of this session.
Areas likely to be covered are new data types, spatial indexing, filestreams.
|
300
Kat
Analysis Services 2008 will contain no radical changes from Analysis Services 2005, but there will be some important (if no necessarily ground-shaking) improvements in the area of query performance, manageability and ease-of-use. This session will describe these improvements and, where possible given the current CTP, demo them.
|
200
Kat
Due to the uncertaintity of whats will be publicly available in October we don't have the specifics of this session.
Areas likely to be covered are change data capture for ETL, enterprise reporting, star join, MERGE, better reporting experience.
We will update this session nearer to the conference.
|
300
BI
You've built your cube and it's working well, but there's one important query which is taking hours to run. How can you tune it? This session will tell you how to diagnose the causes of poor query performance with Analysis Services 2005 and share some hints and tips on how to solve them by optimising your cube structure and writing efficient MDX.
|