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.
Dynamic Data Masking is a great new feature in SQL Server 2016. I am actually shocked it has taken this long to finally get this feature. Here is a great blog post from exactly a year ago from my friend, Kenneth M. Nielsen on how to set it up and get the most out of this awesome security setting.
On July 20, 2015, NASA released to the world the first image of the sunlit side of Earth captured by the space agency’s EPIC camera on NOAA’s DSCOVR satellite. The camera has now recorded a full year of life on Earth from its orbit at Lagrange point 1, approximately 1 million miles from Earth, where it is balanced between the gravity of our home planet and the sun.
(Updated post from last year on the Building Skills at SQL Saturday events: Still holds true today, except the event this year is on August 13, 2016.) Over the past year, I have had the privilege of speaking at several SQL Saturday events, and I have been amazed at the turnout and passion of the SQL Server community. If you have never heard of SQL Saturdays, they are free community-driven, one-day training events for SQL Server professionals. These events rely on local speakers and volunteers to provide a variety of high-quality technical sessions covering all aspect of SQL Server. Click here to read more.
Had a great time in Columbus, Ohio this weekend. Started off early to volunteer at the SQL Saturday event and then right before lunch I delivered my presentation on The PROCESS of Queries. It was standing room only with over 40 people in attendance. I did leave a little early in the day, because I wanted to visit The Deardurff House while I was in town. Built in 1807, it is the oldest standing structure in Columbus and also served as the first post office in Central Ohio.
Now that it has been publicly announced. I have been working on the accelerated pilot program for Microsoft’s Professional Degree Program in Data Science these last two months. I still have one class and a capstone project left to finish it up. Very excited to be a part of this demanding program.
Microsoft just announced the release of Server 2016 and System Center 2016 in September during their Ignite Event (Sep 26-30). However, you can get Tech Preview v5 now… System Center 2016 TP5 and Server 2016 TP5 and start playing around. To find out more about the Release Date, check out Windows IT Pro.
Some older links on working with PowerShell and Exchange. I really liked this quick reference sheet from Exchangepedia.com that describes the most commonly used Exchange 2007 shell cmdlets and is still relevant today. And then over at MSExchange.org I always liked this 5 part series on PowerShell 101 for the Messaging Administrator. As always, the free sample PowerShell scripts for Exchange over at ExchangeServerPro.com is a must have link in any Messaging Administrators toolbox.
If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it into a video. Just as a reminder, I will be delivering this presentation at the SQL Saturday in Columbus, Ohio on July 16th and then again in Louisville, KY on August 6th. Or you can just take my 20461 SQL Query Writing class at New Horizons and see the three hour version of this presentation.
In-depth Introduction to Machine Learning in 15 hours of expert videos from Stanford University professors Trevor Hastie and Rob Tibshirani (authors of the legendary Elements of Statistical Learning textbook).If you are new to machine learning or a newer R user, I highly recommend getting the available free PDF download from the authors’ website to gain both a theoretical and practical understanding of many important methods for regression and classification.
Hear from Microsoft Engineers and customer experts on how you can build data driven intelligent solutions, on-premises and in the cloud, with R, Python, Hadoop,and Spark that will drive new and exciting services at the two days at the Data Science Summit that coincides with Microsoft Ignite in September. I am definitely going to try and catch a few of these sessions.
So you’ve heard about DevOps and now you’re considering implementing it? Get the help you need with these 8 hands-on training courses from Microsoft and edX.
Just finished renewing my Exchange 2013 certification and should be good for another three years. It was a pretty good idea to double check the requirements as they went from 15 down to 13 courses. I will probably take the Exchange 2016 exam in the next few weeks. But with all the SQL Saturday events coming up, I am not sure how much study time I am going to get.
If you plan to implement Exchange Server 2016 or Exchange Online, or if you want to make sure that your implementation was done right, these online training courses are for you! The Exchange Team is excited to announce the release of four new edX online training courses for Microsoft Exchange Server 2016:
Microsoft announced today that New MCSA certifications are out for both Windows Server 2016 http://bit.ly/295AIN0 and SQL Server 2016 http://bit.ly/295AWUG. Upgrade exams are also available for those who already have earned an MCSA on Windows Server 2012 or SQL Server 2012.
We had three times as many speaker submissions as we had actual open speakers slots for the upcoming SQL Saturday Indianapolis. It was very difficult to select from so many excellent individuals. However, we have finalized the sessions and Here is our schedule for the August 13th event. We’ve done our best to provide a good mix of topics and skill levels, we hope you’ll find something of interest throughout the day. Our thanks to the speakers for volunteering their time, we couldn’t do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.