Last minute half-price offer for Sydney and Melbourne classes

As we draw close to our IE1 Immersion Events in Sydney and Melbourne, we have a few seats still available so we’re offering a special offer. For each registration at the regular price, you can bring another person for half price (US$1995 + GST). First-come-first-served! Drop us an email if you’re interested – here. Thanks

2014 Australia classes open for registration

We’ve finalized the details of our two classes in Australia next year and they’re open for registration. Kimberly and I will be presenting our popular IE1: Immersion Event on Internals and Performance back-to-back in Sydney and Melbourne. You can read more about the locations and costs in: Sydney, March 10-14, at this link Melbourne, March […]

New online course: Why Physical Database Design Matters

Kimberly’s first Pluralsight online training course went live today: SQL Server: Why Physical Database Design Matters It’s 4 hours long and is the first in a multi-part series on performance. The modules in this course are: Introduction Data Types and Row Size Data Types and Index Size Data Types and Query Performance You can get to […]

New online course: Detecting and Correcting Database Corruption

My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in a two-part series, with a more advanced course coming in a few weeks. The modules in this course are: Introduction Causes of Database Corruption Detecting Page Corruption Consistency Checking DBCC […]

New classes for 2014 in Tampa, Chicago, Bellevue, Australia open for registration

Kimberly’s been hard at work finalizing details of the classes we’ll be offering in the first half of 2014 and we have 17 new classes open for registration, covering the whole range of courses we teach. Where are we going? We’re heading to Tampa, Chicago, and Bellevue in the US, plus Australia (see below) and […]

A few seats still available in September classes in WA

There are only a few weeks to go until our September set of classes start in Bellevue, WA and there are still some open seats available. IE1 Immersion Event on Internals and Performance, 9/16-20, is sold out at 36 IEHW Immersion Event on SQL Server Hardware, 9/18-19, has several seats left, plus a two-for-one deal – […]

Anniversary special pricing for September classes

I haven’t posted much in July (and won’t until the second half of August as we’re on vacation diving with the kids) and today we’re sitting at the dock in Kona, HI on the Kona Aggressor II (one of our favorite live-aboard dive boats) waiting to ride out the remnants of Tropical Storm Flossie that’s […]

Classes and conferences this year

I have a busy second half of the year planned, with more classes, conferences, and Pluralsight courses coming up! For classes, I’ll be teaching at or helping out with the following: September 16-20, 2013: Internals and Performance (IE1) in Bellevue (SOLD OUT!) NEW: September 18-19, 2013: Hardware (IEHW) in Bellevue, WA – USA September 23-27, 2013: […]

SQLskills training for only $29 a month? Try it free for 10 days!

This is a really simple post, making sure you’re aware of the incredibly cost-effective way you can get hold of the kind of quality SQL Server training that only SQLskills provides. Since last year we’ve been recording a variety of online training courses, partnering with our good friends at Pluralsight. They provide a hassle-free, multi-platform […]

The Accidental DBA (Day 30 of 30): Troubleshooting: Transaction Log Growth

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

New IE1 class added in Chicago in November

Our last scheduled IE1 Immersion Event on Internals and Performance in Bellevue, WA in September has just sold out at 36 students, and there’s still huge demand for IE1 this year so we’ve added another one! The final class of the year will be IE1 in our usual location just outside Chicago (the same hotel […]

The Accidental DBA (Day 11 of 30): Backups: Backup Storage and Retention

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 10 of 30): Backups: Backup Testing for Validation

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 9 of 30): Backups: Essential BACKUP Options

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 8 of 30): Backups: Planning a Recovery Strategy

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 7 of 30): Backups: Recovery Models and Backup Types

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our Immersion Event for The Accidental/Junior DBA, which we present several times each year. If you know someone who would benefit from […]

New Immersion Event for Accidental/Involuntary/Junior DBAs

As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer. We have a new Immersion Event for the Accidental DBA! This is a three-day class taught by Jonathan Kehayias and Erin Stellato. This course will help you learn how to keep the lights on so that SQL Server meets the […]

New Immersion Event on Advanced Transact-SQL

As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer. We have a new Immersion Event on Advanced Transact-SQL! This is a four-day class taught by Bob Beauchemin, our resident developer expert. The first public class will be offered in Bellevue, WA on September 30 – October 3, 2013 – which […]

New Immersion Event on SQL Server Hardware

As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer. We have a new Immersion Event on SQL Server Hardware! This is a two-day class taught by Glenn Berry, author of the popular SQL Server Hardware textbook. The first public class will be offered […]

Last call for London classes until 2015 or 2016

