MSSQLTips Author Profile - Ray Barley

join the MSSQLTips community


Today's Site Sponsor

	SQL Compare quickly and easily compares and synchronizes SQL Server database schemas

Today's Tip Tips By Category Latest Tips Top 10 Tips Suggest a Tip Search By Tip ID

Tools Tutorials Webcasts Whitepapers Blogs Forums Forums - Active Forums - Unanswered RSS Feeds

Join MSSQLTips Authors Contribute Giveaways Feedback User Groups Follow us on Twitter Follow us on LinkedIn

About Us Advertise Copyright Disclaimer Feedback Privacy Statement

Search By Tip ID Search By Category

Author - Ray Barley
	Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com).

Analysis Services

Building Integrated SQL Server Business Intelligence (BI) Solutions with Microsoft Office 2007 (3/26/2009)
Dimension Security Stored Procedures in SQL Server Analysis Services SSAS 2005 (9/24/2009)
Handling Weeks that Overlap Years in a Date Dimension in a SQL Server Data Warehouse (1/29/2008)
How To Build a Cube From an Existing Data Source Using SQL Server Analysis Services (7/2/2008)
How To Build a Cube Without a Data Source Using SQL Server Analysis Services (6/27/2008)
How To Define Measure Group Partitions in SQL Server Analysis Services (SSAS) 2005 (7/28/2008)
How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS) (6/16/2009)
How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005 (8/15/2008)
Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005 (9/10/2009)
Using a Parent Child Hierarchy in SQL Server to Implement a Custom Security Scheme (2/16/2010)
Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis (3/13/2008)
Using the SQL Server Analysis Services (SSAS) Deployment Wizard (11/18/2009)

Common Language Runtime (CLR)

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

Encryption

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

Entity Framework

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

FILESTREAM

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

Performance Point

Performance Tuning

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

Policy Based Management

Using Policy-Based Management in SQL Server 2008 (5/6/2008)

PowerShell

PowerShell Support in SQL Server 2008 - Invoke-Sqlcmd Cmdlet (2/10/2009)

Reporting Services

Creating Dynamic Report Filters in SQL Server Reporting Services (SSRS) (12/9/2009)
Dynamically Control Data Filtering in SQL Server Reporting Services Reports (5/4/2009)
How to Analyze Report Execution and Usage Statistics in SQL Server Reporting Services (SSRS) 2005 (12/24/2009)
How To Enable Caching in SQL Server Reporting Services (SSRS) (1/11/2010)
How to Optimize Report Parameter Dropdowns in SQL Server Reporting Services (SSRS) 2005 (12/18/2009)
How To Remove a SQL Server Reporting Services (SSRS) Report from Cache Using RS.EXE (5/12/2008)
Introduction to SQL Server 2008 Report Builder 2.0 (2/18/2009)
Using a SharePoint List as a Data Source in SQL Server Reporting Services 2008 R2 (7/22/2010)
Working with a Parent-Child Hierarchy in SQL Server Reporting Services (SSRS) (2/10/2010)
Working with Report Snapshots in SQL Server Reporting Services (SSRS) (1/18/2010)

Sharepoint

Best Practices for SharePoint Content Databases in SQL Server (6/22/2009)
Best Practices for SharePoint Search Databases (7/15/2009)
How To Call a SharePoint Web Service from a SQL Server CLR Function (7/23/2008)
How To Configure SQL Server Reporting Services 2005 to Run in SharePoint Integrated Mode (10/29/2008)

SQL Server 2008

How To Process Change Data Capture (CDC) in SQL Server Integration Services SSIS 2008 (5/20/2009)
Using Change Data Capture (CDC) in SQL Server 2008 (4/10/2008)
Using Table-Valued Parameters (TVP) in SQL Server 2008 (4/23/2008)
Using the SQL 2008 Lookup and Cache Transforms in a SQL Server Integration Services (SSIS) Package (6/3/2008)

SQL Server 2008 R2

Introduction to Data-Tier Applications in SQL Server 2008 R2 (8/27/2010)
Introduction to SQL Server Express 2008 R2 (5/26/2010)

SQL Server Integration Services

T-SQL

How to Use Synonyms to Abstract the Location of Database Objects in SQL Server (8/20/2009)

Triggers

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

XML

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

Sponsor Information

Free SQL Server performance monitoring dashboard – Idera SQL check

Free trial: Red Gate SQL Response for no-nonsense monitoring & alerting of SQL Server health & activity. Download now.

We fill in the gaps... SQL Server Training, Development, Performance Tuning, SSIS and more

Win a FREE trip to SQL PASS! All expenses paid!

Valuable SQL Server web casts on Performance Tuning, Development, Administration, Disaster Recovery, Replication and more...

Idera - SQL diagnostic manager

Idera SQL diagnostic manager is an award-winning performance monitoring solution for SQL Server that provides agent-less, real-time monitoring, customizable alerting, and extensive historical reporting. SQL diagnostic manager also puts must-have troubleshooting information at the DBA’s fingertips such as worst-performing code, long-running or frequently run queries, and blocking or blocked sessions.

Download now!

More SQL Server Tools

SQL diagnostic manager

SQL compliance manager

SQL comparison toolset

SQL Refactor

SQL Prompt

Copyright (c) 2006-2010 Edgewood Solutions, LLC All rights reserved
privacy statement | disclaimer | copyright | advertise | write for mssqltips | feedback | about
Some names and products listed are the registered trademarks of their respective owners.

CareerQandA.com | MSSharePointTips.com | MSSQLTips.com