Invoke-Sqlcmd variable parameter
Using PowerShell Invoke-Sqlcmd with Variable parameter
26 Feb 2020

In this blog, our Chief Technology Storyteller Bill Ramos shows how to use the array sub-expression operator and “splatting” with hash tables to build the parameters needed for the Invoke-Sqlcmd cmdlet.

analyze Windows Perfmon
Using Power BI to analyze Windows Perfmon data for SQL Server
27 Jan 2020

In this second blog post for my series, Power BI for the SQL Server DBA, I’m going to show how you can take Windows Perfmon (Performance Monitor) data for SQL Server and analyze it with Power BI.
I’m going to assume that as an SQL Server DBA, you probably have not used Power BI yet. If you have some familiarity with Power BI, I hope there are still gems you can pull out of this blog post.

optimize SQL Server performance on AWS EC2
Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
22 Jan 2020

Over the last few months of benchmarking SQL Server performance on AWS, I discovered a way to optimize SQL Server performance running on EC2 instances by paying close attention to several key Windows performance counters. This blog post is the first in my new series called Power BI for the SQL Server DBA. I’m going to show how you can easily capture performance counters to optimize SQL Server performance and cost on AWS EC2 instances. I’m going to start with […]

Power BI Set Filters
Power BI — Set Visual, Page, and Report Level Filters — Episode 13
28 Jun 2019

Welcome to the last episode of my Power BI Best Practices Series. In today’s episode, I will show you how to filter your report based on visual level, report level, or page level filters.
Visual level filters allow for filtering only the selected visual. Likewise, page level filters allow for filtering the entire page. And report level filters allow for filtering all tabs together in your entire report.
Read more on our blog and be sure to watch the related video.

Power BI — Edit Interactions — Episode 12
21 Jun 2019

Welcome to Episode 12 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should edit your interactions in your visuals. Editing interactions allows for you to apply the filter directly on a visual. Also, you can change the way the filter interacts with different visuals on your page.
Please note that you can not edit interactions if the report was shared with you. Also, by default, drilling one visualization has no impact on the other visualizations on the report page.
Find more details from this blog post.

Report Support Tab
Power BI — Include a Report Support Tab — Episode 10
07 Jun 2019

Welcome to Episode 10 of my Power BI Best Practices Series. In today’s episode, I will show you how to include a report support tab in your Power BI report. This tab helps your users see where the data comes from. Also, here you can include your contact information, so the users of your report will know how to reach you if they have questions.
A report support tab is not mandatory. However, this is one of the developers’ best practices and the way to show some respect to the other users working with your report.

Power BI Themes
Power BI — Themes Are Your Best Friend — Episode 9
31 May 2019

Welcome to Episode 9 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create themes in your Power BI report and allow for more branding experience.
Power BI themes allow for brighter visualizations, as well as customizing and standardizing your reports. You can select one of the predefined themes, import an existing theme, pick up a theme from the gallery or even create a new theme.

Create Drillthrough Pages
Power BI — Create Drillthrough Pages with Detail — Episode 8
24 May 2019

Welcome to Episode 8 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create drillthrough pages in your report.
Drillthrough pages allow for your users to navigate to different pages within your report to expore the details of the visuals that they choose. For example, you can create a drillthrough filter in Power BI based on the specific entity.

Power BI — Align Your Visuals
Power BI — Align Your Visuals — Episode 7
17 May 2019

Welcome to Episode 7 of my Power BI Best Practices Series. In today’s episode, I will show you how to align your visuals to make users happy with the content they see.

Power BI Relate tables
Power BI — Relate Tables Using Your Data Model — Episode 6
10 May 2019

Welcome to Episode 6 of my Power BI Best Practices Series. In today’s episode, I will show you how to relate tables and your data model to allow for cross filtering and relationships. Here we go! Power BI — Relate tables and your data model By default, Power BI relationships are not active. So, you need to set the relationships in your dashboard. You can also set the type of cardinality of the selected relationship from one of the following […]