TechEd North America 2013 Review


I decided to use the last few days of 2013 to write posts to review conferences and events that I attended outside Trinidad this year. Why? Because I find people's views on events to be helpful when deciding what to attend and hopefully my feedback will be useful to someone when they are choosing events in 2014! I will start off with TechEd North America 2013 which was held at Ernest N. Morial Convention Center in New Orleans, Louisiana. TechEd is an annual technical conference which is held by Microsoft for IT professionals and developers.  The conference has various sessions that allow you to learn about the future of Microsoft’s products, solutions and services. Please note that this was my first time attending a TechEd event so I can’t compare it to previous instalments.

Front view of the Convention Center

Content
There were many sessions to choose from but not many if your focus is just one product/technology like SQL Server. To me this wasn’t an issue because if there were no SQL Server sessions that I wanted to attend then going to an Infrastructure or Developer session was still very useful to me. Even if you couldn’t find a track session that you considered interesting, there were certification sessions that were valuable even if you already passed the exams. Let's be real, passing an exam doesn’t mean you know absolutely everything in the course and who knows this may come in handy if you start offering training in the future (hint: opportunity). As for the speakers, the list is made up of individuals who are well-established and very knowledgeable in their field. 

Transaction Log session

Certification and Labs
If you went to sessions and saw something that interested you in a session then you could head down to the hands-on lab area and actually try out what you saw or play around with the product/feature. Not sure what you're doing or how to get started? No problem because there were a number of MCTs available to assist at the labs area. Also, you could have done certification exams on the spot for 50% of the cost. There was even the option to take practice tests

Expo Area 
Me at MSE Booth
Expo areas are my favourite at conferences because it is the best place to meet new people and build your network. The interesting thing about this expo was the fact that there were vendors with products  that are considered competition to Microsoft products. They were there because they were a sponsor and added some value to another product (Yes Oracle had a booth!).  This expo was also different because I was working at Microsoft Solutions Experience (MSE) Data Insights area. In most MSE areas there were a number of product experts made up of MVPs and Microsoft Product Group members who answered questions about various products and features. One cool thing about the MSE was the fact that the experts included speakers so if you needed clarity on anything from their session then you could have asked them at the booth.
Other Cool Stuff
There were many book signings which meant free autographed books. There were lots of swag from various vendors and you also had the option to buy at a conference store at the venue. An abundant supply of caffeine was available but I guess that is expected at Microsoft events. The event had random events at various MSE booths and various “After Hours” events during the week which included vendor parties and the closing attendee party at the Mercedes-Benz Superdome with a Tina Turner performance. Last thing that I must mention is the super Surface sale that allowed me to get my Surface Pro for $399.

Closing Attendee Party with Tina Tuner on stage

Expo Hall

Con
The venue was too big which made it very difficult to get to some sessions on time and in some cases I didn’t even bother to attend one or two because of the hassle involved in reaching back to the booth on time.

As I mentioned this was my first time at TechEd and also my first time in New Orleans so everything was fantastic for me (hence why only one con). I know people say TechEd has become more marketing oriented but the sessions that I went to had lots of demos and the MSE areas is a great platform for technical discussions. I understand why you might not want to attend if your focus is one product but I recommend it if you want to widen your scope or if your focus is more than one Microsoft product. New Orleans was also a factor for the event because I really enjoyed the food and the weather. I also had a great tour guide named Adam Machanic so finding the right places to eat and hangout wasn’t an issue.

Registration is open for TechEd North America 2014, which is being held from May 12-15 in Houston, Texas.

Continue Reading →

Business Intelligence and Data Mining Presentation at USC Event


At the end of October, I presented at a University of the Southern Caribbean (USC) event called "Innovation and Technology: Novel Approaches for 21st Century Researchers”. This event focused on topics such as Data Mining, Geographic Information Systems and Data Analysis. It was an honour to be a presenter at this event which had the following lecturers and researchers as speakers:  Dr. Daren Conrad, Dr. Rene Jordan, Professor Prakash Persad, Amanda Thomas and Samuel Gabriel.
 
The deck for my presentation, Microsoft Business Intelligence and Data Mining tools is available here and more information about Microsoft SQL Server Analysis Services Data Mining is available here.
 
 
Continue Reading →

T-SQL: Tips and Tricks Presentation


