Scott Murray

Scott Murray
Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

linkedin 
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.
2021 Awards   MSSQLTips award

2020 Awards   MSSQLTips award

2019 Awards   MSSQLTips award

2018 Awards   MSSQLTips award

2017 Awards   MSSQLTips award

2016 Awards   MSSQLTips award   MSSQLTips award

2015 Awards   MSSQLTips award   MSSQLTips award

2014 Awards   MSSQLTips award   MSSQLTips award

2013 Awards   MSSQLTips award

Category Tip Title
Analysis Services Administration SQL Server 2012 Analysis Services (SSAS) DMVs
Analysis Services Administration SQL Server 2012 Analysis Services XMLA
Analysis Services Administration SQL Server Analysis Services Cube Processing Status Report
Analysis Services Administration SQL Server Analysis Services Partition Maintenance and Processing
Analysis Services Administration SQL Server Analysis Services Processing Order Options
Analysis Services Development Build a SQL Server Analysis Services Data Dictionary
Analysis Services Development Excel Actions and Drill Down for SQL Server Analysis Services
Analysis Services Development MDX Case Statement Examples for SQL Server Analysis Services
Analysis Services Development Order and Sort with MDX in SQL Server Analysis Services
Analysis Services Development SQL Server Analysis Service DAX Time Intelligence
Analysis Services Development SQL Server Analysis Service Named Sets using the WITH Keyword
Analysis Services Development SQL Server Analysis Services (SSAS) 2012 Standard Deviation Functions
Analysis Services Development SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions
Analysis Services Development SQL Server Analysis Services Aggregation Designs
Analysis Services Development SQL Server Analysis Services Dimensions, Levels and Hierarchy
Analysis Services Development SQL Server Analysis Services Period over Period Variance Analysis
Analysis Services Development SQL Server Analysis Services Perspectives
Analysis Services Development SQL Server Analysis Services Rank and Row Number Ordering
Analysis Services Development SQL Server Analysis Services SSAS Processing Error Configurations
Analysis Services Development SQL Server Analysis Services Top N Plus All Other Rollup
Analysis Services Development SQL Server Analysis Services-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions
Analysis Services Development SQL Server Video on Analysis Services Aggregation Designs
Analysis Services Development SQL Server Video on Analysis Services SSAS Processing Error Configurations
Analysis Services Development What I wish I knew when I started working with SQL Server Analysis Services
Analysis Services Dimensions SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn
Analysis Services Dimensions SQL Server Analysis Service Changing a Source Table and a Data Source View (DSV)
Analysis Services Dimensions SQL Server Analysis Services Attribute Relationships
Analysis Services Dimensions SQL Server Analysis Services Discretization
Analysis Services Dimensions SSAS Time Account Dimension Intelligence
Analysis Services Measure Groups SQL Server Analysis Service Levels of Granularity
Analysis Services Security Add SQL Server Analysis Services Role Members via PowerShell or XMLA
Analysis Services Security Configuring permissions for SQL Server Analysis Services
Backup SSRS report for SQL Server Database Backup Status
Install and Uninstall SQL Server Data Tools (SSDT) is Missing After Installing SQL Server 2014
Integration Services Best Practices SQL Server Integration Services Inline Documentation Methods
Integration Services Development Import UTF-8 Unicode Special Characters with SQL Server Integration Services
Integration Services Development Importing XML documents using SQL Server Integration Services
Integration Services Development SQL Server Integration Services File Name Usage
Microsoft Flow Microsoft Flow and SQL Server Integration Example
Monitoring Customized SSRS report to monitor server and database status
Power BI Analyzing Power BI data with Excel
Power BI Binning and Grouping Data with Power BI
Power BI Compare Power BI Desktop vs. Power BI Online
Power BI Connect to on-premises data sources with Power BI Personal Gateway
Power BI Deploy Reports from Development to Test to Production using the Power BI Deployment Pipelines
Power BI Development Best Practices for Power BI
Power BI Getting Started with Power BI Designer
Power BI How to use the Power BI Enterprise Gateway
Power BI Introduction to Power BI Report Server
Power BI Pinning a SQL Server Reporting Services Report to Power BI
Power BI Power BI - How to Download and Get Started
Power BI Power BI Advanced Q & A Techniques
Power BI Power BI Advanced Q&A
Power BI Power BI Animated Scatter and Bubble Charts
Power BI Power BI Anomaly Detection
Power BI Power BI Data Import and Export with Excel
Power BI Power BI Data Insights
Power BI Power BI Data Source (PBIDS) Files
Power BI Power BI Designing with Diagrams
Power BI Power BI Desktop - The What, Why and How
Power BI Power BI Desktop - What is it and how do I use it?
Power BI Power BI Desktop Custom Visualization
Power BI Power BI Desktop Report and Panel Design
Power BI Power BI Desktop Web Queries to Screen Scrape Data from Websites
Power BI Power BI Drill Through Example
Power BI Power BI Embedded Example
Power BI Power BI Enterprise Content Packs
Power BI Power BI Export and Publish to PowerPoint
Power BI Power BI Features for Notifications
Power BI Power BI Filter Pane
Power BI Power BI Focus Mode for Images and Data on Dashboards
Power BI Power BI Merge Queries and Append Queries
Power BI Power BI Native Query and Query Folding
Power BI Power BI New Navigation Features
Power BI Power BI Online Alerts
Power BI Power BI Performance Analyzer
Power BI Power BI Personal Bookmarks
Power BI Power BI Q & A Example and Demo
Power BI Power BI Q&A Linguistic Schema
Power BI Power BI Report Automation
Power BI Power BI Row Level Security
Power BI Power BI Smart Narrative
Power BI Power BI Subscriptions
Power BI Power BI Table Based Row Level Security
Power BI Power BI Templates, Printing and Favorites
Power BI Power BI Tooltips Enhancements
Power BI Power BI Visual Interactions
Power BI Power BI Workspace Permissions and Roles
Power BI Power BI Zoom and Focus
Power BI Power BI: What I wish I knew when I started?
Power BI Querying SQL Server Data with Power BI Desktop
Power BI SQL Server Power BI Cortana Search
Power BI SSRS vs Power BI
Power BI Using Parameters in Power BI
Power BI Using Power BI with JSON Data Sources and Files
Power BI Charts Power BI Funnels and Waterfalls
Power BI Charts Power BI Key Influencers Visual
Power BI Charts Power BI Pulse Charts
Power BI Charts Power BI Ribbon Charts
Power BI Charts Power BI Small Multiples Visual Example
Power BI Formatting Power BI Conditional Formatting for Matrix and Table Visuals
Power BI Formatting Power BI Custom Infographics
Power BI Formatting Power BI Layouts and Themes
Power BI Formatting Power BI New Mobile Development Features
Power BI Formatting Power BI Personalization
Power BI Formatting Power BI Table, Matrix, and Chart Formatting
Power BI Formatting Power BI Theme Generator New Methods and Customizations
Professional Development Interview Questions BI SSRS Interview Questions and Answers
Reporting Services Administration Find Tables, Columns or Stored Procedures used in a SQL Server Reporting Services Report
Reporting Services Administration Manage SQL Server Reporting Services in Management Studio
Reporting Services Administration SQL Server Reporting Services 2008 R2 Report Server Database Helpful Queries
Reporting Services Administration SQL Server Reporting Services Caching and Snapshots
Reporting Services Administration SQL Server Reporting Services Log Files for Troubleshooting
Reporting Services Administration SQL Server Reporting Services Rest API
Reporting Services Administration SQL Server Reporting Services RS.EXE Utility
Reporting Services Administration SQL Server Video on Reporting Services Trace Logs and PerfMon Counters
Reporting Services Administration SSRS deploying reports using RS.EXE command line video
Reporting Services Best Practices SQL Server Reporting Services: What I wish I knew when I started?
Reporting Services Charts Embed Pie Charts, Manage Outliers and Display Reports on a Mobile Device with SQL Server Reporting Services
Reporting Services Charts Graphing the Sine Function in SQL Server Reporting Services
Reporting Services Charts SQL Server Reporting Services Multi-Layer Pie Charts
Reporting Services Charts SQL Server Reporting Services Range Charts
Reporting Services Configuration Making Adjustments to SQL Server Reporting Services Configuration Files
Reporting Services Configuration SQL Server Video Reporting Services (SSRS) RS.EXE Utility
Reporting Services Data Sources Developing a SSRS report using a SSAS Data Source
Reporting Services Data Sources SQL Server Reporting Services Report with Teradata Data Sources
Reporting Services Data Sources Using JSON as a data source for a SQL Server Reporting Services report
Reporting Services Development 5 Things You Should Know About SQL Server Reporting Services
Reporting Services Development Creating a Reporting Service Report Template
Reporting Services Development Getting Started with SSRS
Reporting Services Development Running a SSRS Report from a Windows Form Video
Reporting Services Development SQL Server Reporting Services 2012 Drilldown Features
Reporting Services Development SQL Server Reporting Services Analytical Marker Maps Including Bing Maps
Reporting Services Development SQL Server Reporting Services CountDistinct and Previous Functions
Reporting Services Development SQL Server Reporting Services Custom Code Assemblies
Reporting Services Development SQL Server Reporting Services Logic Expressions Xor, AndAlso and OrElse
Reporting Services Development SQL Server Reporting Services Repeating Headers On Pages
Reporting Services Development SQL Server Reporting Services ReportViewer Control for Windows Applications
Reporting Services Development SQL Server Reporting Services Reusable Code Blocks
Reporting Services Development SQL Server Reporting Services String Manipulation
Reporting Services Development SQL Server Reporting Services Unknown but Useful Functions
Reporting Services Development SQL Server Reporting Services Using Multi-value Parameters
Reporting Services Development SSRS data specific report drill through to Bing Maps
Reporting Services Development SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports
Reporting Services Development SSRS Textbox Tips and Tricks
Reporting Services Formatting SQL Server Reporting Services Bookmarks and Document Maps
Reporting Services Formatting SQL Server Reporting Services Bookmarks and Document Maps Video
Reporting Services Formatting SQL Server Reporting Services Controlling Report Page Breaks
Reporting Services Formatting SQL Server Reporting Services Embedding .NET Code for Report Formatting and Error Handling
Reporting Services Formatting SQL Server Reporting Services Formatting and Placeholders
Reporting Services Formatting SQL Server Reporting Services Indicators
Reporting Services Formatting SQL Server Reporting Services Matrix within a Matrix
Reporting Services Formatting SQL Server Reporting Services Report and Group Variable References
Reporting Services Formatting SQL Server Reporting Services Report and Group Variable References Video
Reporting Services Formatting SQL Server Reporting Services Video Embedding .NET Code for Report Formatting and Error Handling
Reporting Services Installation SQL Server Reporting Services Standalone Installation
Reporting Services Migration Common Issues After Upgrading to SSRS 2014 and the BIDS Helper Tool
Reporting Services Migration Common Issues After Upgrading to SSRS 2014 Video
Reporting Services Monitoring SQL Server Report Server 2008 R2 Execution Log Reports
Reporting Services Overview What's New in SQL Server 2012 Reporting Services
Reporting Services Parameters SQL Server Reporting Parameters Functions
Reporting Services Parameters SQL Server Reporting Services ReportItems Collection
Reporting Services Performance Using PerfMon for SQL Server Reporting Services Performance Management
Reporting Services Report Builder SQL Server Reporting Services Report Builder 2012 Security
Reporting Services Report Builder SQL Server Reporting Services Report Builder Manual Data Sources
Reporting Services Report Builder SQL Server Reporting Services Report Builder with DAX Query Support
Reporting Services Security SQL Server Reporting Services 2012 Permissions
Reporting Services Security SQL Server Reporting Services Encryption Key
SharePoint SSRS report server permissions when integrated with SharePoint
SharePoint Administration Upgrading SharePoint 2007 to SharePoint 2010: First Steps
SharePoint Administration Upgrading SharePoint 2007 to SharePoint 2010: Second Steps
SQL Operations Studio SQL Operations Studio Overview and Features
SQL Server 2016 DBCC Commands for SQL Server Analysis Service 2016
SQL Server 2016 SQL Server 2016 Reporting Services Mobile Report
SQL Server 2016 SQL Server Reporting Services 2016 Subscription Enhancements
SQL Server 2017 SQL Server Management Studio 2017 Data Discovery and Categorization
SQL Server Agent SQL Server Reporting Services SQL Agent Job Status Report
SQL Server Configurations SQL Server 2016 Priority Boost Setting Caused Consistent Cluster Failover Issues
XML SQL Server Reporting Services XML Data Source and Data Set
Tutorial Topic
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Installation and Configuration Setup
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Data Sources
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Data Sets
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Parameters
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Design Grid
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Deployment and Implementation
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Website Security and Options
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 and Management Studio
SQL Server Reporting Services 2017 (SSRS) Tutorial SQL Server Reporting Services SSRS 2017 Backup and Encryption Key Maintenance
SQL Server Reporting Services 2017 (SSRS) Tutorial Get Free SQL Tips - SQL Server Reporting Services 2017 (SSRS) Tutorial
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (33)
Analysis Services Analysis Services Development (95)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tutorials (6)
Business Intelligence Artificial Intelligence (23)
Business Intelligence Big Data (25)
Business Intelligence Data Science (3)
Business Intelligence Data Warehousing (7)
Business Intelligence Import and Export (81)
Business Intelligence R Language (11)
Business Intelligence Snowflake (29)
Cloud Amazon AWS (38)
Cloud Amazon AWS RDS (21)
Cloud Azure (149)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Functions (7)
Cloud Azure SQL Database (51)
Cloud Azure SQL Managed Instance (5)
Cloud Cloud Strategy (24)
Cloud Google Cloud (10)
Cloud Analytics Apache Spark (13)
Cloud Analytics Azure Data Factory (73)
Cloud Analytics Azure Databricks (39)
Cloud Analytics Azure Integration Services (14)
Cloud Analytics Azure Synapse Analytics (41)
Cloud Analytics Microsoft Fabric (17)
Data Quality Data Cleansing for Validation (4)
Data Quality Data Quality Services (10)
Data Quality Master Data Services (41)
Database Administration Central Management Servers (10)
Database Administration Comparison Data and Objects (14)
Database Administration Database Administration (208)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Scripts (35)
Database Administration System Databases (31)
Database Configuration Compression (22)
Database Configuration Database Configurations (19)
Database Configuration Database Mail (18)
Database Configuration FILESTREAM (9)
Database Configuration Full Text Search (21)
Database Configuration In Memory OLTP (32)
Database Configuration Linked Servers (18)
Database Configuration Policy Based Management (29)
Database Configuration Recovery Models (4)
Database Configuration Resource Governor (5)
Database Configuration SQL Server Configurations (75)
Database Design Constraints (20)
Database Design Data Types (22)
Database Design Database Design (92)
Database Design Identities (17)
Database Design JOIN Tables (23)
Database Design Synonyms (5)
Database Design Table Valued Parameters (4)
Database Design Temp Tables (15)
Database Design Temporal Tables (13)
Database Design User Defined Type UDT (3)
Database Design Views (17)
Database Development Application Development (46)
Database Development Common Runtime Language (13)
Database Development Debugging (4)
Database Development DevOps (36)
Database Development Entity Framework (13)
Database Development Language Integrated Query LINQ (7)
Database Development Paging (5)
Database Development Referential Integrity (5)
Database Development Service Broker (11)
Database Development Testing (32)
Database Development XML (14)
Database Maintenance Database Console Commands DBCCs (25)
Database Maintenance Fragmentation and Index Maintenance (28)
Database Maintenance Maintenance (34)
Disaster Recovery / High Availability Availability Groups (79)
Disaster Recovery / High Availability Backup (81)
Disaster Recovery / High Availability Clustering (77)
Disaster Recovery / High Availability Database Mirroring (33)
Disaster Recovery / High Availability Disaster Recovery (23)
Disaster Recovery / High Availability High Availability (3)
Disaster Recovery / High Availability Log Shipping (18)
Disaster Recovery / High Availability Replication (77)
Disaster Recovery / High Availability Restore (42)
Functions Dates (56)
Functions Functions System (99)
Functions Functions User Defined UDF (41)
Infrastructure Contained Databases (4)
Infrastructure Containers (12)
Infrastructure Hardware (14)
Infrastructure Spatial Data Storage (9)
Infrastructure Virtualization (25)
Integration Services Admin Integration Services Administration (10)
Integration Services Admin Integration Services Best Practices (12)
Integration Services Admin Integration Services Configuration Options (22)
Integration Services Admin Integration Services Performance (12)
Integration Services Admin Integration Services Security (7)
Integration Services Admin Integration Services Upgrade (4)
Integration Services Development Data Transformation Services (6)
Integration Services Development Integration Services Analysis Services Tasks (5)
Integration Services Development Integration Services Connection Managers (5)
Integration Services Development Integration Services Control Flow Transformations (14)
Integration Services Development Integration Services Data Flow Transformations (19)
Integration Services Development Integration Services Development (116)
Integration Services Development Integration Services Error Handling (8)
Integration Services Development Integration Services Excel (14)
Integration Services Development Integration Services Execute Package Options (8)
Integration Services Development Integration Services Oracle (4)
Microsoft Office Microsoft Access Integration (8)
Microsoft Office Microsoft Excel Integration (44)
Microsoft Office Microsoft Flow (1)
Other RDBMS Other Database Platforms (16)
Other RDBMS PostgreSQL (11)
Other RDBMS SQL Server and Oracle Comparison (29)
Other RDBMS SQL Server on Linux (78)
Other RDBMS SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance Dynamic Management Views and Functions (34)
Performance Error Logs (11)
Performance Extended Events (22)
Performance Indexing (94)
Performance Locking and Blocking (43)
Performance Monitoring (110)
Performance Partitioning (17)
Performance Performance Data Warehouse (4)
Performance Performance Tuning (124)
Performance Profiler and Trace (20)
Performance Query Optimization (15)
Performance Query Plans (20)
Performance Query Store (7)
Power Platform Power Apps (20)
Power Platform Power BI (170)
Power Platform Power BI Charts (57)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (20)
Professional Development Professional Development Certifications (62)
Professional Development Professional Development Community (16)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (24)
Professional Development Professional Development Management (14)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Python Python (88)
Reporting Services Admin Reporting Services Administration (21)
Reporting Services Admin Reporting Services Best Practices (6)
Reporting Services Admin Reporting Services Configuration (10)
Reporting Services Admin Reporting Services Installation (10)
Reporting Services Admin Reporting Services Migration (5)
Reporting Services Admin Reporting Services Monitoring (5)
Reporting Services Admin Reporting Services Network Load Balancing (4)
Reporting Services Admin Reporting Services Performance (6)
Reporting Services Admin Reporting Services Security (8)
Reporting Services Development Reporting Services Analysis Services (4)
Reporting Services Development Reporting Services Charts (25)
Reporting Services Development Reporting Services Data Sources (10)
Reporting Services Development Reporting Services Development (67)
Reporting Services Development Reporting Services Dynamic Reports (11)
Reporting Services Development Reporting Services Formatting (26)
Reporting Services Development Reporting Services KPI (5)
Reporting Services Development Reporting Services Overview (5)
Reporting Services Development Reporting Services Parameters (15)
Reporting Services Development Reporting Services Report Builder (9)
Security Auditing and Compliance (47)
Security Encryption (35)
Security Security (199)
Security SQL Injection (5)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
SQL Coding Change Data Capture (16)
SQL Coding Common Table Expressions (4)
SQL Coding Dynamic SQL (7)
SQL Coding Error Handling (11)
SQL Coding Stored Procedures (30)
SQL Coding Transactions (9)
SQL Coding Triggers (44)
SQL Coding TSQL (340)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
Tools SQL Server Management Objects SMO (3)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (35)
Versions Deprecated Features (6)
Versions Express Edition (16)
Versions Install and Uninstall (33)
Versions Licensing (4)
Versions SQL Server 2016 (96)
Versions SQL Server 2017 (44)
Versions SQL Server 2019 (20)
Versions SQL Server 2022 (21)
Versions Upgrades and Migrations (55)










get free sql tips
agree to terms