The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]
Posts Tagged ‘best practices’
Show Last N Month Data using single Date Slicer & What if Parameter in Power BI
Have you ever had a scenario where you need to Display the last 6 month or 4 month or N months of data just by selecting a single date dimension in slicer, sounds difficult“? Let’s me show you step by step how to display last N months of data just by selecting single date dimension […]
Mitigation Plan: Preparation Tips for Time-off
Have you ever suddenly found that a person you depend on for a project is out on vacation? No matter your role on a team, a mitigation plan can be an ideal way to capture your expectations when it is your turn to take vacation. Your plan can provide guidance for how to handle certain […]
The 1001st Piece in your 1000 Piece Puzzle: .NET Default Interface Functions
I recently worked with a client who wanted a reasonably large subsystem added to Optimizely that would add automated management to their content. While cutting the code for this, I found myself writing similar code across multiple classes. I had to write it that way: 1) The client was currently on CMS11 and didn’t have […]
Ensuring a Smooth Go-Live with a Cutover Plan
Project go-lives can be intense and take hours or even days. Following a detailed plan can streamline your go-live to help avoid a rollback and allow everyone to shut their computers as quickly as possible. Let’s discuss how to create a solid Cutover Plan to set yourself up for success. Why a Cutover Plan? First, the […]
6 Ways to Ensure a Successful Project Closeout as a Project Manager
Imagine you’re running a marathon – you’ve trained hard, your pace is great, and you’re feeling good. Finally, after many miles, you spot the finish line. Is that when you pump the brakes and lose focus? Of course not! You’d keep pushing through to the very end – you’ve come this far, you’re way too […]
How good is your AEM security? – Sling Resolution
Large scale data breaches and critical security vulnerabilities have companies thinking about security more than ever. Many developers are familiar with the OWASP top 10 (https://owasp.org/www-project-top-ten/) and there are already many resources on generic mitigation for these vulnerabilities. Instead in this series, I cover security issues and mitigations specific to AEM. Today’s topic is Sling […]
How good is your AEM security? – XSS
Large scale data breaches and critical security vulnerabilities have companies thinking about security more than ever. Many developers are familiar with the OWASP top 10 (https://owasp.org/www-project-top-ten/) and there are already many resources on generic mitigation for these vulnerabilities. Instead in this series, I cover security issues and mitigations specific to AEM. XSS and AntiSamy As […]
JIRA – Novice to Pro
You must have heard “Practice makes a Man Perfect” quite a lot and it can be summed up to this one word, i.e., “CONSISTENT”. Make JIRA part of your daily routine spicing it with JIRA Best Practices. Be a JIRA – Novice to Pro User! Yes, this blog is that easy!! Why make JIRA a […]
Makeup of Technical Project Teams: Solutions Architect (Pt. 2)
Welcome back! Last time we left off with our Solutions Architects discussing how best to set responsibilities and expectations of this role early on a new project. I have found amongst many projects that another important responsibility of a Project Manager is to evaluate meeting time. How many meetings, how many hours, how effective or […]
What is Bravo for Power BI?
What is Bravo for Power BI? Bravo studio is a design before, no code tool which allows you to turn your app designs and prototypes into real publishable mobile apps (both iOS and Android). You can use Bravo to build even complex apps by connecting your design to external tools via APIs. In this blog, […]
Introduction to “Export to PDF” in Power BI Desktop
Microsoft has released the feature Export to PDF option from Power BI Desktop. This feature has been available in every update of the Power BI desktop since August 2018. Read to explore this option and how to use it. Now, let’s get started. The following screenshot refers to the sample of my report. How To […]