|
SSIS Deployment and Practices in Production
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
I see SSIS tool has a lot of potential and with recent deployment of these services in various production environments. Still the users are not fully accustomed to use the SSIS and there is a need for development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as must and should but these are tried and tested methods and if nothing else should serve as a basis for you developing your own SSIS best practices.
|
|
|
|
Reporting in SQL Server 2008
|
300
|
BI
|
|
Andrew Fryer
|
|
Reporting Services has had a major overhaul in SQL Server 2008. At the backend the architecture has been completely changed to make it faster and easier to manage. A new data grid, tablix, allows for the design of more complicated reports and the charting has also been significantly improved. The best news for developers and DBA's is the new report designer tool which can be used by end users and IT professionals alike to get access to all of the functionality of reporting services from an office style application.
|
|
|
|
Using Analysis Services as a data source for Reporting Services reports
|
200
|
BI
|
|
Chris Webb
|
|
Anyone who has ever tried to build a Reporting Services report on top of an Analysis Services cube will tell you that it’s nowhere near as easy to do as it should be. This session will explain why it’s so difficult and demonstrate some techniques and workarounds for building reports with SSAS.
|
|
|
|
New Product Demos
|
100
|
|
|
Small Companies
|
|
Product demonstrations from small companies. Small companies can present there product for 15 minutes more details to follow.
|
|
|
|
What is important for a DBA - SSAS, SSRS & SSIS in one shot
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
IT departments once generated analytical business reports. Now, individual users can create reports from their desktop and even from remote locations. This report from Gartner outlines how you can take advantage of Business Intelligence tools. Users of an enterprise's BI data have traditionally been inside the enterprise, but with the explosion of the Web for conducting business; i.e., e-business, an enterprise's BI users can be external to the enterprise, as well. So what are the important factors that can affect for a DBA, look for more information on these BI tools and their effective usage.
|
|
|
|
SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management.
|
300
|
Kat
|
|
Satya Shyam K Jayanty
|
|
Declarative Management Framework - is a policy-based system for managing one or more instances of SQL Server 2008. Tighten your database security with policy management, explicit administration & automated administration. You can design a policy to prohibit usage of unauthorized applications and imply the naming convention on the databases for developers.
|
|
|
|
SQL Server 2005 BI & Relational Databases upgrades overview and best practices
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
Microsoft SQL Server 2005 provides various features and as an industry trend the Upgrade from previous versions of SQL Server is a major role to implement. The available tools such as Upgrade Advisor helps you prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates reports that identify issues to fix either before or after you upgrade to SQL Server 2005. When you run Upgrade Advisor, the Upgrade Advisor Home page appears. From the Home page, you can run the following tools:
• Upgrade Advisor Analysis Wizard
• Upgrade Advisor Report Viewer
• Upgrade Advisor Help
This session totally covers about the Upgrade features, issues and resolution to take care for smaller databases to larger databases.
|
|
|
|
Introduction to SQL 2008 Performance Data Collector
|
300
|
Kat
|
|
Jasper Smith
|
|
SQL 2008 includes a new Data Collector infrastructure that expands on the work done with the Performance Dashboard custom reports introduced in
SQL2005 SP2 to allow you to easily configure and collect performance data from your SQL instances and store them in a Management Data Warehouse. In this session I'll cover the architecture and system data collection sets and
demonstrate how to create your own custom collections. I'll also cover how to create custom reports hosted in SSMS to display and report on the collected data.
|
|
|
|
SQL Server 2000 -> 2005 - Upgrade Specifics
|
300
|
Dev
|
|
Charley Hanania
|
|
Didn't anyone tell you?!? Mainstream Support for SQL Server 2000 ends on the 8th of April 2008!
So upgrading to SQL Server 2005 is the right move in most cases (unless 2008 is an easier option for you) but it doesn't come without its share of concerns.
This session focuses on the upgrade of SQL Server databases from SQL Server 2000 to SQL Server 2005, the general approach and traps that may be easily overlooked. We'll even look at the upgrade path to SQL Server 2008 from SQL Server 2000 and SQL Server 2005.
|
|
|
|
Managing change in the database world
|
300
|
DBA
|
|
Dr András Belokosztolszki
|
|
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.
|
|
|
|
Understanding the ADO.NET Entity Framework and Data Services
|
300
|
Dev
|
|
Mike Taulty
|
|
In this session we’ll take a look at the two new data access frameworks coming with the next release of ADO.NET in 2008. Entity Framework extends ADO.NET to provide a mechanism to program at a higher level than we do today with connections and commands. Data Services sits on top of Entity Framework and uses Windows Communication Foundation to offer an extremely productive way of exposing your data model as “RESTful” web services for easy access over HTTP. We’ll split this session half-and-half and cover off both of these new areas for data access.
|
|
|
|
Understanding LINQ in .NET Framework V3.5 and Beyond
|
300
|
Dev
|
|
Mike Taulty
|
|
The biggest change in .NET Framework V3.5 and Visual Studio 2008 was the introduction of Language Integrated Query (LINQ). In this session we’ll talk about what LINQ is, how it works and how it can be extended to any data source via the IEnumerable and IQueryable interfaces. We’ll look in brief at the implementations that come in .NET Framework V3.5 (LINQ to Objects, LINQ to XML, LINQ to SQL) and take a glance at the implementation coming in ADO.NET Entity Framework.
|
|
|
|
Best Practices for Business Continuity in SQL 2005
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
Do you have a challenge of performing ETL processes in your Enterprise without any downtime?
Does your IT support have Business Continuity measures? This session covers Business Continuity challenges, recovery strategies to use and document plans for ETL exercise & maintenance that are important for Business Continuity.
This session also covers implementing business services like systems monitoring, operations (including support), technology adoption and Trustworthy computing. Leave the session with a measuring success method and develop a strategy for a consistent implementation of Business Continuity standards to drive your business efficiently. Adopt latest technology and industry accepted (best) practices in using SQL Server 2005 efficiently.
|
|
|
|
Extending SSIS with custom Data Flow components
|
300
|
BI
|
|
Darren Green
|
|
Get some real-world insights into developing data flow components for SSIS. This starts with an introduction to the data flow pipeline engine, and explains the real differences between adapters and the three sub-types of transformation. Understanding how the different types of component behave and manage data is key to writing components of your own, and probably should but be required knowledge for anyone building packages at all. Using sample code throughout, I will show you how to write components, as well as highlighting best practice and lessons learned.
|
|
|
|
Advanced XML and XML Query Plans
|
200
|
Dev
|
|
Martin Bell
|
|
In this presentation we will be looking at the different ways to create XML query plans such as T-SQL statements, SQL Profiler and DMVs. He will look at using XML schemas and the schema used for XML Query Plans. Methods of loading XML Query Plans into a database including SSIS, CLR and T-SQL statements will be demonstrated. XML Query Plans will be analysed using XQueries to show how you can monitor and detect performance issues.
|
|
|
|
Recruitment Open Panel
|
100
|
|
|
Recruitment Panel
|
|
Presentation from a leading recruitment company on the SQL Server recruitment market, good practices to getting jobs. Followed by an open panel discussion on recruitment covering anything from interview techniques to CV styles to paying TAX as a contractor
|
|
|
|
Choosing the SQL Server 2005 edition that best fits in the organization
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
Installation requirements can vary widely, depending on your application needs. The different editions of SQL Server 2005 accommodate the unique performance, runtime, and price requirements of organizations and individuals. Which of the various SQL Server 2005 components you install will also depend on your organization or individual needs. The following sections help you understand how to make the best choice among the editions and components available in SQL Server 2005.
There is lot of confusion and uncertainty to choose which edition will provide and that fits to the organizational needs in an Enterprise environment. This session covers the edition features and provides idea about which one to choose for effective usage.
|
|
|
|
Where do you live? Intro to spatial indexing
|
300
|
Kat
|
|
Simon Sabin
|
|
Spatial indexing in SQL Server 2008 is a really exciting development. There are lots of problems that can be solved using the spatial data.
This session will give you an insight into
What spatial data is.
How you use it in the database
How it works in your application
How to get the performance you want
|
|
|
|
Transient data in SQL Server
|
300
|
Dev
|
|
Dr András Belokosztolszki
|
|
This session is focused on transient data in SQL Server. We will look at questions like: What is stored in tempdb? Is tempdb a performance bottleneck? What are the differences between temporary tables and table variables? What is stored in the transaction log file and how can its size be kept under control?
|
|
|
|
Understanding the ADO.NET Entity Framework
|
300
|
Dev
|
|
Mike Taulty
|
|
The ADO.NET Entity Framework provides a provider-based-framework which abstracts more of the underlying database schema and SQL-dialect than ADO.NET does today in V2.0. In this session we’ll take a look at the layers involved in the Entity Framework talking about the Entity Data Model, how it is put together and how you can program against it in read-only manner using the new Entity Client and Entity-SQL and in read-write manner using LINQ to Entities. We’ll also look at the tooling that’s available for the Entity Framework and briefly talk about how provider writers can plug-in to the framework.
|
|
|
|
SQL Server 2008 – Take help of Extended Events to Diagnose and perform advanced troubleshooting
|
200
|
Kat
|
|
Satya Shyam K Jayanty
|
|
Diagnosing production issues affecting Microsoft SQL Server can be difficult and time consuming. Microsoft SQL Server 2008 introduces Extended Events, which provide deep visibility into the inner workings of SQL Server and give the power to diagnose what were once impossible problems while having minimal impact on a running system. In this webcast, we introduce the SQL Server Extended Events features, describe the architecture of Extended Events, and explain how you can use Extended Events to diagnose real issues.
|
|
|
|
ASP.NET SQL Server Providers (aren’t they lovely)
|
300
|
Dev
|
|
Phil Winstanley
|
|
ASP.NET 2.0 brought with it the SQL Server providers for Membership, Profile, Roles and a whole range of other Services.
In this session we’ll discuss the tools for generating the tables and stored procedures as well as the different ways ASP.NET applications can be configured to take advantage of these tables. In addition we’ll explore how you can hack the providers to do what you want.
This will be a fun relaxed session where you’re guaranteed to learn something new.
|
|
|
|
SQL Server 2008 – New Performance Monitoring & Troubleshooting techniques using SSMS.
|
300
|
Kat
|
|
Satya Shyam K Jayanty
|
|
What’s new in SQL 2008 Management Studio – to provide an in-depth preview of new performance monitoring tools? This is to enable:
1. Understand the architecture of how SQL Server 2008 collects performance and diagnostic data and presents the information in Microsoft SQL Server Management Studio.
2. Develop a plan for enabling performance data collection and analyzing the results for troubleshooting and diagnostics.
3. Learn how to create your own collection sets and manage the performance data collection warehouse database.
|
|
|
|
Advanced T-SQL (2005 and 2008)
|
300
|
Dev
|
|
Dr András Belokosztolszki
|
|
SQL Server 2005 and 2008 both introduced many language elements that simplify complex queries. In this session we will look at a number of less frequently used, but very powerful T-SQL features like PIVOT, ROW_NUMBER() and MERGE.
|
|
|
|
Designing For High Performance SSIS Solutions, High Availability on SQL 2008
|
200
|
Kat
|
|
Aftab Chopra
|
|
SSIS: Discuss what the major changes in SSIS are over 2005. Learning’s from the field. Appropriate usage of the various tools, and good design principles.
High Availability: The principles of High Availability. Clustering, Partioning, Log shipping etc.
|
|
|
|
What can WMI do for you?
|
200
|
DBA
|
|
Martin Bell
|
|
Windows Management Instrumentation has two distinct areas of use, one is for configuration where it can be an extremely useful tool to manage and configure SQL server installations, the other area is for Alerts where it can be an extremely useful tool to monitor SQL Server and an alternative to DDL triggers or SQL Trace.
|
|
|
|
SQL Server 2008 – What’s new: Database Tuning Advisor – review, evaluate & clone your best tuning sessions
|
300
|
Kat
|
|
Satya Shyam K Jayanty
|
|
Database Tuning Advisor (DTA) - MOT your database.
Using DTA tool all the existing tuning sessions available to review makes it easy to: clone sessions based on existing ones, edit existing tuning recommendations. How to perform this tuning exercise at regular intervals to monitor the physical design of your databases. A tour with "what-if" analysis to keep up the performance.
|
|
|
|
Making more of SSIS in 2008
|
400
|
Kat
|
|
Allan Mitchell
|
|
Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is a 400 session so you we will hit the ground running and not stop throughout.
|
|
|
|
Partitioning is not just for "enterprise"
|
200
|
DBA
|
|
Hue Holleran
|
|
Partitioning is absolutely essential for "enterprise" class systems - BUT this session shows how systems with even conservative volumes of data can benefit significantly from partitioning. If you haven't discovered yet what partitioning can do for you on your system or are considering a move to work on systems that use partitioning - then this session is for you.
This session is comprehensible for those that have not used partitioning yet, as partitioning is a simple concept to grasp. The session starts with a brief 5-minute overview and gives a unique insight into the lessons learned and will prove invaluable if you are considering using partitioning now or in the future.
Many resources teach the basics of partitioning - BUT this session shows how to implement partitioning in the real world and how partitioning can give benefits on almost any size of system not just enterprise. Drawing on examples from large and small projects with which the presenter has direct experience - to show how partitioning solves real world problems.
|
|
|
|
I wanna get physical. Let me hear your engine talk
|
200
|
DBA
|
|
James Rowland-Jones
|
|
Let’s get physical, physical. I wanna get physical, let’s get into physical! Let me hear your engine talk, your engine talk, let me hear your engine talk.” Ok - thanks for the intro Olivia. Get to grips with your IO Subsystem in this one hour blitz session on SQL Server IO. In case you hadn’t guessed that’ll be physical IO. Benchmark your disk subsystem with SQLIOSim. Learn how to monitor and troubleshoot your IO subsystem using performance monitor and if there is time the DMV’s too.
|
|
|
|
Master Data Management (MDM)
|
100
|
BI
|
|
Sutha Thiru
|
|
What is MDM and How does it help BI?
What is Microsoft vision on MDM?
Overview of the new Microsoft MDM offering.
Demo of the product (Providing CTP is out by then)
|
|
|
|
SQL Server 2005 Online index operations for DML concurrency – guidelines & best practices
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This presentation involves my experience with a demo & discussion of the index process and provides guidelines and best practices for implementing this feature in a production environment.
|
|
|
|
I/O! I/O! It’s off to disk we go...
|
300
|
DBA
|
|
James Rowland-Jones
|
|
You’ve issued your select query – the data isn’t in memory and so you’ve got to go to disk to get it. There are no dwarves to help you so the question is - How is this satisfied? What exactly is read-ahead? Does the edition you have installed affect how this is performed? Does partitioning alter anything? That’s just the half of it – there’s writes to talk about too. Understand the fundamentals of SQL Server I/O in this one hour practical session.
|
|
|
|
Where’s my data? An introduction to Spatial Queries in SQL Server 2008
|
200
|
Kat
|
|
Colin Angus Mackay
|
|
It is reckoned that 80-90% of data has a spatial component to it. But what do we do with it now? At best, we constrain it to postcodes. Well, that would be great if we were delivering letters, but the majority of us aren’t. In this session we look at Spatial Queries in SQL Server to see how it works and what can be done with it.
|
|
|
|
Making the leap into Advanced SQL
|
200
|
Dev
|
|
Tony Rogerson
|
|
There are three major features in SQL Server that are usually under used or not used optimally; these are - a) Derived Tables, b) Common Table Expressions and c) The CASE expression. In this session I look at the in's and out's of each feature from basics right through to advanced techniques and considerations.
|
|
|
|
SQL Server 2008 TSQL Enhancements
|
300
|
Kat
|
|
Tom Pullen
|
|
A look at the new TSQL features of SQL Server 2008, including
- MERGE
- Table-valued Parameters
- Grouping Sets
- Row Constructors
- Hints
|
|
|
|
Getting to grips with Service Broker.
|
200
|
Dev
|
|
Eric Allsop
|
|
Service Broker is a powerful technology at the heart of SQL Server that enables developers to build asynchronous processing directly into the data tier of their applications. In this session we will look at:
• Why use Service Broker over other asynchronous technologies,
• When to use message based processing,
• The building blocks of Service Broker,
• How to use Service Broker,
• How to build practical solutions for message and batch based problems.
|
|
|
|
Self taught DBA techniques from SQL Server 2000 to 2008 version
|
300
|
DBA
|
|
Satya Shyam K Jayanty
|
|
SQL Server has evolved into a major RDBMS provider since the release of 2000 version. Now the 2005 provides various features and industry trend is taking a lot of importance for SQL Server. So all these years what DBA responsibilities are getting intelligent and need to keep up with constant learning and training. So where you need to begin your journey? So what it will take to get real world experience, how far you can learn and how best you can implement within your environment.
I will also cover the enhancements from SQL 2005 to 2008 that every DBA is interested to manage their environment with available technologies.
|
|
|
|
Development Life Cycle using Visual Studio Team Edition for DB Professionals
|
200
|
Dev
|
|
Richard Fennell
|
|
Microsoft Visual Studio Team Edition for Database Professionals for the first time makes the database developer a first class citizen in the Microsoft development family. In this session I will cover the complete development life cycle using this tool, addressing issues such as schema management, source control, testing, data generation and deployment.
|
|
|
|
A Tour of LINQ to SQL
|
300
|
Dev
|
|
Mike Taulty
|
|
LINQ to SQL is a LINQ-enabled, object relational mapping technology that shipped with Visual Studio 2008 and .NET Framework V3.5. In this session we’ll take a tour around LINQ to SQL, look at the main types in the object model and how we use them for query, insert, update and delete. We’ll also take a look at the tooling for LINQ to SQL and how we use the framework to work with stored procedures, transactions, concurrency, etc.
|
|
|
|
2005 SQLCMD Scripting
|
200
|
Dev
|
|
Hue Holleran
|
|
Scripting is essential for many tasks: eg. automating tasks and streamlining installs and performing changes on remote databases. Solid scripting is essential in larger organisations - all changes are deployed to production in this way.
Improving your scripting not only makes you more productive but can also make a difference to your pay packet - giving you access to these larger and more formal environments!
On the surface, scripting is not the most exciting of concepts BUT the world has changed significantly since isql grew up and became SQLCMD and many uses that we could only once dream of are now made possible with SQLCMD.
If you've not used SQLCMD yet - be prepared for a surprise - I can guarantee you that once you leave this session you'll have the "by default, open new queries in SQLCMD mode" option permanently checked!
This session will be useful to you even if you can only "string together a handful of SQL queries" - as that's all scripting is at the simplest level! This session goes well beyond the concepts and shows tried-and-trusted techniques used every day by the session's presenter.
|
|
|
|
SQL Server 2008 – an Evolutionary Database
|
300
|
Kat
|
|
Mark Whitehorn
|
|
Whilst there has been much talk about Evolutionary Database Design, we decided to take the ‘E’ word fractionally more literally. For the past four years I have been working with a group at Cambridge University on the application of advanced analytical database techniques to furthering our understanding of how Darwin developed the theory of Evolution. Using the multi-dimensional capabilities of SQL Server 2005 and ProClarity as a front end, we were able to prove to our satisfaction that the accepted history of how Darwin developed the theory is incorrect. We also managed to convince most of the rest of scientific community; only a few noses were put out of joint during this work.
More recently our focus has been on using the new spatial data types in 2008 to continue this work. For my group these new data types are a huge boon – enabling us to answer in seconds questions that would have taken days if not weeks to answer.
The talk will cover the work we have done, the techniques we used and take a look at how these new spatial data types can be more generally applied.
|
|
|
|
What Are You Waiting For?
|
300
|
DBA
|
|
Christian Bolton
|
|
Think about what happens when you issue a query to update a row:
*The optimizer creates an execution plan
*The query is executed
*The row will be read from disk into memory
*The update will be written to the transaction log
*The row will be changed in memory
*Confirmation will be sent back to the client
Imagine if you could measure the amount of time that was spent waiting for things within each of these stages. It probably won’t surprise you to hear that you can and not only is monitoring waits possible, but it can actually form a very effective part of a performance troubleshooting strategy.
Wait time is effectively dead time, and if you can reduce the amount of |
|