Currently Filtered By

Microsoft'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...

As 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...

This 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...

Execution 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...

SQL 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...

Is 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...

A 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...

Every 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...

New 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...

With 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...