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
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	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 (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 Tools (1)
Analysis Services	Analysis Services Tutorials (6)
Analysis Services	Cortana (5)
Analysis Services	Performance Point (4)
Business Intelligence	Big Data (25)
Business Intelligence	Data Warehousing (4)
Cloud	Amazon AWS (51)
Cloud	Apache Spark (8)
Cloud	Azure (146)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (13)
Cloud	Azure Data Factory (69)
Cloud	Azure Databricks (25)
Cloud	Azure Integration Services (14)
Cloud	Azure SQL Database (45)
Cloud	Azure SQL Managed Instance (2)
Cloud	Azure Synapse Analytics (38)
Cloud	Cloud Strategy (19)
Data Quality	Data Quality Services (9)
Data Quality	Master Data Services (41)
Database Administration	Amazon AWS RDS (1)
Database Administration	Availability Groups (78)
Database Administration	Backup (78)
Database Administration	Central Management Servers (9)
Database Administration	Clustering (74)
Database Administration	Comparison Data and Objects (14)
Database Administration	Compression (22)
Database Administration	Contained Databases (4)
Database Administration	Containers (12)
Database Administration	Database Administration (196)
Database Administration	Database Configurations (18)
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 (34)
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 (27)
Database Administration	Google Cloud (3)
Database Administration	Hardware (14)
Database Administration	High Availability (3)
Database Administration	Indexing (87)
Database Administration	Install and Uninstall (32)
Database Administration	Licensing (4)
Database Administration	Linked Servers (18)
Database Administration	Locking and Blocking (39)
Database Administration	Log Shipping (18)
Database Administration	Maintenance (34)
Database Administration	Monitoring (116)
Database Administration	Other Database Platforms (86)
Database Administration	Partitioning (17)
Database Administration	Performance Data Warehouse (4)
Database Administration	Performance Tuning (123)
Database Administration	Policy Based Management (29)
Database Administration	PowerShell (130)
Database Administration	Profiler and Trace (20)
Database Administration	Query Store (7)
Database Administration	Recovery Models (4)
Database Administration	Replication (75)
Database Administration	Resource Governor (5)
Database Administration	Restore (42)
Database Administration	SQL Server 2016 (100)
Database Administration	SQL Server 2017 (44)
Database Administration	SQL Server 2019 (20)
Database Administration	SQL Server 2022 (19)
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 (54)
Database Administration	Virtualization (25)
Database Administration	Windows Internal Database (1)
Database Development	Application Development (39)
Database Development	Azure Functions (7)
Database Development	Change Data Capture (15)
Database Development	Common Runtime Language (13)
Database Development	Common Table Expressions (3)
Database Development	Constraints (21)
Database Development	Data Cleansing for Validation (2)
Database Development	Data Science (3)
Database Development	Data Types (18)
Database Development	Database Design (76)
Database Development	Dates (53)
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 (71)
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 (40)
Database Development	Microsoft Flow (1)
Database Development	Paging (5)
Database Development	Python (65)
Database Development	Query Optimization (14)
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 (10)
Database Development	Temporal Tables (13)
Database Development	Testing (31)
Database Development	Transactions (9)
Database Development	Triggers (45)
Database Development	TSQL (350)
Database Development	User Defined Type UDT (3)
Database Development	Views (15)
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 (19)
Power Platform	Power BI (144)
Power Platform	Power BI Charts (50)
Power Platform	Power BI Formatting (15)
Professional Development	Professional Development Books (3)
Professional Development	Professional Development Branding (14)
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 (49)
Professional Development	Professional Development Community (16)
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 (38)
Professional Development	Professional Development Job Search (17)
Professional Development	Professional Development Management (10)
Professional Development	Professional Development Recruiters (6)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Reporting Services	Reporting Services Administration (19)
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 (45)
Security	Encryption (32)
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 (93)
Tools	SQL Server Management Studio (77)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (9)
Tools	Tools (33)