Scott Murray

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
Title Category Date
Develop SSRS report using SSAS Data Source Reporting Services Data Sources2026-06-09
New SQL Regex Functions in SQL Server 2025 and SSMS Functions System2025-11-19
SQL Server Management Studio and Copilot SQL Server Management Studio2025-06-04
What is Tableau? Data Science2025-04-25
Data Quality Testing Data Cleansing for Validation2025-01-14
SSRS IIF, Switch and Choose Functions Reporting Services Development2024-12-31
Datasets in SSRS to Define the Data Structure Reporting Services Development2024-12-10
SQL Server Reporting Services Security Reporting Services Security2024-09-23
SQL Server Reporting Services Quick Reference Guide Reporting Services Overview2024-08-20
Power BI Best Practices for Development, Visualizations, Performance Power BI2022-08-22
Power BI Download, Install and Get Started Power BI2022-06-29
Power BI Desktop for Report and Dashboard Design Power BI2022-05-11
Power BI Desktop for Business Intelligence Power BI2022-04-13
New Power BI Diagram View and Schema View for Power Query Editing Power BI2022-02-11
Power BI New Navigation Features for Improved Interactivity Power BI2021-12-27
Power BI Zoom In and Focus Mode for Charts and Graphs Power BI2021-12-24
SSRS Interview Questions Business Intelligence Interview Questions2021-12-21
Auto-Create a Power BI Report Power BI2021-10-25
Build Better SSRS Reports – Things I Wish I Knew Reporting Services Development2021-08-12
SSRS vs Power BI Power BI2021-05-19
Getting Started with SSRS Reporting Services Development2021-04-08
Power BI Anomaly Detection Power BI2021-03-17
Power BI Smart Narrative Power BI2021-03-04
Power BI Small Multiples Visual Example Power BI Charts2021-02-12
Power BI Theme Generator New Methods and Customizations Power BI Formatting2021-01-05
Power BI Merge Queries and Append Queries Power BI2020-12-28
How to Format Indicators in SSRS Reporting Services Formatting2020-11-13
Power BI Mobile Features Power BI Formatting2020-10-20
Power BI Deployment Pipelines Power BI2020-09-23
SSRS Reusable Code Blocks Reporting Services Development2020-09-09
Power BI Tooltips Enhancements Power BI2020-08-11
Power BI Personalization Power BI Formatting2020-07-29
Power BI Workspace Permissions and Roles Power BI2020-07-15
Power BI Data Source (PBIDS) Files Power BI2020-06-10
Power BI: What I wish I knew when I started? Power BI2020-05-29
Power BI Table Based Row Level Security Power BI2020-03-26
Power BI Q&A Linguistic Schema Power BI2020-02-26
Power BI Advanced Q&A Power BI2020-01-21
Power BI Conditional Formatting for Matrix and Table Visuals Power BI Formatting2019-12-17
Power BI Filter Pane Power BI2019-11-13
Power BI Row Level Security Power BI2019-09-09
Power BI Performance Analyzer Power BI2019-08-07
What I wish I knew when I started working with SSAS Analysis Services Development2019-07-19
SSRS: What I wish I knew when I started? Reporting Services Best Practices2019-06-19
Power BI Personal Bookmarks Power BI2019-05-15
Power BI Key Influencers Visual Power BI Charts2019-04-18
Power BI Embedded Example Power BI2019-02-27
Power BI Drill Through Example Power BI2019-02-08
SSRS Report Builder with DAX Query Support Reporting Services Report Builder2019-01-09
SSRS Report Builder Manual Data Sources Reporting Services Report Builder2018-11-08
SSRS Caching and Snapshots Reporting Services Administration2018-07-26
SSRS Rest API API2018-07-10
Power BI Layouts and Themes Power BI Formatting2018-06-15
SQL Server Management Studio 2017 Data Discovery and Categorization SQL Server 20172018-05-29
Power BI Subscriptions Power BI2018-05-15
Power BI Data Insights Power BI2018-05-02
SQL Operations Studio Overview and Features SQL Operations Studio2018-04-09
Power BI Pulse Charts Power BI Charts2018-03-15
Introduction to Power BI Report Server Power BI2018-02-21
SSAS Processing Order Options Analysis Services Administration2018-02-08
Power BI Ribbon Charts Power BI Charts2018-01-26
SQL Server Reporting Services 2017 Installation and Configuration Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 Data Sources Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 Data Sets Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 Parameters Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 Design Grid Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 Deployment and Implementation Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 Website Security and Options Reporting Services Development2017-12-29
SQL Server Reporting Services SSRS 2017 and Management Studio Reporting Services Development2017-12-29
SSRS 2017 Backup and Encryption Key Maintenance Reporting Services Development2017-12-29
Microsoft Flow and SQL Server Integration Example Microsoft Flow2017-09-28
Power BI Funnels and Waterfalls Power BI Charts2017-09-18
Running a SSRS Report from a Windows Form Video Reporting Services Development2017-08-10
SQL Server 2016 Priority Boost Setting Caused Consistent Cluster Failover Issues SQL Server Configurations2017-06-23
Power BI Features for Notifications Power BI2017-06-09
SSRS 2016 Standalone Installation Reporting Services Installation2017-05-31
Power BI Custom Infographics Power BI Formatting2017-05-03
Power BI Visual Interactions Power BI2017-04-07
Binning and Grouping Data with Power BI Power BI2017-03-03
Power BI Animated Scatter and Bubble Charts Power BI2017-02-16
Add SSAS Role Members via PowerShell or XMLA Analysis Services Security2017-02-06
Power BI Export and Publish to PowerPoint Power BI2017-01-24
Using JSON as a data source for a SSRS report Reporting Services Data Sources2017-01-19
Using Power BI with JSON Data Sources and Files Power BI2017-01-05
Power BI Online Alerts Power BI2016-12-22
Power BI Table, Matrix, and Chart Formatting Power BI Formatting2016-12-07
Power BI Native Query and Query Folding Power BI2016-11-30
Power BI Focus Mode for Images and Data on Dashboards Power BI2016-11-03
Using Parameters in Power BI Power BI2016-09-29
Power BI Templates, Printing and Favorites Power BI2016-08-09
Power BI Data Import and Export with Excel Power BI2016-07-27
Analyzing Power BI data with Excel Power BI2016-07-19
SQL Server Power BI Cortana Search Power BI2016-06-28
Customized SSRS report to monitor server and database status Monitoring2016-06-15
Power BI Advanced Q & A Techniques Power BI2016-05-26
Power BI Q & A Example and Demo Power BI2016-05-05
Power BI Enterprise Content Packs Power BI2016-04-21
SSRS CountDistinct and Previous Functions Reporting Services Development2016-04-07
How to use the Power BI Enterprise Gateway Power BI2016-03-30
SSAS Cube Processing Status Report Analysis Services Administration2016-03-24
SSRS SQL Agent Job Status Report SQL Server Agent2016-03-09
SQL Server 2016 Reporting Services Mobile Report SQL Server 20162016-03-04
Connect to on-premises data sources with Power BI Personal Gateway Power BI2016-02-18
SSRS report for SQL Server Database Backup Status Backup2016-02-10
Compare Power BI Desktop vs. Power BI Online Power BI2016-01-12
Pinning a SSRS Report to Power BI Power BI2016-01-06
SQL Server Reporting Parameters Functions Reporting Services Parameters2015-12-23
Power BI Desktop Custom Visualization Power BI2015-12-11
Power BI Desktop Report and Panel Design Power BI2015-12-03
SSRS String Manipulation Reporting Services Development2015-11-19
SSRS Formatting and Placeholders Reporting Services Formatting2015-11-05
SSRS 2016 Subscription Enhancements SQL Server 20162015-10-27
DBCC Commands for SQL Server Analysis Service 2016 SQL Server 20162015-10-21
SSRS Logic Expressions Xor, AndAlso and OrElse Reporting Services Development2015-10-14
Power BI Desktop Web Queries to Screen Scrape Data from Websites Power BI2015-10-05
SSRS Unknown but Useful Functions Reporting Services Development2015-09-15
Querying SQL Server Data with Power BI Desktop Power BI2015-09-10
Find Tables, Columns or Stored Procedures used in a SSRS Report Reporting Services Administration2015-08-05
Getting Started with Power BI Designer Power BI2015-07-23
SSIS File Name Usage Integration Services Development2015-06-19
SSAS Dimensions, Levels and Hierarchy Analysis Services Development2015-06-09
SSAS Processing Error Configurations Video Analysis Services Development2015-05-19
SQL Server Analysis Service Levels of Granularity Analysis Services Measure Groups2015-05-12
SQL Server Video on Analysis Services Aggregation Designs Analysis Services Development2015-05-05
SSRS Multi-Layer Pie Charts Reporting Services Charts2015-04-29
SSRS Report and Group Variable References Video Reporting Services Formatting2015-04-23
SSRS Analytical Marker Maps Including Bing Maps Reporting Services Development2015-04-21
SSRS Embed .NET Code for Report Formatting and Error Handling Video Reporting Services Formatting2015-04-16
SSRS Bookmarks and Document Maps Video Reporting Services Formatting2015-04-08
SSRS Range Charts Reporting Services Charts2015-04-07
SSAS Rank and Row Number Ordering Analysis Services Development2015-03-27
SSRS Bookmarks and Document Maps Reporting Services Formatting2015-03-16
SSRS Controlling Report Page Breaks Reporting Services Formatting2015-03-04
SSAS Processing Error Configurations Analysis Services Development2015-02-11
Common Issues After Upgrading to SSRS 2014 Video Reporting Services Migration2015-02-10
SSRS Mobile Device Report with Pie Charts and Outliers Reporting Services Charts2015-02-02
Common Issues After Upgrading to SSRS 2014 and the BIDS Helper Tool Reporting Services Migration2015-01-23
SSRS Repeat Headers on Pages Reporting Services Development2015-01-13
SQL Server Data Tools Missing After Installing SQL Server 2014 Install and Uninstall2014-12-24
SSAS Attribute Relationships Analysis Services Dimensions2014-12-03
SSAS Aggregation Designs Analysis Services Development2014-11-18
SQL Server Video Reporting Services Trace Logs and PerfMon Counters Reporting Services Administration2014-10-15
Using PerfMon for SSRS Performance Management Reporting Services Performance2014-10-14
SSRS ReportViewer Control for Windows Applications Reporting Services Development2014-10-09
SSRS Log Files for Troubleshooting Reporting Services Administration2014-09-26
SSRS Encryption Key Reporting Services Security2014-09-02
SSRS deploying reports using RS.EXE command line video Reporting Services Administration2014-08-29
SSRS Matrix within a Matrix Reporting Services Formatting2014-08-20
SQL Server Video Reporting Services (SSRS) RS.EXE Utility Reporting Services Configuration2014-08-15
SSAS KeyColumn vs NameColumn vs ValueColumn Analysis Services Dimensions2014-06-27
SSRS RS.EXE Utility Reporting Services Administration2014-06-18
SSAS Changing a Source Table and a Data Source View Analysis Services Dimensions2014-05-23
SSRS Report and Group Variable References Reporting Services Formatting2014-05-16
SSRS Custom Code Assemblies Reporting Services Development2014-05-08
SSAS Perspectives Analysis Services Development2014-04-16
SSRS Embedding .NET Code for Report Formatting and Error Handling Reporting Services Formatting2014-04-07
SSAS Top N Plus All Other Rollup Analysis Services Development2014-03-19
Excel Actions and Drill Down for SSAS Analysis Services Development2014-02-19
SQL Server Analysis Service Named Sets using the WITH Keyword Analysis Services Development2014-02-14
MDX Case Statement Examples for SSAS Analysis Services Development2014-02-04
SSAS Discretization Analysis Services Dimensions2014-01-28
SSRS XML Data Source and Data Set XML2014-01-03
Importing XML documents using SSIS Integration Services Development2013-12-27
Order and Sort with MDX in SSAS Analysis Services Development2013-12-17
Import UTF-8 Unicode Special Characters with SSIS Integration Services Development2013-12-05
SSIS Inline Documentation Methods Integration Services Best Practices2013-11-20
Making Adjustments to SSRS Configuration Files Reporting Services Configuration2013-11-04
SQL Server Analysis Service DAX Time Intelligence Analysis Services Development2013-10-18
SSRS Report Builder 2012 Security Reporting Services Report Builder2013-10-08
Manage SSRS in Management Studio Reporting Services Administration2013-09-13
SSAS 2012 Top and Bottom Functions Analysis Services Development2013-09-05
SSAS Time Account Dimension Intelligence Analysis Services Dimensions2013-08-20
SSAS 2012 Standard Deviation Functions Analysis Services Development2013-08-07
SQL Server 2012 Analysis Services (SSAS) DMVs Analysis Services Administration2013-07-26
SQL Server 2012 Analysis Services XMLA Analysis Services Administration2013-06-26
SSRS ReportItems Collection Reporting Services Parameters2013-06-12
SSAS Partition Maintenance and Processing Analysis Services Administration2013-05-01
SSRS data specific report drill through to Bing Maps Reporting Services Development2013-04-10
SSAS Period over Period Variance Analysis Analysis Services Development2013-03-27
SSAS-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions Analysis Services Development2013-02-08
SSRS Using Multi-value Parameters Reporting Services Development2013-01-21
Graphing the Sine Function in SSRS Reporting Services Charts2012-12-20
SSRS 2012 Drilldown Features Reporting Services Development2012-12-12
What’s New in SQL Server 2012 Reporting Services Reporting Services Overview2012-11-28
SSRS 2012 Permissions Reporting Services Security2012-10-23
Configuring permissions for SSAS Analysis Services Security2012-09-25
SSRS Textbox Tips and Tricks Reporting Services Development2012-08-29
SSRS 2008 R2 Report Server Database Helpful Queries Reporting Services Administration2012-08-14
SQL Server Report Server 2008 R2 Execution Log Reports Reporting Services Monitoring2012-06-29
SSRS Report with Teradata Data Sources Reporting Services Data Sources2012-05-25
Creating a Reporting Service Report Template Reporting Services Development2012-04-04
Build a SSAS Data Dictionary Analysis Services Development2012-03-02