What is Techdays?
The Canadian IT Pro Team would love to call it a Tech-Ed of the north, except on tour.
Check out the site:
www.techdays.ca to get the
info, but the dates are:
Date |
City |
Venue |
October 29/30 |
Toronto |
Toronto Congress Centre |
November 6/7 |
Montreal |
The Palais des Congrès |
November 27 |
Ottawa |
Mariott Hotel |
December 4 |
Winnipeg |
Delta Hotel |
December 10/11 |
Calgary |
Calgary Stampede Roundup Centre |
December 17 |
Halifax |
Halifax World Trade Centre |
January 21/22 |
Vancouver |
Vancouver Convention Centre |
I will be doing a presentation in Montreal and Ottawa entitled
Microsoft SQL Server:
Essential Database Maintenance for New and Seasoned DBAs. The synopsis is:
Every DBA knows that managing a database using SQL Server
requires dealing with a key set of components of SQL Server in an optimal in order
to make their lives easier. But what are the elements of SQL Server that you need
to really focus on to get the best bang for the DBA buck, and what best practices
should be followed to ensure an optimally-running an instance in SQL Server? In this
session we will walk through the Top 10 List of DBA techniques and best practices
to ensure a smooth running database and instance. You’ll learn: how to optimize data
files and transaction logs; why TempDB is special and how to treat it properly; indexing
strategies dealing with corruption; and much, much more.
I'm also doing a session entitled
Beyond Relational SQL Server 2008: Managing Unstructured
and Semi-Structured Data:
The amount of data that does not fit into the tabular format
of relational tables is increasing tremendously, be it images, sounds, text documents,
XML documents, or semi-structured data. Integrating this data with the robust, efficient
processing capabilities of SQL Server and providing integrated querying and management
of that data together with the standard relational data becomes increasingly more
important. This presentation will present new and existing functionality on how SQL
Server 2008 supports these non-relational kinds of data. The presentation will provide
insights into FILESTREAM, Remote Blob storage, new XML functionality, integrated Full-Text
Search, sparse columns, filtered indexes and the new hierarchyID type.
Should be fun. See you there!