Top 10 SQL Resources on the Web

The other day I was talking to a guy who is just starting out his SQL career.  He asked what are my favorite web sites for SQL Server are.  I mentioned a few, but I got thinking about it and decided to come up with my official list …as of now….tomorrow things will probably change.

[...]

Error Opening Cognos 8 Framework again…

I went to open a frame work on our development server today and I got the following error:

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

The same thing had happened earlier this year. The same thing worked to fix it. If you’ve only got one environment, [...]

RSS feed in Report Studio – ITtoolbox Groups

RSS feed in Report Studio – ITtoolbox Groups: “RSS feed in Report Studio” – I need to keep my eye on this one because adding RSS to the mix would be very powerful.

Creating a RSS Channel to Inform Users When Cubes are Refreshed: Supportlink

Creating a RSS Channel to Inform Users When Cubes are Refreshed: Supportlink: “Creating a RSS Channel to Inform Users When Cubes are Refreshed”

Download details: Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Download details: Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables: “Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTablesBrief DescriptionThis document outlines how to improve the end-user experience by optimizing the cube design for Microsoft Office Excel 2007 PivotTable dynamic views.”

WinSQL

Here's the tool I use to query and update the AS400 database.  It's called WinSQL – Download the latest greatest version of the lite version and open it up.  It will ask you to register, do that – they will send you an email to activate it.  Then all you need to do is set [...]