On Thursday I did my last 2013 presentation for the Data Architecture Virtual Chapter. I found out that the session had 334 attendees and I would like to thank everyone for taking the time to attend and also thanks for all the feedback that I received. Special thanks to Rob Canzonire, the VC member who asked me to present and also moderated it as well.

The presentation and the SQL scripts are available here. One of the databases is created by the '01_DemoDB' script and the other one, AdventureWorks2012, can be downloaded here. Below is a YouTube video of the session. Enjoy!
 



Continue Reading →

Online Presentation for the Data Architecture Virtual Chapter


This Thursday at 12:00 pm Central Time (2:00 pm in Trinidad ) I will be presenting, 'T-SQL Tips and Tricks' for the Data Architecture VC.

Session abstract:
Queries are running longer than expected? Your database server isn't performing as well as it should? There are many reason that this could be happening and one of them is the T-SQL being executed on the system. T-SQL offers various ways to get the information that you need but sometimes the option you choose might return the data that you want but may not be the best query structure or logic to use.

This session will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries. It will also show you some tips and tricks to avoid some bad T-SQL coding habits and help you write better queries. This session is for Developers and Database Administrators.

To register for this online meeting or to find out more about the group and their meetings, then visit their homepage.

Continue Reading →

Free Microsoft Software and Tools


Before you get too excited this isn't a situation where I am giving away any software. It also is not a promotion or a scam, it is about legitimate sites and programs that offer Microsoft software and tools for various time periods. I thought this post would be useful to people with personal projects and students who are choosing what software to use for their final project as well as students entering the upcoming Teleios Code Jam competition which has highlighted bonus points for using specific technologies. I am focusing on Microsoft products because whenever I suggest using Microsoft products in classes or during presentations I always hear complaints about license price especially for small short projects.

Here is the list of sites and programs that I am aware of:

MSDN Evaluation Centre - This centre allows individuals to download full featured Microsoft software and tools which can be used for a trial period (90 or 180 days). It also sometimes has links to Microsoft preview of new products.

DreamSpark - This program allows students, educators and academic institutions to get access to Microsoft software and tools at no cost to assist with learning, teaching and research. In technical education who wouldn’t want to use the latest technologies?

BizSpark - This program provides start-ups with free software, tools and support for three years. For more information about eligibility of the BizSpark program check out the FAQ. 

Windows Azure Free Trial - This is a great option if you want to see what you can do in the cloud.

While the options above are the full products for a limited time, if you want to use a free version of the product for an unlimited time then look for the Express edition. Of course each product Express edition will have some limitations and lack some features.

If you know about any other legitimate sites or programs please feel free to mention them in the comments.
 
 
Continue Reading →

Querying Microsoft SQL Server 2012 Live Event


This Friday, Tobias Ternstrom (Microsoft Principal Program Manager Lead) and Brian Alderman (CEO and Founder, MicroTechPoint) will be the instructor team for this 8 hour Microsoft Virtual Academy (MVA) Jumpstart event. The purpose of this course is to help you prepare for the MCSA Exam 70-461. Even if you are not interested in taking the exam, I suggest attending to get some more insight into the power of queries and T-SQL.

Course Outline
   - Introduction to SQL Server 2012
   - Advanced SELECT statements
   - SQL Server data types
   - Grouping, aggregating and modifying data
   - Table expressions and SET operators
   - Programming with T-SQL
   - Retrieving SQL Server metadata

Event details
Date: September 13th 2013
 
 
 
Continue Reading →

Speaking - Red Gate's SQL in the City Charlotte Event


I have been accepted as a speaker for the SQL in the City event in Charlotte which is being held on October 14th at the Ritz-Carlton. Red Gate's SQL in the City is a free, all-day SQL Server training event that takes place in various cities and provides great learning and networking opportunities for the SQL Server community. I will be presenting a session entitled Understanding and Controlling Transaction Logs.

Here's the abstract:
This session will unravel the mysteries of the transaction log, including how you can manage your logs and optimize their performance. Transaction logging is one of the most important activities SQL Server does for you, and understanding it thoroughly means you can ensure SQL Server does the best job possible. You'll leave with tips you can implement as soon as you get back to the office.

The event has an awesome line-up of speakers and a great agenda for the day. Remember the event is taking place the same week as PASS Summit 2013 so if you want to secure your spot then register as soon as possible.

I will also be attending SQL in the City Atlanta and look forward to meeting many of you at both events - Atlanta and Charlotte. See you in October!
 
 
Continue Reading →

Community Links