I read this article and it didn’t sit well with me. https://towardsdatascience.com/5-common-sql-interview-problems-for-data-scientists-1bfa02d8bae6 This has got the be one of the worst ways to conduct an interview. Of those 5 problems, only two of them I have ever had the need to perform. They are the duplicate email and the highest salary. Sadly I did not appear on the list. The
Continue readingSlow Dynamics AX reports? Are you forgetting DataAreaId and Partition?
One of the benefits of Microsoft Dynamics AX is that the schema is fairly easy to navigate around. Every day I thank Microsoft for not going down the obfuscation route. Have you ever worked on ACCPAC? It’s a nightmare. Peoplesoft isn’t that much better. Most AX systems I’ve worked on have some external reporting running on the database. Because of
Continue readingDo you really have job security?
I used to work as a contractor at a big corporation and one day they decided to go through a huge restructure. Everyone’s job, from the top down, was on the table. Peoples terms of employment weren’t a factor in whether they would stay. The value their role contributed to the business would be the main factor. As it happened,
Continue readingAnalysis services, perspectives and different granularities
One of the wonderful features of Analysis Services (SSAS) are perspectives. Perspectives allow you to limit what measure groups, measures, dimensions, attributes and hierarchies are displayed. This is great if you have lots of measure groups and dimensions because you can build them all in one cube and use a perspective to display only a subset of them. You can
Continue readingHow to take awesome notes
Note taking is one of the most useful things you can do. You should do it when you’re in meetings, working on an idea, on the phone, reviewing a document, or just having a chat with someone. They give you a simple written account of what happened which you can refer back to at any time. This is vital because you will not
Continue reading