Guest Columnist: Robert Pearl

The Database Recovery Advisor in SQL Server 2012 will aid the ability of DBAs to recover their databases to a point in time in a crisis. Read about this new feature and how it can speed the process of recovery.  Read more...

Robert Pearl brings us a few more potential SQL Server 2008 installation issues on Windows 7 and a few workarounds that might help you get around them.  Read more...

MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.  Read more...

Today we have a guest editorial from Robert Pearl that talks about the SQL Server community, and how you can get involved.  Read more...

After a great presentation from Brian Knight at the NYC User Group, Robert Pearl summarizes some information about SSAS and when it makes sense to use this subsystem. And why you might want to attend that next user group meeting.  Read more...

It seems that the ownership of jobs is something that is often overlooked when articles explain   Read more...

What do you do when you run an SSIS package and it works, but it fails when scheduled? You might have a credential problem. Robert Pearl brings us a solution to a cryptic message that prevents you from scheduling a package.  Read more...

Continuing the interview with Brad McGehee, Robert Pearl asks about the new features in 2008 and his books.  Read more...

MVP Brad McGehee, director of DBA Education for Red Gate Software, sat down recently with longtime author, Robert Pearl. In this interview, learn a bit about how Brad got started in the SQL Server world.  Read more...

One of the ways that some companies deal with the lack of a DBA is with remote DBA services or perhaps part time consulting. Robert Pearl brings us a short article explaining what these services can do for you.  Read more...

Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.  Read more...

An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.  Read more...

Service Pack 2 for SQL Server 2005 has had a few issues and one of the big ones is maintenance plans. Longtime DBA and developer Robert Pearl, of Pearl Knowledge Solutions brings us a fix for your maintenance plans.   Read more...

Are you considering upgrading from SQL Server 2000 to SQL Server 2005? Are you using Full-Text Search? One of the top SQL Server consultants in New York walks us through an interesting issue that you might want to consider before migrating your databases.   Read more...

With the release of SQL Server 2005, the paradigm of working with this database changed. Robert Pearl brings us a book review of the highly acclaimed book from one of the premier SQL Server consulting companies in the US: Scalability Experts.   Read more...

Continuing on an interview with Raj Gill, SQL Server 2005 Roadshow Presenter by Robert Pearl. Get inside the mind of the co-founder of Scalability Experts.   Read more...

An interesting interview with Raj Gill, SQL Server 2005 Roadshow Presenter by Robert Pearl. Get inside the mind of the co-founder of Scalability Experts.   Read more...

If you have not had the chance to work with SQL Server 2005, or even if you have, Robert Pearl brings us some important information about what your upgrade or installation of the next version of SQL Server will bring. This is information every administrator needs to know to get prepared.   Read more...

Ongoing now, the SQL Server 2005 Roadshows in conjunction with PASS. Read Robert Pearl's notes from the show and if you are in Dallas or Houston or Europe, there is still time to attend on of these events.   Read more...

Robert Pearl of Pearl Knowledge Solutions, Inc., recently attended a meeting of the NY Database Professionals Council where SQL Server Analysis Services 2005 was a large part of the topic of conversation. Read his report on the push to move business intelligence into the mainstream.   Read more...