Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for January, 2012

SQL Server 2012 Upcoming Launch Events

Posted by denglishbi on January 30, 2012

[tweetmeme source=”denglishbi” only_single=”false”]

Just wanted to do a quick post to make sure everyone was aware that there are a few SQL Server 2012 Launch events coming up in the near future.  sql server 2012

SQL Server 2012 Virtual Launch Event

The first one is on Wednesday, March 7.  This is a free event and it is also an online virtual event as well.  There will be a couple of keynote presentations and then three tracks and it will even include a virtual ‘Expo Hall’ where you can talk with vendors and partners as well.  This will be a great event to get exposed to what is coming in SQL Server 2012 so you will be aware of the new features and capabilities.  Register now over at http://sqlserverlaunch.com/.

SQL Server 2012 Special Ops Tour

Another event that will be starting up in March is the SQL Server Special Ops Tour being put on by the PASS organization and Microsoft.  This will be in the U.S. only and going to 12 cities – Atlanta, Irvine, Denver, Columbus, Jacksonville, Chicago, Dallas, Philadelphia, New York, Boston, Minneapolis, and San Francisco.  Now this is not a virtual event, so seating will be limited.  Registration is open and it is a free event, so make sure you secure your spot today – http://specialops.sqlpass.org/#fbid=PH48KYb0Gig.

24 Hours of PASS – Spring 2012

Another 24 back-to-back hours of free SQL Server training is also coming up brought to by the PASS organization and the SQL community.  Call for speakers is currently open through tomorrow and the event will take place on March 21, focusing on SQL Server 2012 of course.  For more details check out the following link – http://www.sqlpass.org/24hours/spring2012/.

SQL Server Connections – Spring 2012

If you are up for a conference and want to head to Las Vegas, NV, then you are in luck.  The Spring 2012 DevConnections conference is coming up and there will be a SQL Server 2012 Launch Conference and Expo included provided by Microsoft and SQL Server Connections.  This event takes place March 26-29.  For more information check out the details here – http://www.devconnections.com/shows/sp2012/default.aspx?s=185.

As you can probably tell the release date for SQL Server 2012 is coming up.  Lots of excitement and information is just pouring out and looking forward to the official release of the product.

Posted in SQL Server, Training | Tagged: , , | 1 Comment »

Free SQL Server Community January 2012 Training

Posted by denglishbi on January 13, 2012

[tweetmeme source=”denglishbi” only_single=”false”]

I am running a little behind schedule after the New Year’s.  If you missed any of the sessions just remember that they are recorded.

Head over to Pragmatic Works site and take a look at all of the training that is available for January – free training on Tuesdays and Thursdays at 11 a.m. EST. Free Training on the T's

  • January 3, Brian Knight – Introduction to PowerPivot 
  • January 5, Mark Stacey – Analysis Services for the DBA 
  • January 10, Arie Jones – Master Data Services in SQL Server 2012 
  • January 12, K. Brian Kelley – Using PowerShell to Check Your SQL Server Security 
  • January 17, Hope Foley – Super-size Your SSIS Breakfast Sandwich: Performance Tuning 2012 SSIS Data Loads 
  • January 19, Devin Knight – Extending Reporting Services with Custom Code
  • January 24, Mark Mortimore – Database Consolidation & Private Cloud Appliance – Available NOW!
  • January 26, Eric Hanson – Performance Tuning with ColumnStore Indexes
  • January 31, Mike Davis – Creating KPI’s, Actions, and Calculations in SSAS Cubes

If you miss a session they record them and you can check them out later on-demand in the webinar resource area.

So what are you waiting for, get registered for one of these spectacular webinars today – Webinar Registration.

Don’t forget, you can stay up-to-date on the training events through the PWFreeTraining twitter account as well.


Posted in SQL Server, Training | Tagged: | Leave a Comment »

PASSMN January 2012 Meeting

Posted by denglishbi on January 12, 2012

[tweetmeme source=”denglishbi” only_single=”false”]

The next Minnesota SQL Server User Group meeting is coming up next week on Tuesday, January 17. The topic this month is on writing better queries and the speaker is SQL Server MVP Joe Webb. Just a reminder that the meetings are no longer in Bloomington anymore, they are over at the Microsoft Technology Center in Edina.

Minnesota SQL Server Users Group

Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Date/Time: Tuesday, January 17 from 3 to 5 p.m.

Live Meeting:


  • 3:00-3:15 : Registration / hospitality / networking
  • 3:15-3:30 : Announcements etc.
  • 3:30-4:45 : Writing Better Queries – Joe Webb (Blog | MVP Profile)
  • 4:45-5:00 : Closing comments/prize giveaways

Please click here for meeting details and to RSVP for the event

Writing Better Queries (Joe Webb, WebbTech Solutions) – Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we’ll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better.

Posted in Training | Tagged: , | Leave a Comment »