As companies move data workloads to the cloud, more and more resources are available online to help you get up to speed. The following learning map provides a path to these online resources not only to give you an overview but also to provide an experience of these technologies .
Posts from the ‘Resources’ Category
A few years ago a manager at work circulated the "Work-Life Balance Quiz", from the Canadian Mental Health Association which tries to quantify your balance. A great quote from the quiz; "Achieving work/life balance means having equilibrium among all the priorities in your life – this state of balance is different for every person."
Minimize the impact on SQL Automation workflows when migrating to SQL Azure by automating stored procedures using Runbooks and E-mail. This step by step tutorial and walkthrough will review a solution to provide scheduling via Azure Runbooks with integrated O365 email alerts.
I must say that I enjoy articles that teach me something new from people who have a great depth of knowledge about a topic. I read an article by Avinash Kaushik, Create High-Impact Data Visualizations: Nine Effective Strategies, which covers nine strategies while reviewing sixteen visualizations. It reminded me of three key learnings I have had over my career.
Data visualizations can become the vehicle that leads a reader through your narrative. Having an infographic or series of visuals allows one to tell a story and provide greater understanding than simply having text alone.
There are times when, as a consultant, you have to produce a demo or training database that has no relation to the client that you are doing the work for. This can be due to security or confidentiality of the data. I try to produce training and samples that at least have realistic values so that the people involved have a frame of reference.
There are many formats that you can write documentation in for the Web. For GitHub projects, Markdown is an accessible format that is cross-platform and compatible with many web editors and CMS systems. This article shows how to add a Wiki to your GitHub project, write in markdown, and convert HTML documentation to the Markdown format.
I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations. R provides many packages and functions that let you perform data discovery over a data set.
There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.