Robert Sheldon Robert Sheldon
After being dropped 35 feet from a helicopter and spending the next year recovering, Robert Sheldon left the Colorado Rockies and emergency rescue work to pursue safer and less painful interests—thus his entry into the world of technology. He is now a technical consultant and the author of numerous books, articles, and training material related to Microsoft Windows, various relational database management systems, and business intelligence design and implementation. He has also written news stories, feature articles, restaurant reviews, legal summaries, and the novel 'Dancing the River Lightly'. You can find more information at http://www.rhsheldon.com.
Understanding Full-Text Indexing in SQL Server
by Robert Sheldon | 29 December 2008 |  1 comment |
Microsoft has quietly been improving full-text indexing in SQL Server. It is time to take a good look at what it offers. Who better to give us that look than Robert Sheldon, in the first of a series. Read more...
SQL Server Index Basics
by Robert Sheldon | 25 November 2008 |  24 comments |
Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to... Read more...
SQL Server Data Warehouse Cribsheet
by Robert Sheldon | 03 November 2008 |  4 comments |
It is time to shed light on Data Warehousing and to explain how SSAS, SSRS and Business Intelligence fit into the puzzle. Who better to explain it all then Robert Sheldon. Read more...
Using Powershell to Generate Table-Creation Scripts
by Robert Sheldon | 04 October 2008 |  11 comments |
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He... Read more...
SQL Server 2008- SSIS Data Profiling task
by Robert Sheldon | 10 September 2008 |  1 comment |
By using SQL Server 2008’s new Data Profiling task, you can do a lot to ensure that data being imported via SSIS is valid, and you can develop a system that can take the necessary steps to correct the commonest problems. Bob Sheldon shows you how to get started with it Read more...
SQL Server 2008 SSIS Cribsheet
by Robert Sheldon | 05 August 2008 |  10 comments |
SSIS has achieved several new and interesting features in SQL Server 2008. And who better to guide you through them and explain them but Robert Sheldon. Read more...
Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk