Ray Barley

Ray is a Principal Architect at IT Resource Partners focused on SQL Server and Business Intelligence. He is a Microsoft Certified Solutions Expert (MCSE) in Business Intelligence, a MSSQLTips.com BI Expert and Ambassador. He is also a co-author of the book: SharePoint 2010 Business Intelligence Unleashed.

2013 Awards
MSSQLTips award

2010 Awards
MSSQLTips award

2009 Awards

2008 Awards
MSSQLTips award

Analysis Services Administration

Using the SQL Server Analysis Services (SSAS) Deployment Wizard (last update: 11/18/2009)

Analysis Services Development

Build a Cube From an Existing Data Source Using SQL Server Analysis Services (last update: 7/2/2008)
Build Integrated SQL Server Business Intelligence Solutions with Microsoft Office (last update: 3/26/2009)
DirectQuery Mode in SQL Server 2012 Analysis Services (SSAS) Tabular (last update: 4/11/2013)
How To Build a Cube Without a Data Source Using SQL Server Analysis Services (last update: 6/27/2008)
How To Enable User Defined Hierarchies in SQL Server Analysis Services SSAS (last update: 6/16/2009)

Analysis Services Dimensions

Built in Time Dimension and Time Intelligence in SQL Server Analysis (last update: 3/13/2008)
Handle Weeks that Overlap Years in a SQL Server Date Dimension (last update: 1/29/2008)

Analysis Services Measure Groups

How To Define Measure Group Partitions in SQL Server Analysis Services SSAS (last update: 7/28/2008)
How To Implement Proactive Caching in SQL Server Analysis Services SSAS (last update: 8/15/2008)

Analysis Services Security

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005 (last update: 9/10/2009)
SQL Server Analysis Services SSAS Dimension Security Stored Procedures (last update: 9/24/2009)
Using a Parent Child Hierarchy in SQL Server to Implement a Custom Security Scheme (last update: 2/16/2010)

Application Development

How To Create an ADO.NET Data Access Utility Class for SQL Server (last update: 7/25/2013)
How to Use a Linked Server in a SQL Server Database Project (last update: 9/10/2014)

Azure

Using Azure Storage and Azure SQL Database for SSIS Development (last update: 2/28/2019)

Change Data Capture

How to Enable Change Tracking in a SQL Server Database Project (last update: 8/26/2014)
Process Change Data Capture in SQL Server Integration Services (last update: 5/20/2009)
Using Change Data Capture (CDC) in SQL Server 2008 (last update: 4/10/2008)

Database Mirroring

Simple Steps to Prepare Mirror Database for Mirroring in SQL Server (last update: 6/6/2012)

DevOps

Introduction to Team Foundation Server (TFS) Build for Business Intelligence (BI) Projects (last update: 4/23/2015)

Encryption

SQL Server 2008 Transparent Data Encryption getting started (last update: 6/6/2008)

Entity Framework

How to Implement Native SQL Server Queries with the Entity Framework (last update: 4/27/2010)
How to Use SQL Server DML Stored Procedures with the Entity Framework (last update: 3/26/2010)
How to Use SQL Server Views with the Entity Framework (last update: 4/22/2010)
Intro to Entity Framework with SQL Server (last update: 3/16/2010)

Express Edition

Introduction to SQL Server Express 2008 R2 (last update: 5/26/2010)

FILESTREAM

Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008 (last update: 5/1/2008)

Identities

SQL Server 2012 Sequence Numbers (last update: 3/29/2011)

Import and Export

Export Multiple SQL Tables to Text Files Using SSIS, Biml, and BCP (last update: 4/16/2019)

Integration Services Administration

Copy or Duplicate SQL Server Integration Services (SSIS) Environments using T-SQL (last update: 2/19/2019)

Integration Services Analysis Services Tasks

Analysis Services Processing Task in SQL Server Integration Services SSIS (last update: 8/12/2008)
Handle Early Arriving Facts in SQL Server Integration Services SSIS (last update: 3/3/2008)
Handle Slowly Changing Dimensions in SQL Server Integration Services (last update: 2/26/2008)
SQL Server Integration Services SSIS Analysis Services Execute DDL Task (last update: 8/7/2008)

