THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Data Education: Food For Your Brain

I've written here before about Data Education, the training company I recently launched, building off my previous company Boston SQL Training. Things have moved along quickly, and I and the rest of the Data Education staff are very happy to announce a jam-packed fall and winter course roster. We'll be announcing even more classes later in the year, but I wanted to give you a run-down of what we're currently offering. (Note that several of these are currently in the Early Bird stage, which means there are steep discounts already available. For any that aren't, I'd like to offer SQLBlog readers a nice shiny $400 discount. Just enter the code SQLBLOG when registering.)



Without further ado:




Teo will be in Boston next month (September 19-23) sharing his impressive and encyclopedic knowledge of all things SSAS and PowerPivot. Considering he's literally written the books on the subject, this is one BI class you don't want to miss. (Class to include discussion and labs on OLAP, data mining, PowerPivot apps, data analysis, and best practices, plus much more.)



The Entity Framework Guru: JULIE LERMAN

This is one boot camp you can't afford to miss, plus world-renowned .NET expert Julie Lerman won't make you do push-ups. (I don't think.) Instead, she'll spend five days (October 3-7) telling you everything you need to know about Entity Framework 4.1, including CodeFirst. This one will be somewhat intensive and very, very thorough. (Class to include discussion of Code First A-Z, E.F 4.1 DbContext/DbSet, EF in the cloud, EF performance tricks, plus much more.)



The PowerShell Virtuoso: ALLEN WHITE

You'd have to live under a rock to not know that PowerShell is the thing to know these days. We're bringing in Allen White for a three-day course (November 14-16) to teach you Everything You Ever Needed to Know About PowerShell in a SQL Server World: writing scripts, managing scripts, and managing your environment. No knowledge of PowerShell required! (Class to include discussion and labs on SMO, backup and recovery, automating, and importing/exporting CSV and XML files, plus much more.)




Yep, we got him: Itzik Ben-Gan is coming to the East Coast (January 23-27) to present his wildly popular Advanced T-SQL Querying, Programming, and Tuning class. Itzik will talk logical query processing. He'll talk islands and gaps. He'll talk nested iterations using recursive queries. And then he’ll talk about so, so much more. There's a reason he sells out classes and fills rooms at conferences, you know. (Class to include discussion and labs on query tuning, aggregating and pivoting data, TOP and APPLY, programmable objects, plus much more.)



Also, I wanted to point out a few other things we're doing at Data Education, all of which I think my fellow SQL fanatics might appreciate:

  • Twitter: We have a very active Twitter stream going (@dataeducation). Every weekday, we tweet the best in database blogs and articles. And sometimes we throw in a Chuck Norris joke. Just because.
  • Question of the Week: In light of the fact that a Friday is made even better by a $25 Amazon gift card, we've launched our new Question of the Week feature. Each Monday, we post a brainteaser. You get until Thursday at midnight to prove your riddle know-how. The questions have been fairly easy so far. Prepare for much trickier challenges. (Yes, that's a threat!)


Enjoy, and we'll see you in class!
Published Tuesday, August 16, 2011 10:20 AM by Adam Machanic

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



NJ said:

I am dying to attend atleast 3 out of 4 above classes but looks like these are all in Boston area. Is there any plan to arrange these programs around San Francisco Bay Area ?

August 16, 2011 3:39 PM

Adam Machanic said:

Hi NJ,

We're slowly expanding to other markets, but it will take some time. We'll definitely add San Francisco to the list. In the meantime, flights aren't too expensive--hope to see you in Boston!

August 16, 2011 3:59 PM

Raj said:

Hello Adam,

You said you would upload the queries for 15 Powerful SQL Server Dynamic Management Objects at your blog. I tried to search and did not know where to find it :)

Could you please upload them and cud u tell us the location of that zipped file

September 20, 2011 1:27 PM

Adam Machanic said:

Hi Raj,

Check my most recent blog post please!


September 24, 2011 1:56 PM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement