300
DBA
Windows PowerShell is a .NET based command shell and scripting language that is being built into all major Microsoft products including SQL Server 2008 (CTP6). PowerShell can be used to administer SQL Server via Server Management Objects (SMO). Using PowerShell to access SMO removes the need to write .NET based applications. PowerShell and SMO bring an increased level of automation to managing SQL Server environments. This session will introduce PowerShell and demonstrate how to administer SQL Server programmatically and interactively at the command line. The PowerShell provider in SQL Server 2008 will (hopefully) be used as well as scripts. The session is demonstration heavy and concentrates on the practical side of using these technologies.
|
300
DBA
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 time you spend waiting, you’ll be able to achieve better overall performance. This session covers how SQL Server waits work, what types there are, and how to view and track them directly through DMV’s as well as using some of the most popular tools. It also covers common scenarios and their associated wait types. Because SQL Server waits represent just a single view of performance, you will also see when to correlate the results with system monitor counters.
|
300
DBA
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.
|
200
DBA
Dynamic Management views were introduced in SQL Server 2005 and have made management and troubleshooting of SQL Server significantly easier than in previous versions. Even if you do not write your own queries against these DMVs you may be using them in Performance Dashboard Reports or other performance reporting applications. In this talk I will go through my TOP favorite DMVs and show how and when they can be used and why I like them!
|
200
DBA
SQL Server exposes many methods and techniques that increases the availability and recoverability your data.
In this session you'll get an overview of the scopes of protection that are available and what technologies cover those bases as well as walk through some disaster recovery scenarios.
|
100
Product demonstrations from small companies. Small companies can present there product for 15 minutes more details to follow.
|
100
BI
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)
|
300
BI
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.
|
300
Dev
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.
|
300
BI
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.
|
200
BI
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.
|
300
Kat
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.
|
300
Kat
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
|
300
Kat
A look at the new TSQL features of SQL Server 2008, including
- MERGE
- Table-valued Parameters
- Grouping Sets
- Row Constructors
- Hints
|
400
Kat
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.
|
300
Kat
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.
|
300
Dev
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?
|
200
Dev
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.
|
200
Dev
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.
|
200
Dev
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.
|
200
Dev
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.
|
100
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
|