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
2010 Awards
2009 Awards
2008 Awards
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 Design
- Microsoft SQL Server Data Warehouse Data Quality, Cleansing, Verification and Matching (last update: 7/29/2021)
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 Sequence Numbers (last update: 4/17/2021)
Import and Export
- Custom SQL Server Change Tracking Example (last update: 4/8/2020)
- 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 (last update: 8/12/2008)
- Handle Early Arriving Facts in SQL Server Integration Services (last update: 3/3/2008)
- Handle Slowly Changing Dimensions in SQL Server Integration Services (last update: 2/26/2008)
- SQL Server Integration Services 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 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 (last update: 5/22/2008)
- How To Use Transactions in SQL Server Integration Services (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)
Integration Services Error Handling
- Custom Logging in SQL Server Integration Services (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)
- Execute SSIS Package from Stored Procedure in SQL Server (last update: 8/19/2020)
- How To Execute an Integration Services Package from a SQL Server Stored Procedure (last update: 7/2/2013)
- How to Execute SSIS Packages from SQL Server Agent (last update: 11/25/2020)
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 (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 (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 (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)
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 (last update: 2/10/2010)
SharePoint
- 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 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)
SharePoint Administration
- Managing SharePoint Content Databases with Central Administration (last update: 2/23/2012)
SharePoint Configuration
- Best Practices for SharePoint Content Databases in SQL Server (last update: 1/22/2010)
SQL Server Agent
- Build an Incremental ETL Process for a SQL Server Agent Data Mart (last update: 11/16/2020)
- How to Maintain State in a SQL Server Agent Job (last update: 3/12/2020)
- Monitor SQL Server Agent Job Activity with Power BI (last update: 10/15/2020)
- Run SQL Server Agent Job from SSIS (last update: 5/11/2020)
- SQL Agent Job Dependencies with Table Driven Solution (last update: 3/30/2020)
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
- How to Use SQL Server Coalesce to Work with NULL Values (last update: 6/25/2020)
- 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)
