I’ve recently brought a new HP Mini Performance Workstation with Windows 10 Pro with Hyper-V and use freely available resources for training such as:
- Windows Server Evaluation, virtual machines – https://www.microsoft.com/en-gb/evalcenter/try.
- SQL Server Developer Editions and Visual Studio Community Edition – https://visualstudio.microsoft.com/downloads/
Using a similiar setup over the last few years helped pass the certifications listed below:
Data Platform Training – Microsoft
Data Science Training – EDX
The EDX courses below are components of their Data Science program:
- DAT206x: Analyzing and Visualizing Data with Excel
- DAT203.1x: Data Science Essentials
- DAT101x: Data Science Orientation
- DAT102x: Data Science Professional Project
- DAT211x: Developing Intelligent Apps
- DAT204x: Introduction to R for Data Science
- DAT203.2x: Principles of Machine Learning
- DAT209x: Programming in R for Data Science
- DAT201x: Querying with Transact-SQL
- DS101X: Statistical Thinking for Data Science and Analytics
Big Data Training – EDX
The EDX courses below are components of their Big Data program, two more courses are need for the certificate:
- DAT220x: Delivering a Data Warehouse in the Cloud
- DAT229x: Microsoft Professional Orientation : Big Data
- DAT221x: Introduction to NoSQL Data Solutions
- DAT223.3x: Orchestrating Big Data with Azure Data Factory
- DAT223.1x: Processing Big Data with Azure Data Lake Analytics
- DAT223.2x: Processing Real-Time Data Streams in Azure
Articles Contributed to SQL Server Central
In addition to the three personal projects mentioned earlier, I’ve also contributed these articles to SQL Server Central:
- Configure an Always On Availability Group using Power Shell
- Transaction Replication Publisher – Fail Over
- Configure an Active/Active Fail over Cluster using an iSCSI SAN
Hobby Projects (3)
The three projects below are ongoing efforts and were written from scratch in my own time. For example, the Graph NEL project was started in a caravan during two week surfing holiday on the days it rained (5). These are attempts to produce something interesting, useful and original, Restore Gene is popular but the other two haven’t taken off yet. A new version of the R graph NEL generator procedure is scheduled for release shortly after my next surfing holiday, if it rains again.
- Restore Gene – This started as a small script and grew, its being used by a lot of people and organisations.
- Bioconductor GraphNEL Gene – This started through frustration with graphing applications that can’t cope with more than one edge.
- CA Performance bench marking – This works well but it’s too complicated and there are other better know bench-marking alternatives.