This is because the encryption and decryption process in this case is manual. Further, due to encryption the value of the column attributes changes and therefore the data type of the column must be changed to varbinary and then recast back to the original value after decryption. the manual process means that none of the automatic techniques used by the SQL Server query optimizer will work.
Cell-level encryption has a number of advantages over the database level encryption provided by TDE in that the encryption is more granular and that data is not decrypted until used.
It can be useful for a targeted security environment.
however, the burden of extensible key management for the administrator is a distinct disadvantage. The greatest disadvantage of cell-level encryption on SQL Server optimization is in the high performance penalty and the cost of administration. Even query optimization is affected as indexes on encrypted columns offer no benefit.
Learn more about Database Management and SQL server database at => http://www.whatisdatabasemanagement.com SQL Server Optimization and the Performance Impact of Encryption
I have an Excel spreadsheet with data such as name, phone, a quotation value etc. I would like to place a button into the spreadsheet, that I can click on, which would automatically open a Word Document with a pre-made template, and populate the name, phone, e-mail (address block area), as well as the quotation value and any other data that I may find important. This would be similar to a mail merge, except the spreadsheet only has 1 person's data.
by michael @ October 25, 2007 11:07 pm
yes, or you can import the entire thing. depends on how much of the data you have to add to properly present what you are stating.
I have a quotation template. I want to create auto quote creator.
Somewhere people input their info on a form and the php will input those into excel and pdf it.
any idea?
many thanks..
by Gitlez @ February 7, 2011 10:18 pm
Search for php excel tutorials, and php pdf tutorials. There are tons of them. Some of which will even be about the exact system you are trying to create. Cheers and good luck.
I need to keep track of my expenses, especially as I'm having building work done so need to keep track of all expenditure incl method of payment - eg, Cash, Internet Banking etc.
I am totally useless with figures and MS Excel is way way way past my abilities.
So therefore I need a free software program that comes as simple as it can.
Also, looking for software that I can use to design, print, copy etc personal business stationary templates such as for Client Quotes and Invoices / and customizable as well - as in, when I quote, I like to give a detailed itemized quote.
by Connie M @ June 19, 2007 3:58 pm
Well, the obvious answer is Quickbooks by Intuit. Everything mentioned above - including Client Quotes and Templates - part of the Quickbooks package.
I am trying to build a template for quotations to customers. I have Workbooks titled Customers, with all of their info. My problem is that I need a cell that will allow me to go to that workbook and choose the customer and retrieve all of their info: name, address, phone, etc. I don't know if I need to format it in a special way. Currently each customer takes up one row, with the columns being their info. I need to retrieve it in a more traditional manner, so as to have it look like the address info on an envelope rather than all onone long line. This may be better done on Word, but I am not sure. The main advantage to using Excel is that I can actually calculate margins and such. All help will be great. Also I apologize if I've confused anybody.
by mod_fundraiser @ August 7, 2007 1:35 pm
Go to File then New... select general templates and take a look at the templates, there is probably one there that suits your needs and can be modified for the specifics. The Sales template might be close. Also there are several good templates available for download from microsoft's website for free. Those are probably you two simplest options. You may also wish to be sure your forms toolbar is turned on (View >> Toolbars >> Forms)
Pages: 1 2 3