Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coxmg
Starting Member
16 Posts |
 Posted - 2012-10-23 : 11:09:28
|
| Hi, what do you guys think is the best way for a user to access financial data that is stored in SQL Server? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-10-23 : 11:21:44
|
you mean legally, or are you asking for attack vectors?Come on -- there is no information in this post that would let us answer that question.....Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
 |
|
|
coxmg
Starting Member
16 Posts |
Posted - 2012-10-23 : 11:26:23
|
| No, I just mean this in general, for example the most convenient way, for example .NET sites, reporting tools such as Crystal, just an opinion question. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-10-23 : 11:41:45
|
well in more detail it completely depends on the use case -- a data warehouse using cubes and ssrs or excel drivers....?To answer the question adequately we'd need to know:1) What does your data look like -- how much, what you are tracking, etc2) What do you want to do with it -- what kind of reports, what kind of analysis -- real time or offline analysis - etc.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
|
|
|
coxmg
Starting Member
16 Posts |
Posted - 2012-10-23 : 11:48:30
|
| Thanks for the follow-up. It would be financial data on companies, like from Bloomberg, its not that large of an amount of data, probably between 10,000 and 500,000 rows and below 100 megs of data. It would be for financial analysts to perform some financial analysis. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-10-23 : 12:01:33
|
so are you looking for a tool that does trend analysis etc? "It would be for financial analysts to perform some financial analysis."Cover's a lot of ground! If you want to do business analysis type reporting maybe look into SSAS --http://msdn.microsoft.com/en-us/library/ms175609(v=sql.90).aspxI think it's actually part of the standard stack from 2012 onwards -- I don't have all that much experience with the BI side. Others on this site are real experts though.good luck. Keep adding details to your requirements and someone will help you.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
|
|
|
|
|
|
|
|
Best way to access SQL Server data