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.
Posts from the ‘Learning’ Category
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.
PowerBI has the ability to mashup data from different sources; this may introduce problems when joining or matching data between systems. I was able to get around this issue by leveraging an R script from an article in the community. As a consultant there is a rule that if you use something from the community, you need to give back and particularly if you use it twice, you have to write a blog post. This is such a post.
Visualizations can make even the most mundane information more accessible and easier to digest. I put together these two facts to make a visualization out of my lesson plan that the students could take away as a memory jogger when they get back to their offices.
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.
If you have an excel table that is built for data entry, it may not be in the best format for data analysis or your data model. By using Query Editor, you can keep the original table and create a version that you can use for analysis as a dimensional fact table.
How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.