Integration Services Configuration Options

How to Manage SSIS Packages Stored in Multiple SQL Server Database Instances (last update: 7/13/2010)
How To Support Multiple SQL Server Package Configurations in SSIS (last update: 8/8/2012)
SQL Server Integration Services SSIS Package Configuration (last update: 1/3/2008)
Using a SQL Server Alias for SSIS Package Configuration Database Connection String (last update: 8/10/2011)
Using XML Package Configurations with Integration Services SSIS (last update: 2/14/2008)

Integration Services Control Flow Transformations

Get List of Files from an FTP Server in SQL Server Integration Services (last update: 12/8/2008)

Integration Services Data Flow Transformations

How To Use the Unpivot Data Flow Transform in SQL Server Integration Services SSIS (last update: 5/28/2009)
Lookup and Cache Transforms in SQL Server Integration Services (last update: 6/3/2008)

Integration Services Development

How To Implement Batch Processing in SQL Server Integration Services SSIS (last update: 5/22/2008)
How To Use Transactions in SQL Server Integration Services SSIS (last update: 9/17/2008)
Integration Services Checkpoints to restart package from failure (last update: 1/9/2008)
Programmatically Drop and Recreate Foreign Keys with SSIS (last update: 8/5/2011)
SQL Server Integration Services Tutorial (last update: 5/17/2011)

Integration Services Error Handling

Custom Logging in SQL Server Integration Services SSIS (last update: 1/22/2008)

Integration Services Excel

Retrieve Excel Schema Using SQL Integration Services SSIS (last update: 1/27/2009)

Integration Services Execute Package Options

DTEXEC Command Line Parameters Using Command Files (last update: 8/10/2009)
How To Execute an Integration Services (SSIS) Package from a SQL Server Stored Procedure (last update: 7/2/2013)

Integration Services Oracle

Execute PLSQL Code in an Oracle Package from SSIS (last update: 3/5/2008)
Export SQL Server Data to Oracle using SSIS (last update: 5/18/2010)
Oracle Parameterized Queries in SQL Integration Services SSIS (last update: 7/6/2009)

Integration Services Security

Get Active Directory Users and Groups with SQL Server Integration Services (last update: 1/2/2009)
Securing Your SSIS Packages Using Package Protection Level (last update: 8/17/2010)

Monitoring

Introduction to Utility Control Points in SQL Server 2008 R2 (last update: 9/15/2010)
Storing Windows Performance Counter Values in SQL Server (last update: 5/26/2011)

Performance Point

Create a Member Selection Dashboard Filter in Performance Point Server 2007 (last update: 4/3/2008)
Creating a Scorecard in PerformancePoint Server 2007 (PPS) (last update: 3/26/2008)
Creating an Analytic Grid Report in Performance Point Server 2007 (last update: 3/19/2008)
Time Intelligence Post Formula Filter Template in Performance Point Server (last update: 9/11/2008)

Performance Tuning

How To Collect Performance Data With TYPEPERF.EXE (last update: 9/3/2008)
Introduction to SQLDIAG for SQL Server Performance Monitoring and Tuning (last update: 10/21/2009)
SQL Server Database Engine Tuning Advisor for Performance Tuning (last update: 11/3/2009)

Policy Based Management

Using Policy Based Management in SQL Server (last update: 5/6/2008)

PowerShell

PowerShell Support in SQL Server 2008 with the Invoke Sqlcmd Cmdlet (last update: 2/10/2009)

Reporting Services Administration

Remove a SQL Server Reporting Services Report from Cache Using RS.EXE (last update: 5/12/2008)

Reporting Services Analysis Services

Building Calculated Members for a SSRS Report using MDX (last update: 4/27/2011)

Reporting Services Charts

Getting Started with Data Bars in SQL Server 2008 R2 Reporting Services (last update: 12/22/2010)
Getting Started with Sparklines in SQL Server 2008 R2 Reporting Services (last update: 12/28/2010)

Reporting Services Configuration

How To Enable Caching in SQL Server Reporting Services (SSRS) (last update: 1/11/2010)

Reporting Services Data Sources

SQL Server 2008 R2 Reporting Services ATOM Data Feeds (last update: 10/19/2010)
Working with Report Snapshots in SQL Server Reporting Services SSRS (last update: 1/18/2010)

