Search results matching tag 'data education'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=data+education&orTags=0Search results matching tag 'data education'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Itzik Ben-Gan in Atlanta: May 13-17http://sqlblog.com/blogs/adam_machanic/archive/2013/02/05/itzik-ben-gan-in-atlanta-may-13-17.aspxTue, 05 Feb 2013 21:10:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47498Adam Machanic<p>This year <b>Data Education</b> is offering a few more classes with <b>Itzik Ben-Gan, the world's foremost T-SQL instructor</b>.<br></p><p>Our first offering has just been announced: <b><a href="http://dataeducation.com/sqltraining/advanced-t-sql-querying-programming-and-tuning-for-sql-server-2005-2008-and-2012">Atlanta, May 13-17</a></b>.</p><p>Neither Itzik nor his class needs much introduction, but click through for a full outline and other details. <br></p><p>We think that Atlanta is a great city, with an amazingly vibrant SQL Server community. <b>Hope you'll be able to join us there</b>!</p><p>&nbsp;</p><p>By the way: if you're joining the class stick around town for <a href="http://sqlsaturday.com/220/eventhome.aspx">a SQL Saturday event</a> that is taking place, coincidentally, on May 18.<br></p>Data Education: Great Classes Coming to a City Near Youhttp://sqlblog.com/blogs/adam_machanic/archive/2012/04/11/data-education-great-classes-coming-to-a-city-near-you.aspxThu, 12 Apr 2012 01:24:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42790Adam Machanic<p>In case you haven't noticed, <a href="http://dataeducation.com/">Data Education</a> (the training company I started a couple of years ago) has expanded beyond the US northeast; we're currently offering courses with top trainers in both <b>St. Louis </b>and <b>Chicago</b>, as well as the <b>Boston </b>area.</p><p>The courses are starting to fill up fast—not surprising
when you consider we’re talking about experienced instructors like <a href="http://sqlblog.com/blogs/kalen_delaney/"><b>Kalen Delaney</b></a>, <a href="http://sqlblog.com/blogs/rob_farley/"><b>Rob
Farley</b></a>, and <a href="http://www.sqlha.com/"><b>Allan Hirt</b></a>—but we have still have some room.<span>&nbsp; </span>We’re very excited about bringing the <b>highest
quality SQL training</b> to the middle of the country.
</p><p class="MsoNormal">If you’re interested
in taking one of the courses (or more! multiple registration discount!), you're in luck: just enter the
<b>special discount codes</b> for SQLblog.com readers<b>: </b></p>
<ul>
<li>KALENSQLBLOG will get
you<span>&nbsp; </span><b>$250 off <a href="http://dataeducation.com/sqltraining/sql-server-2005-2008-2012-internals-and-query-tuning">Kalen Delaney’s Internals course in St. Louis (May 7-11)<br></a></b></li>
<li>ROBSQLBLOG will get you <b>$150 off <a href="http://dataeducation.com/sqltraining/advanced-t-sql-querying-and-reporting-building-effectiveness">Rob Farley’s T-SQL course in Chicago (May 14-16) </a><br></b></li>
<li>ALLANSQLBLOG will get
you <b>$250 off <a href="http://dataeducation.com/sqltraining/forget-mission-impossible-this-is-mission-critical-high-availability-for-sql-server-2008-and-2012">Allan Hirt’s Mission Critical course in Boston (June 18-20)</a><br></b></li>
</ul>
<p class="MsoNormal">Without further ado, the course descriptions (full outlines
at <a href="http://dataeducation.com/sqltraining">DataEducation.com</a>) … hope to see many of you soon in a Data Ed classroom!</p>
<p class="MsoNormal"><br></p>
<p>
<a href="http://dataeducation.com/sqltraining/sql-server-2005-2008-2012-internals-and-query-tuning"><span style="font-size:11pt;font-family:'Calibri','sans-serif';font-weight:bold;">SQL
Server 2005, 2008, and 2012 Internals and Query Tuning (May 7-11; St. Louis,
MO):</span></a><span style="font-size:11pt;font-family:'Calibri','sans-serif';"><a href="http://dataeducation.com/sqltraining/sql-server-2005-2008-2012-internals-and-query-tuning"> </a>Kalen Delaney is back with her blockbuster internals course, now with information on SQL Server 2012. In this world-renowned five-day course, students will learn how to take a long, hard look at the SQL Server relational engine. After better understanding what’s happening internally, students will get the opportunity to investigate how internals can affect how you set up your databases for maximum performance and reliability. Query tuning within SQL Server 2005 and 2008, as well as parts of SQL Server 2012, will be discussed in depth.<br><br>(This course is geared toward both SQL Server DBAs and developers with some experience with application development and architecture.)<span style="text-decoration:underline;"></span></span><b><span style="font-size:11pt;font-family:'Calibri','sans-serif';"></span></b></p>
<p>&nbsp;</p>
<p class="MsoNormal" style="line-height:normal;"><a href="http://dataeducation.com/sqltraining/advanced-t-sql-querying-and-reporting-building-effectiveness"><span style="font-size:11pt;font-family:'Calibri','sans-serif';font-weight:bold;">Advanced
T-SQL Querying and Reporting: Building Effectiveness (May 14-16; Chicago, IL):</span></a><span style="font-weight:bold;"> </span>You know this one will be good if MVP Rob Farley is flying all the way from his native Australia to our classroom in Chicago. This three-day course is a journey through the more advanced side of T-SQL, designed to help you create queries that are simply more effective. Rob Farley takes his students on a road trip of unlearning bad habits of querying and reporting, and into a deeper understanding of what makes a query effective. Common student feedback for this course includes “You’ve made me want to go back and rework every query I’ve ever written” and “I didn’t realize how much I didn’t understand about even the fundamental parts of T-SQL.”<br><br>(The T-SQL taught will be primarily for SQL Server 2012, but most of the principles taught will also apply equally to SQL Server 2005 and SQL Server 2008.)<b></b></p>
<p class="MsoNormal" style="line-height:normal;">&nbsp;</p>
<p>&nbsp;</p>
<p class="MsoNormal" style="line-height:normal;font-weight:bold;"><a href="http://dataeducation.com/sqltraining/forget-mission-impossible-this-is-mission-critical-high-availability-for-sql-server-2008-and-2012"><span style="font-weight:bold;">This is Mission
Critical: High Availability for SQL Server 2008 and 2012 (June 18-20; Boston,
MA):</span></a> <span style="font-weight:normal;">This course is another perfect example of learning an in-depth topic straight from one of the world’s biggest experts in that area. In this three-day course, Windows, clustering, and SQL Server high availability/disaster recover expert Allan Hirt will dive into new features and enhancements within SQL Server 2012 (as well as 2008), including the enhanced multi-site failover clusters and AlwaysOn availability groups. Windows 8 Server and Server Core will also be discussed as they relate to highly available SQL Server deployments.</span><br><br><span style="font-weight:normal;">(This course is perfect for SQL Server DBAs eager to get an early understanding of SQL Server 2012 and what is means for creating and maintaining mission-critical database systems.</span></p>
<p class="MsoNormal" style="line-height:normal;font-weight:bold;">&nbsp;</p>
<p>&nbsp;</p>
<p class="MsoNormal" style="line-height:normal;font-weight:bold;">Let me know if you have any questions about these or other Data Education course offerings.</p>Data Education: Food For Your Brainhttp://sqlblog.com/blogs/adam_machanic/archive/2011/08/16/data-education-food-for-your-brain.aspxTue, 16 Aug 2011 13:20:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37833Adam Machanic<p class="MsoNormal">I've written here before about <a href="http://dataeducation.com">Data Education</a>, 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 <a href="http://dataeducation.com/courses/">fall and winter course roster</a>. 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 <b>there are steep discounts already available</b>. For any that aren't, <b>I'd
like to offer SQLBlog readers a nice shiny $400 discount</b>. Just enter the code
SQLBLOG when registering.)</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal"><b>Without further ado:</b><b> </b></p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal"><a href="http://dataeducation.com/applied-ssas-2008-and-powerpivot-course-outline/"><b>The BI Master: TEO
LACHEV</b></a></p>
<p class="MsoNormal">Teo will be in Boston next month (September 19-23) sharing
his <b>impressive and encyclopedic knowledge of all things SSAS and PowerPivot</b>.
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.)</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal"><a href="http://dataeducation.com/entity-framework-bootcamp/"><b>The Entity Framework
Guru: JULIE LERMAN</b></a><br></p>
<p class="MsoNormal">This is one boot camp you can't afford to miss,<b> </b>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<b> everything
you need to know about Entity Framework 4.1, including CodeFirst</b>. This one will
be somewhat intensive and very, <i>very </i>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.)</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal"><a href="http://dataeducation.com/get-to-know-powershell-analyzing-and-managing-sql-server/"><b>The PowerShell
Virtuoso: ALLEN</b> <b>WHITE</b></a><br></p>
<p class="MsoNormal">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 <b>Everything You Ever Needed to Know About
PowerShell in a SQL Server World</b>: 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.)</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal"><a href="http://dataeducation.com/advanced-t-sql-querying-programming-and-tuning-for-sql-server-2005-2008/"><b>The T-SQL Super Star:
ITZIK BEN-GAN</b></a> <br></p>
<p class="MsoNormal">Yep, we got him: Itzik Ben-Gan is coming to the East Coast (January 23-27)
to present his wildly popular <i>Advanced
T-SQL Querying, Programming, and Tuning</i> class.<b> Itzik will talk logical
query processing. He'll talk islands and gaps. He'll talk nested iterations
using recursive queries</b>. And then he’ll talk about so, <i>so</i> 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.)</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">&nbsp;</p>
<p class="MsoNormal">Also, I wanted to point out<span style="font-weight:bold;"> a few other things we're doing
at Data Education</span>, all of which I think my fellow SQL fanatics might
appreciate:</p>
<ul>
<li><span style="font-family:Symbol;"><span><span style="font:7pt 'Times New Roman';"></span></span></span><b>Twitter:</b>
We have a very active Twitter stream going (<a href="http://twitter.com/dataeducation">@dataeducation</a>). Every weekday, we tweet the best in database blogs
and articles. And sometimes we throw in a Chuck Norris joke. Just because.</li></ul><ul>
<li><span style="font-family:Symbol;"><span></span></span><b>Blog:</b>
<a href="http://dataeducation.com/blog">The Data Education blog</a> has been up and
running for a while. I wrote most of the initial posts (including such fun as
<a href="http://dataeducation.com/managing-bitemporal-data/">bitemporal data</a> and
<a href="http://dataeducation.com/assigning-server-level-permissions/">assigning server-level permissions using module signing</a>,
but we have guest posts and Important SQL People profiles coming up very
shortly. Plus we just posted a rather intriguing <a href="http://dataeducation.com/a-denali-by-any-other-name/">behind-the-scenes look at
Denali</a>;
apparently <b>size<i> does </i>matter</b>.
(Interested in becoming a guest blogger? Get in touch!)</li></ul><ul>
<li><span style="font-family:Symbol;"><span></span></span><b>Question
of the Week:</b> In light of the fact that a Friday is made even better by a
$25 Amazon gift card, we've launched our new <a href="http://dataeducation.com/qotw">Question of the Week</a> feature. Each Monday, we post a brainteaser. You
get until Thursday at midnight to<b> prove your riddle know-how</b>. The questions have
been fairly easy so far. Prepare for much trickier challenges. (Yes, that's a
threat!)</li>
</ul>
<p class="MsoNormal">&nbsp;<br></p>
<b>Enjoy, and we'll see you in class!</b><br>Two Days of Advanced Performance Techniques - July 14-15, New York Cityhttp://sqlblog.com/blogs/adam_machanic/archive/2011/05/18/two-day-of-advanced-performance-techniques-july-14-15-new-york-city.aspxWed, 18 May 2011 16:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35709Adam Machanic<p>I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15.</p><p><b>This seminar focuses on achieving "next-level" performance--going beyond that which you can gain via normal tuning methodologies</b>. The vehicles for this performance improvement are two technologies that I've been pushing on this blog and in other venues for a long time: SQLCLR and parallelism. The seminar will be based on the in-depth materials that I used for my full-day sessions PASS conference in 2009 and 2010. These seminars were both quite well-received, but <b>I have tweaked and tuned the content</b> to make it even better and more focused on the bottom line goal of achieving maximum performance.</p><p><a href="http://dataeducation.com/taking-it-to-the-extreme-sqlclr-and-parallelism-course-outline/"><b>Full information on the seminar is available on the Data Education web site</b></a>. There is also an early bird discount currently in effect. Use the discount code "EARLYBIRD" to save $100 on the $1050 registration fee.</p><p>&nbsp; <br></p><p>I would like to take this opportunity to mention that <a href="http://dataeducation.com/">Data Education</a> is a new training venture that I've recently launched. This will be the company's second public training event (our first featured Kalen Delaney in the Boston area). The company is an evolution of Boston SQL Training, a company that I started a couple of years ago with the goal of bringing extremely high-quality SQL Server training events to the Boston area. <b>The new name, Data Education, reflects our desire to focus beyond Boston and on a broader technology spectrum</b>. We plan to eventually move into training on data-related programming (Entity Framework and similar), other DBMS platforms, NoSQL technologies, and wherever else the database industry moves.</p><p>Currently, aside from my course in New York we've announced an <a href="http://dataeducation.com/applied-ssas-2008-and-powerpivot-course-outline/"><b>Analysis Services and PowerPivot course featuring Teo Lachev</b></a>, which will take place in the Boston area September 19-23. Several other courses will be announced shortly, so stay tuned and consider following us on Twitter (<a href="http://twitter.com/#!/dataeducation">@DataEducation</a>).</p><p>If you've read this far, <b>I would greatly appreciate your taking part in a quick and informal poll</b>: in the comments section below, please let me know what geographic location would be interesting to you for an advanced SQL Server course, and what topic areas you're not seeing enough of. </p><p>&nbsp; <br></p><p><b>Thanks, everyone, and I'm looking forward to seeing you in New York!</b><br></p>