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
Monitoring Seamless Monitoring and Reporting for SQL Server
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 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 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 Drill Through SQL Server Reporting Services 2012 Drilldown Features
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 Functions SQL Server Reporting Services CountDistinct and Previous Functions
Reporting Services Functions SQL Server Reporting Services Custom Code Assemblies
Reporting Services Functions SQL Server Reporting Services String Manipulation
Reporting Services Functions SQL Server Reporting Services Unknown but Useful Functions
Reporting Services Installation SQL Server Reporting Services Standalone Installation
Reporting Services Maps SQL Server Reporting Services Analytical Marker Maps Including Bing Maps
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 (31)
Analysis Services Analysis Services Development (94)
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 Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (24)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (40)
Cloud Amazon AWS RDS (21)
Cloud Apache Spark (10)
Cloud Azure (146)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Data Factory (68)
Cloud Azure Databricks (37)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (3)
Cloud Azure Synapse Analytics (41)
Cloud Cloud Strategy (22)
Cloud Google Cloud (9)
Cloud Microsoft Fabric (8)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Availability Groups (79)
Database Administration Backup (80)
Database Administration Central Management Servers (10)
Database Administration Clustering (75)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (202)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (28)
Database Administration Hardware (15)
Database Administration High Availability (3)
Database Administration Indexing (92)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (43)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (112)
Database Administration Other Database Platforms (82)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (133)
Database Administration Policy Based Management (29)
Database Administration PowerShell (131)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (5)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (24)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (21)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (55)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (43)
Database Development Artificial Intelligence (13)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (4)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (4)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (80)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (74)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (44)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (80)
Database Development Query Optimization (15)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (9)
Database Development Temporal Tables (13)
Database Development Testing (32)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (386)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (162)
Power Platform Power BI Charts (56)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (56)
Professional Development Professional Development Community (15)
Professional Development Professional Development Conferences (2)
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 (18)
Professional Development Professional Development Management (14)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (21)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (35)
Security Security (197)
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)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (36)










get free sql tips
agree to terms