Reporting Services Development

How to launch an SSRS report in a browser window from a .NET application (last update: 8/12/2013)

Reporting Services Dynamic Reports

Creating Dynamic Report Filters in SQL Server Reporting Services SSRS (last update: 12/9/2009)
Dynamically Control Data Filtering in SQL Server Reporting Services Reports (last update: 5/4/2009)

Reporting Services Functions

SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions (last update: 3/13/2019)

Reporting Services Images

Rendering images from a database on SSRS reports (last update: 6/20/2013)

Reporting Services Maps

Maps in SQL Server 2008 R2 Reporting Services (last update: 11/29/2010)

Reporting Services Monitoring

Analyze Report Execution and Usage Statistics in SQL Server Reporting Services (last update: 12/24/2009)

Reporting Services Parameters

Customize Dropdown List in SQL Server Reporting Services Report using a SSAS Cube Data Source (last update: 4/19/2011)
Optimize Report Parameter Dropdowns in SQL Server Reporting Services (last update: 12/18/2009)

Reporting Services Report Builder

Getting Started with Report Builder 3.0 Shared Datasets (last update: 1/11/2011)
Getting Started with Report Parts in SQL Server Report Builder 3.0 (last update: 1/31/2011)
Introduction to SQL Server 2008 Report Builder 2.0 (last update: 2/18/2009)
SQL Server Report Builder Tutorial (last update: 7/12/2011)

Reporting Services SharePoint

Integrating SQL Server 2008 R2 Reporting Services with SharePoint 2010 (last update: 9/28/2010)

Reporting Services Subreports

SSRS Report Parts Versus Sub Reports FAQ (last update: 2/24/2011)
Working with a Parent Child Hierarchy in SQL Server Reporting Services SSRS (last update: 2/10/2010)

Reporting Services Tutorials

SQL Server Reporting Services Tutorial (last update: 5/24/2011)

Sharepoint

Best Practices for SharePoint Content Databases in SQL Server (last update: 1/22/2010)
Best Practices for SharePoint Search Databases (last update: 7/15/2009)
Configure Reporting Services to Run in SharePoint Integrated Mode (last update: 10/29/2008)
Getting Started with SharePoint Development and Visual Studio 2010 (last update: 2/24/2011)
How To Call a SharePoint Web Service from a SQL Server CLR Function (last update: 7/23/2008)
How To Migrate SharePoint 2007 My Sites Databases to SharePoint 2010 (last update: 5/3/2012)
Introduction to SharePoint 2010 for SQL Servers DBAs (last update: 2/2/2012)
Managing SharePoint Content Databases with Central Administration (last update: 2/23/2012)
Managing SharePoint Content Databases with PowerShell (last update: 2/8/2012)
New Book: SharePoint 2010 Business Intelligence (BI) Unleashed (last update: 6/22/2011)
SharePoint 2010 Databases Maintenance Health Analyzer Rules (last update: 3/21/2012)
Using a SharePoint List as a Data Source in SQL Server Reporting Services 2008 R2 (last update: 7/22/2010)

Stored Procedures

How To Return a Result Set from a SQL Server 2005 CLR Stored Procedure (last update: 6/12/2008)

Synonyms

Use Synonyms to Abstract the Location of SQL Server Database Objects (last update: 8/20/2009)

T-SQL

Introduction to Data Tier Applications in SQL Server 2008 R2 (last update: 8/27/2010)

Table Valued Parameters

Using Table Valued Parameters (TVP) in SQL Server (last update: 4/23/2008)

Testing

How to Setup Boot from VHD for a SQL Server test or development environment (last update: 3/15/2011)

Tools

Introduction to SQL Server Data Tools (last update: 11/6/2012)
SQL Server Data Tools Connected Database Development (last update: 12/6/2012)

Triggers

Maximum stored procedure, function, trigger or view nesting level exceeded limit 32 (last update: 3/23/2009)

XML

Replacing OPENXML with the XML nodes() Function in SQL Server (last update: 10/21/2008)

Tutorials DBA Dev BI Career Categories Webcasts Scripts Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Ray Barley

More SQL Server Solutions