|
|
|
|
|
Total Hits: 229 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
There are a plethora of steps one can take to harden their data-drive applications from malicious hackers. The first and most important step is to harden your database software. Do you have the latest service packs installed? If you're using Microsoft SQL Server, have you chosen a sufficiently complex password for the sa account? Is your database configured only to accept Windows authentication? For more information on improving your database's security see 10 Steps to Help Secure SQL Server 200...
|
|
|
|
Total Hits: 1833 | Today: 1
|
|
Rating:
|
|
This step-by-step article demonstrates how to install a certificate on a that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients....
|
|
|
|
Total Hits: 7 | Today: 0
|
Author: Ken Spencer
|
Rating:
|
|
I have lots of experience developing ASP applications that use Visual J++® components wrapped in COM running in Microsoft® Transaction Services (MTS). I am currently developing an application with the Microsoft .NET Framework and have written several classes that perform the bulk of my data access. I then use these classes in my ASPX pages. This application will have as many as 10,000 concurrent users....
|
|
|
|
Total Hits: 20 | Today: 0
|
Author: Tim Cullen
|
Rating:
|
|
I need to encrypt data in my SQL Server 2005 database and currently have a Database Master Key and Certificate installed. Can I encrypt using only a certificate? The answer is "yes". Symmetric and asymmetric keys are not required for the encryption/decryption process, although they do add another layer of security to the mix. When deciding on an encryption/decryption process, you must think about who needs to see what data. If there are different levels of security needed then multiple certifica...
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Tim Cullen
|
Rating:
|
|
I recently accepted the challenge of designing a database for an employee application, and the first thought to cross my mind was," I will need to encrypt at least one piece of data". Along with SQL Server 2005 came the native ability to encrypt data in the database. Prior versions depended on third-party tools or encryption via the front end application. In this four-tip series we will cover the objects needed and steps required to encrypt data using SQL Server 2005:
* Database Master Ke...
|
|
|
|
Total Hits: 30 | Today: 0
|
Author: Tim Cullen
|
Rating:
|
|
I have a Database Master Key created in the database. Can I start encrypting data in my database now? The answer is "not yet". A Database Master Key per se' cannot encrypt data. You either need another key or a certificate. In this second tip of a four-part series we'll cover all things Certificates.
NOTE - For the first tip in these series, please reference - Managing SQL Server 2005 Master Keys for Encryption....
|
|
|
|
Total Hits: 31 | Today: 1
|
Author: David Banister
|
Rating:
|
|
Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are difficult to debug and maintain. Is there a better way? In fact, regular expressions provide a much more efficient and elegant solution. It is easy to see how they would be helpful for comparing text to identify recor...
|
|
|
|
|
|
