Viewing 15 posts - 16 through 30 (of 31 total)
It's important to log into the machine as the account that starts SQL Server before you configure any mail.
Also, there used to be an issue with NT and SQL Server...
March 3, 2004 at 7:20 am
I do BI for a living and I agree with bnordber. The users are the best source of naming conventions for BI deliverables. I've also found that different user groups...
February 18, 2004 at 12:58 pm
How about a cursor-driven "SELECT TOP 1000 * INTO..." statement. You could script the source DB, remove the CREATE TABLE statements, run the cursor code then use the script to...
February 12, 2004 at 4:55 am
There's a small book from Cognos called "The Multidimensional Manager" that give a good, non-technical overview of OLAP. The book is really a sales tool (I'm a Cognos partner), but...
November 4, 2003 at 8:21 am
Sometimes the decision is made for you. If you need to track Type 2 slowly changing dimensions, then surrogate keys are required. To get "current" data, create and index on...
October 14, 2003 at 7:02 am
I recommend Cognos products to my clients if they don't want to deal with Crystal. The whole report development/distribution process is much more intuitive.
Don
July 10, 2003 at 6:15 am
Saari,
From what I can tell here, personal attacks and name calling are normally frowned upon. We all come here to share information, and hopefully learn something.
I'm currently evaluating Crystal as...
January 7, 2003 at 9:47 am
Scorpion, thanks for the great explanation. I also have converted DTS packages to BCP. Not only is it a little faster, but I hate the "black box" of DTS.
You mentioned...
December 31, 2002 at 2:39 pm
Is Active Reports the software produced by Data Dynamics? If so, it looks like something worth checking out.
Don
Don
December 31, 2002 at 9:13 am
As an aside, can anyone explain why someone would require a stored procedure when it's so easy to use DTS? Could it be portability?
Don
December 31, 2002 at 6:10 am
I'm a little prejudiced as a reseller, but Cognos has two tools that report well off of SQL Server. One is an OLAP tool called PowerPlay. The other, called Impromptu,...
December 31, 2002 at 5:42 am
Check out "Disconnected Edit" in Enterprise Manager. I haven't used it, but many properties are exposed.
Don
September 26, 2002 at 3:23 am
That sounds like a good idea. I'm a little weak in VBScript, though. Can you give an example?
Don
September 16, 2002 at 6:17 am
That sounds like a good idea. I'm a little weak in VBScript, though. Can you give an example?
Don
September 16, 2002 at 6:16 am
Viewing 15 posts - 16 through 30 (of 31 total)