Cool workshops at SQLintersection in October

This year’s Fall SQLintersection conference in October is fast approaching and we’ve got some excellent full-day workshops lined up for you:

  • Sunday 25th: Kimberly with Queries Gone Wrong: Statistics, Cardinality, Solutions
  • Monday 26th: Jon and Tim with Managing SQL Server for the Non-DBA
  • Monday 26th: Glenn with Analyzing and Improving I/O Subsystem Performance
  • Friday 30th: Me with Performance Troubleshooting with Waits and Latches
  • Friday 30th: Brent with Advanced SQL Server High Availability and Disaster Recovery

And then of course there are another 30+ workshops on all kinds of Developer and I.T. topics (even a hands-on Internet-of-Things workshop where you program micro-controllers against Azure IoT Services!).

You can get more details about this year’s Fall SQLintersection conference in Las Vegas, October 25-30 at this website. And don’t forget to use the discount code SQLSKILLS when you register to save $50.

We hope to see you there!

June 2016 London classes open for registration

I’ve just released our London classes for 2016 for registration!

We’ll be teaching the following classes:

  • IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1
    • June 13-17 (US$200 discount for registering in 2015)
  • IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2
    • June 20-24 (US$200 discount for registering in 2015)

As you can see, we’re offering discounts off the early-bird price for all our 2016 classes if you register before the end of this year. The regular early-bird prices will apply from January 1st, 2016. If you’ve previously attended an Immersion Event, there’s a larger discount that’s always available to you whenever you register.

You can get all the logistical, registration, and curriculum details by drilling down from our main schedule page.

We hope to see you there!

New SSIS Immersion Events with Andy Leonard and Tim Mitchell

We’re very excited to announce that we’re partnering with our friends at Linchpin People to offer two new Immersion Events on SSIS, both debuting in 2016 along side our existing classes.

IESSIS1: Immersion Event on Learning SQL Server Integration Services

This is a 5-day course taught by Andy Leonard, with the following modules:

  1. Introduction
  2. Creating Your First SSIS package
  3. Introduction to the Data Flow Task
  4. Data Flow Task 201
  5. Data Flow Task 202
  6. The Control Flow
  7. Loop Containers
  8. Data Flow Task 301
  9. Data Flow Task 302
  10. Data Flow Task 303
  11. Event Handlers, Logging, and Configurations
  12. Security, Deployment, and Execution
  13. ETL Design Patterns
  14. Enterprise Execution Patterns

You can read through the detailed curriculum here.

The first offering of this new class will be in Chicago, at our usual location, from May 2-6, 2016 – all the details are here.

IESSIS2: Immersion Event on Advanced SQL Server Integration Services

This is a 4-day course taught by Andy Leonard and Tim Mitchell, with the following modules:

  1. SSIS Catalog
  2. SSIS Security
  3. Load Performance
  4. Data Flow Internals
  5. Testing Patterns
  6. SSIS Scripting
  7. Data Quality and SSIS
  8. Hacking the SSIS Catalog
  9. Advanced Logging
  10. Advanced SSIS Load Patterns
  11. Error Handling
  12. Data Edge Cases
  13. Business Intelligence Markup Language (Biml)

You can read through the detailed curriculum here.

The first offering of this new class will be in Bellevue, at our usual location, from September 19-22, 2016 – all the details are here.

Cool stuff – hope to see you there!