Sessions Title

Filter Sessions:
300
DBA
Are you trying to meet the need for high availability within your environment? This session guides you to meet the criteria to keep up the high availability using SQL Server 2008 configuration features that can support mission-critical database application. These technologies propose high business processes, help addressing planned downtime, unplanned downtime and performance problems.
400
BI
It is a fair request from users that, after slicing and dicing a cube, they want to have a look at the underlying transactions that make up a particular cell. It is unlikely that all the attributes that they are interested in are in the cube, but rather stored as relational data - making it non-trivial to reconcile. This session demonstrates the use of SQL Server Analyis Services, .Net, MDX, ADOMD and SQL Server to build a seamless front-end to satisfy this requirement.
300
DBA
SQL Server 2005 & 2008 versions 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 and Backward compatibility helps you prepare for upgrades to SQL Server 2005 or 2008. This session totally covers about the Upgrade features, fixtures, issues and resolution to take care for smaller databases to larger databases.
200
DBA
SQL Server 2008 is intended to provide a comprehensive data platform for both structured and unstructured data that is more secure, reliable, manageable, and scalable than previous releases. In addition, SQL Server 2008 pushes the envelope with powerful new features for developers, enabling them to create new applications that store and consume all sorts of data on everything from tiny mobile devices to corporate “big iron” servers. SQL Server 2008 also provides a number of new features to turn all of that data into actionable information that enables your users to make informed decisions with new levels of insight and prescience. SQL Server 2008, like SQL Server 2005, provides a plethora of new features and capabilities, as well as the usual bevy of bug fixes and performance improvements. Microsoft, however, has identified three areas where they’re focusing their improvements: • Trustworthiness of the platform, its data, and its users: provide the security, reliability, and scalability that are required by the most demanding business applications • Productivity of database administrators and developers: offer an array of new data-driven management solutions that reduce the time and cost of managing and developing applications • Business intelligence: provide a comprehensive platform for delivering and consuming intelligence when and where your users want it That’s how Microsoft has divided up the main elements of their marketing thrust for SQL Server 2008. However, as a working DBA and developer, my mind is not on the marketing as much as it is on the particulars within SQL Server 2008 that will make my life easier and solve my particular points of pain. With that in mind, this white paper will introduce you to the top ten features and capabilities in SQL Server 2008 that I find to be the most exciting and valuable: 1. SQL Improvements 2. Developer Improvements 3. Reporting Services (RS) Improvements 4. Compression 5. Data Types and Data Storage 6. Security 7. Resource Governor 8. Auditing and Change Tracking 9. Analysis Services (AS) Performance Improvements 10. Multi-Server Management
300
BI
this session should give an independent review of the 9 different clients Microsoft offers for its Anaysis Services Cubes, their capabilities and limitations, as well an overview of their integration in sharepoint. It will also cover more advanced OLAP features such as drill-trough, actions, member propreries, custom security, etc.. as well as deployment issues, such as needed components, licenses and security limitations.
300
DBA
Dynamic Management Views were added to SQL Server 2005 and have been enhanced in SQL Server 2008. While they provide great functionality and usefulness, it appears they are not widely understood or implemented as yet. This session provides an overview of the Dynamic Management Objects available (both Views and Functions), describes those considered the most useful, and shows how they can be utilized in monitoring, troubleshooting, and ongoing management of SQL Server systems and in gaining an understanding of SQL Server’s operation. It also shows how they can be utilized in custom reports in SQL Server Management Studio.
200
DBA
It's impossible to truly tune a SQL Server without a good understanding of its performance profile and work load. This session describes techniques and procedures to assess the baseline performance profile of a SQL Server, benchmark the performance of the server under varying workloads, and how to continuously monitor the server for maximum availability and performance. The session includes detail demos of how to use the native Microsoft tools to run baseline and benchmark tests. In addition to the main objectives, this session will help you: 1. Learn how to set up baselines, benchmarks, and monitoring 2. Understand the benefits and drawbacks of the two main approaches to monitoring 3. Learn major PerfMon counters that are important for baselining, benchmarking, and monitoring 4. Learn how to correlate results from PerfMon, SQL Profiler, and other tools to get a cohesive understanding of testing results
200
BI
This session will explain the basic principles of good data vizualisation techniques which are in use on a daily basis to improve the reporting from SQL Server. It will show examples from the "Hall of Shame" and the "Hall of Fame" and explain the good, bad and ugly referencing some of the new learnings from industry luminaries such as Edward Tufte, Stephen Few and Rolf Hichert. We will build a simple sample dashboard from scratch linked to SQL Server and provide directions to set of reference material.
400
Kat
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 session, 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.
200
DBA
Resource Governor is a new technology in Microsoft SQL Server 2008 that enables DBAs to manage SQL Server workload and resources by specifying limits on resource consumption by the workloads. In an environment where multiple distinct workloads are present on the same server, Resource Governor enables Administrators to differentiate these workloads and allocate shared resources based on the specified limits. Understanding the Resource Governor model will help developers as well, enabling smarter applications that utilize this new technology fully. During the session we will cover the functionality associated with the SQL Server 2008 Resource Governor, followed by a demonstration.
300
DBA
As a DBA for hire I'm mostly thrown into the deep with dozens if not hundreds of SQL Servers and SA rights. This is usually ok, I do have some DBA skills through my years of experience and I'm not one of those cowboy developers :-) Sometimes though I get myself, and occasionally also the customer, in trouble by doing something silly. This session is not about best practices. I'll show you what can go wrong during day to day DBA stuff and how to fix it.
300
Dev
Statistics say “25 – 30 % of all tables for an application are lookup tables”. Whether you are working on a “small” or “big” application it is worth analysing this problem and try to generalise the solution. Saving developer’s time is saving money, less code means less bugs, code once and reuse the code through the application(s). I’ll show you my thinking about this problem and give you some examples you can use in your applications. You can, of course change the code, improve it and modify the solution in any way.
300
Dev
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.
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?
100
BI
Performance Point is Microsoft's Performance Management offering that's part of the office suite. This session will explore three aspects of this relatively new aplpication: What is Performance Managemebnt and why should I care about it? What does it look like? What's under the covers? including the architecture, and the integration with SQL Server
300
DBA
If you wish to maintain your Production SQL Servers and Databases then you need to be proactive - this means you need to collect and trend performance data to be able to recognise a problem before it fully manifests itself. Understand your work patterns - detect trends - identify potential problems - keep your manager happy with performance and trend reports. The Performance Dashboard was a start for sql 2005 and sql 2008 has the start ( RC0 ) of a built in dashboard. This presentation will walk you through how to collect real time data and what you can do with it when you have it. We'll also show how to create graphical dashboards in SSRS 2005 and SSRS 2008 and how to make use of the data. ( the source system can be sql 2000 - sql 2008 )
300
BI
This session aims to demonstrate how SQL Server, PerformancePoint Server and Microsoft Virtual Earth can be used together to deliver a geographical representation of business intelligence data. It will cover the following topics: • Brief overview of PerformancePoint Monitoring Server, demonstrating how dashboards are created and the various types of report which can be contained in dashboard areas. • Introduction to Virtual Earth, explaining its features and the SDK which can be used to develop interactive applications. This will explain the creation of the HTML and Javascript which renders the map, the use of layers to add custom points to the map, and the structure of the GeoRSS and KML files which provide the overlay layers. • Creating a web site in IIS to host the mapping application. • Walkthrough the steps required to generate GeoRSS from SQL Server. This includes adding geocode data to location information, and the creation of SQL which produces a correctly structured XML file as supported by Virtual Earth. • Adding the map application to PerformancePoint and a demonstration of functionality. AdventureWorks will be used as the source of the data. Following the session source code will be available, along with a PowerPoint deck and a virtual machine image containing a working copy of the solution.
100
Dev
SQL Server's big secret is out. Service Broker is getting attention and people are loving it. However, a lot of people still don't know what it is or how to build solutions using this technology. In this one hour overview, I will show you just how easy it can be to integrate Service Broker into your solution.
300
Dev
There has been much news lately about SQL Injection attacks and more people that I know have been affected by recent attacks than in any time in the past 10 years. Thats because the type of attacks have changed. So whats it all about? We will look at the vulnerabilities that mean your system is open to SQL Injection attacks. Why you may have those vulnerabilities The options available to you, to protect your system whilst still achieving the functionality you need. Most places will tell you you just need to use stored procdures, its not as simple as that and we will look into why thats the case.
200
Dev
Since SQL Server 2000 XML has been part of SQL Server. More functionality has been added with each release. In this session we wil look at the three scenarios, processing XML data coming in, doing stuff with it once its in the database and finally getting data out in XML form. The latter is what I find most people need to do, to interface to other systems, get RSS feeds etc. We will look at the pitfalls of using XML and the tips and tricks to get what you want with the best performance.
300
Kat
SQL Server 2008 has some great new features for developers which on the surface may look small but will change your development experience for good. In this session we will cover the debugger, intellisense, intialising, incrementors, MERGE, table valued functions and more.
300
DBA
This session will present techniques for minimizing downtime during database upgrades. We’ll look at what’s required to deliver a reliable database upgrade while maximizing data availability. During the session I will present my own upgrade checklist, relevant whether you’re upgrading to SQL Server 2005 or SQL Server 2008. We’ll consider all aspects of upgrade planning, testing and preparation - including upgrading system databases, options for high availability upgrade, ensuring predictable post-upgrade performance and data consistency.
300
Dev
With the advent of CLR in SQL Server anything is possible. We will look at how you can implement an array data type in SQL Server using CLR. We will show how it makes procedural programming much nicer, by adding items to the array, removing items, iterating though items and returning the items as a rowset. If your excited about table valued parameters then this is how you can achieve similar in SQL Server 2005
200
DBA
As a DBA one of the tools of tuning that I use is effective indexing; This is a walk through on the basics of indexing from a performance point of view, this isn't best practice or text book solutions, this is based around hard pratical experience. This session will also cover the new index features of SQL2008 which in effect allow you to create partitioned indexes on a non partitioned table. Also covered will be some of the myths surrounding index performance degredation and why and for whom we actually create indexes.
300
DBA
We look at how FineBuild helps provide a best practice 'Gold Build' of SQL Server 2005 and SQL Server 2008. Items such as Service Packs, Cumulative Updates, optional components, third-party tools and user customisation are swallowed whole in an automated build process designed to give consistent results. Experienced DBAs will like the sophistication included in FineBuild. New staff will like the security and best practice achieved without weeks of study. Professionals installing SQL Server at home will like this can now be done while watching The Simpsons.
300
DBA
In this session, I will present how to fine tune Oracle ERP Applications such as JD Edwards that runs on SQL Server as a back end.
300
Kat
SQL Server 2005 introduced a wealth of new features for developers. The new SQL Server 2008 release does not introduce as many groundbreaking features as SQL 2005. However the features that have been introduced are certainly mouth-watering and will definitely make developers life easier. In this session we will take an in-depth look at some of the new and very exciting features that SQL Server 2008 have to offer; tables as parameters, the MERGE keyword, capturing of changed data etc.
300
BI
The Microsoft BI stack is now mainstream, and mission-critical implementations can be found in the largest businesses worldwide. However, the kind of monitoring tools that we take for granted with the relational engine simply don't exist yet for Integration Services, Analysis Services and Reporting Services. How do we know if our Integration Services packages are taking longer and longer to run every day, who's running that big query that's slowing Analysis Services down, or if the boss ever looks at that Reporting Services report you took three weeks to create for him? Luckily the solution is close at hand: we can use SSIS, SSAS and SSRS to build an application for monitoring SSIS, SSAS and SSRS. This session will describe how you can do this.
400
Dev
SQL Server 2005 introduced new types of Query Plans and how Query Plans can be used as query hints. In this session we will do a deep-dive into Query Plans, looking at how Query Plans are stored and how to interpret Query Plans. We will also look at different system management vies who can help developers and DBA's to better understand what goes on with query plans and subsequently write better performing queries.
300
Dev
The XML enhancements in SQL Server 2005 provide more than simple storage and parsing of XML data. XML functionality in SQL Server 2005 opens up exiting ways of architecting the database, interfacing with applications and providing data storage mechanisms that solve some nagging problems that have existed with the relational model. This session illustrates, by way of example, some practical applications of XML in SQL Server to work with classifications, query denormalized data and work with objects serialized in the application layer.
400
Kat
Details a typical DBA's day demonstrating the new improvements of the Management Platform made for Microsoft SQL Server 2008 as they pertain to more efficient system management, multi-server management, performance tracking, and policy creation, state detection and enforcement, using both graphical and command-line tools. We cover everything from the new Management Interfaces to Policy Based Management, Management Data Warehouse and also have a practical demonstration of PowerShell integration in SQL Server administration tasks.
200
DBA
Do you feel that there's something missing in your DBA life? I did ... before I discovered unit testing with SQL Server! Fact: you're a busy, hard-working DBA ... are unit tests relevant to you? You probably feel that you have enough to do already just "keeping the lights on". BUT - consider for a moment that unit tests are now a crucial part of all modern development. It's at the core of agile development: Test First/Test Driven Development. So why is unit testing neglected for the database? This session's presenter, awarded "Best Presenter" in last SQLBits(!) - will show you quickly and easily how to get started with SQL Server unit testing ... and as a bonus the presenter has several free copies of a commercial unit testing framework to give away! If you feel that you just don't know where to start; or that you can't see how testing even applies to databases - come along to the session, give me just 1-hour of your time. I guarantee, I will change your mind. The session is accessible - even if you've never written a single test before. The simplest tests are simple one-liners that could save you hours of pain in the future. The session goes well beyond the concepts and shows tried-and-trusted techniques used every day by the session's presenter.
300
Dev
If you have ever had a requirement for an 'Audit Trail' then this is the session for you. It covers various patterns that deal with temporal data - data that changes over time - from natural temporal structures, to pure audit trails and use of SQLs XML features to support application controlled temporality.
400
DBA
Hints are a powerful mechanism to force SQL Server to use alternate query plans. More often than not, the query optimizer does a fantastic job in creating the most optimized query plan for data access, but there may be numerous occasions when you would like to use alternate query plans to boost performance. Hints may adversely affect performance so should be used with care. In this breakout session, we first alert the DBAs on using Hints as they need to be sure that there is indeed a problem with the query plan. Let us have a look at different types of Hints including Query & Table Hints with various concepts on SQL Server query processing architecture are also explained wherever relevant, to ensure that the audience gets the most out of the session.
200
DBA
Frequently there is the question of whether to consolidate your SQL Servers on single machines hosting multiple SQL Server instances, or to consolidate the SQL Servers in a virtualized environment. Virtualization is attractive as it means instead of having to purchase 5 physical machines to run 5 Windows servers running SQL Server, you can run the 5 Windows servers on a single physical machine, each of these Windows servers running one or more instances of SQL Server. In addition to the fixed cost savings by having to purchase fewer machines, there is also the savings in on-going costs of power consumption. Another benefit of virtualization is the when using SQL Server consolidation you would need to run on the Enterprise Edition of SQL Server and Windows. Even when you factor in the costs of the virtualization software, and the cost for multiple versions of the OS and licenses, there are clear economic arguments to running a virtualized environment. While there is some performance degradation with running multiple servers on the same machine as well as the virtualization host software, for many workloads this performance degradation is acceptable, tests have shown that each virtual instance can support 80% of the workload in a virtual environment that it could support is if was running on a non-virtualized environment. Still virtualization is not a good choice for mission critical SQL Servers running large workloads. Virtualization is favored in some implementations as the virtualization software has greater levels of control as to memory or CPU resources that each virtual instance can consume. Whereas with SQL Server consolidation it is possible that the work load on a single database can degrade performance on an instance and even all instances running on a consolidated server. It is possible to isolate instances to specific CPUs by CPU affinity; however it is difficult to isolate memory usage. In SQL Server 2008 there improved options to limit the resources a process can consume with Resource Governor. Some implementations will involve a combination of SQL Server instances on a single virtual instance. So the choice between consolidated environments running on SQL Server 2008 as opposed to a virtualized environment is now more complex. Virtualization can be a solution where it is necessary to run multiple incompatible versions of software simultaneously on the same physical machine, for example SQL Server 6.5 can run on the same physical machine as one running SQL Server 7 as long as they are hosted in separate virtual environments. Virtualization is also sometimes used when the connection string cannot be an instance for example where the connection string must be a server name (like SQLServer01) as opposed to an instance name (like SQLServer02\instanceName1). Naturally if you are hosting multiple servers in a virtualized environment, your servers are always vulnerable to a crash of the virtual host software. This is analogous to the host OS of a consolidated SQL Server environment crashing. Most companies running virtualized environments are comfortable with uptimes that the virtualization software provides and find it to be no different from what a consolidated SQL Server environment will support.
300
Dev
This session is for your average .NET Developer who does SQL rather than those who are dedicated SQL Developers (that's not to say you won't pick up interesting tips). This is some of the stuff that I have learned over the years which you might find useful. This session is completely from a .NET developers perspective and the things that have helped me out when working with SQL Server. We will be looking at T-SQL, parts of the SQL Server Toolset, SQL Server commands etc. Hopefully by the end of this session you will come away with some useful stuff that you will be able to use in your day to day life. I will try and skip theory and best practice, and go with loose observations as much as possible.
300
DBA
Learn how the SQL Server 2008 new feature is addressing the needs of storing large volumes of unstructured data, while still retaining relational control over it. These solutions enable you to reduce both capital and operational costs for large stores of unstructured data. In this session we also cover the best practices in such storage kind of projects.
200
DBA
Without a clear picture of data storage and rate of disk consumption it is difficult to identify whether you are getting optimal performance from your storage investment or if an out-of-disk situation is looming. This presentation addresses these challenges and explores methodologies to help make the most efficient use of allocated disk space and ensure that your highest performing disk is available to your enterprise storage and production environments. Presentation Objectives: 1. Define methodologies for analyzing database growth trends 2. Forecast storage and disk requirements based on rates of consumption 3. Ensure highest performing disk is available to your production database environment 4. Deliver recommendations to help tune disk and optimize management in your storage environment
200
BI
Slowly Changing Dimensions (SCDs) in their various forms are a standard part of most BI implementations and yet they still manage to confound many developers when they come to implement them. Drawing from experience gained in the field, this session will briefly describe what an SCD is, what it does, how it can best be modelled in both the relational and OLAP layers and which of the various options available in SQL Server 2008 is the best way of loading it. Topics covered may include: - "There are 6 types of SCD? WHAT?!?"; - "To Snowflake or not to Snowflake?"; - "The SCD Wizard is brilliant and should always be used"; * - "CHECKSUM(): the solution to all my problems"; * - "MERGE - the obligatory SQL Server 2008 bit": It may also try and present an adaptable and performant strategy for loading SCDs that actually works. * - May not be true
400
DBA
Planning for a disaster is not enough, unless you have tested it! Also it's a topic that not many people like to think about it! Let us have a look at how SQL Server technologies can help to build a strategy that is essential to your Business, before you need it. With SQL Server 2005 and SQL Server 2008, there are many features that will help you to successfully weather the storm with minimal loss of data and time. Make sure you're aware of all of the tools available to help you sleep easier at night.
200
DBA
With the 2008 release, SQL Server makes a major advance in scalability for data warehousing. With data and backup compression, SQL Server 2008 reduces the size of tables and indexes and allows saving disk media space for your SQL backups. This session will guide you through the new compression features of SQL 2008 (ROW and PAGE Compression, Backup Compression), and will show which options are available for different data warehousing scenarios.
300
BI
PerformancePoint is an excellent tool for doing planning, forecasting and financial consolidation. However, unless you can load data into its staging / application database model, you are not going to go very far. In this session, you will be shown how integration services can be used automate data load into the PPS Staging database. And then how this can be used to populate the PPS Model. There is a lack of documentation in this area and in this session you will be shown a series of steps to achieve this.
300
DBA
Understanding memory architecture and how SQL Server uses it can help a great deal with how you approach performance troubleshooting or setup a new SQL Server and while a lot of information is available on the topic its often lightweight or very in-depth with nothing to help join the two. In this session I'll be discussing common topics like PAE, AWE, /3GB and 64bit along with more advanced subjects concerning SQL Server's usage in a way that's very accessible to any audience. At the end of the session you will have a good understanding of the best practices and normal usage profile for SQL Server memory as well the architecture to help you understand why certain best practices exist and when they can be flexible.
200
DBA
Over the past few years, the role of database servers has dramatically increased its importance in almost every industry. Meanwhile, SQL Server has increased its feature set and its ability to scale in enterprise environments. As a result the management of database servers has become a complex, manual and brittle process, with limited insight for trouble shooting problems. Aiming at improving, SQL Server manageability, as part of an ongoing effort by Microsoft to reduce the total cost of ownership, SQL Server 2008 introduces Declarative Management Framework (DMF), a new policy-based management framework (DMF). DMF enables users to manage SQL Servers by declarative intent, a.k.a., policies, that is, by specifying how the system should be and not the means to achieve it. By raising the level of management abstraction, DMF simplifies the management process, provides policy automation, and provides greater insight into the system.
200
BI
This session is designed to follow on from the PerformancePoint server introductory session and it will cover the following: 1. MS BI - "the art of the possible": there are a lot of tools in the Microsoft BI kit bag, end users aren't interested in tools, so this part of the session is designed to showcase how content can be surfaced in Sharepoint in an integrated and hopefully seamless manner. 2. MOPPS - "My First Dashboard": this will go through the process of creating and publishing a simple dashboard. Starting from nothing and ending up with a common parameter driven interactive dashboard (including PPS, MSRS, Excel Services, and ProClarity content). 3. MS BI front ends - "tips & tricks": from how to de-brand or skin ProClarity to how to build an Analytic workbench application in Sharepoint. There will be absolute minimum Powerpoint and as much hands on demo as possible - although for those that already know MOPPS, there won't be much new in there for you, that's why it's level 200.
200
Kat
Audience This session is aimed towards those who are new to using Microsoft SQL Server 2008 Reporting Services and those who wish to learn the features of Reporting Services 2008. It is advantageous if you understand • Experience using Microsoft Windows Operating System • Basic Transact SQL Select statements • An understanding of basic relational database concepts Description With Reporting Services 2008, Microsoft takes a step forward in presenting SQL Server as an enterprise data platform rather than just a database engine. With innovations in data regions, vast improvements in visualisation, and a new Report Designer, Microsoft SQL Server 2008 Reporting Services provides a tool that can be used by all members in the organization. This session will walk through the authoring, management and delivery of reports with a focus on the new features of Reporting Services 2008. At the end of this session you will understand how to create a report in the new report designer. Be aware of the Report management options available and the delivery mechanisms that can be used to deliver reports. This seesion will also finish on the Objectives At the end of this session, students will appreciate how to: • Create and explore report structures in Business Intelligence Development Studio o New Report Designer o Tablix data region o Gauge data region o Improved visualisation through charts • Delivering reports to your User o Report Manager o Report Builder • Managing Report in Report Manager. o Properties o History • Reporting Services 2008 Installation. o Where is IIS? o Sharepoint Integrated mode o Migration issues
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
An introduction to SQL Server Integration Services (SSIS). If you have never used SSIS before then this is for you, come and find out what all the fuss is about. Get some ideas on what you could do with SSIS, and how to get started. This is not an advanced session.
300
DBA
Policy-Based Management is a new and exciting feature in SQL Server 2008. In this session we will look at how it can be used to define and enforce policies for configuring and managing SQL Server across the whole enterprise.
300
Kat
The answer is simple - get your users to do it! SQL Server 2008 Reporting Services, has a new report builder(V2), which allows the users to do their own reporting, leaving you time to try out the other new features covered in other sessions in SQL Bits cubed. This session will explore the validity of that claim, by setting up the backend server and then using the Report Builder to do deploy reports. We'll also explore the new architecure and conclude with migration issues for those already using reporting services.
300
DBA
This session concentrates on the non T SQL aspects of performance tuning. Performance tuning a SQL Server is more than just running a profiler or capturing long running queries. There may be any number of factors within the setup and configuration of your server which are impacting your sql performance. This presentation will expose possible problem areas, in effect providing a checklist for the DBA. We wil also cover x64 and x32 memory usage including system cache settings, DEP, AWE and the various memory switches. We'll also look at the microsoft tools you can use to help your diagnosis. The impact of memory on storage and storage itself will also be covered. This session is based on Windows 2003 operating system.
200
Dev
In this session we’ll take a look at building RESTful services to expose your data store with the forthcoming ADO.NET Data Services (formerly code-named “Astoria”). We’ll look at how to surface data with the framework and how to build both .NET and AJAX clients.
200
Dev
Database Edition gets some TLC from Gert and the guys at redmond. GDR is on its way and you need to know what it does and how it may change your life. Ok a little extreme perhaps but let's find out what it does and how it integrates with Team Foundation.
200
BI
Reporting Services is a hugely powerful feature of SQL Server that you get for free with SQL Server. It allows you to produce reports in many different formats including excel and pdf, from different data sources like Excel, Access, SQL Server, produce them on demand or to a schedule and much more. 1. We will look at what Reporting Services is 2. Why you may want to use it 3. How you use it Some of the things we will cover are; Building a report Simplifying your reporting Securing data Producing scheduled reports Emailing reports
400
Dev
FOR XML, namespaces, nested XML, xquery, shredding hierarchical data, are some of the complex XML functions that you will encounter if you start delving into the XML world in SQL Server. We will look at the internals of the XML type and XML Indexes, the different ways to shred data and the reasons why each is best suited and other advanced tips and tricks to get round some advanced XML requirements.
300
Dev
Cloud Computing with SSDS. That's not a typo that's SQL Server Data Services. Currently in beta this could be the next big thing. We will first look at the model of cloud computing and try and identify where it 'fits' in today's enterprise. Will this be the product that replaces Express or Enterprise edition? Will it replace them both? Only time will actually tell but by looking at the functionality provided in the current (whatever that is) release of SSDS we will try and draw out a picture of this emerging market. This will be followed up with some practical demonstrations of the functionality available in SSDS as we attempt to build our own data cloud.
300
BI
Aren’t end-users a pain? You provide them with a beautifully crafted cube in which all their business needs have been analyzed, dimensionalized, and sanitized and all they seem to do is complain that they can’t get the information they need. What are they on about? In this presentation I will discuss how report building imposes sometimes complex data modelling requirements that are likely to be lost in the traditional interview and analysis process and how capturing these requirements can lead to happier end-users. I will show some approaches to solving problems such as: 1. Handling of flow, balance and average data types 2. Providing commonly used time based aggregations (YTD, QTD, Rolling 12 months etc.) 3. Scaling of data to provide reports in Millions, Thousands and Units 4. Providing periodic and cumulative views of results 5. Allowing back-dating of reports so that the user can get correct results for prior reporting periods 6. Flexible handling of Scenarios and versions 7. And for those of you who get stuck with financial applications how to handle Credits, Debits and normal balance conversion The solution shows how addressing these reporting needs will lead to additional dimensions in the data model and the need to handle complex inter-dimensional relationships.
300
Kat
SQL Server 2008 (a.k.a Katmai) introduces quite a few new data types (hierarchies, spatial types, file-stream, date, etc.) that will make life easier for a developer as well as enabling developers to create even more advanced applications. In this session we will take a look at some of these new datatypes and see how we can use them both from T-SQL as well as from client-side.
100
BI
Although Analysis Services is being used in more and more business intelligence projects few people still feel comfortable writing MDX. This session will provide a basic introduction to MDX, looking at the basic building blocks of the language and how you can write SELECT statements and some simple calculations.
200
Kat
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. Here's what Gary Short said about the session when he saw it: - "Colin Mackay's Spatial Data talk last night really rocked! If you get the chance to see it you should."
300
Dev
After the introduction of .NET inside SQL Server 2005, there has been a debate when to write what kind of code; should we stop writing T-SQL in favour of .NET or… This session will hopefully provide some answers. We will compare T-SQL code with .NET code and see scenarios where T-SQL is to be preferred as well as when .NET code is preferred.
200
BI
Data Mining is now a fully paid up member of your SQL Server arsenal. Data mining allows you to look into your data and discover more value than you could by simple querying. Iam going to try to dispel some of the unfounded myths around Data Mining during the session. In the first part of this session I am going to take you through some of the things you can do with Data mining. In the second part I will look at some of the new stuff that is coming along in SQL Server 2008.
400
Kat
SQL Server has always had the ability and tools to monitor server state and diagnose issues inside SQL Server (for example, SQL Trace and performance monitors). SQL 2005 introduced the ability to use the tracing capabilities within the operating system—Event Tracing for Windows (ETW). SQL Server 2008 builds upon this with Extended Events (EE), a general event-handling infrastructure. Extended Events is by far the most flexible and efficient event engine available within SQL Server. We look at the architecture of EE, the various components that EE introduces and also how we can use EE together with ETW to correlate event data from inside SQL Server with data from the operating system.
300
Dev
The relational model is not particularly supporting of classification structures but that does not mean that useful and fast classifications cannot be implemented. This session looks at mechanisms to perform fast searches on classifications using bitmasks and covers a technique from a .Net front-end via ADO to T-SQL.
400
Kat
SQL Server introduces the Data Collector and Management Data Warehouse for troubleshooting common performance issues for a SQL Server database engine instance. This session demonstrates how to troubleshoot various problem scenarios using the new tools within SQL Server Management Studio (SSMS). It demonstrates how to plan for a deployment of the data collection tools taking into account lessons learned from deploying the tools within Microsoft IT. Learn how you can create your own collection sets and get the data out of the Management Data Warehouse.