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.
There is a very active community around PowerBI with many sites specializing in different aspects of the product. The following 4 resources are ones I always fall back on recommending that provide both beginner and advanced users learning resources.
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. 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.
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.