24 Hours of PASS 2016

24 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.

Indy SQL Saturday 2016

finalsqlsatindy 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.

SQL Saturday #531

agu6 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.


Database Engine Rankings

dbengines 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.

Subject Expert at Ignite

Capture  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.

One Year on Earth

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.

Networking at SQL Saturday

530sqlindy (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.

Columbus, Ohio

DeardurffHouse 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.

Exchange Powershell

download 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.

The PROCESS of Queries

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.

Intro to Machine Learning

13626637_1200808509937403_4504488124619486545_n 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.


Data Science Summit

13606998_1200631483288439_8477340474913116672_n 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.

SQL Saturday Schedule

530sqlindy 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.