Over the last few months we’ve started thinking about our 2014 and 2015 international class locations. We’ve been in London for the last three years (including this year) but we’re asked for lots of different non-US locations. We’re seeing more people traveling from Europe to our US classes and we want to hit some of […]

Chicago classes are all sold out, don’t wait to register for London

As of this afternoon all eight classes we’re doing in Chicago in April/May are sold out – that’s 160 people we’ll be training! The reason for this post is to remind those of you who are planning to come to one of our London classes in June that they’re all more than half full already […]

All SQLskills 2013 Immersion Events open for registration!

All of our 2013 public classes are now open for registration! Based on requests from people, attendee ratings of the hotels we used this year, and the ease of using hotels we know, we’re using the same locations again. This means we cover both sides of the US, central US, and Europe. Please know that […]

Last SQLskills classes of 2012 coming up in August

Time flies when you're having fun! August is fast approaching and it brings the last set of scheduled SQLskills Immersion Events of 2012 – Bellevue, WA. We will not be doing any more public classes after August anywhere in the world until Spring 2013. The main reason for this is that the team has a […]

2012 class schedule finalized

We're just back from presenting three Immersion events back-to-back in Tampa (see Brad Hoff's summary here, Tim Radney's here, and Randolph Potter's here) and while there we discussed our plans for the remainder of 2012. I know a lot of you have been waiting to see whether we will add another set of classes later in […]

Training budget: use it or lose it – prepaid seats offer

It's the end of the financial year for most companies and we've had two companies in the last week approach us about pre-paying for 2012 classes to use up 2011 budget. We've put together an offer that will run from now through the end of April (to entice you to spend 2012 budget early too!) […]

Four new Spring 2012 classes in Chicago, IL open for registration

We’re continuing to add to our 2012 class roster (see the Tampa classes in February/March) and we’re coming back to Chicago by popular demand in Spring 2012! We’re teaching our first two 5-day Immersion Events back-to-back in Chicago plus we’re co-locating our Immersion Event on Business Intelligence along with week 1, and our Immersion Event for Developers along with […]

Spring 2012 classes in Tampa, FL open for registration

We’ve started to confirm our 2012 classes, and we’re coming to the south-east of the US by popular demand in Spring 2012! We’re teaching three 5-day classes back-to-back in Tampa, FL so not only can you get your learning on, you can also escape the winter weather and get your shorts and sunglasses on too! We don’t […]

New DBA, dev, BI classes for Fall in Chicago and Atlanta

We’ve just finalized our Fall line-up of classes, and we’re very excited to introduce two new classes on development and business intelligence. This means SQLskills.com now covers the full spectrum of SQL Server technologies with master-level classes taught by five of the most highly-respected and deeply-qualified instructors in the world. We don’t allow anyone else […]

London class in June open for public registration

The Immersion Event on Internals and Performance in London, UK from 20-24 June, 2011 is now open for public registration! It’s been open to SQLskills Insiders for the past two weeks, with an exclusive discount offer, and is 1/3 full already. The hotel discount link will be sent to all registered attendees as soon as it […]

Internals, Design, and Performance class in Chicago in May

A few weeks ago Kimberly did a blog post survey about which city in the US you'd like to see us come to with our next Immersion Event and there were two that stood out: Chicago, IL and Tampa, FL. We looked into the logistics of putting on an event at each location and we ended up […]

London calling…

Continuing our musical theme this week is the The Clash with their classic '79 album London Calling…   Which incidentally, is what's been happening to us over the last month as so many of you have asked us to bring our Immersion Events to the UK for the first time ever. Well, we've answered your […]

Leaving the Land of Confusion…

I've been a big fan of Genesis since as long as I can remember, and I especially like their 1986 album Invisible Touch with the cool song Land of Confusion.   Over the last couple of months we've led you into the Land of Confusion. We revamped and expanded our training classes late last year and […]

My name is Kyle, and I’ve got SQLskills

It's all very well hearing about how cool our training classes our from *us*, but what do attendees like you think? I recently did an email interview with Kyle Hayes, a member of the Production DBA Team for Bridgepoint Education. He attended our Immersion Event back in August 2010 in Bellevue, WA. Here's what Kyle […]

Competition: win a free place in our class in February!

We’re really excited about the classes we’ve got coming up and to say ‘thank you’ to the SQL community for all your support of SQLskills.com over the years, we’re running a competition. The contest is now closed. The Prize The prize is a free seat in our class in our 5-day Internals and Performance class in […]

All MCM free training videos now available

The final set of MCM training videos we recorded for Microsoft have been posted on TechNet and are available for download. For your convenience, I've created a page that lists all the videos, with links, grouped together to match the training classes we provide. These videos are designed to give you an idea of the […]

