On my way to the Columbus, Ohio SQL Server User Group to talk about “How to get Microsoft Certified”. Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The presentation walks you through the certifications, exams, and resources available to get you ready for success. You can download the presentation here.
Obviously, the first place I would recommend for SQL Server training is to take one of my classes at New Horizons Learning Center. But, I also know that isn’t always possible. However, I do want to share a very great resource for SQL Training and that is the good people over at SQL Skills or more specifically, the videos they publish to PluralSight (Which is also a competitor that I highly recommend.)
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.
Headed back down to Atlanta on December 10th for another SQL Saturday. It is the Business Intelligence Edition, but I will be talking about the new Streamlined Microsoft Certifications and how you can become certifiable.
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.
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.
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!
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.
When Microsoft introduced the Azure Data Lake, they decided to also include a new language called U-SQL to make Big Data processing easy. It unifies the declarative power of SQL and the extensibility of C# to make writing custom processing of Big Data easy. It also unifies processing over all data – structured, semi-structured and unstructured data – and queries over both local data and remote SQL data sources.Find out more in this webinar on U-SQL and learn why they decided to build a new language, what its core design underpinnings are as well as show the language in its natural habitat. Sign up now!http://msft.it/6186BbHb8
Save the date for the TechNet Virtual Conference on March 1-3, 2016. This an event for IT professionals, but it could still be interesting for Microsoft fans who care about technical stuff. Anyway, here is the program:
March 1, 9AM to 1PM PST: Microsoft Senior Evangelist Rick Claus and journalist Mary-Jo Foley will present this first session labeled “Inspiring IT Pros”, covering topics like online security, IT careers and the role of IT leaders in companies.
March 2, 9AM to 4:30PM PST: This session labeled “Windows 10 and mobility” promises to explore the latest developments in Windows 10 and to provide IT Pros the skills needed to plan out scaled deployments. Presenters are still unknown.
March 3, 9AM to 4:30PM PST: The concluding session is labeled “Infrastrucure, on-premises and in the cloud”, and may interest you if you’re passionate about datacenters, Azure and Windows Server.
If you want more details about the event, you can already sign up right on the website for getting speaker previews and other important announcements. Moreover, if you’re an IT professional and legal resident of the US, you may really want to sign up as Microsoft will give participants the chance to win one of 5 Air Hogs remote control quad drones! Who said IT conferences were not interesting?
Ready for one more SQL Saturday event of the year. Final stop will be in Providence, Rhode Island. For those attending, here is the powerpoint presentation from my session. Thank you once again for another amazing Saturday.
Today I will be delivering two sessions on the new Windows 10 Features. Here is the presentation for those interested. I will be discussing information about Cortana, the New Start, Windows Hello, Microsoft Edge and so much more.
Stopping by SQL Saturday – Kansas City on my way home from the MCT Summit. One last time for my presentation on The Process of Queries and how this effects Batches, Transactions and Error Handling. You can find the PowerPoints here and the handout of the lecture here.
Once again excited to be speaking at SQL Saturday – Indianapolis 2015. This is my favorite SQL Saturday event, since it is about 2 miles from my house. As always I have attached my presentation as well as the pdf of the demonstrations.
This is my Working with Data Types presentation for the SQL Saturday in Cleveland on February 7th, 2015. Some helpful links.
- Sample Code from Presentation
- Character Data Type Demonstration
- Integer Data Type Demonstration
- Date and Time Data Type Demonstration
- Data Type Conversion Demonstration
- How Rows are Stored in a Data Page
- Data Type Precedence
- SQL Server Data Type Conversion Chart
- CAST and CONVERT Functions
- Parse, Try_Parse, and Try_Convert Functions
- Every Byte Counts by Andy Yun
The schedule for SQL Saturday for Cleveland has been released. Looks like I will be doing my presentation on Data Types at 3:00pm in Training Room 5. Click here for the complete schedule.
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Feb 7 2015 at Hyland Software – Building 1, 28500 Clemens Rd., Cleveland, OH 44145. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch – not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.
The World Wide Web has emerged as an increasingly large and open network of creativity, connectivity, and free speech. This has led to a conflict between those who provide internet broadband services with those who provide content. The content providers wish to keep their ideas and creations freely open and available to others regardless of income or residence and without restrictions dictated by the Internet Service Providers. Click here to read my entire research paper.