Yesterday New Horizons in Fort Lauderdale asked me to present to some of their customers on SQL 2012 and and 2014, focusing in on the new features most essential to know. You can find the slides in the Presentations link above. The presentation was only 3 hours, so I really struggled with what to cover, and I boil down the most important features to these: AlwaysOn in SQL 2012/2014 Clustered ColumnStore Indexes in SQL 2014 (2012 has Non Clustered ColumnStore Indexes only) In-Memory OLTP in SQL 2014 Yes, I talked about DQS,MDS,Tabular,SSIS Project Model, T-SQL Enhancements, Azure options, and some other cool features. But the three above are, in my opinion, the most important. Disagree with me? Let me know your opinion in a comment or by contacting me!
Tonight I presented a hands on introduction to PowerShell for the great folks at the FlaDotNet user group. I skipped the slides and dove into PowerShell from the console and the PowerShell ISE. PowerShell scripts and referenced resources are available. UPDATE: Dave Lord documented the event with photos! Thanks Dave!
I am privileged to be a member of the fifty or so Microsoft Certified Trainers who are volunteering their time this week with the Hands On Labs here at TechEd 2014 in Houston. There are 300 general use machines plus 400 machines dedicated to Instructor Led Labs. Look at my computer lab! :) [caption id="attachment_366" align="alignnone" width="604"] Hands On Labs area at TechEd 2014 (click to enlarge)[/caption] There are over 150 different labs available at the conference, all created and hosted by HynesITe. They do this with over 70 host servers, many with half a TERABYTE of RAM, all from a single colocation facility in Tampa, Florida. The labs are made up of one to several virtual machines that are spun up and ready for the attendees when they sit down to…
Yes, six months just went by. Since I've last posted: My youngest is walking, and also talking (in his own language, English will come soon I'm sure.) I've assisted a small handful of clients and their customers with their database, application and infrastructure needs. Taught SQL querying and administration classes onsite around Florida. Delivered a custom PowerShell Module and PowerGUI interface to a client for testing. Next week will deliver a 5 day class on using SQL 2012 SSIS to populate a data warehouse. Then I'm off to Houston to learn and to volunteer along with the other MCTs there to help deliver hands on labs to thousands of TechEd attendees. Talk to you again in six months (or less, hopefully.)