2011 comprehensive training curriculum, schedule, and details announced

After a lot of fine-tuning, we’ve come up with a comprehensive training curriculum to satisfy those looking for comprehensive SQL Server training. We’ve designed four week-long classes that cover everything we think you need to know: Immersion Event on Internals and Performance (5 days) Data Storage Internals, Designing for Performance, and Indexing for Performance Instructors: […]

Configuring SSMS for presenting

A few people have asked over the last few days how Kimberly and I have SSMS set up for presenting so I thought I'd do a quick blog post explaining what we do. The first thing is to go download ZoomIt so that you can zoom in the screen and people can see the details. […]

Big changes to the MCM program and how SQLskills can help you

This morning at PASS our good friend Joseph Sack, who runs the SQL Server Microsoft Certified Master (MCM) program, announced some sweeping changes to the SQL MCM program and how it look going forward. We at SQLskills have been deeply involved with all aspects of these changes and now I'm free to blog about them. […]

San Diego SQL Immersion class has only ten seats left

We like to keep our class sizes limited to around 30 so that everyone gets a chance to ask all the questions they want and we have time to spend answering them in whatever depth is needed. So far we're up to 20 registrations for the San Diego class (December 6-10), which means we've got […]

Last call for the 5 day comprehensive BI course in two weeks!

Time is running out to sign up for our BI class in Bellevue, WA in a couple of weeks… there are some spots left so make sure one of them goes to you! Check out our Immersion Event page for details – hope to see you there! PS Next week I'll have time to put […]

SQL Immersion Event in San Diego, CA in December!

It's official! We're doing another 5-day SQL Immersion Event (our ever-popular SQL Server master-class) this year in the US! Through popular demand we've decided to put on a class in San Diego, CA this time – the climate is *much* better than Seattle in December! The class will follow our regular 5-day format with our best […]

BI Immersion Event in Bellevue, WA in October!

It's official! We're putting on a 5-day BI Immersion Event this year in the US! We've just confirmed with our well-known BI expert, Stacia Misner, who will be teaching the class. Stacia teaches all the Microsoft internal BI classes and we're looking forward to sitting in on the class to learn from her too. Check […]

Student comments from our class last week

We've got two more classes on the books now for 2010 – a 5-day BI class in Bellevue, WA the week of October 25th, and a 5-day SQL Immersion class in San Diego, CA the week of December 6th. Watch the blogs for announcements for when registration goes live. In the meantime, here a some […]

August SQL class filling up fast – space still available!

With exactly a month to go until our 5-day Immersion event in Bellevue, WA we've got 25 people registered for the class (wow!) and space for a few more! It's going to be a *really* good class – with people flying in from all over the country to spend the week with us. We're also […]

Last call for Ireland SQL classes next week

One of the places I really look forward to going every year is Dublin – not just for the countryside, friendly people, and our very good friends Carmel, Sandra, and Bob of Prodata, but also for the fabulous Irish breakfasts that the hotel serves – nowhere beats it, not even Scotland! And now that time […]

Presenting for PASS DBA virtual chapter June 9th

Next Wednesday, June 9th, I'll be presenting at the monthly meeting of the PASS DBA virtual chapter. The Live Meeting starts at 11am PST and lasts for an hour (hopefully I can try to speak for that short a length of time :-) Title: Building the Right Backup Strategy Abstract: In many situations, database backups […]

SQL Immersion Event in Bellevue, WA in August!

It's official! We're doing another 5-day SQL Immersion Event (our ever-popular SQL Server master-class) this year in the US! We decided to put on a class near Seattle this time as Washington is *fabulous* in August! The class will follow our regular 5-day format with our best content covering: On-disk structures: how the data is […]

Special one day SQL MasterClass in London June 17th

      The top things YOU need to know about managing SQL Server – in one place, on one day – presented by two of the best SQL Server industry trainers! This one-day MasterClass (June 17th, 2010) will focus on many of the top issues companies face when implementing and maintaining a SQL Server-based […]

Three public classes in Dublin in June and July, with testimonials

We enjoyed Dublin so much in 2008 and 2009 that we're going back for two weeks this time – and teaching three classes while we're there! We'll be working with our fabulous friends (Carmel, Sandra, and Bob) at Prodata and the event will be hosted by the nice folks at Microsoft Ireland. We'll also be […]

Still some spots available on the 5-day class in Boston in 3 weeks

Our first public class of the year is just over 3 weeks away! This is the *only* public class we'll be teaching in the US in 2010. There are a few spots left so book now to avoid disappointment. We've teamed up with our good friend Adam Machanic to bring a week-long custom class to the […]

