493 reputation
411
bio website Loadedduck.blogspot.com
location Maryland
age 45
visits member for 3 years, 3 months
seen Nov 2 '12 at 13:58

BS Mechanical Engineering; lead architect and developer with systems engineering experience, C#, Perl, ColdFusion, Oracle (SQL, PL/SQL), SSAS, web and windows experience.


Jan
3
awarded  Yearling
Oct
9
awarded  Notable Question
Jun
28
awarded  Taxonomist
Feb
6
awarded  Popular Question
Jan
3
awarded  Yearling
Aug
12
comment SSAS Dimensions Hierarchy causes deployment errors
Great explanation - thanks!
Aug
1
comment SSAS Dimensions Hierarchy causes deployment errors
@Kenneth I agree, "As I said, this doesn't SOLVE the issue...", I'd love to hear your thoughts on identifing the cause and what the solution might be.
May
2
comment SSAS Dimensions Hierarchy causes deployment errors
@gbn there's a proposed edit? I don't see one either on my answer, the original question or the comments. Just curious to what you are referring.
Mar
25
comment Index vs. partition
Instead of thinking of indexing and partitioning as either-or solutions for performance improvement, you should be thinking of both as tools that can be used separately or in conjunction to achieve performance improvements in your database.
Mar
4
comment Is polling the only way for updating app's data from a database?
well said. After reading your DBMS_ALERT answer, I learned another way of doing this - more tools for the toolbox! +1
Mar
4
awarded  Editor
Mar
4
revised Is polling the only way for updating app's data from a database?
added 64 characters in body
Mar
4
answered Is polling the only way for updating app's data from a database?
Mar
3
comment SSAS Dimensions Hierarchy causes deployment errors
@Lumpy - glad to hear it, just remember to watch those logs to make sure you aren't allowing meaningful errors to fall through the cracks.
Mar
3
comment Multiple Oracle Instances — is this a good practice?
Thanks much @BillThor
Mar
2
comment Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?
I really do not understand why Microsoft isn't able to fix this issue? For the same reason Microsoft stopped supporting the dotnet framework Oracle client library - "other people do it better", if I ruthlessly paraphrase their responses in the past. No love lost between those two, I tell you.
Mar
2
comment Multiple Oracle Instances — is this a good practice?
Can you provide examples where its necessary to run multiple instances?
Mar
2
comment What database front end do you use?
+1 because its the only response, so far, that supports multiple RDBMS's. That being said, I don't like it compared with other commercial solutions like PL/SQL Developer and TOAD (which, admitedly, only work with Oracle).
Mar
2
answered SSAS Dimensions Hierarchy causes deployment errors
Mar
2
answered How do I stop refresh conflicts between Proactive Caching of facts and timed refresh of Dimensions in a SQL Server Analysis Service 2005 OLAP cube?