SQLShare - Public Profile for Robert Cain

Member for 545 days

Robert Cain (Author)

Sr. BI Architect

http://arcanecode.com

Robert C. Cain is a Microsoft MVP in SQL Development, and works as a Senior BI Architect for ComFrame. His main responsibility is the SQL Server Business Intelligence Data Warehouse for the NASA ARES project. He is also a contributing author to the book "SQL Server MVP Deep Dives". Prior to his current position, Robert spent five years working for a south eastern nuclear power company designing and developing the BI/Data Warehouse as well as leading the development team. Robert also spent 10 years as a senior consultant, working for a variety of customers in the Birmingham area using Visual Basic and C#. He maintains the popular blog http://arcanecode.com .

Report Card

Questions Attempted:	0
Correct Answers:	0
Current Score:	0.00%

Videos I've made

Title	Published Date
Useful Sql Server Full Text Search System Views	11/7/2008
Customizing the Full Text Search Thesaurus	11/6/2008
Customizing Stop Word and Stop Lists in Full Text Indexes	11/6/2008
Installing SQL Server Full Text Search	11/6/2008
Creating a Full Text Search Catalog	11/6/2008
Altering SQL Server Full Text Catalogs	11/6/2008
Creating a Full Text Search Index	11/6/2008
Valid Data Types of Full Text Search Indexes	11/6/2008
Maintaining Full Text Indexes in SQL Server	11/6/2008
Querying Full Text Indexes Using the Contains Method	11/6/2008
Querying Full Text Indexes Using the FreeText method	11/6/2008
Querying Full Text Indexes Using the FormsOf method	11/6/2008
Enhancing Searching of Full Text Indexes	11/6/2008
Ordering Full Text Index Search Results by Relevance	11/6/2008

Videos I've watched

Title	When Watched
Data Profiling in SSIS	1/29/2009
Parameterizing the Execute SQL Task in SSIS	1/29/2009
Left Join Operators	1/29/2009
What is a Scalar UDF?	1/29/2009
What is a Clustered Index Scan?	1/15/2009
SQL Server Table Scans	1/15/2009
What is an Index Scan?	1/15/2009
What is a Clustered Index Seek?	1/15/2009
What is an Identity Gap?	1/15/2009
Using Excel 2007 with Analysis Services	1/15/2009
Adding a SQL Login to SQL Server	1/15/2009
Creating a Basic SSAS Cube	1/15/2009
Creating a database project with Team Edition for Database Professionals	1/10/2009
Performing Updates with Common Table Expressions (CTE)	1/10/2009
Aggregrate Queries in SQL Server T-SQL for Beginners	1/10/2009
Looping Through and Loading Files with SSIS	11/23/2008
SSIS Configurations	11/23/2008
Introduction to Data Warehousing Part 2 - DW Tables	11/23/2008
Introduction to Data Warehousing Part 1	11/23/2008
Designing A Data Warehouse: Part 1 Dimension Types	11/23/2008
Demo of Visual Studio Team Edition for Database Professionals	11/17/2008
Using SQL Server 2005 Profiler	11/17/2008
Creating a Full Text Search Index	11/11/2008
Installing SQL Server Full Text Search	11/11/2008

My Playlists