Date changes for SQL Connections and Boston public class

Due to some Microsoft date changes, the Spring SQL Connections show had to move to the week of April 12th. As a knock-on effect – and believe me, there were a bunch for us! – the public class Immersion Event we're doing in Boston had to move out of that week, and is now two […]

Paul and Kimberly public class in Boston April 2010

The first of our public classes (what we call Immersion Events) in 2010 is now officially open for registrations! We've teamed up with our good friend Adam Machanic to bring a week-long custom class to the Boston area. In this class Kimberly and I take turns teaching modules and we're both on hand to answer questions, […]

Australian classes start next week, and the Fall conferences

We're part-way through the Fall conference season, and in the middle of teaching week 1 of the current Microsoft Certified Master – SQL class. At the weekend we head off to Australia to teach some public classes in Melbourne – last chance to sign up for them! Here's what we have coming up: October 15-16. […]

Demo scripts from Ireland SQL Immersion Event uploaded

Yes, I'm a week late (at least) uploading these, and I apologize. But better late than never! For those lucky 48 people who attended our week-long SQL class in Dublin at the end of September, I've uploaded all our demo scripts on our past conferences page. Let me know if you have any issues. Enjoy!

Ireland SQL User Group September 23rd

While we’re in Ireland teaching our Immersion Event (week-long in-depth class on SQL Server internals/performance/maintenance/DR), we’ll be doing a user group meeting as well in Dublin on Wednesday September 23rd.  The Immersion Event (Septemer 21-25) already has a good class size but of course we have space for a a few more attendees – check […]

Fall line-up of classes and conferences

We've finally nailed down the dates for all our Fall classes and conferences around the world. Here's the plan: September 21-25. Kimberly and I will be teaching a week-long Immersion Event in Dublin, Ireland - combining internals, performance tuning, database maintenance and more. September 29-30. Kimberly and I will be presenting a full day of SQL Server sessions […]

Public SQL Server Immersion Event in Dublin in September

Kimberly and I will be teaching a week-long public Immersion Event in Dublin, September 21-25, in partnership with our good friends at Prodata and Microsoft Ireland. The class will cover: Day 1: SQL Server Internals (On-disk structures, index internals, logging, recovery, transaction log architecture) Day 2: Designing for Performance (data types, table and index partitioning) Day […]

Coming up fast: SQL Connections Spring 2009 – indexes!

This year it looks like we’re not going to be involved in TechEd US in May so the SQL Connections show in Orlando in March (21-26) will be the best way to pick up some of our training in the first half of the year. We are planning to do some Immersion events in various locations […]

Conference corruption demo scripts and example corrupt databases

This blog post explains the demo scripts and databases I've posted to cover all the Corruption Survival Techniques and DBCC CHECKDB sessions I've presented at conferences this year. There are two zip files you need to download: the example corrupt databases (36-MB zip) (and this one if you're on 2008) and the demo scripts. These […]

Last chance to register for our class in Scotland next week

Well, we’re here in England now to teach the first of our UK classes and we’re staying with our good friend Tony Rogerson (UK SQL Server Community founder and SQLBits co-organizer) and his great family once again – I was beaten at tennis on the Wii by their 5-year old son last night… It’s too late to […]

BI classes in Iceland in September

In conjunction with our Iceland partners Miracle, we’re offering three BI classes in Iceland in September, taught by Stacia Misner. The three classes are as follows: September 17th-19th: Expanding Your SQL Server 2005 Business Intelligence Skills, Part 1 Abstract: Deeper than traditional introductory courses for SQL Server 2005 business intelligence technologies, this course teaches students […]

User groups and classes in August and September

Fresh off a week of teaching classes on the Microsoft campus, we’ve finalized some user group dates. Here’s what we have coming up: Monday August 18th: user group meeting in Redmond .NET Developer’s Association Database Meeting at the Microsoft Redmond Campus Topic: Index Internals and Maintenance Monday September 1st to 3rd: public class in England In […]

2008 Conferences: TechEd EMEA, SQL Connections, PASS Community Summit

  September, October, and November are going to be a whirlwind this year – after 3 weeks in the UK and Ireland in September, teaching and the San Francisco Power Workshop in October, we have three back-to-back conference weeks in Barcelona, Las Vegas, and back to Seattle! Hey – who booked that schedule?!?!?! Well, at least it helps us keep our […]

Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco

People have been complaining that I’ve stopped blogging so much – vacation folks, vacation! Today I’ve got a few class and conference posts to get through and then I’ll get back to the technical posts. We’re doing a 2.5 day public class based on the SQL Server 2008 material we developed earlier this year. This will […]