Showing posts with label module. Show all posts
Showing posts with label module. Show all posts

Monday, March 12, 2012

Interactive Reporting

Software packages like Microsoft Small Business Accounting and Quickbooks offer a very powerful reporting module that lets end users change grouping, filtering, sorting, etc at run time (having it change the report dynamically infront of them). More importantly, their reporting tools let users click on details on the reports which opens the data in the form based portion of their software.

For example: If the end user pulls up a financial report, lets say "All Bills for February 07", the user get a report of all the bills that have gone out in that time frame. The end user can then click on the actual details in the report, and the Bill will come up in the Windows Forms portion of their software so they edit the bill, or create a new bill.

I have done a very limited amount of reporting in SQL Server, so I am not sure of how they were able to achieve this. If someone could give me some key words or ideas that I can bring up more information from in google, or even on here, I'd appreciate it.

Thanks in advance!

Have you taken a look at Report Builder yet?

Jarret

|||

Possibly... I will have to look that term up shortly to see what it actually is. So far I have just gone through visual studio biz intelligence projects and created new reporting projects. Ive done the wizards, created them manually, but I havent seen any kind of options to set that would actually let an end user interact with the report directly.

Wednesday, March 7, 2012

Integration Services?

Hi,

is Integration Services included in SQL Server Express?

In what version/module?

Thanks

just Do It

http://msdn2.microsoft.com/en-us/library/ms165636(SQL.90).aspx

The following list highlights the major SQL Server 2005 components that are not supported in SQL Server Express:

... Integration Services...

HTH

Sunday, February 19, 2012

Integrating Hardware Security Module (HSM) for Cryptographic Key storage with SQL Server

Hi,

I have come to know from the SQL Server documentation that the Hardware Security Modules (HSM) can be used for Cryptographic Key storage within SQL Server to increase the level of protection of data at rest. We provide a HSM Solution which protects cryptographic keys and performs cryptographic operations onboard. The aforesaid fact about SQL Server and HSMs motivates us to test our HSM product with the SQL Server. Our HSM solution provides SDK for applications/servers to communicate with the HSM hardware. The SDK basically consists of two libraries:

-MS CAPI Interface (CSP Library)

-PKCS#11 Interface (cryptoki Library)

I have found this forum best for such kind of discussion. So could you guys on the list let me know:

- How the CSP or PKCS#11 library can be integrated with the SQL Server for HSM box to protect the cryptographic keys?

- Would I need to write a new Interface/Wrapper for this integration, If yes please help?

Thanks in advance.

Harsh.

hi harsh,

We cant do it in SQL Server 2005 as it dosn't support third party CSP. Infact i also want to store my Private key in HSM. I tried but there is no help available from SQL Server 2008 Documents regarding integration of SQL Server with HSM. I would also appraciate if there is some form of document available for Integration. Can anyone from Microsoft SQL Server team help ?

Regards,

Bansal.

|||

Wanni is correct: you cannot do this in SQL Server 2005. For discussions and suggestions for future SQL Server versions, you can visit the SQL Server Katmai Security forum.

Thanks

Laurentiu