By Vyas Kondreddi – This article shows you how to design the storage for email addresses, how to validate email addresses, how to write different types of queries on email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.
Author: SSWUG Research
Master joins with these concepts
To efficiently handle queries and good database design, you must have a good understanding of SQL join statements. Beyond the logistics of basic syntax, there are several concepts that will round out your knowledge of joins and facilitate data referencing, such as aliasing, self joins, and ON clause
A better way to protect your site from hack attacks
Think malicious users need sophisticated tools to attack a Web site? Think again. All they really need is a Web browser and basic knowledge of SQL or another scripting language. Sometimes all malicious users do is place a script inside the username, address, or search query field on a We
SQL Server 2000 (64-bit) Beta Benchmarks
New Record SAP R/3 4.6C Sales and Distribution Two-Tier Results The HP server rx5670 produced the world’s best four-way system performance result on the SAP R/3 4.6C Sales and Distribution (SD) two-tier benchmark, supporting 470 SD benchmark users at an average response time of 1.97 secon
SQL Server Accelerator for BI Jump-Starts Business Analytics
Would you and others in your company like to make better decisions faster? Would your company like to capitalize on information assets to thrive in a competitive marketplace? The Microsoft SQL Server Accelerator for Business Intelligence (BI), a free tool that helps you quickly get BI solutions in p
Oracle Apes Microsoft Strategy
Speaking at Oracle’s semiannual analyst day, CEO Larry Ellison uttered words many people never thought they’d hear: Oracle will adopt many of the strategies that made arch-enemy Microsoft successful and will focus on inexpensive, integrated software suites. “The suites always win,” Ellison said. “Th
Basic and complex SQL joins made easy
If you’re new to SQL, joins can be a daunting concept. There are many different types of joins and seemingly little information available that explains and compares them. But after you digest a few basic concepts, the practice of joins actually isn’t very difficult. Let’s look at the fund
Oracle Japan completes company’s revenue decline
In common with its parent company, Oracle Japan – one of the great hopes for the supplier – has report a decline in both profits and revenues for the last fiscal year. Oracle Japan posted a non-consolidated net profit of 17.62 billion yen in 2001/02, down down 3.8 per cent from the previ
SQL Server 7.0 and 2000 Trace Flags
Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that mos
Guard Your Data with Kerberos
All security operations in SQL Server depend on the twin processes of authentication and authorization. If the server doesn’t have total confidence in the user’s identity and, thus, can’t be sure of the permissions a user has, all attempts to control access to data fail. Microsoft has long preferred