Security Squad: Database security- encryption Episode23 min 51 sec
Information Security magazine editors Neil Roiter and Michael Mimoso discuss Google's foray into the security market and whether companies should turn to database encryption to meet the PCI Data Security Standard in the wake of the TJX data security breach. Also the editors discuss whether the "month of" security flaw Web sites are helpful in securing software or just shameless publicity by security researchers. And finally, SearchSecurity.com News Writer Bill Brenner provides analysis from the Gartner IT Security Summit in Washington.
Listen to the Podcast
|
Using Index Intersection to Boost SQL Server Performance
First introduced in SQL Server 7.0, and of course available with SQL Server 2000, Index Intersection gives you new options for creating indexes on tables in order to maximize performance.
Read the Article
|
Optimizing SQL Server Performance Using Files and Filegroups
Each database consists of at least two files: one is a primary data file (by default, with the .mdf extension), the other is a log file (by default, with the .ldf extension). There are also optional secondary data files (by default, with the .ndf extension).
Read the Article
|
Speeding UPDATEs Using the CASE Statement
One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation. By doing this, some transactions can be shorted, and performance boosted.
Read the Article
|
Test Your Knowledge of SQL Server Performance Tuning
After each question is the answer, along with an explanation of why it is the correct answer. Also on each page will be a running total of the number of questions you got right, so you can keep track of how well you have done. Be sure you don't click on the Back button on your browser. If you do, the counter will not keep accurate track of your correct answers, and you will have to do so manually, yourself.
Read the Article
|
Save Space To Boost SQL Server Performance
If you have ever looked at an Execution Plan for a SQL Server query (and if you haven't, you should!) you will see that SQL Server produces an estimated "cost" for executing queries. This cost is not in money terms, obviously, but in terms of computer resources required to run the query. The primary component of this costing is disk I/O, so it stands to reason that if we can reduce disk I/O, then we reduce the cost of executing a query, and therefore increase performance. In this article we will look at a few ways of doing this.
Read the Article
|
Upgrade to SQL Server 2000 SP1 for Improved Performance
All service packs includes numerous fixes to resolve various problems that Microsoft has found since the initial release of the product, and the recent release of SP1 for SQL Server 2000 is no different.
Read the Article
|
An Introduction to SQL Server Clustering
If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?
Read the Article
|
Speed Tips For SQL Server SELECT Statements
You can code a SQL SELECT statement in a number of ways to get the same results, but some versions of the same query may perform better than others. In this article we will look at ways to exploit this.
Read the Article
|
Use SET STATISTICS IO and SET STATISTICS TIME to Help Tune Your SQL Server Queries
This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries.
Read the Article
|
