The Know It, Prove It challenge starts today and I’ve already earned my first badge. Next up, I’m going to start working on the Azure challenge. Six total challenges for you to choose, that is if you are up to the challenge.
This coming Wednesday, April 19 at 8AM Pacific Time (click for your local time), Microsoft will be hosting a major on-line event of interest to anyone working with big data, analytics, and artificial intelligence: Microsoft Data Amp.
During Data Amp, Executive Vice President Scott Guthrie and Corporate Vice President Joseph Sirosh will share how Microsoft’s latest innovations put data, analytics and artificial intelligence at the heart of business transformation. The event will include exciting announcements that will help you derive even more value from the cloud, enable transformative application development, and ensure you can capitalize on intelligence from any data, any size, anywhere, across Linux and other open source technologies.
Finally received my scores from the 70-764 Beta Exam I took back in January. Passing score of 874 which is not too shabby. I guess I could also add that I took the exam while on my lunch break during the week I was teaching the class for the 4th or 5th time. But I won’t do that, because then I would just be bragging.
There is a new Know it. Prove it challenge over at the Microsoft Virtual Academy. The challenges are open to developers, data pros, and students, all of whom can pick up valuable skills quickly through video tutorials, assessments, and more.Accept the Know it. Prove it. challenge, earn unique badges, and display them proudly. The challenges run from April 18 through May 17, 2017.
Having a great time at the MCT Summit. Always enjoyable to meet up with old friends, talk about certification courses, and pick up new skills to be a better trainer. This is just a quick little post to share my presentation for my Azure Exam Prep session that will be delivered after lunch on Wednesday.
The newly designed PASS website is now live! Come meet us: http://www.pass.org/ PASS is your invitation to a global community of over 250,000 like-minded data professionals who leverage the Microsoft Data Platform. Becoming a member unlocks incredible year-round learning and professional development opportunities, virtual webinars, and in-person networking.
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.
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.
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.
- Mastering Microsoft Certification Exam Prep
- Microsoft Learning – SQL Server Certifications
- Larry Kaye announces New Streamlined Certifications
- MTA – Exam 98-364: Database Fundamentals
- Why get Microsoft Certified
- Online Proctored Exams
- Microsoft Certification Study Groups
- Channel 9 SQL Server videos
- Microsoft Exam Question Types
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!
From the SQL Server Database Engine blog: With the release of SQL Server 2016 SP1, one of the outcomes is that In-Memory OLTP (aka Hekaton), is now available in SQL Server Standard Edition and Express Edition. Get a recap of the technology and some of the resource/memory limitations in these two SQL Server editions.
There were so many great session at Microsoft Ignite that I could not attend them all. Fortunately, we can catch all the videos online. One session I did attend that I want to see again is the Exchange Online vs Exchange On-Premises debate.
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.
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.
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.
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.
In this article Pankaj Kumar Choudhary explains some general purpose queries. Every developer should have knowledge of these queries. These queries are not related to any specific topic of SQL. But knowledge of such queries can solve some complex tasks and may be used in many scenarios.
Here is a short 13 minute tutorial I put together on how to use XML within SQL Server. While I made this for the Born to Learn Study Groups, I am sure it will be helpful for others who might be studying for the 70-461 exam.
Exciting news! Starting today, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members. Microsoft is making this change so that all developers can leverage the capabilities that SQL Server 2014 has to offer for their data solution, and this is another step in making SQL Server more accessible. SQL Server Developer Edition is for development and testing only, and not for production environments or for use with production data.
Headed up to SQL Saturday – Chicago for another SQL Saturday. Attached are my powerpoints for my presentation on what you need to know about working with SQL Server Data Types. I will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions. I have my schedule built out for all the sessions I want to attend. I’ve been wanting to see some of these for awhile, but I always seem to be speaking at the time.
- Turbo Charged Transaction Logs – David Maxwell
- Regular Expressions for the DBA – Sean McCown
- Lock, Block, and Two Smoking Barrels – Mark Broadbent
- Are you Optimistic about Concurrency – Kalen Delaney
- What is your Character Data Type – John Deardurff
- Monitoring Counters That Count – Jimmy May
- Indexes and SARGability – Jared Karney