Columbus SQL User Group

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.

SQL Skills Online Training

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

Cloud Tech Summit – Chicago

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.

Nashville #581

 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.

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.

U-SQL for Big Data

usqlWhen 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!

TechNet Virtual Conference

savethedateSave 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?

Working with Data Types


This is my Working with Data Types presentation for the SQL Saturday in Cleveland on February 7th, 2015. Some helpful links.

Cleveland Schedule Released


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.

Net Neutrality Preservation


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.