Monday, September 19, 2005

Migrating Existing Analysis Services Databases

Migrating Existing Analysis Services Databases

Upgrading or Migrating Analysis Services

Upgrading or Migrating Analysis Services

Wednesday, September 14, 2005

MSMVPs.com Weblogs

MS MVPs weblogs - big list

Captain LoadTest

Captain LoadTest: "Question number two asks the candidate to list the types of testing with which s/he has experience. This reply included integration testing (also stated in his resume, correctly spelled). My follow-up asked him to define integration testing; a common ploy to make sure I�m not just being fed buzz-words. It was a definition he could not supply, or even attempt.
A candidate should be able to define every �word� he claims experience with. If you can not define it you obviously do not have enough experience in it to make it applicable. If you can not define �integration testing�, I will not hold it against you providing you do not list experience in it. Similarly, if you do not list it, and I ask you what you know about it, be straight; tell me straight-up that you cannot define it. You will rate higher in my book than someone who stumbles through an obviously concocted and blatantly incorrect response."

Amazon.com: Books: Expert .NET Delivery Using NAnt and CruiseControl.NET

Tom Hollander's blog : Instrumentation in Enterprise Library

a href="http://blogs.msdn.com/tomholl/archive/2005/02/18/376187.aspx">Turning off event logging & perf counters in App Blocks.<

Friday, August 26, 2005

MSSQL Server Reporting Services: Mastering OLAP Reporting: Extending Conditional Formatting: SWITCH and Drilldown Defaults

MSSQL Server Reporting Services: Mastering OLAP Reporting: Extending Conditional Formatting: SWITCH and Drilldown Defaults

Bait & SWITCH()

MSSQL Server Reporting Services : Black Belt Components: Manage Nulls in OLAP Reports

http://www.databasejournal.com/features/mssql/article.php/3436441

This article is a member of the series MSSQL Server 2000 Reporting Services. The series is designed to introduce MSSQL Server 2000 Reporting Services ("Reporting Services"), with the objective of presenting an overview of its features, together with many tips and techniques for real-world use. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting.

Basic assumptions underlying the series are that...

Thursday, August 18, 2005

Sample asp page for OLAP

&#10 &#10 9.0.0.3821 &#10 &#10 &#10'>


<% set rsProject = nothing

set comPS = nothing

set prmPS = nothing

set conPS = nothing %>

Thursday, July 14, 2005

Tuesday, April 19, 2005

cool stuff - stored proc resultset queries

This command allows you to link to the local SQL Server & select individual columns from a stored procedure

sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = @@servername
GO

select * from openquery(localserver,'exec mystoredproc')
GO

Great for comparing the results of 2 stored procedures, or doing union queries against multiple stored procedures without temp tables.

http://www.sommarskog.se/share_data.html

Wednesday, March 09, 2005

Reporting Services companies

One of the things the company I work for specializes in is Reporting Services deployments.

Here's a list of some companies with add-ons for RS.

Cizer
Capricorn Software, LTD
Central Information Systems
Groeneveld Management Services BV
The Henson Group
JM Consulting
Microsoft
Northwest Training Systems, Inc.">
NxTrend
ReportsTrader.com
Tridec
ZAPTECH
Other