Tech·Ed Europe 2009
- Berlin, Germany
- November 9 - 13, 2009
- Speakers at Tech·Ed Europe 2009
Tech·Ed Europe 2009
- List
- Top Rated
- Most Viewed
- All
-
Microsoft's Vision for Data WarehousingMicrosoft's continued focus on large-scale Data Warehousing has been evident with the launch of a SQL Server appliance dedicated to Data Warehouse workloads (FastTrack). The announcement of Microsoft project code name "Madison" for scalability into the Petabytes, and the new BI/DW capabilities in Microsoft... -
Microsoft SQL Server Automation, Including PowerShell SupportAs a DBA, performing the same tasks day-in and day-out limits how much you can meet the demands of your organisation. Microsoft SQL Server provides several tools to meet your automation needs, including SQL Server Agent, SQL Server Alerts, and now PowerShell. This session demonstrates how and when to... -
Optimizing Microsoft SQL Server 2008 Applications Using Table Valued Parameters, XML, and MERGEThis session covers passing sets of data from a client application to a SQL Server 2008 instance. There are several solutions to this task, including the use of the SQL Server 2008 feature Table Valued Parameters (TVPs). In this session we describe and compare multiple approaches to passing sets of data... -
Masterclass: Microsoft SQL Server Execution Plans, from Compilation to Caching to ReuseExecution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it's also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we discuss in detail the following aspects... -
Analysing Performance Trends and Peeking into the Plan Cache with Microsoft SQL Server 2008SQL Server 2008 makes getting a handle on the plan cache and analysing query plan reuse easier than ever before. Additional DMV support is just the tip of the iceberg. I'll demonstrate using Activity Monitor and Performance Data Warehouse to get the information more easily, both on a real-time basis... -
Microsoft SQL Server 2008 Reporting Services Best PracticesIs there anything you could be doing better with SQL Server Reporting Services? This session explores some of the best practices associated with report design and report server deployment. Topics range from the best way to plan your scale out architecture, to the best way to optimise your reports design... -
Auditing and Compliance Features in Microsoft SQL Server 2008A hot topic of study in today's IT shops is compliance with regulations such as PCI-DSS, the Data Protection Act, Directive 95/46/EC, and EuroSox. This session looks into new security facilities in SQL Server 2008, including built-in granular auditing, transparent data encryption (including encrypted... -
Masterclass: A Day in the Life of a Database TransactionEvery data modification that you ever do in your database is a transaction. Do you know how this affects your performance? Do you know what is the best way to code your transactions to achieve maximum performance without compromising transactional consistency? Do you know how to use different transaction... -
Developing with Microsoft SQL Server Spatial: Deep Dive into Spatial IndexingNew spatial data support in Microsoft SQL Server 2008 gets most of its performance and scalability from the ability to define indexes on spatial data. This presentation describes how SQL Server 2008 spatial indexes work and goes through a series of use cases to show you how to improve your spatial application's... -
Developing with SQL Server Spatial: Flat Maps to Round EarthWith the advent of GPS phones and devices, spatial data is becoming increasingly more central to data processing and everyday applications. This session provides an overview for the Microsoft SQL Server 2008 spatial types and methods, focusing on some common pitfalls and differences between the flat...
