Today, five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties are being released. These credentials are aligned to Centers of Excellence, used by the Microsoft Partner Network to identify technical competencies that are widely recognizable by both Microsoft partners and customers. Learn more here.
What a fun, educational, and entertaining MCT Day. I arrived at the Embassy Suites a few hours early to help set up the projectors and other tech stuff (moving tables). It was so great to see all my old friends and meeting some new friends. The session with Larry Kaye on the future of Microsoft Certifications should have been in a bigger room as it was probably the most packed session of the day. I missed the session on Flipped Classrooms as Tiago Costa and myself were delivering our session on planning events. Overall, it was an exciting day. The after party at Top Golf was top notch and an even greater time hanging out with all my MCT friends. It definitely was an awesome start to Microsoft Ignite week.
For my MCP friends going to Microsoft Ignite. Be sure to pick up your party pass at Certification Central on Monday or Tuesday to attend the MCP party at the Museum which will be held at the Fernbank Museum of Natural History on Tuesday, September 27th from 8 pm to Midnight. Not an MCP yet? Take advantage of half priced on-site exams during Ignite.
Being able to write functional SQL queries is a useful skill, of course, but functional is only the first step. An understanding of how SQL Server processes your queries is necessary to ensure that what you are writing is handled quickly and efficiently.
In this session, we will cover the basics of SQL Server storage, clustered and non-clustered indexes, the three main join algorithms, scans versus seeks, and other fundamental concepts behind the processing of Transact-SQL queries.
This has been rumored for some time, but it now seems that Microsoft’s latest iteration of online community is live. Launched on September 2nd, but in beta testing for months, the Microsoft Tech Community asserts to bring multiple communities together in a central location. Sound familiar? That’s essentially what Microsoft did by ending 5 different conferences and merging them into Microsoft Ignite.
Learn on Demand Systems is rolling out with a fun new achievement system. The team will be at Microsoft Ignite in Atlanta, GA from September 26-30, 2016, where they will be showcasing this great new program. Just some of the badges you can earn include Head in the Cloud, Day Tripper, Houston We Have a Problem, and The Exterminator. For example to earn the Head in the Cloud badge, you have to take 5 different Azure labs. Do you think you have what it takes to earn all the #IgniteAchievements? For a full list of achievements and their requirements, check out www.tinyurl.com/LODSAchievements.
I had such a great time at the SQL Saturday in St. Louis. There were about 25 people for my presentation which you can download here. I am thinking of reworking the last portion of it, but you can watch a streamlined version of my presentation here. I really enjoyed George Walkey’s presentation on Using Powershell to Document SQL Server. His scripts from that session are invaluable.
SQL Sentry is introducing the new unified Plan Explorer! This edition includes all features of Plan Explorer PRO, plus two new and incredibly powerful features: Index Analysis and Performance Profiling. These new features were originally going to be part of Plan Explorer ULTIMATE at higher price point. However, they ultimately decided to make all features of Plan Explorer freely available to everyone. That is right FREE!
Don’t forget tonight at 11pm, Andy Yun will be presenting hour 16 of the 24 Hours of PASS .http://bit.ly/2boVHxb This session will be moderated by myself, but don’t miss out on the other 23 hours of this PASS Summit Preview.
Recently at the World Partner Conference in Toronto, Alison Cunard unveiled the Microsoft Professional Degree (MPD) program. Fortunately for myself, over the last three months I have been able to participate in the curriculum preview of Microsoft’s new endeavor as they try to help narrow the skills gap in the computer science industry. Find out more about my Deep Dive into Data Science.
Meet me in St. Louis where I will be presenting my session on “The PROCESS of Queries“. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on Sep 10 2016 at SLU Center for Workforce & Organizational Developement, 3545 Lindell Blvd , Saint Louis, Missouri, 63103, United States.
Thinking of planning a Rock-Star MCT event? Or maybe you have tips of your own to share? Join John Deardurff and Tiago Costa at MCT Day in Atlanta for a round table discussion on making your MCT event legendary. You’ll want to stay for the encore!
Are you interested in becoming a Microsoft Certified Professional (MCP)? Getting ready for a Microsoft Certification exam? Then you already know that having the requisite content knowledge is only part of the complete picture. You also need practical, hands-on technology skills and strong test-taking strategies.In this on-demand Microsoft Certification exam prep session quickly ramp up on what you need to know to conquer Microsoft Certifications. Find out what they are, who they’re for, and how to become a better test-taker. Take a look at different kinds of questions and how to be prepared for them. Plus, get details on special deals, pricing, and registration, along with next steps in your Microsoft Certification journey.
Conversational Microsoft Azure, written by Azure MVP Peter de Tender and cloud expert Ron Barrett, has now been released. Cloud Computing is more than a buzzword, learn about the different types of “clouds” and the various services they can provide and how Microsoft Azure’s cloud computing platform helps deliver on-demand services to any sized organization!
Well it looks like I will be moderating session 16 for the 24 Hours of PASS: Summit Preview 2016 that takes place September 7–8, featuring 24 consecutive one-hour webinars from upcoming PASS Summit 2016 speakers. Whether you have attended Summit before, or are a newcomer who needs to convince your boss, these previews give you a taste of the great content and expert speakers that will be on offer at Summit this year. Best of all, Summit Preview is free thanks to the support of our generous sponsors.
That’s a wrap for SQL Saturday Indianapolis 2016. We had record breaking attendance and a great day of excellent training sessions. Thank you again to all the sponsors, speakers, volunteers and of course all the attendees for supporting our most awesome community event. Lessons learned, we will definitely have a bigger room for the #SQLStarter track. They were definitely our biggest sessions and hopefully will be added to other SQL Saturday events. (My session on SQL Certifications was so nice, I ended up doing it twice.) I think our biggest mistake is that we ran out of coffee about an hour before lunch and we almost had a revolt. Fortunately, the caterers arrived just in the nick of time. I hope to see everyone again next year.
Had a great time at the SQL Saturday in Louisville, KY. I always enjoy this one because it is only a two hour drive and I get to see the southern contingent of the #sqlfamily. I delivered my presentation on The PROCESS of Queries which seems to have become my most popular session. You can download the demo scripts and powerpoint presentation here or as always watch the abbreviated video version here. Really enjoyed the great reviews and even picked up some tweets during the session.
Whenever I am teaching a database class it seems I always get the question of what is the most popular Relational Database Management Systems (RDBMS). I always refer to the DB-Engine Ranking monthly trend website. The problem is I keep forgetting where the website is located. So for myself and for my students I am putting a link here. So I have it as a quick resource. As you can see, Oracle, MySQL, and SQL Server lead the group by a wide margin. With 14 of the top 25, RDBMS still seems to be the ruler of databases.
Very excited and honored to be once again working at the Microsoft Ignite conference. It is always a fun time and an incredible learning opportunity. Be sure to stop by and see me as Microsoft Ignite is again bringing certification and training resources to “Certification Central”. You’ll find exam prep sessions, a study hall full of learning resources, and an onsite testing center managed by the Microsoft Learning team. During the conference week, all Microsoft Certified Professional (MCP) exams will be offered at a 50% discount exclusively for Microsoft Ignite attendees, and all practice tests will be free to attendees who activate them in the study hall. Exam appointments will be available Monday through Friday and pre-registration will open in July 2016.