My Talks:
SQL Server - Non-clustered Index internals and structure
Length: 75 minutes
Tags: IT Professional | DBA | Database | SQL | SQL Server | MSSQL | Indexing
Indexes are necessary for efficient access to data within tables, but a fine balance must be struck. Too many indexes will increase your data needs and slow down data modifications, too few and you will not be able to get your data out of the tables effectively. With that said, this presentation will go into detailed analysis of non-clustered index structures, explain how SQL Server uses them, and how to determine if your indexes are designed properly and being used effectively.
SSIS Workload Thread Balancing
Length: 75 minutes
Tags: IT Professional | DBA | Database | SQL | SQL Server | SSIS | MSSQL
SSIS is a powerful tool that has many inherent features, one of which is parallel execution.
With little coaxing you can run dozens of threads wihthin a single package and also realize very poor performance. In this session the attendees will learn
how parallelism works within SSIS, the concept of 'Silos', advanced techniques to improve parallel flat file ingestion, and an advanced parallel framework
which prevents 'Silos' and improves overall parallel efficiency.