SQL Server 2016 Priority Boost Setting Caused Consistent Cluster Failover Issues
Read this tip to learn about the priority boost setting that was causing a SQL Server cluster to consistently restart or fail over to the passive node.
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU's Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) - 2016 | Author of the Year - 2015 | Author Contender - 2014, 2016-2021
Power BI Features for Notifications
In this tip we look at Power BI features that are available to notify a report consumer of data changes.
SSRS 2016 Standalone Installation
You are now able to install SSRS 2016 as a standalone install. No need to have the full SQL Server install files anymore read this tip to learn more.
Power BI Custom Infographics
In this tip we look at how to use a custom Power BI Visual or Infographic within a Power BI report.
Power BI Visual Interactions
In this tip we look at how to adjust the interactions that take place between different visuals on a Power BI report page.
Binning and Grouping Data with Power BI
Often when you speak with a DBA about grouping items into specific sets or binning data into certain groups, they will say, Do it in the presentation layer and not in your query. Read this tip to learn how to do this in Power BI.
Power BI Animated Scatter and Bubble Charts
Power BI has many neat visualizations, and one of the neatest is seeing animations in action. In this tip we cover how to add animation to your Power BI charts.
Add SSAS Role Members via PowerShell or XMLA
Learn how to add a user (member) to a SQL Server Analysis Services (SSAS) Database role via PowerShell or XMLA scripts.
Power BI Export and Publish to PowerPoint
In this tip learn how to export Power BI files to PowerPoint.
Using JSON as a data source for a SSRS report
In this tip we cover how you can use JSON source data as input for a SSRS report.
Using Power BI with JSON Data Sources and Files
In this tip we look at how to use a JSON source data and files with Power BI.
Power BI Online Alerts
Read this tip to learn how Power BI can send alerts when data changes.
Power BI Table, Matrix, and Chart Formatting
In this tip learn some tricks to make customizing a table for visualization easier in Power BI.
Power BI Native Query and Query Folding
Learn about Power BI Native Query and Query Folding with an example on how to discover and troubleshoot the queries as well as current limitations.
Power BI Focus Mode for Images and Data on Dashboards
I heard Power BI Desktop has a focus mode? Is that for images? What exactly does it do? How can I better manage the visualizations in Power BI? How can I embed my images in Power BI?
Using Parameters in Power BI
Read this tip to learn how to use parameters in Power BI.
Power BI Templates, Printing and Favorites
I am always looking for new things that can be done with Power BI. Read this tip to learn about templates, printing and favorites.
Power BI Data Import and Export with Excel
How can I import my Excel workbooks into Power BI Online? Are there any options to export data from Power BI to a CSV file? If so, can you provide the steps to complete both tasks?
Analyzing Power BI data with Excel
We have been working more and more with Power BI and the users have asked about how to export data to Excel as well as the ability to analyze data directly within Excel.
SQL Server Power BI Cortana Search
How can I enable PowerBI to use the Cortana search capability? How can Cortana help users be productive? Can you provide any examples?
Customized SSRS report to monitor server and database status
Read this tip to learn how to create a SQL Server Reporting Services report to monitor your servers and databases.
Power BI Advanced Q & A Techniques
How can you enhance the Power BI Q & A functionality? Are there any advanced techniques to make the data interaction any easier? I need ways to enhance the accuracy and efficiency of Power BI Online Q & A queries.
Power BI Q & A Example and Demo
How can I use the Power BI Q and A? What are some helpful tips for using it? Are there any limitations? What sort of visualizations are available? Can I pin the visualizations to dashboards?
Power BI Enterprise Content Packs
Power BI Content Packs provide a way to share Power BI objects, such as reports, datasets, or dashboards with individuals within your organizations. Check out this tip to learn how to use them.