I am very excited to be helping others learn new technologies and asisst them in earning new certifications. On January 19, 2017, I will be delivering two exam prep session at the Microsoft Tech Summit in Chicago. The first is for the 70-473: Cloud Data Platform exam and the second session is for the 70-475: Big Data and Analytics Solutions. Click on the appropriate link if you would like to download the powerpoint presentations.
During the session I focus on Microsoft websites, however, if you have a Pluralsight account I would recommend the following video sessions to study for the exams. For the 70-473 exam: SQL Azure by Scott Seely, SQL Server 2016 New Features by Leonard Lobel, Implement Storage for Azure by Tim Warner, and Practical SQL Server HA/DR by Russ Thomas. For the 70-475 exam: Start with the 70-473 videos and then add Applying the Lambda Architecture by Ahmad Alkilani, HDInsight Deep Dive with Elton Stoneman, and Real World Big Data in Azure by Elton Stoneman.
It is a very cold and rainy day for the first SQL Saturday of 2017. Nashville is one of the events I attend every year as there are many members of the #SQLFamily that also attend. I am getting to do two sessions this year. First up at 8:30 am is my presentation on “The PROCESS of Queries”. This is the one I have been requested to present the most often. It is a very beginner level into how queries are optimized and how this effects batches, transactions, and errors. The second session will be at 1:30 pm and is a brand new presentation for a SQL Saturday, “The Basics of Data Manipulation”. This is from one of my favorite chapters from the T-SQL courses that I teach and I am really excited to put it into a one hour session format.
So I was planing my trip to the MCT Summit which is in Bellevue, Washington from March 28 -30, 2017. I was originally going to fly to Phoenix and speak at a SQL Saturday. But instead, I figured I would take the scenic route on a train trip through the Northwest. A little more relaxed journey and I get to see four states I have never visited.
Last September I took the BETA exams for 70-761: Querying Data with Transact-SQL and 70-762: Developing SQL Databases. Well it looks like I passed them, because today I received an email saying I have earned my MCSA: SQL Server 2016 Database Development. I always like when I pick up a new certification, but it’s really cool to wake up and earn one you were not expecting. I am just now sure to count it towards my 2016 goals or 2017.
Two weeks from today, I will be delivering Prep sessions on the 70-473 (Cloud Data Solutions) exam and the 70-475 (Big Data Analytics) exam at the Chicago Tech Summit. There are so many other great Azure and Office 365 sessions to attend if you are in the area.
Well, I am off and running on my Masters of Business Administration degree from Western Governors University. Finished my first course, Managing Organizations and Leading People. I was required to write two papers, the first I evaluated my fictional boss Roscoe P. Coltrane on his leadership style. The second paper, I had to evaluate my strengths and weaknesses based off a profile from the book, The Seven Habits of Highly Effective People. Next up is IT Project Management with three papers that I need to complete. It will probably take 5-6 weeks as I need to start off by reading A Guide to the Project Management Body of Knowledge.
Would you like to know how to build big data and advanced analytics solutions? This course from Microsoft Virtual Academy is a great starting point. Learn features and capabilities of the Microsoft cloud data platform that can help you build solutions using big data and analytics.
Well, that was not as difficult as I thought it would be. I was able to pass the 70-473 exam for the Cloud Data Platform Specialist certification. The first place to start if you are interested in passing this exam is Microsoft Virtual Academy. It has a great overview of the exam topics with some demonstrations. Next, spend some time with the Azure Documentation to walk through some very excellent tutorials.
Well, that is one busy infographic. If you need more insight into Cybersecurity, here is a great video on securing #Office365 like a cyber security professional. This session covers the primary areas of customer responsibility with Office 365 including administrative privilege management, account and access management, and client endpoints.
I was doing some research on Security and SQL Azure Databases and found this great article form Joseph D’Antoni (Denny Cherry & Associates Consulting) and Stacia Varga (Data Inspirations) that I highly recommend. The summary states, “This paper details the security and data management features found in Microsoft Azure SQL Database. It first describes the security foundation provided by Microsoft Azure and then explains the techniques and features used to manage data access in SQL Database; to log and monitor database activity; to protect data at rest and in transit; and to build secure applications. By understanding and using these features correctly, you can remain confident that your data in the cloud is protected.”
It is time for T-SQL Tuesday #85 and this month the party is being hosted by Kenneth Fisher from SQL Studies.This month’s topic is Backup and Restore and I will be discussing the differences between database Restore and Recovery.Click here to read more.
Opportunities for data scientists are rapidly growing in response to the exponential amounts of data being captured and analyzed. Companies hire data scientists to find insights and to solve meaningful business problems. Get the real-world knowledge and hands-on experience that can help you succeed in one of these new jobs. Prove that you have what it takes in the Microsoft Professional Program.Enrollment for the next Data Science Program starts on December 16th. https://lnkd.in/gnBkFKM
Attached is my presentation on SQL Server Certification that will be presented at SQL Saturday Atlanta: BI Edition this weekend. I have also provided useful links in getting certified on SQL Server.
I am starting to work on the 70-473 exam and normally the exam would cost $165. With my MCT discount it would only be $82.50. However, right now Microsoft has a deeply discounted offer for select Azure exams. With this discount I was able to get not only the exam voucher for the 70-473 exam, but also the Measure Up Practice exam, and a free re-take for only $99. There is an even deeper discount if you are going to take 3 exams. Found out more here.
Azure Machine Learning Studio has a large library of algorithms from the regression, classification, clustering, and anomaly detection families. Each is designed to address a different type of machine learning problem. Download the Azure Machine Learning Algorithm Cheat Sheet that helps you choose the right algorithm for a predictive analytics model.
The MCT Summit team has finalized the location and dates for 2017 as we move to the spring. While we are staying in Bellevue we are moving over to the Embassy Suites. It is a much larger environment and has better bacon for breakfast. Registration is now open. Be sure to follow us on Facebook https://lnkd.in/eu3uW8B or the website http://www.namctsummit.com to get future announcements.
Had the chance to teach two weeks of SQL Server in Phoenix, Arizona with a weekend off in between the two weeks. I took the opportunity to drive up through Sedona and Flagstaff to stay a night at the Grand Canyon. It was such a surreal experience as if I had stepped into a life-sized acrylic painting. After checking out these pictures I am sure you will add this adventure to your bucket list.
I completed the Know It, Prove It challenge and earned the Microsoft Virtual Academy Big Data badge. Whether you’re a Developer, Data Pro, or student, you can learn valuable skills quickly and correctly through video tutorials, assessments, and more. From now until December 14th you too can choose from one of three learning challenges that takes less than 12 hours to complete. Sign up now!
Looking to combat today’s enterprise security threats? Want to respond to and recover from security incidents more quickly? Learn how Azure Security Center helps you prevent, detect, and respond to threats with increased visibility and control over the security of your Azure resources.
Really, can’t believe it has been close to 18 months since my last Microsoft Certification. (Not counting the new Streamlined Certifications that came out on September 26, 2016. Those were just updates to existing MCSEs.) But, I finally passed the two Office 365 exams (70-346 and 70-347) for the corresponding MCSA. I spent about two month total of study time. I started with the Microsoft Press book mainly because I picked up a free copy while attending Microsoft Ignite. However, If you join Microsoft Virtual Academy you can get a discount on Microsoft Press books and also watch all the great Office 365 videos while you’re there. Finally, I do have to give a Thank You to Pluralsight and Jeff Adkin for the great videos that really gave me a great foundation for the exams.