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.

2021 Awards   

2020 Awards   

2019 Awards   

2018 Awards   

2017 Awards   

2016 Awards      

2015 Awards      

2014 Awards      

2013 Awards   

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 (25)
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 (42)
Cloud Analytics	Microsoft Fabric (18)
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 (80)
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 (78)
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 (45)
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 (172)
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 (89)
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 (342)
Tools	Azure Data Studio (18)
Tools	PowerShell (131)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (95)
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)